How to reconcile Fixed Assets to verify that the balances are correct in General Ledger in Microsoft Dynamics GP

Article ID: 857464 - View products that this article applies to.
Expand all | Collapse all

INTRODUCTION

This article describes how to reconcile Fixed Assets to verify that the balances are correct in General Ledger in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains.

MORE INFORMATION

  1. Run the Fixed Assets to General Ledger Reconciliation report. To run this report, point to Fixed Assets on the Reports menu, and then click Activity. In the Reports list, click Fixed Assets to General Ledger Reconciliation, and then press ENTER.
  2. Run the Fixed Assets Inventory List by Class report. To run this report, click Fixed Assets on the Reports menu, and then click Inventory. In the Reports list, click Fixed Assets Inventory List by Class.
  3. Run the Annual Activity report. To run this report, click Fixed Assets on the Reports menu, and then click Activity. In the Reports list, click Annual Activity, and then press ENTER.
In the following scenarios, errors may cause the entries in Fixed Assets to be out of balance with General Ledger:
  • An asset is deleted in Fixed Assets. This asset was interfaced with General Ledger. And, a general entry was not created in General Ledger to back out the information for the asset. When you delete an asset, a report is automatically printed. This report tells you what activity has occurred for the asset. If the line item has been interfaced with General Ledger, the report contains a batch number.
  • The correct General Ledger account is not setup in Fixed Assets to default on the transactions.
  • An incorrect book is set up as the Corporate Book in the Fixed Assets Company Setup window .
  • Typically, the balances are already in General Ledger during the initial setup of Fixed Assets. The balances may have been entered as Payables Management transactions. Or, the balances may have been entered manually in General Ledger. After you add all the assets into the system, run a dummy General Ledger interface. When you do this, enter 0000-000 in the Begin Date field and in the End Date field of the period through which the assets are currently depreciated. Then, delete the batch in General Ledger. This step updates each asset and uses the flag with which the assets were interfaced. However, because the batch is deleted, it does not affect the General Ledger. If you forget to create and delete the dummy batch, there is a risk that you will run an interface in the future that will update General Ledger again.
  • You use the interface from the Payables window or from the Purchase Order Processing window, and you do not add all the assets into Fixed Assets. If you use a true clearing account in purchasing, the balance remains in the clearing account. You can check this account to verify that all the assets have been entered into Fixed Assets. If you do not use a true clearing account, view the FA-AP Post Table Inquiry window to verify that all the assets have been added. To do this, use one of the following steps:
    • In Microsoft Business Solutions - Great Plains Dynamics 7.0 and in later versions, click Inquiry, click Fixed Assets, and then click Purchasing Transactions.
    • In Great Plains 6.0, click Inquiry, click Fixed Assets, and then click FA-AP Post Table.
  • If you use the Purchase Order Processing "by receipt" line, the clearing account should be the same account that is debited in Purchase Order Processing. The clearing account is the account that is credited when an asset is added in Fixed Assets. For example, if you use the Fixed Assets account in Purchase Order Processing, the clearing account should be set up as the Fixed Assets account. If the clearing account is not set up as the Fixed Assets account, the Fixed Assets account is debited two times.
Example

The following tables describe the accounts that are used when you post an invoice in Purchase Order Processing in Microsoft Dynamics GP.
Collapse this tableExpand this table
ModuleDR/CRAccount typeAccount number
Purchase Order ProcessingDRFixed Assets account000-1500-00
Purchase Order ProcessingCRAccounts Payable000-2100-00
Fixed AssetsDRCost account000-1500-00
Fixed AssetsCRClearing account000-1590-00
Notice that the 000-1500-00 Fixed Assets account would be debited two times. To prevent this, the clearing account should be the Fixed Assets account. This setup would result in a debit entry and a credit entry to the Fixed Assets account when the asset is added in Fixed Assets. Therefore, the Fixed Assets account is only debited one time. Consider the following example.
Collapse this tableExpand this table
ModuleDR/CRAccount TypeAccount Number
Purchase Order ProcessingDRFixed Assets account 000-1500-00
Purchase Order ProcessingCRAccounts Payable 000-2100-00
Fixed AssetsDRCost account 000-1500-00
Fixed AssetsCRClearing account 000-1500-00
  • The FA-AP Post account is set up as one account, and the clearing account is set up as a different account. These two accounts should be the same account number. This account is frequently known as the "trigger" account.
  • There may have been adjustments made directly to a Fixed Asset account in the General Ledger. These adjustments are not reflected in Fixed Assets.

Properties

Article ID: 857464 - Last Review: July 13, 2011 - Revision: 3.0
APPLIES TO
  • Microsoft Dynamics GP 2010
  • Fixed Asset Management, when used with:
    • Microsoft Dynamics GP 10.0
    • Microsoft Dynamics GP 9.0
    • Microsoft Business Solutions–Great Plains 8.0
    • Microsoft Great Plains Dynamics 7.0
    • Microsoft Great Plains eEnterprise 7.0
    • Great Plains Dynamics 6.0
    • Great Plains eEnterprise 6.0
Keywords: 
kbexpertisebeginner kbhowto kbexpertiseinter kbmbsmigrate KB857464

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com