Imported data automatically multiply with 100
My company is in the 1st stage of building Anaplan. Recently, we've managed to automate the process of data integration which is to import data from our server (Microsoft AX 2012) into Anaplan. To be simplified, we have 2 step. Firstly, a batch job will download data from server (pre-scheduled) to a local file, and then a script will upload data to Anaplan. I double-check the output and it's correct without x100.
In Anaplan, there will be 2 actions: firstly, it will extract the transaction ID to a list, secondly it will import data to a module. And here comes the issue: the numerical value (money amount) is multiplied with 100 and I don't want that.
We've been trying but cannot find out the problem until now.
Anyone knows how to solve this?
Thank you so much!