Small and medium business | Business Central, N...

Non Calendar Month Accounting Periods

(1) Share

Report

Posted on by Samantha73

3,247

Hi All
Has anyone implemented non calendar month accounting periods like 5-4-4 or any config where start and end date does not fall month start/end? What are the gotchas and considerations? I looked at the accounting periods table and it does not have a field for the month as a unique identifier which means reporting is a bit hard if you are using PBI

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ahmad Subhani 581 on at

Like (1)

Report

There is a Method to solve this:

- Currently you want it According to Weeks. (4,4,5)

- Click on the Create New Year in Accounting Period Page, then a "Create Fiscal Year" page will Open.

1- Starting Date: The Starting date of your Fiscal Year.

2- No. of Periods: There are 52 Weeks in an Year so specify 52.

3- Period Length: Specify 1W (Means 1 Week)

The Results will be Like:

Hope so that is Helpful,

Thanks

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (2)

Report

hi

implementing non-calendar month accounting periods, like the 5-4-4, in Business Central can be complex but feasible. Here are some considerations and potential pitfalls:

Setting Up Accounting Periods: Business Central allows for customized accounting periods, but it requires careful attention to ensure the start and end dates are correct. Clearly defining each period is crucial to avoid discrepancies in reports.

Reporting: As you noted, the accounting periods table does not have a field for the month as a unique identifier. This can complicate reporting, especially if you use Power BI. You might need to create custom fields or use other reporting solutions to manage the data accurately.

Data Consistency: Maintaining data consistency during the transition to a new accounting period system is essential. Ensure all transactions are correctly allocated to the new periods to avoid errors in financial statements.

Training and Support: Make sure your team is adequately trained on the new accounting period setup. Continuous support might be necessary to resolve any issues that arise.

bye

DAnienel

Was this reply helpful? Yes No