We get questions yearly from a few GP Fixed Asset users whose auditors are looking for the forms 4562 and 4797, these are IRS regulatory tax forms. It would be a great feature to include in Dynamics GP, rather than relying on 3rd party or manually preparing the forms
Please set the posting process to post through to the G/L, not just post to. If unable to make that the default, please allow an option.
For all other main sub ledgers, when I create a batch (as I do in Fixed Asset GL Posting routing) and select 'Post', the batch posts through to the G/L.
Currently in fixed assets, I have to generate the batch, post the batch in Fixed Assets & the subsequently go post the batches again in the G/L.
On the FA Transfer Maintenance window, you can transfer the Physical Location, Location ID, G/L Accounts, Master Asset ID & Structure ID, which is all good. However this would be much more powerful and simpler if you could transfer the asset class as well.
Classes are frequently linked to Account Groups in a GP deployment so that when a class is assigned to an asset, the associated account group gets assigned and the assets inherits the appropriate GL accounts.
Most of our customers setup their classes to represent both the asset class and the location, so for example FF&E-NORTH, FF&E-SOUTH, etc... They do this because their COA contains separate accounts for FF&E depending on the location. Since both the asset class and the location are part of the class, they can then setup matching Account Groups, and once again by simply adding the class to a new asset, the appropriate accounts get assigned.
So in the above scenario, it is very common to need to move an asset from one class to another, either because it was coded incorrectly initially, or more commonly, because the asset physically moved from one location to another.
For example, a new desk was setup as FF&E-NORTH and depreciated for a number of months, but then it was moved to FF&E-SOUTH. Doing a transfer of this asset allows us to transfer any of the fields mentioned above. Most importantly it creates the GL distributions to move the Cost and Accumulated balances plus it assigns the new GL accounts to the asset, which is all good. However, it does not change the class of the asset, which in the above scenario is necessary. So after the transfer is done, we then have to pull up the general window and manually change the asset class.
Not only is this an extra step that is easy to forget, but it also adds confusion to the entire process. If someone forgets the proper sequence and changes the class first and then does the transfer, that is typically problematic because changing the class will very likely also update the GL accounts with the new GL accounts because of the linked account group. Then when they go to transfer the asset, GP already has the updated GL accounts on the asset therefore you can't transfer them. It seems to me that simply adding the class id to the transfer window would solve all of these problems.
When trying to post FA to General Ledger (i.e. MDGP>>Tools>>Routines>>FA>>GL Posting), if any of the GL accounts in the batch are inactive, you cannot post and receive a message that some of the accounts are inactive.
However, there doesn't appear to be any notification of which inactive accounts are the problem. Including the problem account(s) along with the rest of the message would be ideal. If that is not possible, then providing some other means of easily identifying the inactive accounts in the FA batch would be helpful.
Our workaround of dumping the edit list to excel and then doing a vlookup against a list of inactive accounts wasn't too difficult, but nevertheless is a bit time consuming and should be unnecessary IMHO.
Add a checkbox in the Fixed Assets setup window (or maybe Posting Setup) to allow Fixed Asset posting to post "through" GL.
Currently there is no consistent key between a Fixed Asset retirement and/or retirement and the G/L posting table FA00902.
This means that in reporting, particular when trying to follow the G/L from the subledger, there is no way to properly link a retirement and/or retirement to the date that transaction was posted to G/L.
A very common request for FA reporting is a schedule of transfers in/out & retirements over a period. This is currently (GP2018) impossible to do without a better link between the FA transaction and the GL posting table.
A column like "Source Document" in FA00902 table that referenced RETIREMENTEVENT or TRANSFEREVENT could be a start. If a company were posting in summary instead of detail... Another table that links transaction to GL posting batch would likely be needed...
Once linked to FA00902 table, adding the G/L posting date to the transaction inquiry would make sense as the G/L posting date appears on just about every other transaction inquiry window in GP...
Please add the drill-back ability to all windows where 'Asset ID' is listed and currently not active for a drill-back. With all other modules/windows, you can simply select the master record (vendor, customer, account, etc.). With Fixed Assets, you cannot in most windows which is disruptive for end-user processes and experience.
Asset Book Inquiry
Book Compare Inquiry
Financial Detail Inquiry
Asset User Data
The UX changes based on how an end-user is selecting pending purchases in the 'Asset General Information' window.
If the user simply selects the drop-down list & select an existing purchase, they can subsequently add the class ID.
If the user select the 'Purchase' button from toolbar which opens the pending purchases window, the user cannot 'select' those purchases unless the Class ID has already been input.
Please provide the end-user the ability to open the purchase window, view existing purchases, select those purchases & then subsequently add the Class ID. In normal processing, the end-user doesn't know what the class ID for the purchase(s) is(are) until they view those purchases. Current process requires them to open the purchases window, close the purchases window, enter Class ID, open purchases window, select purchases.
An option to pass through the 'Source Document' field in the Fixed Assets subledger to the 'Source Document' field in the general ledger would greatly enhance financial reporting capabilities.
In Management Reporter for example, I'd be able to just reference the 'Source Document' field in the GL10000, GL20000, GL30000 tables & put together an asset schedule (Additions, Retirements, Transfers, etc.). Without the true source document in the G/L tables, we must develop this type of report using another method since only 'FA' is used as the source document currently.
For posting options in FA, if detail were used, it simply passes through the source document. If summary were used, we'd have the option to 'summary' by source document, thus the source document could be passed through. If summary (existing option as-is) were used, the existing method of just putting 'FA' in the source document field of g/l would suffice.
When apostrophes are used in Fixed Asset descriptions, the intercompany transfer feature throws a sql syntax error.