Lots
File name |
|
Importance | If Applicable |
Description | Stock lots and expiration dates |
Criteria | All lots with stock remaining |
Columns
Pos | Name | Type | Importance | Description |
1 | Item Code | Char | Required | Product / SKU code |
2 | Location Code | Char | Required | Warehouse / branch code |
3 | Lot Number | Char | Required | Lot / batch number |
4 | Supplier Code | Char | If Applicable | Vendor code of the supplier |
5 | Manufacture Date | Date | If Applicable | Date the lot was manufactured. YYYY/MM/DD format |
6 | Actual Expiry Date | Date | If Applicable | Date the lot expires. Used only for reference. YYYY/MM/DD format |
7 | Effective Expiry Date | Date | If Applicable | Last date that the lot can be sold to customers, transferred to another location or used in manufacturing. It can be the same as the actual expiry date. Used in expiry calculations. YYYY/MM/DD format |
8 | Quantity | Decimal | Required | The quantity on hand. Express in terms of the "Netstock unit of measure" |
Forget about these π π π π Have your say here!

