Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Running the IV HITB Reset process after upgrading from Microsoft Dynamics GP 8

Running the IV HITB Reset process after upgrading from Microsoft Dynamics GP 8

  • Comments 2

Marian Verzosa - Click for blog homepageHi Everyone,

I recently worked on a case where the IV10201 table is not recording any transaction that sells the quantity.

The IV10201 table is the Inventory Goods Received Detail (IV_Purchase_Receipts_DTL) table.

This table was added on Microsoft Dynamics GP 9.0 and is used to record all the outflow transactions affecting the quantity of the item.

Upon reviewing the IV10200 (Inventory Goods Received Work) table, we verified that there are unsold receipts in the IV10200 table that have valuation method of 0. The Valuation Method is stored in the VCTNMTHD column.

These lines were coming from a pre v9.0, v10.0 or GP 2010 build of Microsoft Dynamics GP.

If the VCTNMTHD column is 0, then when that receipt layer in the IV10200 is sold, the outflow will not be written to the IV10201 table.

Due to the extent of changes with inventory costing between Microsoft Business Solutions - Great Plains 8.0 and the latest builds of Microsoft Dynamics GP, we are recommending that all customers who use the Average Perpetual valuation method for their items and are upgrading from version 8.0 to a newer version, perform the steps that are required to implement the Historical Inventory Trial Balance (HITB) report as part of their upgrade process, even if they do not plan to use the HITB report.

It is advised to implement the HITB report before performing any transactions that involve average cost items on Microsoft Dynamics GP but you can run this process at any time.

For more information on the inventory costing changes, refer to the white papers within Knowledge Base (KB) Article 939912:

 

For more information on the HITB report and IV Reset tool, refer to the information provided at one of these links:

PartnerSource

CustomerSource

 

The IV Reset process to implement HITB has a Data Integrity Check that allows for the system to review the IV10200 layers.

This stage in the IV Reset process updates the unstamped (VCTNMTHD =0) and unsold layers in the IV10200 resulting in the outflow lines being recorded in the IV10201 table upon consumption of these layers.

Regards,

Marian

Page 1 of 1 (2 items)
Comments Information

PLEASE READ BEFORE POSTING

Please only post comments relating to the topic of this page.

If you wish to ask a technical question, please use the links in the links section (scroll down, on right hand side) to ask on the Newsgroups or Forums. If you ask on the Newsgroups or Forums, others in the community can respond and the answers are available for everyone in the future.

Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post