Accounts Receivable > Open Credits > Reports on Open Credit

The Open Credit Report function allows you to generate a report that provides information on customer open credits.

This report has the following uses:

•To track the amount of open credit per customer for a specified period of time.

•To determine the composition of the open credit balances of your customers whether they originate from prepayments, over payments or sales returns.

To print an Open Credit Report, perform the following steps:

1.Access the Open Credit Report function from the Receivable Management 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 Invoice/Receipt # (Customer #) checkbox if you want to generate the report for a single invoice/receipt (customer #) and enter the invoice/receipt # (customer #) in the field; otherwise, select in the Filters area the preferred criteria in generating the report.

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

•Sales Returns and Payments

•Sales Returns Only

•Payments Only

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

oCombine Subsidiary Transactions

Mark this checkbox if you want to show in the report all subsidiary customers transaction combined.

oConsolidate Report

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

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 Open Credit Report 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 Credit Invoice document when you double-click the invoice number in the report.

oReceipt #

AccountMate displays the Cash Receipts Report when you double-click the receipt number in the report.

oCurrency

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

Open Credit Report

Open Credit Report

See Also