Hi Justin,

When you manually enter a record in Physical Count Entry the "Quantity on Hand" value is automatically populated based on the information in the IM_ItemWarehouse table, meaning you can't enter the "Quantity on Hand" manually either.  The perform logic in VI will accomplish the same. it will populate the "Quantity on Hand" automatically during the import.

Hi Steffen,

Thanks for the response.  I performed a test and it seemed like the qty on hand was pulled in only if the item was frozen, otherwise I got a qty on hand of zero.  The problem with freezing the items is that the items to freeze are non-consecutive and large in qty, so basically I wanted to know if there was a way to freeze a large number of non-consecutive item codes.

Thanks again.

I just used the following method for a customer:  

I set the items I wanted to freeze with an Inventory Cycle code that was not otherwise in use (using a VI job importing to CI_Item).  Then the Physical Count Worksheet screen could be used to intelligently select / freeze the correct items.  

I didn't have to change the IC code back because the customer didn't use Inventory Cycle for anything (and I was moving that inventory to a different company code), but if you need to have this data preserved, export the existing setting to a csv for later import.

This worked as mentioned by Kevin. Thank you Kevin.