Using Fixed Asset Modules in Dynamics GP – Straight Line Depreciation

You can use Fixed Asset modules, to set up, enter, and maintain asset records. When necessary, you can add insurance and user-defined information. Above all, you can also create additional records for each asset. In addition, this might include the investment tax credit information and lease information.

Similarly, you also can use Fixed Asset modules to complete the following tasks:

A meeting of people regarding Fixed Asset

If you’re using General Ledger, you can track General Ledger information entered in Fixed Asset modules. In other words, details such as additions, transfers, depreciation, the retirement of assets, and other changes.

If you’re using Payables Management, you can track assets that originate in those modules. This can also be done in Purchase Order Processing. For instance, you can even add them as fixed assets.

Fixed Asset Depreciation Formula

The following formula is used in Microsoft Dynamics GP for depreciating Fixed Assets. In addition, the method used is the straight-line method for depreciation.

Formula: (Cost – Salvage Value – (LTD Depreciation Amount – YTD Depreciation Amount)) ÷ Remaining Life in Days. 


Cost = Cost of Asset.
Salvage Value = Estimated realizable value of an asset at the end of its life.
LTD Depreciation = Life to date depreciation.
YTD Depreciation = Year to date depreciation.

In conclusion, GP determines the daily depreciation rate using this. After that, it is multiplied by the number of days in a year.

However, suppose you take the Average method as “None”. Dynamics GP will calculate depreciation as follows:

For example: 
Asset Cost: $ 200,000
Asset Life: 10 years

Daily Depreciation = 200,000/(360*10) = $ 55.55
Monthly Deprecation = 200,000/((360*10))*30 = $ 1,666.67


For more information, please visit us at Microsoft Dynamics GP – Great Plains

AccSoft Business Solutions will help you in dealing with the issue you are looking at now.

You can email us at info@localhost or call us at 1-888-929-3266.

Leave a Reply

Your email address will not be published. Required fields are marked *