Wednesday, April 10, 2019

Serial Number appearing on the On Hand list under the Serial Numbers tab but with the Status of Not In Stock

A serial number will appear on the On Hand list under the Serial Numbers tab but will have the status of Not In Stock when the following occur:

1. An Inventory Transfer from Location 1 to Location 2 gets deleted and
2. The serial number has an existing quantity deducting transaction on Location 2 dated after the Inventory Transfer

This would result to the serial number being on hand for Location 1 and negative on Location 2.

To check which Locations are affected you may create a Saved Search using the steps below:
1. Navigate to Lists > Search > Saved Searches > New > Inventory Numbers

2. On the Criteria tab > Standard sub tab, set the following:
a. Item Fields... > Name > Set the item name
b. Number > Set the serial number
3. Click Preview or Save & Run

The item will appear as 1 on Location 1 and -1 on Location 2.

Once the affected locations have been determined, you may create two separate Inventory Adjustments via Transactions > Inventory > Adjust Inventory. The first adjustment is to remove the serial number from Location 1. The second is to add the serial number to Location 2 in order to offset the negative serial number in this location.

 

 

No comments:

Post a Comment