Calculating a Supplier or Supplier Site Balance
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:
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 calculates 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. 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 displays and includes in its calculation any prepayments.
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 calculates 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 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. Payables also displays and includes in its calculation any prepayments.