Consolidated Purchases by GL

The Consolidated Purchases by GL report displays purchasing data that was reconciled over the selected period for all locations within the selected hierarchy. The Grand Total section at the top of the report displays the total for each General Ledger account from all invoices at all of the hierarchy locations. The Location Details section at the bottom displays the total for each GL account from all invoices at each location. Each Location Name is a link to the invoice details for that location, each GL Code is a link to the transactional data for that GL account (at each/all locations), and the Total label is a link to the transactional data for all GL accounts (at each/all locations).

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 > Consolidated Purchases by GL
Menu Paths: Net-Chef > Reports: Purchasing > Consolidated 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

Hierarchy: Select the desired hierarchy level from the drop-down

Funnel (Filters): Location Code, Location Name, GL Code, GL Description, Purchase Amount

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 Company base currency.

Location Code & Name (Location Detail groups) – The Code and Name for the location.
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.

“Drill Down” Links - Grand Totals:

GL Code – Opens a GL Details sub-report w/totals by Product within the selected GL account at all locations within the selected hierarchy.
Grand Total label – Opens a Location Totals sub-report w/totals by GL Code for all purchases at all locations within the selected hierarchy.

“Drill Down” Links - Location Details:

Location Name – Opens a report with transaction details for all purchases within the selected date range at the selected location; equivalent of the Purchases by GL report for that location.
GL Code – Opens a GL Details sub-report w/totals by Product within the selected GL account at that location.
Total label – Opens a Location Totals sub-report w/totals by GL Code for all purchases at that location.