The Approved checkbox is not displayed if you have enabled the Journal Entries Approval Routing Accounting Preference. This preference enables you to use SuiteFlow to create a custom journal entry approval routing workflow. If the preference is enabled, an Approval Status Field will be displayed instead of an Approved checkbox. In this case, the Approved checkbox cannot be mapped during CSV import as it is not showing on the form. Mapping the Approval Status field is a current System limitation. This is still a pending Enhancement Request logged under Enhancement #434764.
Solution
To solve this we can use a script or workflow to approve the journal entries in bulk. The approval status field is accessible through workflow and script.
Step 1: Create a Workflow
- Navigate to Workflows:
- Go to
Customization>Workflow>Workflows>New.
- Define the Workflow Properties:
- Name: Give a meaningful name to your workflow, such as “Bulk Journal Entry Approval”.
- Record Type: Set the record type to “Journal Entry”.
- Event Type: Set this to “On Demand” or “Scheduled”.
- Initiation: Depending on your preference, set it to be triggered by a button or schedule.
- Add State and Transitions:
- Add State: This is where the action of approving journal entries will take place.
- Add Action to the State:
- Select “Set Field Value”.
- Field: Approval Status.
- Value: Approved (or the corresponding value for approved status in your setup).