Unable to convert value with currency to internal format at conversion exit

[jennychen1]

Hi, Experts:

I am loading data from a flat file into PSA using infopackage. The same data file was loaded in development system successfully before. However, I load it in QA system, it failed with the following error:

"Unable to convert value -35983137170186261 with currency CAD to internal format at conversion exit RSDS_CONVERT_CURRENCY_INTERNAL (field /BIC/ZBEGBLNC record 15122, value -35983137170186261)"

Message Class "RSDS", Message no "167", Message type "E".

I checked in QA and Dev systems for the data in the flat file also the set up for infoobject, datasource, infopackage. They are the same in 2 systems.

What else should I do to trouble shoot this error?

Thanks,

Jenny

[jennychen1]

All:

Just some updates. It turned out that the length of the data field from data file exceeded its defined length in BI. I increased the length for the filed in datasource and loaded again. It passed through. Still don't understand why the same data loaded OK in development system with the old shorter field length setting.

Thanks for your help and input.

Jenny

[Former Member]

Hi

If you pass the source system global settings for Flat files i don't think it will update all the things(currencies,fiscal year etc), flat files are user defined we can change the data at any time. but in the case of ERP once the postings are happend through the internal programs the currencies and quantities automatically it will get loaded.

check your flat file once and then check it out.

Regards,

chandra.

[Former Member]

Sometimes theres a problem between interna end external formats for the currencies...You must find the equivalence between internal and external format and adjust it....i recomend you to check the conversion routine almost ever are very simple and appears the name of the table....and check if the currncy appears there.....

Another option is to create a routine that convert the CAD value to the expected valur for the routine....

Regards

[Former Member]

Did you load the currency and units from the source system?

Regards

[jennychen1]

Thanks for the suggestion. I loaded the currency and units from the source system (by right-clicking the source system -> Transfer Global Settings, and select "Currencies" and "Unit of Measures"). Then I tried loading the data file. But It failed again with the same error.

Jenny