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.
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.
Add a checkbox in the Fixed Assets setup window (or maybe Posting Setup) to allow Fixed Asset posting to post "through" GL.
When apostrophes are used in Fixed Asset descriptions, the intercompany transfer feature throws a sql syntax error.
Changing the Cost Basis and splitting the Cost Account results in an unbalanced GL entry when Fixed Assets is set to post in DetailScenario: A new asset is acquired via trade for an old asset. The old asset is retired with x$ proceeds that Debits a suspense account. New asset is created and x$ proceeds from trade is reflected in Internal Book distributions as Debit to suspense account.GL Posting routine picks up all correct distributions (Fixed Assets General Ledger Posting window). At the GL, two unbalanced Journal Entries are created where One would be expected. One Journal Entry has one line for x$ on suspense account and the second Journal Entry has the Depreciable Assets and Fixed Assets Clearing distributions.
Workaround edit distributions