Small and medium business | Business Central, N...

GP to BC Customer Class Dimension Conflict

(8) Share

Report

Posted on by ahanson

254

Hello, I'm trying to setup dimensions like a customer had on their customer class in GP.

Here is their GP setup:

AR 13000-0-001-000

Sales 30800-0-410-180

COGS 50150-0-410-180

Inventory 17680-0-001-000

The accounts are GL, shortcut 3, global 1, global 2

In GP, they had their account roll down from the customer in the transaction, not the item. They do sell an inventory item.

How would you configure the dimensions like this between the header and line without having to let it process and then do a dim correction on an account?

Thank you.

Categories:

Dynamics 365 Business Central migration

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

OussamaSabbouh 12,878 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

You can’t replicate GP’s customer-based account roll-down in standard Business Central. In BC, items + posting groups control the G/L accounts, not the customer. The supported approach is to put customer-related dimensions on the Sales Header (via Default Dimensions); they flow to all lines automatically, while accounts stay fixed. Changing G/L accounts per customer (like GP segments) is not supported without customization—dimensions are the intended replacement.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If this helps: https://community.dynamics.com/forums/thread/details/?threadid=2f4e010b-4d27-f011-8c4e-7c1e521a9c2c

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey Buddy, that's simple and you are on the right direction of bifurcation, Interestingly I did 3 GP to BC migration so I had been on it -

AR 13000-0-001-000

Sales 30800-0-410-180

COGS 50150-0-410-180

Inventory 17680-0-001-000

EG -

GL - 13000

D1 - 0

D2 - 001/410.....

D3 - 000,180,000

You need to decide between Global & Shortcut - Entity and Department you can go for Global One Rest Shortcut.

Make the FL Default mandates for the shortcut

Use the corresponding GL while doing transaction and run the Analysis View for shortcut's.

Was this reply helpful? Yes No
ahanson 254 on at

Like (0)

Report
Copy link

Link copied!

@RockwithNav how do you handle though if the COGS, sales, and inventory don't have the same of a particular dimension value? That's our conflict.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,084 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: Default Dimension Priorities (Avoiding conflicts)

https://yzhums.com/23962/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,947 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ahanson - This is tricky, Dimension will flow exactly as it is , so we can't do anything on that, Dimension will flow exactly as we have in Business central or else major customization will come in picture to just handle this.

Was this reply helpful? Yes No