Best Before List
The Best Before List report is a list of the Serial Numbers with Best Before Dates that are currently in stock. It includes Items that are Serial Numbered at the unit and batch levels. The Best Before Dates will be taken from the
Batch Specifications setting. Serial Numbered Items that do not have Best Before Dates will not be included in the report.
For each Serial Number, the report shows the Item Number and Name, Serial or Batch Number, Best Before Date, quantity in stock, unit sales or purchase price and value (quantity in stock * unit price).
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the start and end dates of the reporting period. The report will list the Serial Numbers that are in stock and that have Best Before Dates that fall within this period.
- Item No
- Paste Special
Item register
- Range Reporting Alpha
- To restrict the report to particular Items, enter an Item Number or a range of Item Numbers separated by a colon (:) here.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- Range Reporting Alpha
- If you need Items belonging to a particular Item Group to be listed in the report, specify that Item Group here. You can also enter a range of Item Groups.
- Item Classification
- Paste Special
Item Classifications setting, Sales Ledger
- Enter a Classification Code in this field if you only need Items with a certain Classification to be included in the report. If the field is empty, all Items, with and without Classification, will be included. If you enter a number of Classifications separated by commas, only those Items featuring all the Classifications listed will be shown. If you enter a number of Classifications separated by plus signs (+), all Items featuring at least one of the Classifications listed will be shown. If you enter a Classification preceded by an exclamation mark (!), all Items featuring any Classification except the one listed will be shown.
- For example:
- 1,2
- Lists Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Lists Items with Classifications 1 or 2.
- !2
- Lists all Items except those with Classification 2.
- 1,!2
- Lists Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 are not shown). Note the comma before the exclamation mark in this example.
- !1,!2
- Lists all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Lists all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be listed).
- !1+2
- Lists Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be listed).
- (1,2)+(3,4)
- Lists Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Lists Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Lists Items with Classifications beginning with 1 but not 1 itself.
- *1
- Lists Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Lists Items with Classifications beginning and ending with 1.
- Location
- Paste Special
Locations setting, Stock module
- If you need the report to list the Serial Numbers that are in stock in a specific Location, specify that Location here.
- Department
- Paste Special
Departments setting, Assets module/System module
- Enter a Department Code if you need the report to list the Items that you have assigned to a particular Department (using the Department field on the 'Stock' card of each Item record).
- Exchange Rate
- These options are only used if the Valuation Method (below) is "Purchase Price", and with Serial Numbers that were received into stock using Goods Receipts and Returned Goods records in Currency (i.e. not with Serial Numbers that were received into stock using Productions or with Serial Numbers that were moved from one Location to another using Stock Movements).
- If you received a Serial Number into stock using a Goods Receipt or Returned Goods record in Currency, these options will specify whether its purchase price in the report will be converted to your home Currency using either the Exchange Rate from the time of receipt (FIFO principle) or the Exchange Rate at the time of the report. The time of receipt is recommended, because it will show the same values as the FIFO value.
- Valuation Method
- Use these options to specify whether the report should show the sales price of each Serial Number (i.e. the Item's Base Price, from the 'Pricing' card of the Item record) or its purchase price (from the Goods Receipt, Production, Returned Goods record or Stock Movement).
---
Reports in the Stock module:
Go back to:
Introduction to Reports in the Stock Module
