News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Data Exchange and Data...

Microsoft Dynamics NAV (Archived)

Data Exchange and Data Transformation

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I am setting up some data import processes to import data from a number of well known online payment processors and I need to manipulate some decimal values. the operators I need are:

1. Division to convert an amount in pence / cents into whole units £, $ & €

2. to change the sign

3. To set the sign based on a value in other field, e.g. CR then value positive and DR then value negative (or something like this)

As far as I can see the transformation rules are ok for formatting text & dates but don't allow for logical tests or numeric operations?

Any advice please

Thanks

Malcolm

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

AJAnsari 5,754 on at

Like (0)

Report

RE: Data Exchange and Data Transformation

Not sure I follow. Can you please elaborate?

From what I understand, you want to perform numerical tests on imported values and are not sure that NAV can handle this. The short answer is, yes it can. You would first convert the imported data type from string to an acceptable numerical value like Decimal or Integer using the Evaluate function, then perform your tests using the IF or CASE statement.

I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans