Change transaction type
Overview
In some situations, the fund’s orders should come in different types of transactions than other purchases and sales. If the sending party cannot control this (for instance, rebalancing or external connections), you can use the rule below to edit assignments.
How to get started
fa-decisiontable-transactionTypeChange.xlsx
Open this spreadsheet.
Make sure that transaction types mentioned in columns 14/15 D (current one) and G (the one, that you would like to use) are matching to your case.
Define a security type code or security code in 14 / 15 E or F columns.
Go to Tools - Administer - Decision tables.
Upload the Excel file.
Click Done.
How the rule works
If the rule finds a trade order:
That has the order status mentioned in column C.
and
That has the transaction type mentioned in column D.
and
That has a security type / code mentioned in column E / F
→ It will change the transaction type to to match the type in column G