Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

Incorrect calculation of Total Credit Amount on an EFT File

Posted on by 785

I'm testing a new EFT File Format (xml file type) and need to include the Batch Total in the header. I would think the calculation field named "total credit amount" would work but it isn't. In my test I'm getting a value of 2 instead of 22.22 or 7 instead of 7.28. Has anyone seen this issue before? It looks like a bug but not certain. Below are a few screen shots to help explain.

EFT File Format

pastedimage1574871713355v4.png

EFT File generation

pastedimage1574871651604v2.png

xml file with incorrect CtrlSum calculation

pastedimage1574871628179v1.png

  • Bob Callanan Profile Picture
    Bob Callanan 785 on at
    RE: Incorrect calculation of Total Credit Amount on an EFT File

    Thank you - right in front me! Good to have a second set of eyes!

  • Verified answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    RE: Incorrect calculation of Total Credit Amount on an EFT File

    Your field Length is set as 1, so that's why it's showing only 1 digit from the Batch Total amount.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,665 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,971 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Product updates

Dynamics 365 release plans