Standard AQ - Invoice Register AQ

Report Description

This proposed AQ would display all invoice information in a comprehensive register format, enabling users to track, manage, and export invoice data to Excel and QuickBooks for improved financial reporting.

(click the image to open a larger view in a new tab)

Parameters

Parameter Name	Options	Description
Branch (Assignment)	All available branches
Date Type	Accounting Period Date, Invoice Date, Date Posted	Accounting Period Date, Invoice Date or Date Posted
Start Date
End Date
Customer Name		Filters results by Customer Name
Roll Up to Parent Customer	True/False	Based on this parameter, results will either displayed per individual customer department or rolled into Root Customer.

Report Fields

Field Name	Description
StaffingCompany	Invoice Supplier
BranchName	Invoice Branch Name
CustomerID	Customer ID
CustomerName	Customer Name
DepartmentName	Department Name
AccountingPeriodDate	Accounting Period Date
PostedDate	Invoice Posted Date
InvoiceDate	Invoice Date
InvoiceNumber	Invoice Number
InvoiceAmount	Invoice Amount
SalesTax	Total Sales Tax levied on Invoice
DiscountAmount	Total Amount discounted
FinanceCharge	Total Finance Charge accumulated for the invoice
ACAAdminFee	Total ACA Admin Fee associated with the Invoice [Transaction type with system name=ACAAdminFee]
PaymentAmount	Total Amount paid to the invoice
BalanceAmount	Balance Amount for the invoice
BillAmount	Bill Amount from Invoice