You receive the error "Open layer exists in purchase receipts table where valuation method not stamped" when you run the Historical Inventory Trial Balance reset tool in Microsoft Dynamics GP

When you run Step 2: Perform Data Integrity Checks of the Historical Inventory Trial Balance (HITB) IV Reset Tool, you receive the following error message on the IV HITB Reset Tool Validation Report:

Open layer exists in purchase receipts table where valuation method not stamped.

You will receive this error message when one or more receipt layers in your Inventory Purchase Receipts (IV10200) table is not sold (RCPTSOLD value = 0) and the valuation method column (VCTNMTHD) is 0 or blank.

This is a normal situation for data to be in when it has been updated from a version of Microsoft Dynamics GP that is before 9.0.

The HITB Reset tool will automatically resolve this error as long as all other errors on the IV HITB Reset Tool Validation Report are corrected.  You will want to first correct any other errors that appear on the report, and then click the Run Data Check
button again. As long as all other errors are resolved, the reset tool will resolve this one for you.

For more information on how to correct the other errors received on this report, refer to the Frequently Asked Questions document on the HITB IV Reset download page. 

FAQ for the HITB Tool for Microsoft Dynamics GP 10 and Microsoft Dynamics GP 2010

https://mbs.microsoft.com/customersource/downloads/servicepacks/mdgp10_hitb.htm?printpage=false

Note This is a “FAST PUBLISH” article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.

More:
You receive the error "Open layer exists in purchase receipts table where valuation method not stamped" when you run the Historical Inventory Trial Balance reset tool in Microsoft Dynamics GP

Comments are closed.

Recent Comments

    Archives

    Categories