Serial/Lot F/M (ICF930)

General Inventory Status Back to top

Use this program to maintain serial numbersand lot numbers for items. Each record contains the warehouse, item, serial/lot number and serial/lot purchase and usage/sales information stored for the record. Initially no data needs to be entered here and the records are maintained by the system.

To access this program, choose Inventory Control-->File Maintenances -->Serial/Lot F/M.

Use the following fields to enter serial/lot number information:

*. Warehouse

Enter the warehouse. The entry must be a valid warehouse code. Press F2 or $image\find_shg.gif$ to search.

*. Item Number

Enter the item number. The entry must be a valid item number and must be a serial or lot item (set in the Item F/M). Press F3 or $image\ex_allft_shg.gif$ to display the first serial/lot item record on file for the warehouse. Press F2 or $image\find_shg.gif$ to search.

*. Serial/Lot Number

Enter the serial or lot number (up to 20 characters). Press F3 or $image\ex_allft_shg.gif$ to display the first serial/lot number on file for this warehouse and item. Press F2 or $image\find_shg.gif$ to search.

General Screen

4. Location

Enter the location of the item in the warehouse (6 characters).

5. Expiration

Enter the expiration date. Press Enter (CR) to default to 123199.

6. Last Physical Inventory

Enter the date of the last physical inventory. Press Enter (CR) to default to 010100.

7. Receipt Purchase Order Number

Enter the purchase order number on which the goods were received (up to 6 characters).

8. Receipt Date

Enter the receipt date. Press Enter (CR) to default to the system date.

9. Receipt Cost

Enter the cost at which the item was received per the costing unit of measure. Press Enter (CR) to default to 0.

10. Receipt Vendor

Enter the vendor number from whom the item was purchased. The entry must be a valid vendor. Press F2 or $image\find_shg.gif$ to search.

11. Receipt Memo

Enter the memo (up to 25 characters).

Inventory Status Screen

4. Total Received

Enter the total quantity received.

The following three fields are updated by the system:

*5. On Hand

The current on hand quantity of the serial/lot number in the warehouse.

*6. Committed

The current committed quantity through sales orders of the serial/lot number in the warehouse.

*7. Available

The available flag is Y (available for sale), N (has been sold), or E (not available because it is in the rental warehouse).

8. Last Use Document Number

Enter the last sale invoice number or usage ticket number (6 characters).

9. Last Use Date

Enter the date of the last sale/usage of the item. Press Enter (CR) to default to 010100.

10. Last Use Quantity

Enter the quantity last sold/used. Press Enter (CR) to default to 0.

11. Last Use Price

Enter the last price per each sold/used per pricing unit of measure. Press Enter (CR) to default to 0.

12. Cust/Memo

Enter customer sold to/usage memo (up to 10 characters). If the item was sold on a sales order, the field contains a customer number. If the item was transferred or manufactured, the field contains the memo from the ticket.