This report gives a summary of each item grouped by item type. The quantities, order amounts, invoice amounts and paid amounts for each item are shown, along with the totals for each item type, and for all item types.
To Pull the Report
Select Event - Select the event from the drop down to run the report for that specific show, leave at ‘---All—‘ to run the report for all financial events in the system that are associated with the logged in user.
Output Format: HTML, Excel, PDF
Results
Item – Name of the item in financial set up, grouped with its item type. The item type is listed first, in bold, and then the items are listed, followed by the totals for that item type also in bold.
Item GL Code – The GL Code associated with this item in financial set up.
Order Quantity – The total number of units ordered for all companies for the selected event.
Order Amount – Total dollar amount ordered for all companies for the selected event for this item.
Invoice Amount – The total amount for this item that has been invoiced for all companies for the selected event. In automatic financials, this is based on the Payment Schedule. **Make sure you Process Invoices (Events > Financial > Settings - Generate Invoices) before you run Financial Reports to ensure the Invoice Amount is up to date.
Paid Amount – Sum of all the payments against orders of this item for all companies for the selected event.
Grand Total – The total of all the items listed above.