How to Display the Total Amount as Vendor in Customer Card

(0) Share

Report

Posted on by Y.Nakayama

Hi,
Balance as Vendor in Customer Card shows only one Vendor's Balance even when the Customer Contact has the relationship with multiple Vendors.
Is it possible to display total amount of all Vendors linked to the contact of the Customer?

Contact can have multiple Vendors and Customers, which looks like many to many relationships with business relation function.

Here is the example:
Cust-A has the relationship to 01-Vendor and 02 Vend with Contact Cust-A.
Account Payable
01-Vendor : 243.75
02 Vend : 120.13
Total : 363.88
Account Receivable
Cust-A : 8,117.50

I want to display the total account payable in Balance as Vendor of Customer Card.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (2)

Y.Nakayama 63 on at

Like (0)

Report

RE: How to Display the Total Amount as Vendor in Customer Card

Thank you, Daniele and ZHU!

I understood Balance As Vendor is not a FlowField, and so customization is needed.

I don't understand why one Contact is able to be set multiple codes for Vendor and Customer in Contact Business Relations.
It looks like 1 to Many or Many to Many relations in Contact Business Relations.
It would be a cause to misunderstand one Customer can link to multiple Vendors.
Verified answer

YUN ZHU 81,789 Super User 2025 Season 1 on at

Like (2)

Report

RE: How to Display the Total Amount as Vendor in Customer Card

Hi, I've investigated the standard code before, and unfortunately, it doesn't support 1-to-many. The standard doesn't take into account multiple vendors, either for getting values, or for Drilldown. So this requires customization if you need it.

More details: https://yzhums.com/23556/

Hope this helps.

Thanks.
ZHU
Verified answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: How to Display the Total Amount as Vendor in Customer Card

hi

customization should be done in AL code

creating a flow field with the same logic as the Balance as Vendor but adding up the vendor amounts linked to the customer

DAniele