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

XMLPort - Purchase invoice with shortcut dimension 3 and 4

(5) Share

Report

Posted on by CU13081445-1

I have an xmlport for purchase invoices that works well, but we need to add shortcut dimension 3 and 4 to it, but those fields don't exist on the purchase line, only in the dimension set ID. How can I go about handling this? is there a way to look up the dimension set ID given the values of dimensions 1-4, or someway to populate that?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

OussamaSabbouh 6,340 on at

Like (1)

Report

Hello,

You can’t write Shortcut Dimensions 3/4 directly on purchase lines. You must build the Dimension Set ID instead. In your XMLport, read the dimension values, then use Codeunit Dimension Management to add/update those dimensions and get a Dimension Set ID, and assign it to the line. BC will reuse an existing set or create a new one automatically.

Regards,

Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, hope the followings can give you some hints

How to add Shortcut Dimensions on the page in Dynamics 365 Business Central (Shortcut Dimension 3 ~ 8)

https://yzhums.com/2182/

Dynamics 365 Business Central: How to add Dimensions to the page (Other than Global and Shortcut dimensions)

https://yzhums.com/5007/

Dynamics 365 Business Central: Use shortcut dimensions in G/L entries for financial reporting

https://yzhums.com/7921/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 4,122 on at

Like (0)

Report

Namaste @CU13081445-1

Shortcut3, Shortcut 4 Dimension code field does not present in purchase line, headers. You can achieve importing in below steps.

1) Add two text fields in Xmlport

2) when you insert in the table use Procedure ValidateShortcutDimCode() oninsert()trigger of xmlport

In your case it will

ValidateShortcutDimCode(3,shortcut3);

ValidateShortcutDimCode(4,shortcut4);

3) it will update dimensions, dimension setid automatically

Check in sandbox.

Warm Regards

Pallavi Phade

www.linkedin.com/in/pallaviphade131116

Was this reply helpful? Yes No