Purchases by GL

The Purchases By GL report displays each invoice that was reconciled over the selected period. The Location Summary section at the top displays the total for each General Ledger account from all of the invoices displayed. The Location Details section at the bottom shows the details for each invoice - the supplier, the invoice number and date, the delivery and reconcile dates, the subtotal per General Ledger account, and the invoice total.

Click the Expand ( V ) or Collapse ( ^ ) controls at the right of a section header to show/hide the details for the desired section.

Menu Paths: Net-Chef > Purchasing: Reports > Purchases by GL
Menu Paths: Net-Chef > Reports: Purchasing > Purchases by GL

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

Report Controls

From/To: Calendar widgets; can select any dates

Funnel (Filters): Supplier, Supplier Code, GL Description, Invoice Number, GL Code, Reconcile Date, Delivery Date

Printer (Export): PDF, Excel, CSV formats

(Gear): Supplier, Supplier Code, Invoice Date, Invoice Number, Delivery Date, Reconcile Date, Invoice Total; the selected sort option is applied to the invoices in the Location Details section

Report Columns - Location Summary/Details

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.

GL Code – The Code for the GL account.
GL Description – The Description for the GL account.
Purchase Amount – Total value of the purchases for the GL account.

Invoice Details:

Invoice Number, Invoice Date – From the vendor’s invoice; entered by the user.
Supplier Code – The vendor or supply location code.
Supplier – The vendor or supply location name.
Submitted (Date & By) – The transaction Create Date and Create User.
(Actual) Delivery Date – The date the purchase was received; entered by the user.
Reconcile Date – The date the transaction was reconciled.
Total – The total cost of the invoice; includes vendor order surcharges.

“Drill Down” Links - Location Summary:

GL Code – Opens a GL Details sub-report w/totals by Product within the selected GL account at that location.
Total label – The sum of the Purchase Amounts for all GLs. Opens a Location Totals sub-report w/totals by GL Code for all purchases at that location.