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. Enter the company.
  2. Specify the range of dates or periods, suppliers, and supplier groups.
  3. Enter the project activity ID.
  4. Select the currency using the List of Values.
  5. Specify a value in the Advance Invoices field to specify how the advance invoices must be dealt with in the report.
  6. Select the Exclude Advance Payments check box if you want to exclude advance payments from the report. 
  7. 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.
  8. If you want to generate a detailed report, select the Print Details check box.  
  9. 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.
  10. 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.
  11. Specify the code parts.
  12. If you want to generate a detailed report, click Yes in the Print Details row. Otherwise, click No.
  13. 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.