Changes to Auto Transfer Consolidation

Consolidated postings

For 'BOS' format interfaces, you specify in the interface definition whether or not you want consolidated postings. The following rules apply:

  • If postings are being consolidated by batch, all items with the same batch number in the sending system are combined to create a single Cash Manager posting.
 

  • If postings are being consolidated by transaction, the incoming items are sorted into ascending narrative sequence. Items with the same first ten characters of narrative are combined to create a single Cash Manager posting. Note that this means that all transactions with a blank narrative will be consolidated.
 

  • If postings are being consolidated by narrative, the incoming items are sorted into ascending narrative sequence. Items with the same first ten characters of narrative are combined to create a single Cash Manager posting. Unlike consolidation by transaction any transactions with a blank narrative will not be consolidated.
 

The date of consolidated transactions is set as follows:

 

  • When transactions are consolidated by batch the consolidated transactions are dated as per the sending system batch date.
 

  • When transactions are consolidated by either transaction or narrative, the date on each of the consolidated transactions is controlled by a setting specified in the interface definition, this can be one of the following:
    • As per the earliest dated transaction contributing to the consolidated transaction.
    • As per the latest dated transaction contributing to the consolidated transaction.
    • The end date of the current period.
    • The date on which the transfer takes place.

Note

If the date of a consolidated transaction is later than the end of the current period in Cash Manager then the current period end date will be used.

 

  • When transactions are consolidated, all payee details attached to them are ignored.
 

  • Dishonoured cheques (type DRE) and foreign currency transactions are never consolidated.
 

  • You can optionally print a report showing the postings created in Cash Manager and a full schedule for each consolidated posting.

Note

There are specific settings in Creditors Ledger to control the consolidation of Credit Transfer or BACS payments made via Creditors Ledger Auto-payments. These settings override any settings specified on the interface definition.

 

Interface Definitions

 

Consolidate postings

(BOS format interfaces only.) Select one of the following:

  • By Batch to consolidate postings by sending system batch number.
 

  • By Transaction to consolidate postings with the same first ten characters in their transaction narrative including transactions with a blank narrative.
 

  • By Narrative to consolidate postings with the same first ten characters in their transaction narrative excluding transactions with a blank narrative.
 

  • No Consolidation.

Obtain date of consolidated transaction from

(Only if consolidating transactions by transaction or by narrative) Select one of the following:

  • Earliest transaction to date consolidated postings as per the earliest dated transaction contributing to the consolidated transaction.
  • Latest transaction to date consolidated postings as per the latest dated transaction contributing to the consolidated transaction.
  • Period end date to date consolidated postings as per the end date of the current period in Cash Manager.
  • Date of transfer to date consolidated postings as per the date on which the transfer takes place.

Note

When transactions are consolidated by batch the consolidated transactions are dated as per the sending system batch date. Regardless of the method of consolidation chosen, if the date of a consolidated transaction is later than the end of the current period in Cash Manager then the period end date will be used.

 

If transactions are consolidated, you can print the constituent elements of each consolidated posting through the Auto-transfer report.

 

Creditors Ledger System Parameters - Second Auto-Payment Printing Options Window

Consolidate credit transfer postings to Cash Manager

Enter Y to consolidate all credit transfer postings in an auto-payments batch into a single transaction in Cash Manager.

Note

The system defaults to consolidating credit transfer and BACS transactions generated by auto-payments into a single transaction in Cash Manager.