Order – Supplier Ledger Open Items
Explanation
Use this activity to view or print the Supplier Ledger Open Items report. This
report displays all unpaid invoices and supplier payments on account. It is useful
for
internal checking against the general ledger. You can display total supplier balances or detailed
information about each supplier. 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 supplier
ID, supplier name, or by ledger account.
Prerequisites
This activity requires that open items exist in the supplier ledger.
System Effects
As a result of this entry, the report is either printed or displayed on the
screen.
Window
Report – Supplier Ledger
Open Items
Related Window Descriptions
Report – Supplier Ledger Open Items
Procedure
- Open the Supplier Ledger Open Items window from the navigator or from
the
Info Services Reports
window.
- Click on the Report
Parameters tab.
- Enter the company.
- Specify the range of dates or periods, suppliers, and supplier groups.
- 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.
- Click on the Options
sub tab.
- Specify a value in the Advance
Invoices field to specify how the advance invoices must be
dealt with in the report.
- Select the Exclude Advance Payments check box
if
you want to exclude advance payments from the report.
- Select the Exclude not Cashed/Open Payment
Documents check box so that open payment documents like checks or bills of
exchange will not be shown in the report.
- If you want to generate a detailed report, select
the Print Details check box.
- Select the Print Separate Debit and Credit
Amounts check box so that the debit and credit amounts
in the vouchers are printed individually. If this check box is not selected
then all amounts from voucher rows will be shown as a total amount.
- If the Subtotals per Currency check box is
selected, all open items will be grouped according to the accounting
currency of each supplier and a summarized total for each currency will be
presented at the end of the report.
- Specify the code parts.
- If you want to generate a detailed report, click Yes in the Print Details
row. Otherwise, click No.
- Click Print to print the report, or click Preview to view it on the
screen. If you choose to print the report, specify whether it will be sorted by
the supplier ID,
supplier name, or by ledger account.
Note: Alternatively, you can view or print this report from the Info
Services/Order Reports window.