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

  1. Open the Supplier Ledger Open Items window from the navigator or from the Info Services Reports window.
  2. Click on the Report Parameters tab.
  3. Enter the company.
  4. Specify the range of dates or periods, suppliers, and supplier groups.
  5. Click on the Selections sub tab.
  6. Select a value for the Template ID field using the List of Values.
  7. 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.
  8. Click on the Options sub tab.
  9. Specify a value in the Advance Invoices field to specify how the advance invoices must be dealt with in the report.
  10. Select the Exclude Advance Payments check box if you want to exclude advance payments from the report. 
  11. 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.
  12. If you want to generate a detailed report, select the Print Details check box.  
  13. 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.
  14. 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.
  15. Specify the code parts.
  16. If you want to generate a detailed report, click Yes in the Print Details row. Otherwise, click No.
  17. 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 AP Reports/Reports.