SYMPTOMS
In the Fixed Assets Purchasing Transactions window of the Fixed Assets module, the amount that appears in the Originating Unapplied box is less than the total acquisition cost of the actual assets that were saved by using this purchasing transaction. This problem occurs only for assets that have the same asset ID but that have a different suffix.
CAUSE
This problem occurs because Microsoft Business Solutions - Great Plains does not update the amount in the Originating Unapplied box in the Fixed Assets Purchasing Transactions window after you create an asset and then clear that asset. If you continue to create the asset after you clear the asset, the asset has an incorrect acquisition cost.
WORKAROUND
To work around this problem, follow these steps:
|
1. |
Back up your company database. |
|
2. |
Click Start , click All Programs , click Microsoft SQL Server , and then click Query Analyzer . |
|
3. |
Select the server to which you want to connect. (This server is a server that is running Microsoft SQL Server.) Enter the login name and the password. |
|
4. |
Run a SELECT statement on the FA01100 (FA-AP Post Master) table and on the FA01400 (Asset Purchase Master) table for this purchasing transaction (FA_AP_Post_Index). |
|
5. |
The sum of the Acquisition_Cost values in the FA01400 table is not equal to the APPLDAMT value and to the ORAPPAMT value in the FA01100 table. To correctly sum the information, use the following script. |
|
6. |
Update the APPLDAMT value and the ORAPPAMT value in the FA01100 table for this specific FA_AP_Post_Index record. |
