Best Before List
This report lists all examples currently in stock of serial numbered and batch Items. It shows Item Number and Name, Serial or Batch Number, Best Before date, Quantity, Unit Price and Value.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end date of the reporting period. Examples of serial numbered and batch Items in stock whose Best Before dates fall within the reporting period (and with blank Best Before dates) will be included in the report.
- Item No
- Paste Special
Item register
- Range Reporting Alpha
- To restrict the report to particular Items, enter an Item Number or a range of numbers here.
- Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- Enter an Item Group number, to include in the report only those Items belonging to the Item Group.
- Location
- Paste Special
Locations setting, Stock module
- To limit the report to a specific stock Location, enter its code here.
- Department
- Paste Special
Departments setting, Assets module
- Enter a Department Code, to include in the report only those Items assigned to a particular Department (specified on the 'Stock' card of the Item record).
- Exchange Rate
- When goods received are entered with prices and values in foreign Currencies, the stock value can be calculated either using the Exchange Rate from the time of delivery (FIFO principle) or the Exchange Rate at the time of the report. The time of delivery is recommended, because it will show the same values as the FIFO value.
- Valuation Method
- The stock values shown in the report can be calculated using the Base Price (the retail price shown on the 'Pricing' card of the Item record) or the Purchase Price (the FIFO purchase price from the Goods Receipt).