Run Replace by Alternate Item in Code (Sales Order Lines)

(0) Share

Report

Posted on by XSpy

209

In the Sales Order Lines, if the Item you add does not have stock, the Replace by Alternate Item will be prompted (when you save it)

it looks like this:

I have this code which adds Item Number / Sales Order Lines by button click,

now i need to run the Replace by Alternate Item in my code.

can you help me achieve it?

here's my code:

void clicked()
{
SalesLine.clear();
SalesLine.SalesId = SalesTable.SalesId;
SalesLine.ItemId = '0000000003';
SalesLine.InventDimId = InventDim::findOrCreate(inventDim).inventDimId;
salesline.initFromSalesTable(salestable);
SalesLine.itemIdChanged();
SalesLine.validateWrite();

SalesLine.createLine();

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

-----------------

PS. im using the code to make a import from excel button, i just need to run the Replace by Alternate Item for now.

please help me, thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

5400 7,162 on at

Like (0)

Report

I will suggest you please add the logic before save the records in DB. once you are getting the inventory dimension value as per your code please check the inventory on-hand as per your present itemid and inventdim, if inventory on-hand is not there please display one dialog as you said above with ItemID lookup. If you want to change the itemid please select from lookup and save the records again with same validation.

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

isn't there any method that runs the lookup for the alternate item?

because if it is working in manual, i think it has method.

i need to get that to apply in my code.

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

For this, I don't think so you need customization. you have to set the parameters and system should check automatically above condition but you are calling same API in our code or not you have to check only.

community.dynamics.com/.../117332

community.dynamics.com/.../73251

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

is there any other way?

i'm having a hard time composing the code because the on-hand inventory (the qty) can only be seen after saving the sales order line.

is there a way to find what function did the AX use to Alternate Item Number in manual inserting of data?

Was this reply helpful? Yes No
Verified answer

Florian Hopfner 2,461 on at

Like (0)

Report
Take a look at class SalesAlternativeItem, depending on what you want to do, it could be as simple as

SalesLine salesLine; SalesAlternativeItem salesAlternativeItem; salesLine = SalesLine::find(mySalesId, myLineNum); salesAlternativeItem = SalesAlternativeItem::newAlternativeItem(salesLine); salesLine.setAlternativeItem(salesAlternativeItem);

Was this reply helpful? Yes No

Community site session details

Run Replace by Alternate Item in Code (Sales Order Lines)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Run Replace by Alternate Item in Code (Sales Order Lines)

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates