Financial Resource

If you are in the Corporate ERP selection phase and considering Microsoft Dynamics GP (often also referred as Great Plains Dynamics by its historical name) and you have the need of Fixed Assets module implementation (including FA data migration from your legacy Accounting system) – we recommend you this small publication.  We will try to give you overview and what to expect, and we assume that you are familiar with Fixed Assets management in theory.  In Dynamics GP you may maintain multiple FA books and by doing so you may show various Balance Sheet, P&L statement versions (Fiscal Reporting to IRS, Managerial Reporting, Corporate Reporting to Shareholders to name few candidates), where only one book should be chosen for posting FA depreciation (or intellectual property amortization) to General Ledger FA depreciation account(s):

1. Fixed Asset data conversion via FA Integration Utility.  If you have existing items that you would like to bring to Dynamics GP Fixed Asset module, you should export them into text files from your legacy Corporate ERP application and organize them into several files, according to Source file structure, described in FA Manual in the section “Importing Asset Records”.  The idea is like that: each file line has prefix: General (here FA import utility will assume that you are importing FA master records or assets in other words), Book (Asset-Book values, including such important features as Depreciation Method and Averaging Convention.  Just to remind – Depreciation Methods are Straight Line, Declining Balance and others) and less likely you may also decide to import Lease, Ins (staying for insurance) and User (user defined info).  We recommend you to create macro from each import, as this should help you to repeat the same process (and you can also alter Macro logic to further advance data conversion scenarios).  We recommend you to try FA import in the Test company, as you should expect several iterations

2. Fixed Asset Data Import via Custom Macro.  In some cases we had to do direct macro recording, and then reviewing macro anatomy and preparing final macro in Excel.  What you do is this – you record macro (entering new Fixed Asset General Record), then you open it in text editor and parse into logic portions and the Data Fields (where you enter data manually – Fixed Asset ID, Description, for example).  Then you place these parsed sections in separate Excel Columns and reproduce similar macro Excel rows for all the rest of your records.  This macro is more flexible and you have absolute control over its logic in Excel

3. Historical Depreciation or Amortization.  We recommend you do not import it from your legacy ERP application and rather try to depreciate it in Great Plains to current date and then compare with your legacy numbers

4. Fixed Assets new acquisitions.  Here you have three options.  First one is simple – you enter new fixed asset general record directly in FA.  Second – you can associate FA acquisition with AP Vendor invoice (if you change Purchase Distribution account to FA specified account) and the third – if you do Purchase Receipt (on FA Purchase account, or by marking item as Capital Item on the Purchase Order)

5. FA Data Repair.  There are known issues when you are closing your FA year several months after your Fiscal Year is closed.  In this specific case your depreciation inquiry and summary might be off – should be easy fix for Dynamics GP consultant

6. FA Reporting.  If you think that existing Report Writer reports are not covering your needs, Fixed Assets could be opened for Crystal Report or Microsoft SQL Server Reporting Services (SSRS)

7. Small article genre requires us to finish it here.  However we would like to hear from you about your FA implementation needs.  Call us: 1-866-528-0577, help@albaspectrum.com

Tags: absolute assets, advance data, amortization, anatomy, asset, asset data, asset records, assets, Averaging, balance, book values, capital, change depreciation filed in dynamics great plains, changing depreciation methods in gp, Data, data conversion, data migration, declining balance method in dynamics gp, Depreciation, depreciation method, depreciation methods, depreciation methods in great plains, Dynamics, dynamics gp averaging convention, dynamics gp fixed asset depreciation rates, dynamics gp fixed asset implementation guide, dynamics gp fixed asset import, dynamics gp fixed asset import manual, dynamics gp fixed asset test cases, dynamics gp historical depreciation, dynamics gp how do i import fixed assets, entering fixed assets into gp, ERP, erp application, erp reports challage, fa books, file, file structure, Fixed, fixed asset import great plains date, fixed asset macro great plains, fixed asset multiple books in gp, fixed asset user manual great plains, fixed assets management, further advance, gp dynamics 2011 fixed assets investments, gp fixed asset import, gp fixed assets import macro, gp test macro, great plains fixed asset change acquisition date, great plains fixed asset module required fields, great plains fixed assets importing sheet, how do i edit a fixed asset in great plains, how to book fixed asset in great plain film, how to edit a fixed asset in great plains, how to record purchase of fixed assets in dynamics gp, how to upload fa depreciations into gp?, how to upload your fixed asset detail into great plains, implementation, implementtation of fixed asset change, import, import to great plains fixed assets, import utility, Importing, info, ins, IRS, lease, Ledger, legacy accounting system, loading assets into great plains, macro, manuals of fixed asset module in gp, method, Microsoft, microsoft dynamic gp fixed assets import, microsoft dynamics gp, microsoft dynamics gp 9.0 fixed assets depreciation, microsoft dynamics gp creating fixed assets without depreciation, microsoft support jobs, ms dynamics great plains fixed asset user guide, ms gp fixed asset manual, need, no depreciation method dynamics gp, Notes, plains dynamics, recording, selection phase, shell climate change, shell climate change united states, shell recruitment accounting or commercial or finance or hr or management or pension or investment or procurement or supply or support, Straight, structure, test, test company, text, upload vendor id gp dynamics fixed assets, uploading assets gp, what is gp fixed assets module, what not to do during fixed assets import dynamics gp, what to expect accounting data conversion, year