Suggested Payments

The suggested payments report provides a list of your supplier transactions that have an outstanding balance. You can filter the transactions that are displayed on the report using the different boxes on the form. The report shows the invoices that are payable either because the payment due date has been reached or because they can be paid early to take advantage of settlement discounts offered by your suppliers. If you use the multi-currency feature, the report shows currency values for foreign suppliers. You can choose to include only suppliers that use a specific currency, or you can include all currencies.

To save this report as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.

Box	Description
Range	You can choose one or more bank accounts to include on the report. You can select home currency and Euro bank accounts, and, if you use the multi-currency feature and have ticked the Foreign banks on Sugg. Paym option on the Purchase Ledger - Utilities - Set Options form, you can also select other foreign currency bank accounts, for example US Dollar accounts. These boxes are disabled if the option on the System - Maintenance - Company Profiles form that links the Purchase Ledger to the Nominal Ledger is not selected.
Default Banks Only	Select this option to only include suppliers that have the chosen bank account/s as the default bank account on the Purchase Ledger - Processing - Options form linked to the supplier record. Any suppliers that do not have a specific default bank will also be included if the ledger-wide bank account (on the Purchase Ledger - Utilities - Set Options form) is chosen in the Range boxes.
Allow Multiple Banks	Select this option to include suppliers on the report that have the Multiple Bank A/C box ticked on the Purchase Ledger - Processing - Options form. All suppliers in the chosen range are then included on the report, even if the bank account on the supplier's record is different to those selected in the Range boxes.
Processing date	Enter the date to be used to determine the selection of transactions according to their due dates. The default date is the current system date.
Sequence	Select the criteria by which the report is sorted and sub-totalled. If you choose Account, you can select a range of supplier accounts to include on the report. If you choose Type, you can select a range of supplier types to include on the report. Each supplier is optionally allocated a supplier type on the Purchase Ledger - Processing - Analysis form.
Use Sett Disc Terms To Calculate Due Date	You can select transactions up to a due date you specify and on the basis of a range of supplier accounts. If you select this box, the following occurs: If settlement discount has been included in the transaction then a further due date will be calculated. If a second settlement discount was included in the transaction then a further due date will be calculated. The application uses the transaction date plus the number of suggested payment days (as defined on the Purchase Ledger - Utilities - Set Options form) to calculate the settlement discount due dates. These further due dates are used to determine whether transactions should appear in the report and the reason. If any of the transactions' due dates fall between the date entered in the Processing date box and this processing date plus the suggested payment days, the transaction appears on the report. Example ... An invoice has a transaction date of August 1st. It includes settlement discount for both Days 1 (by 11 August) and Days 2 (by 21 August). The due date that was entered when posting the transaction is 31 August. - The number of Suggested Days for Payments (on the Purchase Ledger - Utilities - Set Options form) is 3. - The Processing date is 10 August. - The Use Sett Disc Terms To Calculate Due Date option is selected. The Suggested Payments report, Authorise Cheques and Authorise BACS commands will include the transaction with a reason of Settlement 1. The reason it does so is the 11 August (the first Settlement Discount date) falls between the 10 August (the Processing date) and 13 August (10 August plus the Suggested Payment days of 3). If the Processing date is 20 August, the invoice will appear as Settlement 2. If the Processing date is 29 August, the invoice will appear as Due.
Select Currency	Either accept the default for all currencies (ALL) which will include transactions for all suppliers, or click to select the currency for the suppliers you want to include on the report. For example, to include only US Dollar invoices, select that currency from the list; to include only Euro invoices, select that currency from the list, and so on. The currencies you can select are those set up on the System - Maintenance - Exchange Rates form.
Payment Method	Select 'Cheque', 'BACS' or 'Other'. Only suppliers with the selected payment method are included in the listing. The Pay By payment method is defined on the Purchase Ledger - Processing - Terms form. You can use a Payment Method of Other if, for example, you pay your suppliers by credit card or direct debits. Suppliers with this payment method will not be included in any automatic payment-run.
Include only if VAT Return Reduction By for Sett Disc is 'VAT Adjustment'	This option relates to processing VAT Adjustment postings when you take settlement discount terms. Select to include only invoices that attract settlement discount and you use a VAT adjustment posting rather than a credit note to process: the discount for the reduction in the goods and VAT values, and a VAT adjustment posting rather than a credit note to adjust the goods and VAT values on the VAT Return. What controls how Opera calculates VAT on invoices with prompt payment discount? From 1 April 2015, VAT in the UK must be calculated before any prompt payment discount (settlement discount) is calculated. Your VAT Return must be updated with the full VAT value when an invoice is posted, even if settlement discount is offered. How do you make sure VAT is calculated before prompt payment discount is calculated? If you use the EC VAT application ... Make sure the VAT After Discount (Settlement) option is selected on the EC VAT - Maintenance - Countries form. If you don't use the EC VAT application ... Make sure the VAT calculated before settlement discount from date is entered on the System - Maintenance - Company Profiles form. If the settlement discount is taken when an invoice is paid, an accounting adjustment must be made which does the following: post the discount for the reduction in the goods and VAT values adjust the goods and VAT values on the VAT Return. The accounting adjustment can be posted using either a credit note or a VAT adjustment after the receipt or payment is posted: In the Purchase Ledger you define on each supplier record how the adjustment will be posted. In the Sales Ledger you can define it either from the Sales Ledger - Utilities - Set Options form, or on each customer record. Important: Customers are set to 'Company Default' for this purpose, so each customer uses the default setting on the Sales Ledger - Utilities - Set Options - Settlement Discount Options form. Suppliers are set to 'Credit Note' by default for this purpose. You may need to change them if necessary.

Box

Description

Range

You can choose one or more bank accounts to include on the report. You can select home currency and Euro bank accounts, and, if you use the multi-currency feature and have ticked the Foreign banks on Sugg. Paym option on the Purchase Ledger - Utilities - Set Options form, you can also select other foreign currency bank accounts, for example US Dollar accounts.

These boxes are disabled if the option on the System - Maintenance - Company Profiles form that links the Purchase Ledger to the Nominal Ledger is not selected.

Default Banks Only

Select this option to only include suppliers that have the chosen bank account/s as the default bank account on the Purchase Ledger - Processing - Options form linked to the supplier record. Any suppliers that do not have a specific default bank will also be included if the ledger-wide bank account (on the Purchase Ledger - Utilities - Set Options form) is chosen in the Range boxes.

Allow Multiple Banks

Select this option to include suppliers on the report that have the Multiple Bank A/C box ticked on the Purchase Ledger - Processing - Options form. All suppliers in the chosen range are then included on the report, even if the bank account on the supplier's record is different to those selected in the Range boxes.

Processing date

Enter the date to be used to determine the selection of transactions according to their due dates. The default date is the current system date.

Sequence

Select the criteria by which the report is sorted and sub-totalled. If you choose Account, you can select a range of supplier accounts to include on the report. If you choose Type, you can select a range of supplier types to include on the report. Each supplier is optionally allocated a supplier type on the Purchase Ledger - Processing - Analysis form.

Use Sett Disc Terms To Calculate Due Date

You can select transactions up to a due date you specify and on the basis of a range of supplier accounts. If you select this box, the following occurs:

If settlement discount has been included in the transaction then a further due date will be calculated. If a second settlement discount was included in the transaction then a further due date will be calculated.
The application uses the transaction date plus the number of suggested payment days (as defined on the Purchase Ledger - Utilities - Set Options form) to calculate the settlement discount due dates. These further due dates are used to determine whether transactions should appear in the report and the reason.
If any of the transactions' due dates fall between the date entered in the Processing date box and this processing date plus the suggested payment days, the transaction appears on the report.

Example ...

Select Currency

Either accept the default for all currencies (ALL) which will include transactions for all suppliers, or click to select the currency for the suppliers you want to include on the report. For example, to include only US Dollar invoices, select that currency from the list; to include only Euro invoices, select that currency from the list, and so on.

The currencies you can select are those set up on the System - Maintenance - Exchange Rates form.

Payment Method

Select 'Cheque', 'BACS' or 'Other'. Only suppliers with the selected payment method are included in the listing. The Pay By payment method is defined on the Purchase Ledger - Processing - Terms form. You can use a Payment Method of Other if, for example, you pay your suppliers by credit card or direct debits. Suppliers with this payment method will not be included in any automatic payment-run.

Include only if VAT Return Reduction By for Sett Disc is 'VAT Adjustment'

This option relates to processing VAT Adjustment postings when you take settlement discount terms.

Select to include only invoices that attract settlement discount and you use a VAT adjustment posting rather than a credit note to process:

the discount for the reduction in the goods and VAT values, and
a VAT adjustment posting rather than a credit note to adjust the goods and VAT values on the VAT Return.

What controls how Opera calculates VAT on invoices with prompt payment discount?