1. Accounts Receivable Implementation Guide
  2. Understanding Customer and Supplier Balance Reports

Understanding Customer and Supplier Balance Reports

The Supplier Balance A/P Report and Customer Balance Report are different versions of the same program (R7404002). Whether a specific version of the program produces a Supplier Balance A/P Report or Customer Balance Report depends on the processing options.

You print the supplier and customer balance reports to review the detail of the transactions between the company and the customers or suppliers. The reports also show this information for each customer or supplier for a given date range and selected companies:

  • Initial balance

  • Debit and credit balance

  • Closing balance

The supplier and customer balance reports have these additional features:

  • Transactions are printed with debit and credit amounts in separate columns.

  • You can print the report with transaction amounts, including draft amounts, displayed in euro (EUR) or another currency.

  • You can print the report in summary or detail mode.

  • You can use the G/L Class (GLC) for data selection, sequencing, and subtotaling if you group by G/L Offset when you build the Customer/Supplier Balance Worktable (A/P and A/R) (F74412).

  • You can determine customer or supplier balances as of a certain date, based on the "from" and "thru" dates specified in the processing options of the Generate Supplier Balance A/P program (R7404003) and Generate Customer Balance program (R7403B001).

  • Transactions are printed within the period specified in the processing options of the Generate Supplier Balance A/P and Generate Customer Balance programs.

  • You can compare customer and supplier balances by G/L offset or trade account with the account balances.

The supplier and customer balance reports are based on information in the Customer/Supplier Balance Worktable (A/P and A/R) table (F74412). You must build the table using the R7404003 and the R7403B001 programs before you run the customer and supplier balance reports.

The initial balance is calculated as of one day prior to the date specified in the Date From processing options for the R7404003 and the R7403B001 programs.

Note:

  • When a voucher is paid for a supplier who is subject to withholding tax, the amount of withholding tax held can be printed on the line immediately after the payment on the supplier version of the report, depending on how the processing options are set for the Generate Supplier Balance program.

  • The data selection is not available for R7404003 and R7403B001 reports.