Year to Date totals in interfacing applications accumulate based on the year end date set in the application settings.
CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.
CAUTION: Sage support can't assist with third-party products, hardware, report customizations, or state and federal tax questions. Refer to our Scope of Support for more info. Contact your Sage business partner, network administrator, or accountant for assistance.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.
Accounts Receivable:
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):
Job Cost:
Contracts:
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?
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?
DocLink: What happens if I change my Fiscal year end date in Job Cost?