In the item list their will be an additional function which specifies the lot number and best before date (these will also be editable from the items section). Additionally, when creating a quickreport you will be able to view the details of the lot numbers and best before date.
When receiving a bill from a purchase order there needs to be an additional section to include lot number and a best before date per line item added. Changes will be reflected to inventory and the items list.
The invoices section will show lot numbers correlating to items to the right of ‘item’ but will not be editable from the invoice sheet.
Reports will include a sales by best before date feature which will specify a list of customer sales by best before date.
Reports will include a sales by lot number function which will specify a list of customer sales by lot number.
Logic (First in First Out):
Reports by Inventory by best before date.
Reports by Inventory by lot number.
Reports by quantity ordered
Reports by quantity shipped
Every time a new lot # is entered into a new bill when receiving a purchase order it is compared with previous lot numbers of the same item type and may not be used until items of the same type but sooner expiration date are sold.