|
Alan, I've also worked with companies that have changed their idea of what constitutes a year, so by hard knocks, now keep all data by calendar month (it never changes). A control file has the fiscal start month to use as an offset. For example if you have a normalized G/L file with year, month, account number as the key and month-to-date dollars as data you can compute the year-to-date on the fly. A change in fiscal start month is a simple change to the contents of the control file with no programs requiring change. P.S. We also operate in a multi company environment and not all companies have the same fiscal start. It works nicely for this situation also. > Alan Cassidy wrote: > > I'm preparing for a fiscal year change coming up at the end of > December 2000. It will be the third accounting period for what is now > our fiscal year 2001, as in the old style. > > The new parent company requires us to change to a calendar-type fiscal > year, which means January 2001 will be the first accounting period in > the new, improved, refreshed fiscal 2001. > > Any suggestions on (generally) best approaches? Or...experiences, > special gotchas... > > - Alan Cassidy > acassidy@pioneermetals.com +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.