The Calculate Balance Owed window shows how much you owe a supplier and how many unpaid invoices you have in the system for the 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 AutoRate or enter an exchange rate in the Invoices window.
To calculate a supplier or supplier site balance:
Open the Find Invoices window from the Invoices window, either by choosing the Find icon from the Toolbar or by selecting Find from the View 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 calculates the balance based on the combination of criteria you enter. If you do not enter a currency, all invoices are included regardless of currency and the balance is shown in the functional currency.
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 displays and includes in its calculation only paid and available prepayments.
To calculate a supplier or supplier site balance in a foreign currency:
Open the Find Invoices window from the Invoices window, either by choosing the Find icon from the Toolbar or by selecting Find from the View 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 calculates the balance based on the combination of criteria you enter.
Choose Calculate Balance Owed to have Payables navigate to the Calculate Balance Owed window. Payables displays the amounts in both the entered currency and your functional currency.
Enter a default exchange rate for Payables to use to convert into your functional currency your foreign currency invoices that do not have an 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.