Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ryan Porter]

I am trying to create a Data Exchange Def for Positive Pay in NAV 2017.  Our bank requires the amount to exclude the decimal point (i.e. – 100.25 should show in the file as 10025).  I cannot find a way to remove the decimal point?  Currently, I have the amount line setup as Data Type = Decimal, Data Formatting = en-US.

One attempted solution I tried was changing the Data Type to “Text”, but that inserted “,” as the thousands separator and still included the decimal point.  

I’ve tried using the Data Format column, but have yet to find the correct format.

Does anyone have a solution to removing the decimal point in the exported file?

Appreciate any help!

——————————
Ryan Porter
Controller
Milgro Nursery
——————————

[Mary Carrero]

Ryan,

You could try creating a transformation rule in the field mapping for the amount field.  Find and replace. (Find the decimal and replace with blank). I have seen this used and it appears to work.

——————————
Mary Carrero
Velosio
apopka NJ
——————————
——————————————-

[Theresa Davis]

In the Data Exchange Definition, we have the check amount set up as follows
&Column No. (2) (PK) is 4
&Constant (12) is blank
&Data Exch. Def Code (1) (PK) is POSITIVEPAY
&Data Exch. Line Def Code (10) (PK) is DEFAULT
&Data Format (6) is blank
&Data Formatting Culture (7) is en-US
&Data Type (5) is Decimal
&Description (8) is blank
&Length (11) is 12
&Name (3) is Check Amount
&Negative-Sign Identifier (14) is blank
&Pad Character (16) is 0
&Path (13) is blank
&Show (4) is No
&Text Padding Required (15) is Yes

And what we are sending to the bank is a list of number with no decimal point showing

——————————
Theresa Davis
Systems Analyst
Group O
Rock Island IL
——————————
——————————————-

[Justin Falconer]

We have it setup with a Transformation Rule called “ALPHANUMERIC_ONLY”

——————————
Justin Falconer
IT Manager
Tender Corporation
Littleton NH
——————————
——————————————-

[Ryan Porter]

Thanks to all for your help!

For anyone in the future that might be searching for a solution to the same question I had, Justin’s recommendation to add a “Transformation Rule called ‘ALPHANUMERIC_ONLY’ ” worked for me.

——————————
Ryan Porter
Controller
Milgro Nursery
——————————
——————————————-