GL Interface (Posting) Takes a Long Time in Fixed Assets using Microsoft Dynamics GP

Applies to: Dynamics GP 2010Fixed Assets

TechKnowledge Content


Issue

The GL Interface (GL Posting routine) has slow performance in Fixed Assets using Microsoft Dynamics GP. 

Resolution

1. Make a BACKUP of the database that can be restored in case an undesired data loss occurs.

2. Open a new query window in SQL Server Management Studio and run the following queries against the company database: 
 
SELECT COUNT(*) FROM FA00902 WHERE BOOKINDX = X 
 
SELECT COUNT(*) FROM FA00902 WHERE BOOKINDX = X AND GLINTBTCHNUM = ''	 


(where X = the Book Index for the Corporate book. You can find this in the Book Setup table (FA40200).)



NOTE: The first query above tells us how many records are in the Fixed Assets Financial Detail table (FA00902) for the corporate book. The second query tells us how many of these records have a blank GL Batch number field which means they have not been posted to General Ledger. If these numbers are both high, this will cause performance issues when performing the GL Interface. 

The performance issue will occur because the GL Interface or Posting is run from current period to current period (Ex 2011-006 to 2011-006). This is not recommended for 2 reasons: 

1. Performance: If you imported in all of your assets or ran the Reset Life on your assets you may have records from prior periods in the Fixed Assets Financial Detail file. If you have never run the interface from 0000-000 to Current Period, batch numbers are never assigned to all these records. Thus each time GL Interface or Posting is run from current period to current period it needs to sort through all of those records that do not yet have a batch number. The first time you run the GL Interface or Posting from 0000-000 to current period it may take quite some time to process, but after you do this process, it will assign batch numbers to all the records so next time it will only need to process the new records that do not have batch numbers attached.

2. Balancing Fixed Assets to General Ledger: If you do run a reset year or reset life or make a transfer of an asset back in time, you are affecting past periods in the Fixed Assets sub module. In order for Fixed Assets to gather up these changes into a batch and post the differences to the current period you need to let the Period Range encompass them by running a GL Interface (GL Posting) from 0000-000 to the current period.

This article was TechKnowledge Document ID: 31173