Dear Experts!!!
This is a scenario where a company sells raw material to us and purchase finished goods from us. At any given time, there will be both receivable balance and payable balance to that company. Is there any functionality to knock off the balances other than manual JV and pay/receive only the net amount? Please share your thoughts or link that may guide to correct process. I have seen similar question in BC, but just want to understand the behaviour in AX.
Hi Manoj,
As per my investigation, I cannot find a standard function for this purpose than manage this via general journal.
Hi Alireza,
Thanks a ton for your efforts. I have gone through the above links and it really helps in a scenario where customer balance is credit. But what if the scenario is other way around. For ex, We are owing 200 to the party through purchases and party is owing only 50 to us (by way of purchases from us). Now if the party ask us to pay only 150 out of 200 and adjust the remaining 50 with the amount they are owing to us, Is there any set up for the adjustment?
There is standard link with customer and vendors on the customer master form while vendor master does not have the same field for customer.
You can find this field on All Customer > Miscellaneous details tab > Remittance/vendor account field:
When it applies to settlement, like you mentioned you can use general journal for this purpose.
If a customer has a credit balance, you can reimburse the customer for the amount of the balance. Please check the following post on Microsoft docs:
https://docs.microsoft.com/en-us/dynamics365/finance/accounts-receivable/reimburse-customers
Related issue on Microsoft Community:
community.dynamics.com/.../link-vendor-to-customer
Thanks for your reply and input. I am checking on how to set off the payable balance with receivable amount from the same company. I believe One way is to pass a General journal. Just curious to know whether there is any other setup for this.
Can you elaborate your question?
You can create this company as a part in Global address book and then you can create this as a vendor and customer in the legal entity.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 823 User Group Leader
André Arnaud de Cal... 673 Super User 2025 Season 2
Martin Dráb 491 Most Valuable Professional
