Integration Manager: Rounding Issue

Issue
While testing an integration, debits and credits didn’t add up. Then I noticed all the the debit amounts have decimal places on the source file but not in GP. I looked at the options for the Debit and Credit fields in the Distribution mapping, there was no option to Not Round. I opened up a ticket with Microsoft, and Lucas Miller from Microsoft support showed me a simple fix but its very not obvious.
Solution
In IM, Go to the Source Properties window by double clicking on the Source, Go to Columns tab, make sure the field that's mapped to your Debit or Credit (whichever one has the rounding issue) has Currency for Datatype as shown in the screen shot below. Mine had Long Integer originally so after I changed to currency and click Apply and OK issue was resolved.


image

I hope this helps.

Excel Smartlist Export breaks or appears blank

Issue

We got this email from a student: “I am having trouble exporting Smart Lists to Excel. I am using Internet Explorer 11 and have Microsoft Office 2016. The data will not export to Excel no matter how I manipulate the data. I even tried using Office 365 and it still shows a blank screen in Excel with no data imported. This is a screen shot of the error Microsoft Dynamics is showing me:”

image

We could get back to him fast enough over the weekend, but he was able to figure it out on his own.

Solution

I was finally able to get it to work by setting Excel as a default program for the file types.

Thanks for your 'help'

Eddie McLain