When creating a Journal Entry, using CSV Import, o...
# general
e
When creating a Journal Entry, using CSV Import, or using SuiteScript it defaults to
Pending Approval
Is there a System Preference that sets that value for a JE? In the SuiteScript I can set the
approvalstatus
but in the CSV Import scenario it doesn't even have that option available. I don't want to default to a Workflow if possible.
l
Is the field type Normal in the form? Other field types won't allow you to set the value via CSV. If Normal, are you selecting the correct JE form where the field is visible in Step 2 of the Import Assistant?
e
It's a little weird. I have checked the option for Accounting Preferences > Approval Routing > Journal Entries It seems to be the culprit. 1. Manually, in the UI, the form has the field, so it takes into account your selection and the JE is created as approved. 2. In the SuiteScript, if no value is passed, defaults to Pending Approval. 3. Using CSV import the standard tool doesn't include the Approval Status as a field. So, it takes the default: Pending Approval. 4. There is ANOTHER CSV import tool for JE only: Transactions > Financial > Make Journal Entry > Import. Here you can set the Approval Status. So, in my use case, I need to create a WF that sets a default value for JE as Approved, in order to affect both CSV imports and SuiteScript. If some conditions are met (amounts, etc.) I set it as Pending Approval and set the approvers.
l
That's odd. I'm pretty sure we are setting the value of the approval status to approved whenever we don't want it to go through the approval logic. Is the field not really disabled in the form?
e
In the context where you can explicitly set the value as approved, it gets approved (UI, SuiteScript, that special JE-only CSV import tool) When you omit the value, it defaults as pending approval (for example, a script where you don't pass that value) When you use the standard CSV Import, where the approval status is not available, it defaults as pending approval. Took me a while to understand all of this 🙂