Skip to main content

Notifications

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

One voucher that has one bank line for multiple vendors payments

(0) ShareShare
ReportReport
Posted on by 70

Hi

I have a scenario where I want system to generate one voucher for multiple vendors but having one bank line entry. 

Example:

Debit Vendor A  $100

Debit Vendor B $100

Credit Bank $200

The reason being, the bank will record the transaction as $200, the same being reflected in bank statement as well. Hence easy to automate bank reconciliation. 

Else, using conventional way of recording, D365 will record Vendor A $100 and vendor B $100 which will be difficult to reconcile since bank statement will have recorded a total amount as $200. 

I know that there is one voucher only feature that I can use but that will not solve my issue. I have come across this issue with multiple clients over many years. However, I am not sure if there is a solution in D365 FinOPs out of box for this. Let me know your thoughts. 

Thanks

Harsha

  • Suggested answer
    RE: One voucher that has one bank line for multiple vendors payments

    Hi,

    As you mentioned you need to use One voucher only in Journal names and allow multiple transactions in one voucher to have this work.

    Please find the below link which explains on one voucher functionality:

    docs.microsoft.com/.../one-voucher

    Thanks,

    Sheela

  • Suggested answer
    Harsha Setty Profile Picture
    Harsha Setty 70 on at
    RE: One voucher that has one bank line for multiple vendors payments

    Hi

    Just figured that marking Yes to 'Allow multiple transactions within one voucher' in General ledger parameters and Selecting 'One voucher number only' in the journal names will solve the issue.

    Thanks

  • Harsha Setty Profile Picture
    Harsha Setty 70 on at
    RE: One voucher that has one bank line for multiple vendors payments

    Hi Andre'

    The reason for generating one bank payment voucher: My client will generate one payment file that contains detailed payments to different vendors. This is an instruction for the bank to pay different vendors. Hence the bank will just debit my customer for one payment (say $200) to pay 2 different vendors of $100 each. This means, bank statement will have one payment line for $200. However in D365 I can only record one vendor per voucher (the scenario I have explained in my post above). 

    Therefore, this would mean when I import bank statement to reconcile, they would find an amount of $200 which I will have to match manually to 2 bank payment voucher entries of $100 each. This is what I would like to avoid. 

    I am using vendor payment journal in Accounts payable module. 

    Thanks

    Harsha 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,969 Super User 2025 Season 1 on at
    RE: One voucher that has one bank line for multiple vendors payments

    Hi Harsha,

    Are you using ledger journals for recording the bank transactions? If so, you can set a document number on the journal header which will be initialized on the lines and the posted accounting entries. This document number could be filled with the bank reference.

    What is the scenario for having one bank payment related to multiple vendors?

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…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,969 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,842 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans