Best Before List
This page describes the Best Before List report in the Stock module.
---
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
- If you need to produce a report for a particular Item or 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 an Item Classification in this field if you only need Items with a particular 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, the report will only include Items featuring all the Classifications that you have listed. If you enter a number of Classifications separated by plus signs (+), all Items featuring at least one of the Classifications listed will be included in the report. If you enter a Classification preceded by an exclamation mark (!), the report will include Items featuring any Classification except the one listed.
- For example:
- 1,2
- Includes Items with Classifications 1 and 2 (including Items with Classifications 1, 2 and 3).
- 1+2
- Includes Items with Classifications 1 or 2.
- !2
- Includes all Items except those with Classification 2.
- 1,!2
- Includes Items with Classification 1 but excludes those with Classification 2 (i.e. Items with Classifications 1 and 2 will not be included). Note the comma before the exclamation mark in this example.
- !1,!2
- Includes all Items except those with Classification 1 or 2 or both. Again, note the comma.
- !(1,2)
- Includes all Items except those with Classifications 1 and 2 (Items with Classifications 1, 2 and 3 will not be included).
- !1+2
- Includes Items without Classification 1 and those with Classification 2 (Items with Classifications 1 and 2 will be included).
- (1,2)+(3,4)
- Includes Items with Classifications 1 and 2, and those with Classifications 3 and 4.
- 1*
- Includes Items with Classifications beginning with 1 (e.g. 1, 10, 100).
- 1*,!1
- Includes Items with Classifications beginning with 1 but not 1 itself.
- *1
- Includes Items with Classifications ending with 1 (e.g. 1, 01, 001).
- 1*,*1
- Includes 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/Human Resources Management/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, with Serial Numbers that were moved from one Location to another using Stock Movements or with Serial Numbers that have been revalued using Stock Revaluations).
- 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, Stock Movement or Stock Revaluation).
---
Go back to:
|
Introduction to Reports in the Stock Module
