In Navision, there’s no function that will give you the fiscal year according to what you’ve setup on the Accounting Period table. Here’s a code that will get the current fiscal year based on the accounting period:<\/p>\n
AccountingPeriod is a record variable \u00a0to table 50
\nDate1 and Date2 are date variables<\/p>\n
AccountingPeriod.RESET;
\nAccountingPeriod.SETRANGE(“New Fiscal Year”,TRUE);
\nAccountingPeriod.”Starting Date” := WORKDATE;
\nAccountingPeriod.FIND(‘=<‘);
\nDate1 := AccountingPeriod.”Starting Date”;
\nIF AccountingPeriod.NEXT = 0 THEN
\n\u00a0 Date2 := 12319999D
\nELSE
\n\u00a0 Date2 := AccountingPeriod.”Starting Date” – 1;<\/p>\n","protected":false},"excerpt":{"rendered":"
In Navision, there’s no function that will give you the fiscal year according to what you’ve setup on the Accounting Period table. Here’s a code that will get the current fiscal year based on the accounting period: AccountingPeriod is a record variable \u00a0to table 50 Date1 and Date2 are date variables AccountingPeriod.RESET; AccountingPeriod.SETRANGE(“New Fiscal Year”,TRUE);Read more<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8],"tags":[25],"class_list":["post-29","post","type-post","status-publish","format-standard","hentry","category-programming","tag-fiscal-year"],"yoast_head":"\n