(Contents)

FIFO Review

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:

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.

FIFO Review Form

This form is displayed when you click File > Review FIFO details on the Purchase Control form, or click the Review FIFO details TableAmend.gif button. It enables you to review FIFO cost records created on your system.

Menu bar Toolbar Action
File > Reset filter HideAutomaticUpdates.gif If any filters have been set, resets all filters back to the default of All record types currently at Open status.
File > Exit Exit.gif Returns you to the Purchase Control form.

Help > Help Help2.gif 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:

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

Related Topics:

Amending FIFO Details