This solution applies to you when you work with your Sage 300 Construction and Real Estate Consultant or Sage Professional Services Group/Expert Services to change your General Ledger fiscal year-end date.
When you change the fiscal year-end date in General Ledger, the interfacing applications will not automatically update. You can manually change the year end dates in these applications, however, yearly totals will not update and may not include the correct periods.
When Changing Fiscal Year End date in interfacing applications, make sure all users are logged out of the software, make sure you log into the software as Application admin, and perform these changes with Audit Setup Activity on.
Example: The fiscal year end date was changed in General Ledger from 9/30/2022 to 12/31/2021 for a short year of 10/1/2021 through 12/31/2021. Job Cost has already been posted and closed through January 2022. The month end date in Job Cost is February 2022 and the Year End date in Job Cost is September 30, 2022. The Year to Date Totals in Job Cost have accumulated from October 1, 2021 through March 30, 2022 (as Job Cost can post one month into the future of the current month).
Additional work would be needed to recalculate the year to date totals to reflect the amounts beginning January 1, 2022.
If you haven't rolled the month forward in interfacing application beyond the current General Ledger Fiscal Year End Date or you are not reporting on the YTD totals stored in the application master files and do not need these to reflect the actual YTD numbers, you can proceed with changing the year end dates in the interfacing applications as follows:
1. TURN ON AUDIT SETUP ACTIVITY:
After you verify the desired year ending dates for reporting purposes, verify that everyone has exited all Sage 300CRE applications and turn on Audit setup activity to change the interfacing applications. Refer to article 17021 DocLink: How do I use Audit setup activity?
2. CHANGE THE APPLICATIONS THAT NEED TO BE CHANGED:
Accounts Payable:
The AP Year ending date controls the accumulation of the vendor totals found on the Totals tab in the vendor setup (AP, Setup, Vendors). Determine if you need to close the existing AP Year first before changing the date.
- From the File menu, select Company Settings, AP Settings.
- Change the Year ending date. Do not change the 1099 year ending date.
- Click OK.
Accounts Receivable:
- From the File menu, select Company Settings, AR Settings.
- Change the Year end date.
- Click OK.
Cash Management:
Because Cash Management uses a calendar year, no changes are needed.
Equipment Cost:
The Equipment application should have been changed when you changed your General Ledger application. Contact your Sage Consultant or Sage Professional Services Group/Expert Services if the EQ changes were not made at that time.
IMPORTANT NOTES FOR JOB COST (JC) AND CONTRACTS (CN):
- Contracts sends entries to Job Cost, and Job Cost sends entries to General Ledger, so these should both be closed before you close the fiscal year in General Ledger. If the new month is the first month of a new year in Job Cost or Contracts, the year-to-date totals are replaced by the next year's totals.
- In the Job Cost and Contracts applications, you can post to the current month, the next month, or any month prior to the current month. When you receive the rejection message Accounting date [date] is beyond next month during posting, the accounting date of your entry is more than one month beyond your current month. You need to close the current month or possibly several months using Tasks, Close Month and then post the entries again.
- Refer to article 17509 DocLink: What happens if I change my Fiscal year end date in Job Cost? for steps and considerations on changing the Fiscal year end date in Job Cost.
Job Cost:
- From the File menu, select Company Settings, JC Settings.
- Change the Fiscal year end date.
- Click OK.
Contracts:
- From the File menu, select Company Settings, CN Settings.
- Change the Year end date (month/year).
- Click OK.
Payroll:
Because Payroll uses a calendar year, no changes are needed.
Property Management:
The property's fiscal year end date controls the accumulation of Misc Income totals (PM, Setup, Properties, Misc Income tab) and Accumulator totals for the property's fiscal year, which may be used for Management Fees. Determine if you need to close the existing fiscal year for the property, by closing the periods in Property Management, before changing the date. See article 20444 DocLink: What happens when I run Close Current Period in Property Management at the start of a new fiscal year?
- From the Setup menu, select Properties.
- Select the appropriate Property from the list.
- On the General tab, click the Controls tab.
- In the Fiscal year end box, type new date.
- Click Yes when the following message appears: "This field is maintained by the system. Are you sure you want to change it?"
- Click Close.
3. TURN OFF AUDIT SETUP ACTIVITY:
Turn off Audit setup activity when you are finished with your changes. Refer to article 17021 DocLink: How do I use Audit setup activity?