You’re offline. This is a read only version of the page.
Announcements
Hi all,
Do you know what is the best approach to implement a vendor/customer balance netting off process? Or if there is any thinking in the roadmap or either an idea to vote.
Business requirement
We deal with some partners in both sales and purchase transactions, and therefore, those partners become both customers and vendors respectively. Such entities may be having both debits (Representing sales transactions) and credits (representing a purchase transaction) balances. Our company may have a requirement to make a single payment to any such partner (representing the net amount of the two separate accounts), instead of two separate payment transactions.
Thank you in advance!
Typically, I would manually create the journal entry to move the AR balance to offset the AP balance (settling this transaction against open invoice items is recommended), which will leave the remaining AP balance for the vendor to be paid by your AP payment run.
Unfortunately, there isn't an automation like in the case of the Reimbursement process.
Hi Magno,
This feature would come in quite handy for a similar customer requirement we are dealing with.
Do you have an idea whether the function will be available for other countries (besides HU and PL) as well?
Thx. in advance!
I stumbled upon this Hungarian/Polish feature that does exactly this.
docs.microsoft.com/.../emea-compensation-customer-vendor-transactions
However you have to set Allow multiple transactions within one voucher to YES or have a journal with a number sequence that allows you to manually change the voucher number. Then you can set an offset account and create two vouchers instead of one.
That's all, Ludwig. Thank you for your support.
Great.
Is there anything else the community can do for you in this respect or can we verify the answers and get this thread completed?
We will do customization to run a routine like a payment proposal to give us the netting off and create the transactions automatically.
Hi Magno,
You are right.
D365FO does not support your scenario B.
If you want to deduct the $100 from the vendor payment then you would have to post the amount from the customer to the vendor account manually.
Alternatively, you can make use of something like PowerAutomate to get this automated for you but the standard feature that you used won't do that transfer without further modification.
Best regards,
Ludwig
Hi Ludwig,
Do you have another way how to do the netting off, considering the examples above?
Thank you in advance.
Hi Ludwig,
I already did a few tests, and I'd like to share with you some thoughts.
TEST A - Netting off OK
TEST B - Netting off not works
However, we would like to move forward and transfer the balance to the vendor account. It means to have a zero customer balance and a 900$ vendor balance.
How do you see this happening?
Thank you Ludwig! I will do some test using the Customer Reimburse.
#1
André Arnaud de Cal...
294,161
Super User 2025 Season 1
#2
Martin Dráb
232,942
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
