Accounting Period Automation

The Goal of accounting period automation is to update allowed posting dates automatically as the month changes to prevent user post transactions out of the accounting period.

Accounting Period Automation extension updates the "Allow Posting From" and "Allow Posting To" dates in both the General Ledger Setup and User Setup are automatically updated each month. This update is driven by the intervals defined in the Accounting Period Automation section of the General Ledger Setup. The system automatically recalculates and updates these dates based on the specified intervals, ensuring posting permissions are aligned with the current accounting period. This automation reduces manual intervention, maintains consistency in posting controls, and ensures compliance with financial rules, thereby safeguarding the integrity and accuracy of financial data.

In this article,

1. Accounting Period Automation Setup

2. Setup Job Queue for Accounting Period Automation

3. General Ledger Setup

4. User Setup

1. Accounting Period Automation Setup

• Search for "General Ledger Setup" and expand the Accounting Period Automation Tab.

• Set the "Change Posting Date on" to 'First Day of Month', 'Last Day of Month', or 'Custom day of Month' as required.
  1. First Day of Month:  Select if you want to update the "Allow Posting From" and "Allow Posting To" in General Ledger Setup and User Setup on the First Date of each month. 
  2. Last Day of Month:  Select if you want to update the "Allow Posting From" and "Allow Posting To" in General Ledger Setup and User Setup on the Last Date of each month. 
  3. Custom Day of Month:  Select if you want to update the "Allow Posting From" and "Allow Posting To" in General Ledger Setup and User Setup on the Custom Day of Month (This date cannot be First or last date of the Month). If Custom Day of Month is selected the Custom Posting Day should be defined.
• Set the "Custom Posting Day" by the selected posting format. This will allow the updating of "Allow Posting From" and "Allow Posting To" in General Ledger Setup and User Setup on the day specified in Custom Posting Day.

2. Setup Job Queue for Accounting Period Automation.

• Create a new Job Queue by clicking on action Accelera > Create Automation Job Queue on General Ledger Setup.

• A new job will be created with the specified Codeunit and will run daily at the designated start time.

1. Object Type to Run:  Codeunit

2. Object ID To Run: 72441880

3. Description: Accounting Period Automation

4. Recurrence: is set to execute on a daily basis at 1 AM.

You can use the Job queue to schedule a task for further details

3. General Ledger Setup

• Search for "General Ledger Setup".
• Once the Job Queue is triggered, the General ledger Setup "Allow Posting From" and "Allow Posting To" will be updated to the current Month's Starting Date and End Date.

4. User Setup

• Search for "User Setup".
• Once the Job Queue is triggered, it will clear the "Allow Posting From" and "Allow Posting To" fields for all Users in the "User Setup", allowing the "General Ledger Setup" to serve as the determining factor.