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. |
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.
|
|
|
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. |