In most cases a company will need to run financial reports for the current year before they have closed the previous year. During a fiscal year close new period entries are created which create the opening balances for the current year. The Year End Simulation can be used to simulate the fiscal year end close and allows the opening balances to display on current financial reports.
Prerequisites
Before running Year-End Simulation, check the following prerequisites:
- Accounts (Setup > Financials > Account classes)
- Verify the ‘Carry forward’ is set to Yes for the appropriate account classes.
- Periods (Common Data > GL Accounting tables > Fiscal Periods)
- Confirm that the period for the current year is open
- Users (Development > Utilities > Verifications > User Monitor
- All users must be logged off of Sage X3. The accounting tasks, EDI and ADC monitors must also be stopped since they are considered a user.
Process
To run the Year End Simulation go to Financials > Utilities > Year End Simulation
- You should deselect “All Companies” and run just for each company at a time.
- Select the current year that needs to reflect the opening balances.
- For example if I am closing 2018 I will enter 2019 (5) for the Fiscal Year.
- General Balance and Analytic Balances must be selected.
- Click Ok
- A log will display when the year-end simulation has been completed
The opening balances should now display on Financial Reports such as NA-TRLBAL and BALGRP.