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.