This report displays a list of each customer's total balances due, divided into three time periods. You can define the length of these periods starting from a specified date. There is also a column with the customer's balance before the first specified time period and a column with the customer's balance after the last specified time period.
The customer's balance due can be shown in foreign currencies for each currency the customer does business in or it can be shown in LCY. The report can be used to manage issuing reminders, to evaluate a customer's creditworthiness or to prepare liquidity analyses.
You can define what is included in the report by setting filters. You can set additional fields on the Customer tab by clicking the Field field, and then clicking the AssistButton that appears to the right. You can also determine what is shown in the report by filling in the fields on the Options tab. Fill in the fields as follows:
No.: Enter the numbers of the customers to be included in the report. To see the existing customers, click the Filter field, and then click the AssistButton that appears to the right.
Search Name: Enter the search names of the customers to be included in the report.
Customer Posting Group: Enter the customer posting groups to be included in the report. To see the existing customer posting groups, click the Filter field, and then click the AssistButton that appears to the right.
Currency Filter: Enter the codes for the currencies to be included in the report. To see the existing currencies, click the Filter field, and then click the AssistButton that appears to the right.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the table.
Starting Date: Enter a date to specify the beginning of the period covered by the report.
Period Length: Specify the length of each of the three periods. For example, enter "1M" for one month.
Show Amounts in LCY: Place a check mark in the check box if you want amounts in the report to be displayed in LCY. Leave this field blank if you want to see amounts in foreign currencies.
Click the Print button to print the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.