PI Types - Unfreeze Stock When Counting Finishes

I have not attempted this in Acumatica but in a previous ERP I worked with they had a similar function. I assume the reasoning is the same.

The reason in that case was due to how Physical Inventory transactions work. You are essentially taking a snapshot of your inventory at a point in time and you are supposed to “lock your inventory” during the Physical Inventory count. The inventory snapshot will say something like for Part A we have 10 onhand in this location. If you consume that inventory in Acumatica through some transaction while  that Physical Inventory Sheet is open, and then you post it after the consumption of inventory, you’re basically causing an inventory discrepancy. The worksheet thinks you have 10 onhand, you then consume it, now when it tries to post the Physical Inventory worksheet it creates an issue because the inventory no longer exists.

It really is best practice to lock your inventory down during the duration of a Physical Inventory and to generate the worksheets right before you do the Physical Inventory and get them posted as quickly as possible. Don’t generate the sheets days in advance or take days to post them after the counts are finished. 

​@amorey 

This is because after counting is complete but before the adjustment is released, the system still hasn't updated the inventory balances.

For example:

1. System quantity = 100
2. Physical count = 95
3. Counting is completed.
4. Stock is unfrozen.
5. A warehouse employee ships 10 units.
6. The adjustment is later released.

Now the system has to reconcile both:

• The physical count adjustment (-5)
• The shipment (-10)

Depending on the sequence of transactions, this can lead to temporary quantity or cost discrepancies that need to be reconciled.

​@mohammadnawaz51  Have you used this flag and encountered a discrepancy?

Testing this flag, we received a purchased part before the PI adjustment was release and Acumatica processed/displayed the transactions in the correct order, but the last cost displayed in the Stock Item-Price/Cost tab was what the purchased receipt had, instead of the actual last transaction which was the PI adjustment (Don’t think this is a big deal if you have in mind what actually happened).