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...
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Where is the current fiscal year stored?
-
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..
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..
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Amazon [Bot] and 1 guest