Page History: Invoice Register Report
Compare Page Revisions
Page Revision: Mon, 06 Apr 2009 12:06
Default Menu Location
Reports >> Account Receivable >> Invoice Register Report
Click here for a screenshotGeneral Description
This screen generates
Invoice Register Report with the Order Number, Invoice Date, and the Amount for all the customers by a specific time frame.
Report Filters
Customer ID: Enter the Customer ID number in the field provided to run the report.
Start Date: Enter the start date for the report.
End Date: Enter the end date for the report.
Terr: Select a territority from the menu.
Invoice Status: Select a status of the invoice.
Order Type: Select an order type.
Sort By: The report can be generated by --
Invoice #, Customner Number, Customer Name, SO#, SP.Summary or Detail: Choose the type of report to be generated.
Show GLDist: Check the box for GL distribution list.
Standard Report Fields(Header)¶
Every customer's report is different. Here is a general Headings for a report.
Company Name, and the Report Header
•Ic_company
•Ic_report
•Ic_date
Standard Report Fields(Line Items)¶
Invoice/Order: The invoice number and the order number.
•alltrim(invno)+"/"altrim(orderno)
Inv Date: The date invoice was generated.
•ttod(invdate)
Cust#: The customer number for the invoice.
•custno
Company: The company name for the invoice.
•company
Net Amount: The net amount of the invoice.
•subamt-disamt
Sales Tax: The sales tax for the invoice.
•taxamt
Invoice Total: The total amount for the invoice.
•totamt
Balance: The total balance of the invoice.
•balance
