Exporting config package results in jumbled number formats - seems to be suited for American users, not European?

(0) Share

Report

Posted on by phkGZ

Hi. When I export a package, for instance from tabel 17 - GL entries - the number format comes out in US format.

For instance the amount will read "9,152.17" instead of "9.152,17". Also the numbers will be formatted as text.

Which means before I can use the data, I need to search and replace commas with decimals and vice versa, and afterward, convert to number using the "NUMBERVALUE" function in excel.

Is there any place in business central that you can define the data type? So that the data will come out correctly from the get go, and I dont have to manipulate it after.

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

JAngle 157 on at

Like (1)

Report
Copy link

Link copied!

What are the regional settings of the user? Also there is a language code in the configuration package. Believe that has an impact

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Hi Josh! Thanks for the input. Yes I really thought the language code on the package itself would do the trick, but it didnt - set it to 1030 Denmark but it had no effect.

The "my settings" shows language set to denmark and region set to denmark.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

Hi

Data in configuration package is always text and same format. I could not find a method to change that.

That being said if you use Configuration Package to just export the data and use them somewhere else then I recommend using ODATA and Excel archerpoint.com/.../

This way you can format the data one time and use it.

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

That seems very interesting, using ODATA! First I've heard of it. Will look into as soon as I have an hour or two to spare - i love optimizing my workflows..

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

You are welcome

Other approach is joshanglesea.wordpress.com/.../

For Web Service (ODATA) see this video if you need more info

www.youtube.com/watch

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Youre a gold mine of information :)

Another thing I was considering was using PowerBI to build these reports... of the choices available, which one do you use? or which one would you recommend?

1) Power Bi

2) Configuration packages

3) PowerAutomate

4) ODATA

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

Hi

My preference is Power BI. if you use this report over and over and want to refresh it then Power BI is the better option. In addition you can integrate Power BI report into BC. See below. This way user with both Power BI license and BC license can see the report in BC.

www.youtube.com/watch

Note:

Power Bi desktop is free but if you want to publish, share, or embedded in BC you need Power BI license.

Was this reply helpful? Yes No
phkGZ 44 on at

Like (0)

Report
Copy link

Link copied!

Great that was my thinking as well, thanks!

Was this reply helpful? Yes No