Purchase Detail Report

This report lets users analyze purchasing activity (not including purchases by invoice) for the selected time period for one location or for the entire company. It displays the details of all received vendor orders, commissary orders and location transfers. This report can display product details for each order, or it can be summarized by product, category, subcategory, microcategory, or general ledger account. Upon retrieval, the report is grouped by "Supplier/Invoice."

Transactions Included: Reconciled Vendor Orders, Vendor Returns, and Location Transfers, Physical and Final Reconciled Warehouse or Commissary Orders

Report Controls

Location: All (default), or select a location from the drop-down. {Franchise Note}: When "Locations" = 'All', franchisees can retrieve data for their own locations but franchisors can retrieve data for all locations.

Currency: Corporate users can run this report for 'All' Locations or for a specific location. When retrieved for multiple locations, report values are expressed in the Company Base Currency. When retrieved from Corporate for a single location, the user can select either the Company or Location Base Currency (if not the same).

Period: Current Month, Current Post, Current Week, Day, Period (limited to 31 days), Post

Group By: Category, Product, Supplier, Delivery Date, Invoice Date, Microcategory, Reconcile Date, Subcategory, Supplier/Invoice (default). For multiple locations, also Location, Location/{option}, Market, Market/Category, Market/Supplier.

Summarize: Product, Category, Subcategory, Microcategory, GL {Note}: Summarize and Filter options will vary based on the "Group By" setting.

Sort by: Any report column (ASC, DESC)

Funnel (Filters): Any report column; Supplier Code, Supplier Name, Location Code, Location Name

Printer (Export): PDF, Excel, CSV formats

-><-, <-->: Click to minimize/maximize the report header

Report Columns: The actual columns shown will depend on how the report is grouped, and on whether or not it has been summarized. The report data includes:

Location – Visible when retrieved for multiple locations and not grouped by location.
Supplier Name and Supplier Code – The name and number of the vendor.
Reconcile Date – The date the transaction was reconciled.
(Actual) Delivery Date, and Invoice Date
Transaction Number – The system-generated transaction number.
Invoice Number – From the vendor’s invoice; entered during reconcile. Displays 'Awaiting Invoice' for physically reconciled vendor orders expecting an e-invoice.
Product Number and Product Name – The number and name of the product.
Quantity – The physical quantity received (in inventory units); from the reconciled order.
Price Used – The unit price used to update the inventory valuation (contract price or invoice price, depending on the vendor's Pricing Rules settings).
Invoice Total = [ Invoice Quantity x Invoice Price ]; from the reconciled order. {Note}: The total row for each invoice will include all applicable taxes and charges in the "Invoice Total.
Inventory Total = [ Quantity x Price Used ]
Other – Tax, Freight/Shipping. Misc. 1, & Misc. 2 charges; from the reconciled order.
Contract Discrep. = [ Invoice Total – Inventory Total ]
Trans. Type – Displays 'VO' (Vendor Orders & Returns), 'CO' (Commissary Orders), 'WO' (Warehouse Orders), or 'LT' (Location Transfers).