Dynamics Community Forum Thread Details

LineAmount, Price and itemName are not being set when creating sales order by code

Hi,

If I do the following, LineAmount, Name and price gets reseted to 0 after I use the createLine

salesLine.initFromSalesTable(_salesTable);

salesLine.ItemId = _salesOrderLineContract.ItemId();
if(_salesOrderLineContract.ItemName())
{
salesLineName = _salesOrderLineContract.ItemName();
}
salesLine.SalesPrice = _salesOrderLineContract.SalesPrice();
salesLine.SalesQty = _salesOrderLineContract.SalesQty();
salesLine.LineAmount = salesLine.calcLineAmount();

salesLine.createLine(true, false, true, true, true, true);

So I update the salesLine back again:

select firstonly forupdate salesLineLocal where salesLineLocal.SalesId == _salesLine.SalesId
&& salesLineLocal.LineNum == _salesLine.LineNum;

if(_salesOrderLineContract.ItemName())
{
salesLineLocal.Name = _salesOrderLineContract.ItemName();
}

salesLineLocal.SalesPrice = _salesOrderLineContract.SalesPrice();
salesLineLocal.LineAmount = salesLineLocal.calcLineAmount();
salesLineLocal.update();

is there another way? I think it's happening because of the the third parameter in createLine _initFromItemOrCategory

Does this mean I need to call salesLine.initLineFromItemOrCategory() before setting prices? then set the parameter as false in the createLine? but would i miss anything from standard behaviour if i do this?

I mean like this:

salesLine.initFromSalesTable(_salesTable);
salesLine.ItemId = _salesOrderLineContract.ItemId();
salesLine.initLineFromItemOrCategory();
if(_salesOrderLineContract.ItemName())

{
salesLineName = _salesOrderLineContract.ItemName();
}
salesLine.SalesPrice = _salesOrderLineContract.SalesPrice();
salesLine.SalesQty = _salesOrderLineContract.SalesQty();
salesLine.LineAmount = salesLine.calcLineAmount();

salesLine.createLine(true, false, false, true, true, true);

Question not related: Do i need to call SalesLine.ItemIdChanged() as well when creating sales order by code? if yes why?

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL