Calculate Balance Owed Window Reference

This window shows a supplier balance for the invoices that match the criteria you enter in the Find Invoices window.

Default Exchange Rate: 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.

Take Discount: If you want Payables to reduce the balance by available discounts, then check this check box.

Include Outstanding Future Dated Payments: If you want to include in the Balance Owed the amount in the Future Dated Payments field, then enable this check box, then choose the Calculate button.

Unpaid Amount: Sum of unpaid, validated and unvalidated invoices. This number includes negative amount invoices but does not include unpaid prepayments.

Future Dated Payments: Sum of all outstanding (issued but not matured) future dated payments. If you do not want this amount included in the Balance Owed, then uncheck the Include Outstanding Future Dated Payments check box and then choose the Calculate button.

Less Available Prepayments: Available prepayments (the sum of Temporary, paid, unapplied prepayments) include prepayment Item distributions and the associated tax. Payables does not use unvalidated or unpaid prepayments when it calculates the balance because they are not available for application.

Balance Owed: Unpaid invoice amount minus available prepayments. If you have enabled the Include Outstanding Future Dated Payments check box, then Payables also subtracts the sum of any outstanding (issued but not matured) future dated payments

Number of Invoices: Number of unpaid invoices, not including unpaid prepayments.

Number of Prepayments: Number of available prepayments.

Other Sources