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
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
Recent Comments