How to check total outstanding you need to pay to a Supplier R12

How to check total outstanding you need to pay to a Supplier

Use the Find Invoices window and choose the Calculate Balance Owed button to see how much you owe a supplier and how many unpaid invoices you have in the system for the supplier.

To calculate the balance owed, Payables subtracts available prepayments from the unpaid invoice amount. Payables does not use unpaid prepayments when it calculates the balance.

If you have foreign currency invoices that do not yet have exchange rates, you can calculate the balance with an exchange rate you enter in the window. The exchange rate you enter will not update the invoices; you are still required to submit Auto Rate or enter an exchange rate in the Invoices window.

How To calculate a supplier or supplier site balance:

Navigation:
Invoices > Inquiry > Invoices
Enter Supplier Name or Supplier Number
and Click on 'Calculate Balance Owed' on the bottom left

1. Open the Find Invoices window from the Invoices window, either by choosing the Find icon from the Toolbar or by selecting Find from the Query menu. Enter the supplier name, site name, or other unique supplier or supplier site information. Optionally restrict the balance to invoices of a particular status or hold. Payables calculate the balance based on the combination of criteria you enter.

It opens "Calculate Balance Owed" form Select the Operating Unit and click on "Calculate" that shows Unpaid Amount.

2. Choose Calculate Balance Owed to have Payables navigate to the Calculate Balance Owed window. Optionally check Take Discount to have Payables reduce the balance by available discounts. Choose Calculate to have Payables display the total due amount and the total number of unpaid invoices that match the criteria you entered. Payables also display and include in its calculation any prepayments.

How To calculate a supplier or supplier site balance in a foreign currency:

1. Open the Find Invoices window from the Invoices window, either by choosing the Find icon from the Toolbar or by selecting Find from the Query menu. Enter the supplier name, site name, or other unique supplier or supplier site information. Enter the currency for which you would like to calculate the balance. Optionally restrict the balance to invoices of a particular status or hold. Payables calculate the balance based on the combination of criteria you enter.

2. Choose Calculate Balance Owed to have Payables navigate to the Calculate Balance Owed window.

Enter a default exchange rate for Payables to use to convert into your functional currency your foreign currency invoices that do not have exchange rates. Choose Calculate to have Payables display for the invoices that match your criteria the Balance Owed in both the foreign and functional currency, and the total number of unpaid invoices. Payable also displays and includes in its calculation any prepayments.