Understanding the Receivables/Payables Netting Report

You print the Receivables/Payables Netting report when you want the system to calculate the potential offsets between open accounts payable balances and open accounts receivable balances.

This report lists information from the F03B11 and F0411 tables.

When you print this report, the system:

1. Totals the open accounts receivable and open accounts payable balances for each account.

2. Compares the two sums.

3. Calculates the potential offsets.

   For example, an account with an open accounts receivable balance of 50,000.00 USD and an open accounts payable balance of 30,000.00 USD has a potential accounts receivable offset of 20,000.00 USD. If the opposite were true, the account would have a potential accounts payable offset.

4. Calculates the net amount of the two offset fields and lists the grand total in the appropriate column.

This report does not have associated processing options.

Before you run this report, update the A/R Netting Workfile table by running the Build Netting Report File program (R03B465).