Skip to main content

Next Generation - The Remittance BACS screen

The Remittance BACS feature allows you to raise payments for multiple invoices for one or more suppliers where bank details have been entered for those suppliers.

An approval process may be defined, meaning that one or two stages of approval are necessary before an invoice can be paid or displayed in the Remittance BACS screen for processing.

The payment approval process can be set up in the Purchase Ledger Option within the System Module which is security profile driven.

When payment approval is set up, you will only see purchase transactions listed in the Remittance BACS screen which have been approved on the Suggested Payments screen.

When payment approval is not set up, you will see all transactions that can be remitted displayed and you can select the checkbox in front of the transactions you wish to process further.

You can set a transaction to be on dispute directly by selecting the Dispute checkbox against the relevant transaction and you can also remove the dispute flag by clicking on the Dispute checkbox against the required transaction.

Note: You have to select the Save action card from the Action Panel to save the changes.


All of our enquiry type screens have the same look and feel and functionality for consistency purposes.

  • You can run enquiries against all records or just a specific record.

  • You can apply filters to ensure that only the transactions you're interested in are displayed in the enquiry window.

  • Access to enquiry windows is controlled by your Security Profile.

Once you have gone through this article, you can progress to processing your remittance BACS or Cheques.


The Remittance BACS is made up of the following sections:

Sections

Description

Payment Date

  • The date of when you are processing the payment.

  • Defaults to the current system date.

  • This date is pulled through to the processing screen where it will disabled. If you wish to change the date, you have to do it on this screen.

Record Count

  • Shows the number of transactions listed in the grid for the provided filter criteria.

  • Updates depending on the filter criteria.

  • Updates when you select transactions when you don't have payment approval set up.

Search field

  • Search on Account Name or Header Ref which is the same as the Invoice and Credit Note Number, or Payment, Debit and Credit Adjustment Reference field.

  • Tip: You have to know the first few characters or numbers to be able to search as these searches are what we refer to as Begins With searches.

  • You can search for the beginning of each word in the available quick search fields, no matter where they are.

  • Example:

    • If you wish to search for an Account Name of "The Access Group", you can now enter the words "The", "Access", or "Group" and Financials will intelligently find this result.

      • Note: The above logic is only available for the search on the Supplier Name and not for the Header Ref.

Saved Filters List

  • A list of any saved filters that are available.

  • Filters are saved using the advanced filter panel, for more information please refer to how to use the advanced filter.

Advanced Filter

  • Opens the advanced filter panel for advanced filtering.

  • Number indicator displays the number of applied filter criteria to the enquiry list.

  • For more information, please refer to the advance filter article.

Cog

  • Contains a list of actions which can be carried out on the enquiry.

    • Configure Columns - Customise the displayed columns in the best order to suit your needs. For more information please refer to Configure Columns.

    • Clear Criteria - Clears all the filter criteria that you have added directly for a column displayed. Doesn't clear the filter you have added to the Advanced Filter panel.

    • Reset Sorting - Removes any sorting that you've set on all displayed columns.

    • Reset Default Column Width - Resets all column widths to their default size.

    • Export to Excel - All - Exports all the transactions for the columns displayed on the screen.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

        • The current limit is set at 500,000 rows to protect the performance.

        • You can run several exports at the same time, even from the same screen and you'll be notified individually as each one is completed.

    • Export to Excel Current View - Exports the currently displayed or loaded transactions and columns, the default is to load 100 transactions.

      • If you wish to see all columns available on your export, you have to add all columns in the configure column option.

      • Once you scroll past the 100th transaction, this loads another 100 transactions. This is done to make sure that you don't come across any performance issues when you have hundreds of thousands of records.

Hide Grouping

  • You can select to group by any column when this option is on by dragging a column into the drag and drop columns header for grouping field.

  • You can group multiple columns.

  • You can turn this option off to allow for more space for your transactions by clicking on Hide Grouping.

  • You can turn grouping back on by clicking on Show Grouping.

Hyperlinks - Code and Supplier Name

  • You can click on the hyperlinks on the account code or supplier name to view the supplier record. The record opens in View mode and if your security permissions has edit permissions, you can edit the supplier.

    • If you don't have access to edit supplier records, instead of an Edit button, you will see a Close button on the supplier record.

The Grid

  • Default columns are displayed when the Remittance BACS screen opens. You can change by manually dragging and dropping the columns to where you want them or alternatively you can customise your columns using the Configure Columns.

  • Each column is sortable, and you can sort on multiple columns at the same time.

    • To sort on multiple columns, hold down the Shift key on your keyboard and click on the column you want to sort.

  • You can filter on all the columns by pointing to the column label and clicking on the icon to open the filter window.

  • You can increase and decrease the column width and the settings are saved for you so you to only have to do this action once.

  • The Totals at the bottom right-hand side of the screen show the Outstanding balance and Remittance balance totals.

    • Where payment approval is set up, the totals update to show the totals for all selected transactions.

More information on the default displayed columns

Column label

Description

Code and Supplier Name

  • You can click on the hyperlinks on the Code and Supplier Name to view the supplier record which depending on your security permissions opens in edit or view mode.

    • If you don't have access to the Financials module Suppliers option, the hyperlinks aren't visible on the enquiry screen.

MDD

  • When Multiple Due Dates is unlocked on your database, and you have set MDD up on transactions, you can see the number of postings as a hyperlink.

  • Clicking on the hyperlink opens the Multiple Due Date screen in view mode for more information.

  • The Allocated value is prepopulated with the next payment value specified on the Multiple Due Date screen.

Transaction Date

  • The date of the transaction that you posted.

Reference

  • The reference field of the transaction which is the same as the Invoice and Credit Note Number, or Payment, Debit and Credit Adjustment Reference field.

Type

  • The type of the transaction displayed.

Allocated Value

  • The allocated value is populated with the outstanding value for the selected transaction.

  • When not using payment approval, the Allocated Value is prepopulated with the outstanding value and can be changed by clicking into the Allocated Value field.

  • Cannot be greater than the outstanding value of the transaction.

  • Must match the sign of the transaction, i.e., you cannot enter a negative receipt value against a positive invoice.

  • A remittance can only be raised for a transaction where the allocated value is not equal to zero.

Outstanding

  • The outstanding value for the selected or displayed transaction.

  • When using Multiple Due Dates, this value will be the value of the payment for the relevant timeframe set up.

Settlement Discount

  • The settlement discount value is populated with the outstanding value minus the agreed settlement discount value for the supplier ot the invoice.

    • When using payment approval, the settlement discount value is pulled through from the Suggested Payments settlement discount field.

      • The settlement discount value must match the settlement discount value approved on the Suggested Payments screen.

    • You can manually edit the settlement discount value, and if differs from the approved transaction, a validation will prevent you from being able to process the remittance BACS.

  • When not using payment approval, the Settlement Discount is prepopulated with the value calculated from the selected supplier terms if any set up or the invoice if any set up or is blank.

    • You can edit the field and enter a settlement discount value only valid for this remittance run. You will be requested to confirm if you wish to add settlement discount.

Settlement %

  • Pulled through from the terms set on the supplier record and cannot be amended.

Gross Value

  • The gross value of the transaction.

Dispute

  • You cannot process any transactions that have been placed on dispute. To be able to process these transactions, you must remove the disputed flag first.

  • You can also place a transaction on dispute directly from the Suggested Payments screen by selecting the check box against the relevant transaction. You can enter a query reason or just click save on the Dispute Reason screen.

  • To remove the dispute flag, just select the Dispute check box again.

Stage

  • Displays the relevant stage the transactions are in.

  • There are 3 stages depending on whether you have payment approval set up or not.

    • No Payment Approval

    • One Stage Approval

    • Two Stage Approval

List Ref.

  • Contains the list reference that you have assigned on the Suggested Payments screen. You can find more information on the list reference functionality in the how to use the Suggested Payment List article.

Audit No.

  • A system generated number assigned to all transactions posted.

Description

  • Pulls through the description entered on the transaction. The description field on transactions is a 30-character field.

Sub Ledger

  • When sub ledgers are set up, this field is populated with the sub ledger assigned to the transactions and you must select transactions that are assigned to the same sub ledger to be able to process the remittance BACS.

Did this answer your question?