File: IV_TRX_WORK_Serial_Lot
This file is used to store serial numbers and lot numbers for line items on Inventory transactions. The line items must be Inventory items which are set to track serial numbers or lot numbers. A single record in this file is used to store one serial number or one lot number. The records in this file for a line item are linked back to the line item's record in the IV_TRX_WORK_LINE file by the values in the IV Document Type, IV Document Number, and Line SEQ Number fields.
For items which are tracking serial numbers or lot numbers, there must be sufficient numbers of serial or lot numbers selected to equal the extended quantity for the line item. In the case of serial numbers, this means that the number of serial numbers entered must equal the extended quantity. In the case of lot numbers, this means that the total of the quantities for the selected lot numbers, not the actual number of lot numbers, must equal the extended quantity for the line item. When allocating the serial number and lot number records, Optimistic Concurrency Control record locking is used.
Serial Numbers
For increase line item entries, the serial numbers entered must be unique across the IV_Serial_MSTR and IV_TRX_WORK_Serial_Lot files for the item being processed. Checking for duplicate serial numbers in the IV_Serial_MSTR file is done by using Key 3, and in the IV_TRX_WORK_Serial_Lot it is done by using Key 2.
For decrease line item entries, the serial numbers must either exist in the IV_Serial_MSTR file at the line item site and not be marked as sold, or the serial numbers need to be added on-the-fly. The number of existing serial numbers which can be selected from the IV_Serial_MSTR file can be no greater than the quantity available for the item, where quantity available = QTY On Hand - QTY Allocated. If the serial number exists in the IV_Serial_MSTR file and is not marked as sold, the following steps are performed to allocate the serial number:
1) Access the serial number record by reading file IV_Serial_MSTR by Key 3.
2) Set field Serial Number Sold = True
For serial numbers which are added on-the-fly for decrease line item entries, the following steps are performed:
1) Serial number is added to the IV_Serial_MSTR file with the following field values:
Item Number - Line item number.
Location Code - Site for line item.
Date Received - Current user date.
Date SEQ Number - Set to 1 greater than the sequence number assigned to the last serial number for the item at the site and date received in the IV_Serial_MSTR file.
Serial Number - Serial number being added.
Finished Good Item Number - Blank.
Finished Good Serial Number - Blank.
Unit Cost - Current cost on item's master record.
Receipt SEQ Number - 0
Vendor Number - Blank.
Component Of Finished Good - False.
Serial Number Sold - True.
Bin – If Mulit-Bin is registered and enabled, this field will store the Bin.
2) The QTY On Hand and QTY Allocated fields are incremented by 1 on the item's site specific and overall quantity records in the IV_Item_MSTR_QTYS file.
For transfer line item entries, the allocating of the serial numbers is similar to the decrease case where the serial numbers must either exist in the IV_Serial_MSTR file at the line item site and not be marked as sold, or the serial numbers need to be added on-the-fly. The number of existing serial numbers which can be selected from the IV_Serial_MSTR file can be no greater than the quantity available for the item, where the quantity available is dependent on the quantity type which the item is being transferred from. Based on the Transfer From QTY Type field the quantity available is:
On Hand = QTY On Hand - QTY Allocated
Returned = QTY Returned
In Use = QTY In Use
In Service = QTY In Service
Damaged = QTY Damaged
The processing for allocating serial numbers and adding serial numbers on-the-fly is the same as listed above for decrease line item entries. For entries added on-the-fly, the QTY On Hand and QTY Allocated fields are updated only if the quantity type being transferred from is On Hand.
If the item is tracking lot attributes for the lot numbers, then additional processing for the lot attributes record is needed. This processing is described below for the IV_Lot_Attributes file.
Lot Numbers
The processing of lot numbers is similar to the serial number processing with the exception that a lot number has a quantity associated with it while a serial number does not, a lot can also record an associated Manufacture Date and Expiration Date for each increase transaction. For increase line item entries, the lot numbers do not have to be unique across the IV_Lot_MSTR and IV_TRX_WORK_Serial_Lot files.
For decrease line item entries, the lot numbers must either exist in the IV_Lot_MSTR file at the line item site and have a quantity available which is greater than or equal to the quantity entered for the lot numbers, or the lot numbers need to be added on-the-fly. The total of the quantities for the lot numbers which can be selected from the IV_Lot_MSTR file can be no greater than the quantity available for the item. If the lot number exists in the IV_Lot_MSTR file, and has sufficient quantity available then the following steps are performed to allocate the quantity:
1) Access the lot number record by reading file IV_Lot_MSTR by Key 3 using values for the Date Received and Date SEQ Number fields from the line item transaction record.
2) Set QTY Allocated to QTY Allocated + quantity entered for the lot number.
3) If the QTY Received = QTY Allocated + QTY Sold for the lot master record, set Lot Number Sold to true.
For lot numbers which are added on-the-fly for decrease line item entries, the following steps are performed:
1) Lot number is added to the IV_Lot_MSTR file with the following field values:
Item Number - Line item number.
Location Code - Site for line item.
Date Received - Current user date.
Date SEQ Number - Set to 1 greater than the sequence number assigned to the last lot number for the item at the site and date received in the IV_Lot_MSTR file.
Lot Number - Lot number being added.
QTY Received - Quantity entered for lot number
QTY Sold - 0
QTY Allocated - Quantity entered for lot number
Unit Cost - Current cost on item's master record.
Receipt SEQ Number - 0
Vendor Number - Blank.
Lot Number Sold – True
Bin – If Mulit-Bin is registered and enabled, this field will store the Bin.
2) The QTY On Hand and QTY Allocated fields are incremented by the lot number quantity on the item's site-specific and overall quantity records in the IV_Item_MSTR_QTYS file.
For transfer line item entries, the allocating of the lot numbers is similar to the decrease case where the lot numbers must either exist in the IV_Lot_MSTR file at the line item site and have an available quantity or the lot numbers need to be added on-the-fly. The total of the quantities for the lot numbers which can be selected from the IV_Lot_MSTR file can be no greater than the quantity available for the item, where the quantity available is dependent on the quantity type which the item is being transferred from. Determining the quantity available is done using the same method listed above for transfer serial numbers.