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.How To calculate a supplier or supplier site balance:
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.
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: