The current Ninety One data feeds we are receiving with foreign currency and local currency combined, do have duplicates for the month.

At the start of the month, Ninety One sends a preliminary data feed with the foreign currency not converted yet, on the same commission statement as with the ZAR currency.

Then, at the end of the month, they send a final data feed with the same foreign currency amounts, already converted.

This means the foreign currency item is processed twice in the month: once not converted, and once already converted.

You have 2 options, depending on your preferences and needs:

Option 1: if you need your Ninety One file before end of the month, you will use the preliminary foreign currency commission statement at the start of the month and do the conversion to ZAR yourself. Then, when the converted data feed comes in later in the month, you will have to delete the final one to avoid duplication.

Option 2: if you can wait until the end of the month, we recommend waiting for the ZAR data feed, where all foreign currencies have already been converted. That means you will delete the preliminary data feed to avoid duplication.

We are having conversations with Ninety One, conveying the frustration in order to drive improvement in terms of the format of the data they are supplying to Commspace.

If you have any uncertainty, please don't hesitate to reach out to us as Commspace Support.