Previous  Next          Contents  Index  Navigation  Glossary  Library

Supplier Customer Netting Report

This report displays the net balance in Oracle Payables and Oracle Receivables for any Vendors and Customers who have the same name, NIF Code, or VAT Registration.

The Supplier Customer Netting report will show a transaction listing and total balance for Receivables and Payables where the transactions are in the selected currency and for the selected range of customers or vendors. The report will calculate a net amount owed where a customer and vendor exist, with exactly the same name. This amount will be calculated as Receivables minus Payables.

Report Parameters

Currency Code: Enter the currency code of the transactions you want used to calculate the suppliers or customers balance. If you do not enter a currency code, the report will show the balance for each currency for which transactions exist for that supplier or customer.

Join Criteria: The join criteria for the report. You may join customers and suppliers by NIF Code, Name, or VAT/Tax code.

Supplier/Customer Low - High Range: If your Join Criteria is Supplier/Customer Name, use this parameter to enter the range of Supplier or Customer names to include in the report.

Supplier/Customer NIF Low - High Range: If your Join Criteria is NIF Code, use the this parameter to enter the range of Supplier or Customer NIF Codes to include in the report.

Supplier/Customer VAT Low - High Range: If your Join Criteria is VAT/Tax Code, use this parameter to enter the range of Supplier or Customer VAT/Tax Codes to include in the report.

Report Headings

Currency Code: The report is grouped by currency within supplier/customer. This heading shows which currency balances are being shown in this section of the report. The heading also shows the exchange rate being used if the currency code is not the functional currency for this set of books. The Period End exchange rate must be set up for this exchange rate to be found.

Sub-ledger: This heading shows whether the balances are from Oracle Receivables or Oracle Payables.

Column Headings

Original Amount/Amount Due Remaining (DEM): The original amount/amount due remaining of this invoice in the entered currency. The currency code is shown in brackets.

Original Amount/Amount Due Remaining (GBP): The original amount/amount due remaining of this invoice in the functional currency. The currency code is shown in brackets. The entered currency amount is converted to the functional currency amount using the period end average rate entered in GL.

See Also

Running Standard Reports and Listings

Common Report Parameters

Receivables Standard Reports

         Previous  Next          Contents  Index  Navigation  Glossary  Library