Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Dynamics GP and Paymode-X payments

Posted on by Microsoft Employee

We are looking to use Bank of America's Paymode-X payments feature. Basically you provide a file with payment data and they process it for you. The file can be a fixed length, delimited (i.e. pipe (|) or comma separated value), or tagged format (i.e. XML). Below is a sample of what the file needs to look like:

P|CHK|PAYER.PAYABLES|111000025|99999999999||0000000001|500.00|0000056000|PHOENIX COMPUTER TECHNOLOGIES INC.|123 MAIN STREET||PORTLAND|ME|04101||N

R|0000000001|INV TEST CHECK 1|11202008|500.00|500.00| |00060028|COMMENT 1

P|PMD|PAYER.PAYABLES|111000025|99999999999|EXCEL.RECEIVABLES|0000000002|330.00|0000056192|EXCEL TELECOMMUNICATIONS

R|0000000002|5468954-11|11252008|150.00|150.00| |00060029|COMMENT 2

R|0000000002|54689523-25|11142008|180.00|180.00| |00060030|COMMENT 3

P|PMD|PAYER.PAYABLES|111000025|99999999999|JL.RECEIVABLES|0000000003|300.00|0000050092|JL & COMPANY PRODUCTIONS

R|0000000003|INV TEST PAYMODE CREDIT|11152008|-100.00|-100.00| |00060025|COMMENT 4

R|0000000003|INV TEST PAYMODE 2|11202008|400.00|400.00| |00060026|COMMENT 5

T|780.00|3|5

Couple of questions, is Dynamics GP (purchasing module) able to create a payment file like the one above without any customizations? If so, how? Thanks!

Edgar.

 

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans