web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Main vendor with sub- vendors

(0) ShareShare
ReportReport
Posted on by 281

Dears, as per my knowledge the feature to have Sub-vendors related to a main vendor not possible in Business central.

I got this request from one client:

Vendor Name: Hyper Market Inc.   | Vendor Type: Main

This vendor has 10 vendors under the same company [Hyper Market Inc. Branches ] but we deal with each sub-vendor separately but sometimes the Main vendor asks to provide a consolidated Statement, as well as the Payments some times he requests to pay to a specific sub-vendor.

Summary: Vendor 1 Main has 10 branches [different legal entity], sometimes we deal separately & sometimes consolidated

Thanks

I have the same question (0)
  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I assume you are aware that in each vendor card under Invoicing section you can define the parent company. This way you buy from company A but bill company B. Also, since all billing is under one company you can consolidate all payments. In addition, since Buy From is vendor branch you can see each branch PO. 

    But looks like in your case it a case by case. Do you know each case when you create a PO or this is after invoicing? 

    Thanks 

  • mahmoud_algindy Profile Picture
    281 on at

    Thanks MahGah

    Yes, I am aware of  Buy-from & Pay-To,

    It seems this will not work with this scenario as the same Main vendor have a lot of Sub-Vendor, dealing with both Main & Sub-Vendor daily with a large amount of transactions.

    Also, Pay to not always be clear at the Point of Purchase.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,111 Moderator on at

    I think the only way you can come close to achieving this in the standard application is with some clever use of dimensions. 

    Then you can have all transactions on one vendor but use dimensions to mark what legal company the transaction belongs to.

    You could also keep them as separate vendors but assign a specific vendor posting group to this group of companies.

    Then you could customize some reports that lets you report on all transactions for one specific vendor posting group. That is probably supported in some of the standard reports but not in all.

  • Suggested answer
    MahGah Profile Picture
    15,529 on at

    Hi

    I believe what Mr. Bruvik suggested is the better method.

    I saw this app and this has some similarity with Inge suggestion (use of dimension).

    appsource.microsoft.com/.../pubid.adacta|aid.adacta-adadm|pappid.2bf73771-ac88-49f8-a142-0189fb069995

    dev.azure.com/.../Customer-Vendor-Item-Classifications

  • mahmoud_algindy Profile Picture
    281 on at

    Thank you

  • mahmoud_algindy Profile Picture
    281 on at

    Thanks NorthW

    The main issue is my customer doesn't need to use dimension for that, I am trying to do some demo & sure he will accept.

    Thanks so much again

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,135

#2
YUN ZHU Profile Picture

YUN ZHU 733 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 612

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans