Order – Customer Ledger Open Items Report

Explanation

Use this activity to view or print the Customer Ledger Open Items report. This report displays all unpaid invoices and customer payments on account. It is useful for internal checking against the general ledger. You can display total customer balances or detailed information about each customer. You can also select by code string. For example, if your company needs to follow up on the code part used for cost centers, you can specify a code part value and compare the report against the general ledger. When you print the report, you can specify whether it will be sorted by the ledger account, customer ID, or customer name. 

Prerequisites

In order to perform this activity:

• Open items must exist in the customer ledger.
• AR selection template must be defined in the AR Selection Template window.

System Effects

As a result of this activity, the report is either printed or displayed on the screen.

Window

Customer Ledger Open Items

Related Window Descriptions

Customer Ledger Open Items
Account Receivable Selection Template

Procedure

1. Open the Customer Ledger Open Items window from the navigator or from the Info Services Reports window.
2. Click on the Report Parameters tab.
3. Select the Period option and enter the year and period up to which the transactions should be fetched. By default the Period option is selected with the current year and the period.
4. Click on the Selections sub tab.
5. Select a value for the Template ID field using the List of Values.
6. Enter from/to values for the selection objects or add new selection objects with from/to values according to the way you want to order the report. If you want the selection information to be saved in a new template, click Create Template and define a new template ID in the Create Selection Template dialog box. Note that the information cannot be saved in the currently selected template or any other existing template.
7. In the Options tab, select a value for the Ledger Status field from the list to specify the ledger status of the transactions to be included in the report. If you select Bad Debt from the Ledger Status field, then enter a value in the Bad Debt Level field.
8. In the Advance/Prepayment Invoices field select a value from the list to indicate whether advance/prepayment invoices should be included in the report. If Include is selected, advance invoices/prepayment based invoices, as well as other ledger items will be included in the report. If Exclude is selected, advance invoices/prepayment based invoices will be excluded from the report. If Only is selected, advance invoices/prepayment based invoices will be included in the report, but all other invoice ledger items will be excluded.
9. Select the Exclude Advance Payments check box if you want to exclude advance payments from the report.
10. Select the Exclude Payments on Account check box if you want payments on account to be excluded from the report.
11. Select the Exclude Not Cashed/Open Documents check box if you want to exclude non cashed/open payment documents like checks or bills of exchange from the report.
12. Select Customer Name option if you want to group the transactions in the report based on the name of the customer. By default the Customer ID option is selected.
13. Select the Summary Only check box if you want to print summarized report.  
14. Select the Subtotals per Currency check box if you want to group all the open items according to the accounting currency of each customer and summarize total for each currency at the end of the report. 
15. Select the Print Separate Debit and Credit Amounts check box if you want the debit amounts and the credit amounts resulting from the transactions to be separately disclosed in the report.
16. Select the Split Report checkbox to split the report, when a report is generated for more than one customer. A summary report is printed in addition to the generated report(s). However, the report will not be split, when it has to be generated for a single customer.
17. Specify the maximum number of lines to be included in the report in the No of Lines field. The value specified in this field is used when the report is generated for more than one customer.
18. Click Forecast, to view the number of reports, including the summary report, which will be created in accordance with the value specified in the No of Lines field.
19. Click OK to order the report.