Purchase Journal

The Purchase Journal lists all purchases reconciled over a specific period, indicating the supplier, delivery date, invoice total, and subtotals by category. Grand totals for the period are displayed at the top of the report.

Menu Paths: Net-Chef > Purchasing: Reports > Purchase Journal
Menu Paths: Net-Chef > Reports: Purchasing > Purchase Journal

Transactions Included: Reconciled – Vendor Orders, Vendor Returns, Commissary/Customer Orders (Physical & Final), Purchases By Invoice, Location Transfers

Report Controls

Location: (Cruise, Corporate only) – Select the desired location from the drop-down

Date Range Start/Finish: Calendar widgets; can select any dates

Default Date Range: Last 30 Days, Last 60 Days, Last 90 Days, Last 120 Days

Group By: Supplier, Invoice Date, Delivery Date, Reconcile Date

Funnel (Filters): Any report column; "Supplier" drop-down includes all those linked to the same market as the current location

Printer (Export): PDF, Excel, CSV formats

Report Columns:

Click any column header to sort by the data in that column. {Note}: Values in this report are expressed in the location's base currency.

Invoice (Number) –Displays the number from the vendor’s invoice; entered by the user.
Transaction # (Hyperlink) – Displays the system assigned transaction number; based on the numbering schemes defined in Enterprise Manager. The link opens the View screen for the selected transaction.
Trans. Type – Displays ‘CO’, ‘VO’, ‘VR’, ‘LT’, or ‘PBI’.
Invoice Date – Displays the date from the vendor’s invoice; entered by the user.
(Actual) Delivery Date – The date the purchased was received; entered by the user.
Reconcile Date – The date the transaction was reconciled.
Supplier – The vendor or supply location that filled the order.
Invoice Total – The sum of [ Invoice Qty x Invoice Price ] for all products + (for vendor orders) shipping and other charges, according to the vendor’s invoice.
Actual Total – The sum of the Category columns, calculated as [ Physical Qty x Price Used ] for all products in each category; Price Used is either Contract or Invoice, based on the vendor’s pricing rules. "Misc" covers all other categories and includes shipping and other charges.
Variance = [ Invoice Total – Actual Total ]. When the Invoice Total > Actual Total, the resulting value is a positive number, which is displayed in red text. This indicates that the location is owed a credit.

The remaining columns show data for the Categories with the “Report” box checked in the Category setup screen in Enterprise Manager.