Page 1 of 1
Where is the current fiscal year stored?
Posted: 22 Jan 2007, 10:02
by Sam
I'm pulling data out of v13 through ODBC. I need to be able to know when the fiscal year has changed. Presumably one of the tables contains a 'Current Fiscal Year' field which gets updated when the year end is done.
Can anyone tell me where this would be stored?
Many thanks...
Posted: 23 Jan 2007, 15:43
by Sam
I'm just going to flog this dead horse again quickly:
The COMPANY table in Line 50 holds the fields START_MONTH, and FINANCIAL_YEAR. In my case this is 11 and 2006.
The FY 2007 runs from Nov 2006 - Oct 2007, so can I take it that Sage stores the month and year in which FY starts, not the FY that we're actually in?
Any ideas? Thanks in advance..
Posted: 24 Jan 2007, 15:17
by brucedenney
You are correct, Sage stores the details of the financial year in the Company table, it records the starting month and starting year for the accounting period in the fields named START_MONTH and FINANCIAL_YEAR.
Posted: 26 Jan 2007, 10:06
by Sam
That's great. Thanks Bruce.