Microsoft Dynamics GP (Archived)

change values when exporting data from smart list to excel

(0) Share

Report

Posted on by Community Member

hello every one .

when ever i'm going to export data from smartlist to excel it change some values.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello Mr. Shaukat

Is this change limited to decimal places ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

A quick solution is to add the following function to your Dex.ini file on the default following path C:\Program Files (x86)\Microsoft Dynamics\GP2015\Data\Dex.ini

SmartlistEnhancedExcelExport=TRUE

Or you may consider the workaround solutions provided by David on Microsoft Dynamics GP 2013 SmartList Export to Excel shows currency values with 5 decimal places

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

Hello M.A Shaukat

Just following up on this case, any update ?

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Saadi.

by entering the following function to dex.ini. My Issue is resolve. but there is one problem. that currency sign is also exported to excel which is not required. and creating difficulty to applying formulas.

SmartlistEnhancedExcelExport=TRUE

Thanks

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Yes, you are correct. Here is another quick work around solution to remove the currency symbol from the exported excel file

Highlight the whole column including the values with the currency

Now, click (CTRL+F), to open the "Find and Replace" window

Include the specific currency symbol under the "Find What" field, and leave the "Replace with" field empty

Click replace all

Please never hesitate to share any further inquiries,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks

This is a manual exercise. Is there not any other way.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

If you want a permanent solution not to export the currency symbol at all, include this function in your Dex.ini file

ExplorerFormatCurrency=FALSE

Was this reply helpful? Yes No
Tanner 360 on at

Like (1)

Report

Mahmoud,

I know this is an old post, but maybe you can help me as well. My client is using GP 2013 and has a weird issue when exporting a smartlist to Excel. I know GP 2013 exports all numbers out to 5 decimals, and that is fine. However, they are getting different results in the manufacturing module than in the inventory module. For example, if I look at the inventory quantities smartlist, I see quantities listed as 2,071 and 1,846.30470 and 30. These numbers export to Excel correctly and show as 2,071.00000 and 1,846.30480 and 30.00000 respectively. The problem is when running the manufacturing orders smartlist. For example, I may have quantities of 950 and 915.00000 and 1,960.00000 BUT when I export these to Excel they show as 950.00000 and 915.00000 and 1.00000. So, as you can see, it seems that anything less than 1000 will export correctly, but 1,100 would export as 1.00000 and 3,456 would export as 3.00000. It seems like rather than just adding the 5 decimals, it is only reading the first digit when the number is greater than 1000.

If you have any ideas on how to resolve this I would greatly appreciate it. Also, if you need more information or clarity on the problem just let me know.

Thank you!

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

A quick solution is to add the following function to your Dex.ini file

SmartlistEnhancedExcelExport=TRUE

this should work...we had the same issue with the Manufacturing module

Tami

Was this reply helpful? Yes No