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).

Type the following in the query pane. Then, press F5, or click the green arrow. select VENDORID, DOCNUMBR, * from FA01100 where VENDORID = 'VendorID' and DOCNUMBR = 'Invoice Document Number' select VENDORID, DOCNUMBR, FA_AP_Post_Index, * from FA01400 where VENDORID = 'VendorID' and DOCNUMBR = 'Invoice Document Number' Note In the statement, replace

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.

Type the following in the query pane. Then, press F5, or click the green arrow. select sum (Acquisition_Cost from FA01400 where VENDORID = 'Vendor ID' and DOCNUMBR = 'Invoice Document Number.

6.

Update the APPLDAMT value and the ORAPPAMT value in the FA01100 table for this specific FA_AP_Post_Index record.

Type the following in the query pane. Then, press F5, or click the green arrow. update FA01100 set APPLDAMT = X, ORAPPAMT= X where DEX_ROW_ID= Z Note In the statement, replace

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×