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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Using dimensions with ...
Small and medium business | Business Central, N...
Suggested Answer

Using dimensions with Sales Orders

(0) ShareShare
ReportReport
Posted on by drew777777 140

Hi,

I have set up a dimension called CUSTOMER TYPE. I will be using the values DOMESTIC and FOREIGN for this dimension.

I would like to assign this dimension to all of my customers. I.e. I want every customer to be classified as either DOMESTIC or FOREIGN.

I've used table 352 to assign the default dimensions.

The problem I am facing is that now when users go to post sales orders they are being forced to select a dimension before posting each order.

Is there a way to configure it so that if customer ABC is assigned a CUSTOMER TYPE dimension value of DOMESTIC every sales order for customer ABC will be automatically posted with the DOMESTIC dimension value? I don't want my users to have to manually select a value for each sales order.

Any help would be much appreciated

Thanks

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Drew,

    On the Customer Card when you navigated to Dimensions, did you setup the Dimension Code = Customer Type, a Value = Domestic or Foreign, and Value Posting = SAME CODE.

    Try this and test.

    Thanks,

    Steve

  • drew777777 Profile Picture
    drew777777 140 on at

    Hi Steve,

    Thanks for the reply. I had set the Value Posting to Same Code.

    When my users went to post sales orders they received the below error message.

    The dimensions used in Order S123456 are invalid (Error: Select Dimension Value Code DOMESTIC for the Dimension Code CUSTOMER TYPE for Customer ABC)

  • Community Member Profile Picture
    Community Member on at

    Drew,

    Was this Sales Order already created and a User tried to Post. If yes, the Dimensions have not been updated to already created documents. If you created a Sales Order from scratch, entered the Item and try to Post, does that work.

    Steve

  • drew777777 Profile Picture
    drew777777 140 on at

    Hi Steve

    This was a sales order that was already created. I tried creating a sales order from scratch and it worked.

    Given that we have hundreds of open sales orders I'm wondering what is the most efficient way to assign the appropriate dimension values to each order.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,664

#2
YUN ZHU Profile Picture

YUN ZHU 960 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans