web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unique Positive Pay Da...
Small and medium business | Business Central, N...
Suggested Answer

Unique Positive Pay Data Exchange Definition

(0) ShareShare
ReportReport
Posted on by Krystal McCarthy 30

Hello has any built a Positive Pay Export data exchange file that has grouping by record type?

 

Header 1          $$ADD ID=ZZYUSRF1 BID='FKI4000026021’

Header 2          *03001820000040000260210

320 Detail        000001007412042040000260213200005680400Bison Usa

320 Footer       &              00001   00005680400 ß the above group of 320 codes are counted and summed

420 Detail        000001007112042040000260214200000000000Bison Usa

                        000001007212042040000260214200000000000Bison Usa

                        000001007312042040000260214200000000000Bison Usa                         

420 Footer       &              00003   00000000000  ß the above group of three voided checks (420) are counted and summed (all zeroed out)

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Imp-_5F00_-Exp-Data-Exch-Def-_2600_-Map.zip

    Krystal,

    Here is my Positive Pay Data Exchange Definition. You can import and compare.

    Hope this helps.

    Steve

  • Krystal McCarthy Profile Picture
    Krystal McCarthy 30 on at

    thank you Steve, but this did not work for the groups.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Krystal,

    Sorry to hear. I checked another one I did for Bank of America and it is roughly the same as my other one. Is this something your Bank wants? The normal structure is Header, Detail, and Footer. Looks like you are looking for the sub-footer between Detail Records and a final Footer for export file. I checked another Bank definition and could not find this Footer request.

    Thanks,

    Steve

  • Airbird22 Profile Picture
    Airbird22 2 on at

    Hey Steven,

    We also have a situation where the footer requires a 2 lines (first line is subtotal and last line the totals). Would we require an update to a codeunit for this to produce the 2 lines for table 242?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans