Where FIFO (First in First out) has been switched on for the currently selected company, the FIFO Review form is available. It is designed to assist you in reviewing FIFO cost records created on your system. The form may be filtered in a variety of ways in order to display exactly the result you wish to review.
The concept of a FIFO system is as follows:
To create cost records for parts as they are brought onto your system through Purchase Control
To keep track of the quantity purchased at that cost, and when sold through Point-of-Sale use this cost of the part rather than the more usual average cost
The quantities sold are then updated against this record until such time as all the available stock for that record has been sold. Additionally, as more of the same part (either at the same or at potentially different costs) are received into the system, multiple records are created corresponding to the sequence in which they are purchased. This allows the stock which was costed earliest to be sold first in Point-of-Sale.
This form is displayed when you click File > Review FIFO details on the Purchase Control form, or click the Review FIFO details button. It enables you to review FIFO cost records created on your system.
Menu bar | Toolbar | Action |
---|---|---|
File > Reset filter | ![]() |
If any filters have been set, resets all filters back to the default of All record types currently at Open status. |
File > Exit | ![]() |
Returns you to the Purchase Control form. |
Help > Help | ![]() |
Displays this help topic in a web browser. |
Choose the filter criteria if required in order to display all records that match your selection in the results group. You can view and amend individual record details by double-clicking the record or right-clicking it and clicking Amend.
Filter Group:
Status: Click the drop-down button to select one of the following:
- O: Open records (default)
- C: Closed records
- B: Both open and closed records
Part numbers: Specific part to filter on.
Supplier account: Specific supplier account to filter on (click the Ellipsis button
to search).
GRN number: Specific GRN number to filter on.
Supplier invoice no:: Specific supplier invoice number to filter on.
Date received from and to: Specific range of received dates to filter on.
Results Grid:
The grid displays the following for each record matching the selection made.
PO number: Purchase order number
Part number: Identifies the part
Supplier: Identifies the supplier
GRN: Supplier documentation reference number, either an advice note number, delivery note number or invoice number
Date received: Date when the part was received
Invoice number: Identifies the number of the invoice
Status: A green tick symbol indicates an open record and a red cross symbol indicates a closed record.
Note: An open FIFO cost record is defined as a record where all or some of the purchased quantity remain unsold. A closed FIFO cost record is defined as a record when all the stock for the record has been sold, so that the purchase quantity and sold quantity match.
Quantity purchased: Identifies the number of this part purchased
Quantity sold: Identifies the number of this part sold
Purchase value: Total purchase value