Welcome Guest, you are in: <root>AFIweb • Login

Page History: Invoice Register Report

Compare Page Revisions

13 12 11 10 9 8 7 6 5 4 3 2 1 0 Current 13 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Mon, 06 Apr 2009 11:57

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Standard Report Fields(Header) Standard Report Fields(Line Items)

Default Menu Location¶

Reports >> Account Receivable >> Invoice Register Report

Click here for a screenshot

General 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)¶

•Ic_company

•Ic_report

•Ic_date

Standard Report Fields(Line Items)¶

Invoice/Order:

•alltrim(invno)+"/"altrim(orderno)

Inv Date:

•ttod(invdate)

Cust#:

•custno

Company:

•company

Net Amount:

•subamt-disamt

Sales Tax:

•taxamt

Invoice Total:

•totamt

Balance:

•balance