RKL eSolutions Blog Trends and Insights

How to Use Year-End Simulation in Sage ERP X3

Most companies won’t be ready to close the books on 2014 before starting to post new transactions in 2015. That’s where the Year-End Simulation feature in Sage ERP X3 can come in handy.

It’s used in cases where the previous fiscal year must remain open for a period of time into the new year. Performing a year-end simulation will roll forward the ending balances for the Balance Sheet accounts without creating the closing journal entries or permanently closing the Fiscal Year. By simulating the close, monthly statements will include the correct opening balances until the previous Fiscal Year is ready to be closed and retained earnings calculated.

Prerequisites Before You Start

Before starting Year-End Simulation, check these prerequisites:

Accounts (Setup > Financials > GL > Account Classes)
Verify that Account Classes are set up correctly for Expense & Revenues (Reset to Zero) and Assets (No).

Periods (Common Data > GL Accounting Tables > Fiscal Periods)
Open the next fiscal year and first month of the new year.

Users (Development > Utilities > Verifications > User Monitor)
All users must be logged off. The Journal, EDI, and ADC monitors must also be stopped since they are considered a user.

Running the Simulation

Once the prerequisites are met, you’re ready to begin:
Financials > Utilities > Year End Simulation

NOTE: You should deselect “All Companies” and run just one company at a time, General Balance and Analytic Balances must be selected, and you always run Year-End Simulation for the NEW or NEXT year (2015 in this case).

Need Help Figuring It All Out?

Read our current blog on 5 Steps to Take in a Sage X3 year-end Close. Contact us with any questions regarding Sage ERP X3 Year End Simulation.

Contact RKL eSolutions

Tags: Sage X3
Cliff Horst

Written by Cliff Horst

Cliff Horst is the VP Application Support at RKL eSolutions with an expertise in SQL Server, Crystal Reports, Sage 500, Sage X3, and KnowledgeSync.