Adding a New Currency in a Transaction Split

The Currency Split option in Account Allocations (ACA) allows you to split a single transaction into several new transactions, referencing different transaction currencies. You can only split the variable currencies, that is the transaction currency value (value 2) and fourth currency value (if it is in use as a variable transaction currency for the business unit). The system generates balancing transactions in each transaction currency to balance the transaction currency values, if required.

For example, this feature would allow you to split an original transaction with a transaction currency in USD and base currency of GBP, into two transactions: one with a transaction value in USD and the other with a transaction value in EUR. The base currency equivalents of each new transaction must total the base currency value of the original transaction. Two currency balancing transactions are also generated, one with a USD transaction currency value only and the other with a EUR transaction currency value to balance the transaction currencies.

Note: If you wish to split the existing currency values on a transaction, without introducing a new currency value or altering any of the currencies, use the Multipart Split - MULTI option.

To perform a currency split:

  1. Identify the transaction to be split in the allocation transaction list.
  2. Choose Action > Currency Split to display the Account Allocation Split Transactions dialog.
    Note: The same dialog appears for a multipart transaction split if you choose the MULTI version on the Find Form List but the form operates in a slightly different way.
  3. The original amount of the transaction is displayed in the Original Amount fields, in each of the currencies in use in the business unit.
  4. Select the fourth currency code for the split transaction, if required, and click OK. All of the split transactions will reference this fourth currency code.
  5. Enter the split currency transaction details. You can enter a revised base currency amount, transaction or fourth currency amount and/or currency, and memo value as required.
  6. In Description, enter a description for this split transaction or any other useful information.
  7. Click OK to create the split transaction which appears in the list at the bottom of the form.

    The amount that remains to be split appears in the Outstanding fields at the top of the form.

  8. Repeat steps 5 to 7 to enter the remaining split transactions.
  9. If you enter a split value incorrectly, click on the transaction in the list. The transaction details reappear in the transaction entry part of the form where you can alter them. If you want to reset all of the transaction values to zero, select Reset.

    Click OK to update the transaction details in the list.

  10. Click Split Complete to generate the split transactions when you have fully split the original transaction and the Outstanding field displays zero.

    Alternatively, click Cancel at any time to abandon the currency split.

    Note: If you cannot complete the split, you can suspend the split details by clicking Hold. This displays the Hold Multi-Part Split form, where you enter your reason for the holding the split.

When you complete the split, the new split transactions appear immediately above the original transaction in the allocation transaction list. The allocation marker is not set of any of the new split transactions. They all retain the allocation marker of the original transaction. You can set the allocation markers on these transactions in the normal way, as required.