Skip to main content

Notifications

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

Vendor payments in one total on the bank statement

(0) ShareShare
ReportReport
Posted on by 10

Hi all

I have generated vendor payments from D365 and passed them to the bank. In the bank statement one line is posted or displayed PER VENDOR.

But I would like to see the vendor payments in one total on the bank statement. What do I have to do for this?

I use this ER:

 

pastedimage1674212487267v1.png

Thanks a lot!

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Vendor payments in one total on the bank statement

    Yes, it is correct.  BtchBookg tag is used to inform the bank if the transactions in the file should be bulk debited. Valid codes for BtchBookg node can either be fasle or true that is described as follows:

    false = Single booking requested

    true = Batch booking requested (within one PmtInf)

  • SabineWR Profile Picture
    SabineWR 10 on at
    RE: Vendor payments in one total on the bank statement

    Thank you very much for your help! 

    In addition I found this information about a parameter when generating a payment in D365:

    pastedimage1674492362610v1.png

    For all those who are searching for a solution in the system itself. 

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: Vendor payments in one total on the bank statement

    Hi Sabine,

    Do have this challenge in bank reconciliation that you need to reconcile one line to several vendor payments? 

    When you generate Pain001 file, total sum will be sent to the bank via <CtrlSum> node and info regarding <PmtInfId>,<InstrId>, <EndToEndId> will be sendt to the bank as payment identification.

    pastedimage1674486473381v1.png

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans