FC 10.1: Number format for Amounts in flat file when exporting package data

[phadke_manas]

Experts,

When exporting package data from BFC windows client to a flat file we're seeing values in Amount field like the below.

-8.7e-005

2.9e-005

We're seeing this happening in case of the output file type txt as well as csv. This is further causing issues when we're trying to use this flat file to load data through FIM to another application since the value cannot be converted to Decimal. We're using FC 10.1 SP09 with SQL server 2012.

Has anybody else also faced this issue previously and is there a way to fix this number format in the FC export?

Regards,

Manas Phadke

[adelaide_brunel]

Hello,

In order to better understand, could you please show how those amounts are displayed in your FC windows client ?
Thanks to confirm it is the same display when you click on information on data.
Regards