22 Jul Release July 2025 – Import Historical Transactions

Posted at 17:13h in Recent Updates by

Import Historical Transactions

Improved Historical Transaction Import (Investors > Import Historical Transactions):
We’ve enhanced the historical transaction import process to give the user more control. The user can now specify the “Transaction Descriptions” that will be visible on the statements and throughout the system.

Previously, the “Transaction Description” field was solely for categorising the transaction type, and the “Display Name” was used as the visible description. If you prefer the previous behaviour, ensure you specify the “Transaction Type” during import, rather than the “Transaction Descriptions.”

For further details, please see link (53061).

More changes include:

General (Includes Reports, Processes, Message Changes & Validation improvements)

  • Added client account switch transactions to main investment instruction. See link (53123)
  • Added functionality to import investment instructions containing model portfolios. See link (53120)
  • Changed 2 column headings of the Instruction group import file. See columns J and AH in the example import file on link (53120)
  • Ability to email Gain and Loss certificates generated on the system. See link (53139)
  • Toggling ‘should send online applications to Adviser’ setting on/off will now generate differing links for Adviser process, or for the member process, in the bulk application link sheet. (53292)
  • Interbank transfer charges may be included in the matched transaction line in the sending or receiving account using the new radio button in the money transfer process. See link (53106)
  • Added functionality under system configuration to include or exclude the accrual of advisor fees on cash instruments. See link (53224)
  • The read-only risk value is calculated and displayed on the client risk assessment based on individual’s nationality or residential address country, or a company’s registered country, registered address, or business address. See link (53280)
  • On the Financial analysis added the ability to select the Group and the Type, also added the option to set the default Group and Type on a product to reflect when a new Financial Analysis item is added. See link (53114)
  • Added an option to “Override legislative cap” on Cash Flow input. See link (53113)
  • Improved how the Cash Residual is calculated on a Policy Document. See link (53266)
  • On the Export Contract Holdings Report, a check box has been added to include the Base Cost and Weighted Average Base Cost per Instrument (53321)
  • The Commission/Fee Statement has been updated to show the currency corresponding to each contract’s investment. (53115)
  • Enhancement to Gain and Loss certificate for South African investors in offshore structured notes. (53313)
  • Enhancement to default and application-selected funds displayed on online application review screen. (53248)
  • The Estimated Flows File now aggregates on a Fund level and not on a class level. (53324)
  • When doing a recurring switch or phase-in into a Model Portfolio, and the fund being sold is in the model, a client account transfer will be executed instead of a sell and a buy for that fund (53298). See link 
  • Review Card Improvements, for details on reviews refer to link (53305):

    1. Change Review Balance date to Balance date for Review Letter.
    2. Change Market Value at Review Balance date to Market Value for Review Letter.
    3. Change Review Date to Review Date (Anniversary date).
    4. Change Take-on date to Contract Start Date.
    5. Default Contract Start Date to contract start date with yyyy being current year (on first review, for subsequently created reviews it can continue to work as-is).
    6. Add Anniversary date to Contract Details. If Anniversary date in Contract details is populated, then update Review date (anniversary date) with yyyy being current year. This enables a sectional transfer to have an anniversary date that will be different to the contract start date.
    7. Default Anniversary date to Contract Start Date.
    8. Added button name: Fetch Current Value, use to updates Market value to use for review, to current value.
    9. Other changes also impacted by this change refer to Review Card Improvements

  • Change “Take on date” to “Contract start date” in Contract export and import. (53305)
  • Add “Anniversary date” to Contract export and contract import. (53305)

Integration (Includes Finswitch, Amazon S3, Azure blob, API, Calestone, Exports)

  • On the Instructions API the call POST/api/instructions/{contractNumber}/switches, the “sell”/”buy” are deprecated and to be replace with “sells”/”buys”, as per the Change Log. (53062)
  • Add error handling (where applicable) for Malformed Request where [] has been omitted, expected error: “Expects input to be JSON array with []”. Refer to the Change Log. (53062)
  • Historical Transaction Import – Momentum: Can now receive a column called FX_PRICE which is the price in the fund’s currency (53112)
  • Instruction Purpose column has been added to the S3 Instruction file (53322)
  • Export Contract Holdings Job, a check box has been added to include the Base Cost and Weighted Average Base Cost per Instrument (53321)
  • New call on Accounts API to return a list of banks : “GET: /api/accounts/banks”. Refer to Change Log and Application Program Interface (API). (53306)
  • New call on the Accounts and Entities API to set an bank account as Verified or not. Refer to Change Log and Application Program Interface (API). (53308)
  • New call on Instructions API to stop a recurring sequence : “POST: /api/instructions/{uniqueId}/stopRecurringSequence”, that can be called on any recurring instruction. Refer to Change Log and Application Program Interface (API). (53307)
  • New field added  to the Model Manager API, “Contract Start Date”, “Take On Date” to be deprecated. Refer to Change Log and Application Program Interface (API).  (53305)
  • New field added  to Amazon S3, Azure blob storage “Contract Start Date”, “Take On Date” to be deprecated. Refer to Export Transaction Data Job (Amazon S3 Bucket or Azure Blob Storage). (53305)

Refer to your online GitLab Project for a full list of changes and enhancements for the release.

Bug Fixes

  • Ensure revert buy transaction prices are the same as the buy transaction prices on debit order reversals (53122)
  • Sliding scale sets (lookup tables) has been improved to validate all existing bands before adding a new band (53092)
  • Stop buy releases the booked units (53200)
  • Ensure finswitch jobs do not run simultaneously to prevent POM errors(clashes) (53080)
  • Client Deposits on Cash Recon error resolved (53227)
  • Transaction fee on Dealer error resolved (53278)
  • Error when attempting to access the Cash Recon resolved (53279)
  • Annual fee run not completing error resolved (53233)
  • Linking adviser on new quote error resolved (53277)
  • Cancellation of Dealer Instruction where the Deal Fee did not cancel has been resolved (53316)
  • Internal Switch on zero available units error resolved (53333)
  • Error when viewing detail of Cash Recon report Clients – Deposits (manual matched EFT and cheque deposits) section
  • Removed the extra tab or column after the BoP Third Party Customs Client Number in the OBE_Payments_ File (52993)
  • Error when navigating to Bulk Processes-> SARS files (53416)
  • Beneficiary Details Report was not limited based on Global Permissions (53387)

Software update can include but is not limited to:

  • Bug fixes.
  • New and/or enhanced features.
  • Further improvement to performance

 

Last Updated on 3 months ago by otto