News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Decimal Place Format P...

Small and medium business | Business Central, N...

Suggested answer

Decimal Place Format Positive Pay File

(0) Share

Report

Report

Posted on by tlhgolfer

12

I want to have a positive pay file and I want the amount field to not contain a decimal place. Any idea how this can be accomplished?

Thanks,

Tanya

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

tlhgolfer 12 on at

Like (0)

Report

RE: Decimal Place Format Positive Pay File

This worked thank you!
Suggested answer

Suresh Kulla 43,846 on at

Like (0)

Report

RE: Decimal Place Format Positive Pay File

Tanya,

As Andy mentioned you need to use the Transformation Rule on the dataexchange definition, you can ALPHANUMBERIC_ONLY or create a new transformation rule of type Replace and use From Value as . You can test it by going to transformation rules and using test data.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Decimal Place Format Positive Pay File

Tanya,

Happy Wednesday. Andy mentions the Data Exchange Definition, Detail Field mapping update that sets the value to not show a decimal image.

Thanks,

Steve
Suggested answer

Andy Sather on at

Like (1)

Report

RE: Decimal Place Format Positive Pay File

Hello Tanya - For the Column Definition set the amount field to a Decimal Data Type. Next go to the field mappings and set the Transformation rule to ALPHANUMERIC_ONLY.

Helpful resources

News and Announcements

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2

Martin Dráb 230,817 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans