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 to table 50
Date1 and Date2 are date variables
AccountingPeriod.SETRANGE(“New Fiscal Year”,TRUE);
AccountingPeriod.”Starting Date” := WORKDATE;
Date1 := AccountingPeriod.”Starting Date”;
IF AccountingPeriod.NEXT = 0 THEN
Date2 := 12319999D
Date2 := AccountingPeriod.”Starting Date” – 1;
There aren’t that many how-to documents on the Microsoft Customersource website. However, this one has to be one of the most important must-reads for all Navision (Dynamics NAV) end users and implementers wishing to setup fixed assets in Navision.
The article is titled – “How to Set Up Modified Accelerated Cost Recovery System (MACRS) Depreciation in Fixed Assets” and can be found here:
For end users, you will need to be current on the Microsoft Enhancement Plan in order to view the document.
This document will teach you how to setup Navision so it can properly depreciate fixed assets according to IRS specifications.
As an implementer, I always encourage the client to use Dynamics NAV for all of their accounting and bookkeeping. This is especially true since the system can be easily setup and used. In addition, keeping all the books in Dynamics NAV will allow you to freely choose the right CPAs for your company without having to be held prisoner by one CPA. It also ensures continuity of your records should you have to switch to a new CPA.