Incorrect calculation of Total Credit Amount on an EFT File

(0) Share

Report

Posted on by Bob Callanan

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

EFT File generation

xml file with incorrect CtrlSum calculation

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (1)

Bob Callanan 785 on at

Like (1)

Report

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 11,003 User Group Leader on at

Like (0)

Report

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.