Hi, we are setting up new integrations to push our data from skyvia into Salesforce Marketing Cloud. However, the data is arriving in marketing cloud without decimal precision (rounded to the nearest whole value). This issue never presented itself in our Sales Cloud integration. When we actually look at the value being generated by the error file, it appears that is it some sort of issue with Skyvia as the value is being rounded there (see attached screenshot).
What we think is most likely happening is it thinks the field in Marketing cloud is numeric only and doesn't have scale and therefore just passes the rounded value. However, we tried converting this and passing into a text field and still get the same issue.
For our customer table, we have ‘AmountSpent’, ‘LastSpent’ & ‘Points’ that need the decimal accuracy, in addition to all the pricing fields in the sales and discount tables.