Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Generating Payment File for multiple methods of payment types

Posted on by 132

Hello,

I was wondering if knows if it is possible to generate an Electronic Reporting Payment File with two types of Methods of Payment?

Our subsidiary would like to generate ONE banking file and have it include both a method of payment with "invoice" AND "total" lines, depending on the method of payment selected on the lines within the payment journal.

The "invoice" and "total" Period setup within the method of payment is below:

pastedimage1683730491172v1.png 

In this scenario, you would be paying two vendors, or the even the same vendor, with the same banking file:

Vendor A: 2 payment lines within payment journal and the method of payment is "invoice"; which means that it will show 2 payment lines on the banking file.

Vendor B: 2 payment lines within the payment journal and the method of payment is "total", which means it will sum all of the payments for that vendor on the banking file.

Can this be done? is there something that we are missing?

  • navnah01 Profile Picture
    navnah01 132 on at
    RE: Generating Payment File for multiple methods of payment types

    Thank you for the message but our subsidiary would like 1 export file even though the payment journal lines have two different methods of payment (that share the same customized payment file).

  • Suggested answer
    Gaurangkumar Jani Profile Picture
    Gaurangkumar Jani 4,480 User Group Leader on at
    RE: Generating Payment File for multiple methods of payment types

    HI navnah01 

    This can be done, you can have multiple payment method having same export file format.

    Create your general as you requested (mostly using payment proposal) and then click on generate payment and system will open a popup window. Select any one method of payment and Bank.

    pastedimage1683804670048v1.png

    This will allow you to generate a file.

    The reason behind this is method of payment allows you to create payment proposal / lines in Payment file, while selecting one payment method will allow generating file based on configuration.

    You can also create customized payment file format that you can select instead of method of payment.

    Please let us know if this helps.

    Thanks,

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans