Microsoft Dynamics AX (Archived)

What is the Method/Code that puts ItemGroup in Sales Order Line

(0) Share

Report

Posted on by Community Member

6136.Untitled.png

Im testing some code to use for inserting Sales Order Lines

but my code does not automatically put the Item Group (It shows in manual adding)

can i know what code/method used to put the Item Group Financial Dimension of the Sales Order Line?

my code for testing (1 item only):

{

SalesLine.clear();
SalesLine.SalesId = SalesTable.SalesId;
SalesLine.ItemId = '100407';
SalesLine.SalesQty = 5;

SalesLine.itemIdChanged();

SalesLine.InventDimId = InventDim::findOrCreate(inventDim).inventDimId;
salesline.initFromSalesTable(salestable);
SalesLine.createLine();

SalesLine_ds.refresh();
SalesLine_ds.executeQuery();

}

what should i add to get the ItemGroup?

help. thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

its something environment specific. i.e any setup which is bringing this behavior.
may be your sales order header has dimensions
may be you are using dimension link in inventory setup under posting

Was this reply helpful? Yes No
Suggested answer

Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!
To display ItemGroup use this code...

display ItemGroupId itemGroupId() { InventItemGroupItem inventItemGroup; select ItemGroupId from inventItemGroup where inventItemGroup.ItemId == this.ItemId && inventItemGroup.ItemDataAreaId == this.dataAreaId; return inventItemGroup.ItemGroupId; }

Was this reply helpful? Yes No
Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report
Copy link

Link copied!

Your code is out of order.

The ItemGroup financial dimension, assuming that it's stored on the Released product, is copied during SalesLine.initFromInventTable(..), which is called from SalesLine.itemIdChanged(). But, in your code, you call SalesLine.initFromSalesTable(salesTable) after that, which copied the DefaultDimension field directly from the sales order header, erasing the financial dimensions copied from the Released product.

SalesLine.initFromSalesTable(..) should be called very soon after SalesLine.initValue() and SalesLine.SalesId = SalesTable.SalesId, which should immediately follow SalesLine.clear(); Then set your ItemId, and then call .itemIdChanged(). You should follow the same sequence of events in your code that would occur if you were entering the order from the UX.

Was this reply helpful? Yes No
Verified answer

Brandon Wiese 17,788 on at

Like (0)

Report
Copy link

Link copied!
In other words, move the .initFromSalesTable as shown.

SalesLine.clear();
SalesLine.initValue(); // add this line SalesLine.SalesId = SalesTable.SalesId; salesline.initFromSalesTable(salestable); // moved here SalesLine.ItemId = '100407'; SalesLine.SalesQty = 5; SalesLine.itemIdChanged(); SalesLine.InventDimId = InventDim::findOrCreate(inventDim).inventDimId;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

@Brandon

it worked. thanks!!

and also thanks everyone for the suggestions!

Was this reply helpful? Yes No