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
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
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
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
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?
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156