Accounts Receivable > Invoice > Invoice Reports

The AR Invoice Line Item Report function allows you to generate a report that shows the line items in the invoices.

This report has the following uses:

•To pinpoint the saleable products by showing you the quantities and values of the inventory item sold over a specified period of time.

•Useful for estimating production needs, planning of shipping volume and analyzing product movements.

To print an AR Invoice Line Item Report, perform the following steps:

1.Access the AR Invoice Line Item Report function from the AR Invoice group under the Reports main menu in the Accounts Receivable module.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

To show multi-currencies in the report, select the option with 'multi-currency' in the layout name. Note that this layout option is only available if the multi-currency feature is activated.

5.In the Report Configuration area, define the report filters. Mark the Individual Customer # checkbox if you want to generate the report for a single customer; otherwise, select in the Filters area the preferred criteria in generating the report.

6.Select any of the following options for which you want to show in the report:

•Invoices and Sales Returns

•Sales Invoices Only

•Sales Returns Only

7.Mark any or all of the following checkboxes:

oInclude Freight Charge

Mark this checkbox if you want to include freight charges in the report.

oInclude Sales Tax

Mark this checkbox if you want to include the sales tax amounts in the report.

oInclude Adjustment

Mark this checkbox if you want to include the adjustment amounts in the report.

oConsolidate Report

Mark this checkbox if you want the report to show the invoices for both the consolidation and subsidiary customers.

oIdentify Upsell Line Items

Mark this checkbox if you want to include in the report an Upsell column, which identifies that the line item was included in the invoice as an upsell item.

oEach Group on New Page

Mark this checkbox if you want the report to display on a separate page each group of information based upon the chosen sorting option. For example, if the Salesperson + Invoice # sorting option is chosen and the Each Group on New Page checkbox is marked, the report will display on each page the invoice line item transactions handled by a particular salesperson.

oShow Kit Formula

Mark this checkbox if you want to display the formula of the kit inventory item in the report.

oShow Serial #

Mark this checkbox if you want to display on the report the serial numbers assigned to the serialized inventory items.

oShow Lot #

Mark this checkbox if you want to display the on the report the lot numbers assigned to the lot-controlled inventory items.

oShow Kit #

Mark this checkbox if you want to display on the report the kit numbers of the kit inventory items.

oShow Item Description

Mark this checkbox if you want to display the descriptions of the inventory items in the report.

oShow Item Class, Prod Line and Inventory Type

Mark this checkbox if you want to display the item class, product line and inventory type in the report. This report option is not available when you sort the report by Item #.

8.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The AR Invoice Line Item Report function also provides you with the flexibility to perform the following:

•Set up user-defined configuration macro

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Include time and printed by information

•Drill-down on certain fields in the report:

oCustomer #

AccountMate displays the Customer Profile when you double-click the customer # in the report.

oInvoice #

AccountMate displays the Invoice document when you double-click the invoice number in the report.

oItem #

AccountMate displays the Item Profile when you double-click the item number in the report.

oComponent Item #

AccountMate displays the Item Profile when you double-click the component item number in the report.

oCurrency

AccountMate displays the Currency Profile when you double-click the currency code in the report.

AR Invoice Line Item Report

AR Invoice Line Item Report

See Also