How do I manually Move Quantity Assets (‘Z’ numbers)?

Quantity Assets or ‘Z’ asset number movement is managed automatically by Bar|Scan using entries in the Transaction table.  For each ‘Z’ transaction, how quantities are moved depends upon (1) whether the transaction is a TAG or a TAKE, and (2) whether there is both a Current and Prior Location or just a Current Location.

Manual movement can be done by performing the same process within the Asset Location History table.  Since you are performing the same operation, but by hand, it is recommended that it be done by entering a Transaction entry.  This will perform the needed checks and make the movement of assets easier.

To ADD assets, see #1 below.

To AUDIT assets, see #2 below.

To MOVE assets, see #3 below.

1. Transaction ‘TAG’ with a ‘Current’ location.
   1. In this scenario, if a ‘Prior’ location is specified, it is ignored.
   2. A Problem results if there is no ‘Current Location’.
   3. The ‘TAG’ operation basically means to ADD the quantity specified in the transaction to the equivalent ‘Z’ number asset in the Asset table. This is done by adding a new Location History line with a quantity exactly matching the quantity of the transaction. If there is no equivalent ‘Z’ number asset in the Asset table, it is created.
   4. If there is a Work Order #, it is copied to the Location History entry created.
2. Transaction ‘TAKE’ with only a Current Location
   1. Normally this will result in a Problem message ‘Quantity <> Quantity in Asset table for current catalog and location’.
   2. However, this message can be disabled (see ‘Set Transaction Validation Messages…’ menu option). If disabled, it will set the ‘Z’ number quantity of the equivalent ‘Z’ asset number to be exactly as specified in the Transaction. It does this by adding two entries into the Location History, one is the negative of the current total quantity for the ‘Z’ number (a zeroing quantity) then the second has the exact same quantity as the Transaction. In short, it allows the quantity for a known ‘Z’ number to be reset to an exact amount, automatically inserting whatever values are needed into the Location History to achieve the target quantity.  Be careful disabling this Problem message and using this functionality. You must verify that there is one and only one ‘Z’ asset bucket with the given Catalog and Current Location.  BarScan allows multiple ‘Z’ assets with the same Catalog and Current Location.
   3. If there is a Work Order # it is copied to all Location History entries created.
3. Transaction ‘TAKE’ with both a Current and Prior Location
   1. This moves the specified number of ‘Z’ assets from one location to another, from the ‘PRIOR’ location to the ‘CURRENT’ location.
   2. Movement is achieved by inserting two Location History entries, a Positive Quantity into a ‘Z’ asset with the specified Catalog and Current Location and a Negative quantity into a ‘Z’ asset with the specified Catalog and Prior Location. If there is no ‘Z’ asset with the same Catalog and Current Location, it is created.
      1. Normally If there is no ‘Z’ asset with the specified Catalog and Prior Location or insufficient quantity to cover the move then a Problem will result ‘Not enough [Z] Asset matching Catalog and Previous Location’.
      2. However, this Problem message can be disabled. If it is disabled, then during the move operation a negative value will added to the ‘Z’ asset with the same Catalog at the Prior Location. If such a ‘Z’ asset does not exist for the Prior Location then it is created. Be careful disabling this Problem message. It can cause the entry of ‘Z’ assets with negative quantity values and totals.
   3. If there is a Work Order # it is copied to all Location History entries created.

After the new location history entries are made, then all of the Location History quantities are added up for each of the ‘Z’ assets involved to get the total quantity of assets for each ‘Z’ number. This quantity is then posted in the Asset tables Quantity field for its ‘Z’ asset number. On the Asset screen it is next to the Asset number.

Remember that (1) each ‘Z’ asset number, by definition, has only one Catalog and one Location. Each Location History entry must have the same location as all others for the same ‘Z’ asset. If you attempt to enter a different location within a ‘Z’ asset number you will get an error message. (2) BarScan allows multiple ‘Z’ asset numbers with the same Catalog and Location, so when doing manual operations do not assume that there is only one such for any Catalog/Location combination.

To move ‘Z’ asset quantities, please use the procedures above or manually perform the equivalent operations by entering adjusted Location History entries. Remember that all adjustments to ‘Z’ quantities should be made by ADDING a new Location History record with the same Location. Moving Assets from one location to another requires two (2) such ADDED location History entries, one in each ‘Z’ asset for the given location, Current and Prior, the Current location receiving a POSITIVE quantity and the Prior location a NEGATIVE quantity.