16.10.1
16.10.1 SN/LOT Over view
pc/MRP's optional Serial/Lot Number module will store current
on hand quantities of each serial/lot number in its snlot.dbf file. It
also keeps records of all transactions adjusting the serial/lot
number quantities in its snlotdet.dbf file. Entering an invoice (I type
transaction) or issuing a part(s) to manufacturing (S type transactions) will decrease the on hand quantity of the serial/lot number. Entering a receiver (R type
transaction) or entering a new serial lot number (J type transaction) will increase the on hand quantity of the serial/lot number. The main menu for
the serial/lot number optional module is shown below:
16.10.2 New (Entering a Serial/Lot Number Record Manually)
You can use this option to create serial lot numbers on the fly. The Enter Serial/Lot Number option will prompt "Enter a Master record only, Detail record only, or Both". If you wish to create a record in the master data base file and no initial quantity, select Master record only. If you wish to enter a transaction record, select Detail only. A master record contains the total on hand quantity for that serial/lot number . A transaction record contains the transaction record adjusting the on hand quantity of that serial number.
Entering both a master record and a detail transaction record will prompt for the part number and then display the next available serial/lot number. pc/MRP will automatically create the next available 15 character serial/lot number or users can type in their own serial/lot number. However, if users choose to enter alpha numberic characters pc/MRP will no longer be able to automatically generate the next available serial/lot number. Users consequently would be required to manually enter unique serial/lot numbers. When this record is entered pc/MRP will create a master record consisting of the Lot/Serial NO, PARTNO, and QUANTITY. It will also create a detail record consisting of the fields shown below.
Detail Transaction Data Entry Screen
The Part Number field (partno) contains the part number of the for that serial/lot number.
The Lot/Serial Number field (snlotno) contains your serial or lot number.
The Quantity field (detqty) contains the quantity issued, invoiced, adjusted or received.
The Revision field (revision) contains the revision level of that of that part number when the serial/lot number was received or created.
The Correction Factor was created for Inhale Therapeutics. It was designed to automatically adjust stock room BOM issue quantities based on concentration. Unless you are Inhale Therapeutics, leave the correction factor setting at 0. If a chemical were 90% pure you would enter 10 as the correction factor. If a chemical were 95% pure, you would enter 5 as the correction factor. If you are issuing a lot number to manufacturing that has a correction factor, you would issue the corrected amount instead of the exact amount required by the BOM. The corrected amount would appear at the bottom of the issue screen.
The Document Number field contains the related document number for this detail record. It would contain the receiver number if this record was created when this serial/lot number was received. It would contain the sales order number if this record was created when this serial/lot number was issued to manufacturing. It would contain the invoice number if this record was created when this serial/lot number was invoiced. It would be blank if this record was created manualy.
The Doc Type field (doctype) contains the document type, J type in this case indicates an adjusting entry. Other Doc Types include, I for Invoice, R for Receiver, and S for an issued to manufacturing stock transaction.
The Cust/Vendor field (sncv) contains the customer/vendor's ID code.
The Date field contains the date of the transaction.
The Vendor Lot Number field (vendlotno) contains the vendor's serial/lot number which may or may not be the same as your serial/lot number.
The Expiration Date field (expirdate) contains the date this serial/lotnumber is set to expire on. Leave this field blank if there is no expiration date.
16.10.3 Entering serial lot numbers when receiving parts
After entering a receiver, pc/MRP will prompt, "Enter a serial lot number for this part number". If you answer "Y" the following screen will be displayed.
The part number, document type, R for receiver, document number (receiver number), vendor id number, date received, and revision level will be inserted automatically. If you are recording lot numbers, enter your lot number, the quantity in the lot, the vendor’s lot number, and the expiration date (if any). If you are recording serial numbers, enter your serial number, the quantity as 1, vendors serial number, and expiration date (if any). If there is more than one lot or serial number press ok and answer "Y" to enter additional serial or lot numbers. . This will create a serial lot number detail record in the snlotdet.dbf with the vendor’s id code in the sncv field, R (Receiver) in the doctype field, and the receiver number in the docno field.
16.10.4 Entering serial lot numbers when issuing parts to manufacturing.
When issuing parts from the stockroom to manufacturing for a sales order you will be asked if you wish to record serial numbers. If you answer "Y", a screen displaying the serial/lot numbers available for that part number will allow you to issue the part(s) by serial/lot numbers as shown below.
Select the serial/lot number and enter the quantity required. Select Skip, to not issue any serial numbers. Select Manual to manually enter serial numbers that do not presently exist in pc/MRP. . If a serial/lot number is selected that is past its expiration date pc/MRP will display a warning and allow you to deselect or use that serial lot number. This will create a serial lot number detail record in the snlotdet.dbf with the customer’s id code in the sncv field, S (Stockroom) in the doctype field, and the sales order number in the docno field.
If you are issuing a lot number to manufacturing that has a correction factor, you
would issue the corrected amount instead of the exact amount required by the BOM. The corrected amount would appear at the bottom of the issue screen. The code for the above screen and correction formula is located in prsndscr.prg. The corrected amount
is basically:
(Required qty - Total corrected qty issued)/(1-(The correction factor/100))
16.10.5 Entering serial/lot numbers when invoicing.
Select the serial/lot number and enter the quantity required. Select Skip, to not issue any serial numbers. Select Manual to manually enter serial numbers that do not presently exist in pc/MRP. This will create a serial lot number detail record in the snlotdet.dbf with the customer’s id code in the sncv field, I (Invoice) in the doctype field, and the Invoice number in the docno field. If a serial/lot number is selected that is past its expiration date pc/MRP will display a warning and allow you to deselect or use that serial lot number. pc/MRP will print out all serial lot numbers issued to this sales order and all serial lot numbers created when entering this invoice in the invoices comment field provided:
16.10.6 Reports (Serial/Lot Number Reports)
The are two type of sn/lot number reports in pc/MRP's optional sn/lot number module, Master Reports (keeps total quantity on hand for each serial/lot number) and Detail Reports (print/displays transactions that adjusted the on hand quantity of the serial/lot number on hand quantity.
|
16.10.7 Serial/Lot Number Master Report Options
|
|
A master report shows the total quantity on hand for a sn/lot. An
example of a master report for all sn lot records is shown below:
|
|
16.10.8 Serial/Lot Number Detail Report Options
Prints out reports listing the sn/lot#, part#, document # (sales
order, receiver, etc), document date, customer/vendor, id,
document, quantity, and type of activity ( r = receive, i = invoice,
s = stockroom transaction j = adjusting and initial entrys)
|
|
Example of a detail sn/lot number report : 
|
16.10.9 Serial/Lot Number File Structure
The Sn/Lot program has two databases.
The master database named SNLOT.DBF contains the quantity available for each serial/lot number. The SNLOT.DBF file contains the following fields:
The second database file named SNLOTDET contains all the transaction records that were used to increase or decrease the quantity onhand of each serial/lot number. It contains the following fields:
16.10.10 Audit Serial/Lot Numbers
pc/MRP version 6.91H and higher contain the option to print/display a Serial/Lot number Audit report. The purpose of this report is to compare the quantities of the part numbers and serial/lot numbers based on the serial/lot number detail database file, the serial/lot number master database file, and the inventory/partmaster database file. The format of the report is as follows.
04/04/00 PARTNO SN/LOT NO QTY IN SN/LOT QTY IN SN/LOT QTY IN INVENTORY/ DETAIL MASTER PARTMASTER ______________________________________________________________________________ 003333 403 10 12 0 003333 504 20 20 0 003333 320 15 15 0 ______________________________________________________________________________ TOTALS 45 47 48 003340 444 100 100 0 003340 990 100 100 0 ______________________________________________________________________________ TOTALS 200 200 120
With the above information in hand, you could use the stockroom module to adjust the inventory/partmaster on hand quantities to match the quantities in the Serial/Lot Module Master file. You could also enter adjusting transactions into the detail file to match the Master Serial/Lot quantities.