Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
For some reason, when I export a list/report from NAV 2018 to Excel, Excel changes the numbers on some columns. For example, I've seen that the quantity is multiplied by 100. So, if the quantity is 1 in NAV, it changes to 100 in Excel. Also, I've seen that if I extract a list of Accounting balances per dimension from NAV to Excel, the Excel file copies the same amount on several rows, which isn't correct.Sometimes the lists/reports that are extracted from NAV are completely correct in Excel. However, the problems that I've described above occurs occasionally Does anyone know if this is a common issue when exporting a list/report from NAV to Excel?Best regards, Eva
Looks like an issue to me, what cumulative update is this. Are you able to reproduce this in standard CRONUS company and what client do you use? Web or Win?
It's CU 08. We have tried to reproduce this in our test environment and we don't get the same error as our customer. Since this problem only occurs occasionally according to our customer, could it perhaps be a setting in Excel that creates this problem and not NAV?
Hi, This is very strange. Is it related to the region and language settings of Application Server?
And if only the quantity is in question, is the Sales Unit of Measure set?
Hope this will help.
Thanks for your reply!
The Sales Unit of Measure is set. As you mentioned, I believe that this issue is related to the region and language settings of Application Server or perhaps a setting in Excel.
Best is to continue the testing in a more accurate CU. We are about to release CU48 (currently CU47):
This means this specific customer environment is running 39 / 40 CU's behind which is a lot.
Business Applications communities