We have been trying to work this one through for a while now...
Here's the issue:
We have at least one part number in tigerpaw that we cannot manually correct the inventory count on. Our physical count of this inventory is 8 on hand which is correct in Tigerpaw for "Available in location" However tigerpaw still shows that there are 53 of this item in this said location and a total of 139 on hand. I checked the status for different warehouse locations that we have in tigerpaw (52 in one, 33 in another and one in another that is physically available). I have tried a few different tricks but cannot figure out how to get our inventory count correct for this item. Is there any way in tigerpaw to do this or do we need to run a SQL script to delete the item and re-add it?
The numbers match up in the LIFO Pool but since the Qty Available in location is less than or 0 we cannot manually correct the inventory.
Here's the issue:
We have at least one part number in tigerpaw that we cannot manually correct the inventory count on. Our physical count of this inventory is 8 on hand which is correct in Tigerpaw for "Available in location" However tigerpaw still shows that there are 53 of this item in this said location and a total of 139 on hand. I checked the status for different warehouse locations that we have in tigerpaw (52 in one, 33 in another and one in another that is physically available). I have tried a few different tricks but cannot figure out how to get our inventory count correct for this item. Is there any way in tigerpaw to do this or do we need to run a SQL script to delete the item and re-add it?
The numbers match up in the LIFO Pool but since the Qty Available in location is less than or 0 we cannot manually correct the inventory.
Comment