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
- Open the Customer Ledger Open Items window from the navigator or from
the
Info Services Reports
window.
- Click on the Report
Parameters tab.
- 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.
- Click on the Selections
sub tab.
- Select a value for the Template ID field using the List of
Values.
- 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.
- 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.
- 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.
- Select the Exclude Advance Payments check box
if
you want to exclude advance payments from the report.
- Select the Exclude Payments on Account check box if you want
payments on account to be excluded from the report.
- 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.
- 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.
- Select
the Summary Only check box if you want to print summarized report.
- 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.
- 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.
- 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.
- 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.
- 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.
- Click OK to order the report.