Vendor Posting Group in hierachy

(6) Share

Report

Posted on by CU24071714-0

How can I set up a vendor posting group on a hierachy level? I have set up few vendor posting group, like utility, but i like to break it down example for the first layer be utility then have diffrent types utility with in this. Or what is the best way to achieve this please?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (4)

Verified answer

Sumit Singh 10,079 on at

Like (5)

Report
In Business Central, Vendor Posting Groups are flat by design — they don’t support hierarchical structures natively. However, you can achieve a hierarchical or categorized reporting structure using a combination of Vendor Posting Groups, Dimensions, and Reporting Filters.
✅ Recommended Approach: Use Dimensions for Hierarchical Categorization
Here’s how you can structure it:
1. Vendor Posting Group (Top-Level Category)

Create a Vendor Posting Group called UTILITY.

Assign this to all utility-related vendors.

2. Dimensions (Sub-Categories)

Create a Global or Shortcut Dimension called UTILITY TYPE.

Define dimension values like:

ELECTRICITY

WATER

INTERNET

GAS

Assign the appropriate dimension value to each vendor or purchase document.

3. Assign Dimensions to Vendors

Go to the Vendor Card → Navigate → Dimensions.

Assign the UTILITY TYPE dimension with the appropriate value.

4. Use in Reporting

When running reports like Vendor Ledger Entries, Trial Balance, or Account Schedules, you can:

Filter by Vendor Posting Group = UTILITY

Break down by UTILITY TYPE dimension

This gives you a hierarchical view:
UTILITY (Vendor Posting Group) → ELECTRICITY / WATER / etc. (Dimension Values)

🔄 Alternative (Less Flexible): More Vendor Posting Groups
You could create multiple posting groups like:

UTILITY_ELECTRICITY

UTILITY_WATER

UTILITY_INTERNET

But this becomes harder to manage and lacks the flexibility of dimensions in reporting and analysis.
Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (3)

Report

Business Central doesn’t support hierarchical Vendor Posting Groups directly. The best way to achieve what you’re looking for is to set a single posting group like “UTILITY” for all related vendors, and then use dimensions to break it down by type.

Helpful links

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-dimensions

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Verified answer

techreviews.digital 376 on at

Like (4)

Report

For Managing the information of Vendor Posting Group on Hierarchy level, the following steps can be considered:

Solution 1:

Step 1: G/L Accounts:

Created and Indent Begin Total, End Total, and Posting G/L Accounts related to the Utilities, in Chart of Accounts. Also create related Payable G/L Accounts.

Step 2: Vendor Posting Groups:

Create and Setup related Vendor Posting Groups. Such as;

- Electricity

- Water

Step 3: Assign the Vendor Posting Groups on Vendor Card:

Assign the vendor posting groups to the related vendors, to be able to see the allocation of amounts in Chart of Accounts, for Utilities Expenses in a hierarchical order.

Solution 2:

Step 1: Vendor Posting Group Setup:

The Vendor Posting Group will be setup as Utility, for reflecting the impact of transactions in their related G/L Accounts:

Step 2: Vendor Card Page:

The Vendor Posting Group will be selected as Utility in related vendors.

Step 3: New Utility Dimension:

Utility dimension needed to be created on Dimensions page.

Step 4: Dimension Values:

- Select Dimension Values from the Dimension menu.

- Create different types of utilities as Dimension Values.

Step 5: Setup Utilities as Global Dimension:

- Update and select the Utility Dimension as your Global Dimension so, the user will be able select the dimension value while posting the transactions.

I hope it will resolve all the concerns.

Thanks.

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 20,363 Super User 2025 Season 2 on at

Like (5)

Report

Please check this: How tp set up Sub-vendor Group in Vendor posting group - Microsoft Q&A

Was this reply helpful? Yes No