Finance | Project Operations, Human Resources, ...

Vendor also being Customer

(0) Share

Report

Posted on by Manoj Srinivas

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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (1)

Report

Hi Manoj,

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.

Was this reply helpful? Yes No
Manoj Srinivas 30 on at

Like (0)

Report

Hi Alireza,

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.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Manoj,

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

Was this reply helpful? Yes No
Manoj Srinivas 30 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (1)

Report

Hi Manoj,

As per my investigation, I cannot find a standard function for this purpose than manage this via general journal.

Was this reply helpful? Yes No