Issue
When submitting the Excel Fund Loader, a message alert pops up with random or unreadable words.
Common Causes and Resolution
This page discusses the more common causes preventing the submission of the Excel Fund Loader in Class and how to resolve them or provide the knowledge article with the resolution.
Cause |
Resolution |
The latest copy of the Excel transaction loader has not been used | Download a fresh copy |
On Overview tab, the brand name is entered into the Brand field |
Navigate to Fund Level > Settings > Brand Details
|
Data has been copy/pasted into the loader, this has overwritten the underlying macros |
Refer to our Knowledge Base article How to copy and paste in an Excel Transaction Loader |
Cells, rows or columns have been deleted, moved or inserted. This has corrupted the loader as there is conditional formatting behind most of the cells |
|
User created holdings have not been set up in Class at Business Level |
If the security has not been setup, refer to User Guide Unlisted Security Set-Up for detailed steps. |
Amounts from another source are copy/pasted onto the loader but have more than 2 decimal places for Dollar Amount Field. |
Dollar Amount field should have only 2 decimal places Unit field should have only 4 decimal places. How to identify numbers entered into Excel Loader with more than 2 decimal places |
On Income and Portfolio tab, the Reference Code Type entered on each tab is not the same, i.e. they do not match |
Ensure that the holding reference code entered and the reference code type selected match. Refer to Income Tab (Excel Transaction Loader) for detailed steps. |