Incorreect calculation of Total File Credit Amount

(0) Share

Report

Posted on by Business Central User

107

Hi Everyone,

I have setup Data Exchange Definition for generating EFT file and I am succeeded doing it.

Every detail in the EFT file generated by system is accurate except one.

For File Footer - Detail 9, Total Credit Entry USD Amount in the File is not showing the accurate figure, if only the sum is having /0/ in the last.

Please refer the attached screenshot below.

If you refer Detail 6 line, 4th & 5th row from the top, 1010 + 2020 becomes 3030 and the sum of it appears in the File Footer 9 (6th row in the screenshot), however, it is only showing /303/ whereas the 0 is missing.

After doing few scenarios I have come to know this is happening only for the amount if there is 0 in the last, if there are any random figure without 0 then it appears correct.

Can you please guide what I am missing.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Valentin Castravet 32,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you post a screenshot of your data exchange definition to see how you have set it up?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,216 Moderator on at

Like (0)

Report
Copy link

Link copied!

you need to check the data format of the footer, below is an example. If you build the EFT formatting on basis of a sample data exchange definition, review if anything is setup incorrectly in your case.

Jun Wang

Was this reply helpful? Yes No
Business Central User 107 on at

Like (0)

Report
Copy link

Link copied!

Hi @Valentin & Jun,

Please take a look the data exchange definition I have configured using the base template.

Data Exchange Definition (Focused line - File Footer)

Field Mapping of File Footer

Just to bring into your notice, that if the sum of the total is greater than 0 then it will appear correctly. However, if the sum of all the credit rows has 0 in the last then the 0 will get ignored.

Eg - 1) Payment for 1st row 1205

2) Payment for 2nd row 25

Total = 1230

When the EFT is generated it will ignore the 0 and only print 123 in file footer

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 32,689 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

In the Field Mapping Page, for the debit and credit amount fields add a multiplier of 100

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No