Hello!
When trying to create an Adjustment for Physical Inventory for an item that has been Transferred to a Project (Track by Project Quantity), the system throws the error “Insufficient Qty. On Hand”.
The only resolution we can find is to transfer the qty. back to Project X, or delete the item from the PI Adjustment and manually create an Issue doc. instead.
Am I missing something?
Best answer by meganfriesen37
What type of inventory adjustment are you trying to make? Are you adjusting the value or quantity or both?
With project specific inventory, if the item has been transferred to a project (but still in inventory, not yet issued) you can do the following:
If you transfer it back to project X then, you can transfer and issue to another project or adjust in the main inventory.
+12What type of inventory adjustment are you trying to make? Are you adjusting the value or quantity or both?
With project specific inventory, if the item has been transferred to a project (but still in inventory, not yet issued) you can do the following:
If you transfer it back to project X then, you can transfer and issue to another project or adjust in the main inventory.
To confirm, there is no method for executing a Physical Inventory count of Project Specific Inventory that is stored in the Project Cost Layer. The only option is to consume the inventory by expensing it to the project, which would preclude the need to verify the count. Or transfer it to the Normal Layer, count it as a Physical Count and transfer it back to the Project. It appears that you could also create an Inventory Adjustment for the Inventory ID and the Project but that would have to be an individual transaction and not part of the Physical Count process.
To Summarize, you cannot use the Physical Count features if you store your inventory in the Project Cost Layer.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
