Error when hit Create in business central in sales order in Virtual page or sales order

(6) Share

Report

Posted on by Aryan

196

In Business central integration we have enabled the legacy sales order sync in the integration setup and we are syncing the sales order from CRM to BC so the direction is from integration table but when we click create in business central then this error comes and i have tried every thing but unable to fix it pls help me resolve this .

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Suggested answer

Ramesh Kumar 7,555 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you please copy paste the error message and also can check integration table which will give the reason for error.

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Aryan 196 on at

Like (1)

Report
Copy link

Link copied!

@Ramesh Kumar
Error message:
The field SALES ORDER of table Sales Header contains a value (SOML25260759) that cannot be found in the related table (Dimension Value).

this is when we are trying to create the synced order in business central.

Was this reply helpful? Yes No
Verified answer

Jeffrey Bulanadi 9,121 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Aryan,

“The field SALES ORDER of table Sales Header contains a value (SOML25260759) that cannot be found in the related table (Dimension Value)”

is a classic case of dimension mismatch during integration. Even though the sales order record exists, BC is unable to resolve the dimension value linked to it, likely due to one of the following:

Here’s what’s possible:

Missing Dimension Value Setup

Go to Dimensions → Dimension Values and confirm that the value SOML25260759 exists under the relevant dimension code (e.g., SALES ORDER). If it’s missing, add it manually or ensure your integration logic creates it before assigning.

Incorrect Mapping in Integration Table

If you're syncing from CRM via the legacy sales order sync, check the integration table mapping. The dimension value might be passed as a free-text field without validation. You’ll need to either:

Pre-validate the value against BC’s dimension list

Or use a default fallback value if the incoming one isn’t found

Virtual Page or Custom Page Logic

If the “Create in BC” button triggers a virtual page or custom logic, inspect the AL code behind it. You may need to wrap the dimension assignment in a TryFunction and log failures gracefully.

Dimension Code vs. Value Confusion

Sometimes the integration passes the dimension code instead of the value, or vice versa. Use ValidateShortcutDimCode to ensure the correct field is being populated.

Helpful references:

Fix dimension errors in BC – Microsoft Learn
Common integration errors – The Central Tech

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Verified answer

Mayank_Jangid 265 46 on at

Like (1)

Report
Copy link

Link copied!

Hi Aryan,

From screenshot seems that sales order which is created in dataverse is having a Dimension SOML25260759 ,and that is not available into Dimension Value Table.

Please check that/

Was this reply helpful? Yes No
YUN ZHU 100,919 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

So is there a value of SOML25260759 in Dimension Value? Try adding it first.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,175 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
The error means that the Sales Order record you're trying to sync has a dimension value (SOML25260759) that doesn't exist in Business Central.

✅ How to fix it:

Go to Dimensions > Dimension Values in BC.

Find the dimension that this value belongs to (you may need to check the integration mapping).

Manually create the missing value: SOML25260759 under the correct dimension code.

Retry the sync or click “Create in Business Central” again.

Did you confirm if this value exists in CRM but was never pushed to BC? You may need to sync or validate dimension values before syncing orders.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No