Master Records > Customer > Customer Reports > Customer Transaction Detail Listing

The Customer Transaction Detail Listing function allows you to generate a report that provides detailed information on the customers' sales invoice transactions. More specifically, this report provides detailed information on the line items included in sales invoices.

This report has the following use:

•To determine what sales invoice transactions have been created for the customer for the specified period.

•To use as a supporting document in the reconciliation of the customer account balance.

To print a Customer Transaction Detail Listing, perform the following steps:

1.Access the Customer Transaction Detail Listing function from the Transaction Log 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.

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

6.Select which of the following you want to include in the report:

•Invoices and Payment Transactions

•Invoice Transactions Only

•Payment Transactions Only

7.Mark any or all of the following checkboxes, if applicable:

oInclude Voided Invoices

Mark this checkbox to include the voided invoices in the report; since the line items were deleted upon voiding, only the invoice # and date will be shown.

oInclude Voided Payments

Mark this checkbox to include the voided payments in the report.

oShow Kit Formula

Mark this checkbox if you want to display on the report the kit item formulas.

oShow Serial #

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

oShow Lot #

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

oShow Kit #

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

oConsolidate Report

Mark this checkbox if you want the report to show the sales invoice transactions for both the consolidation and subsidiary customers. This report option is only available when you sort the report by Customer #.

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 Customer Transaction Detail Listing function also provides you with the flexibility to perform the following:

•Set up user-defined report 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 number in the report.

oInvoice #

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

oSO #

AccountMate displays the Sales Order document when you double-click the sales order number in the report.

oItem #

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

Customer Transaction Detail Listing

Customer Transaction Detail Listing

See Also