Sales Line Cost Price/Line Amount not updating when creating sales line using code(x++) AX 2009

(0) Share

Report

Posted on by Community Member

Hi All,

I am able to create sales order header and sales lines through code in AX 2009 AOT job. But Sales Line price or amount not updating for items.

Here is my sample code to create sales lines:-

static void CreateSalesLine(Args _args)
{
SalesTable salesTable;
SalesLine salesLine;
;
ttsbegin;
salesTable = SalesTable::find('sales order number');
salesLine.clear();
salesLine.SalesId=salesTable.SalesId;
salesLine.ItemId = "itemId";
salesLine.createLine(NoYes::Yes,
NoYes::Yes,
NoYes::Yes,
NoYes::Yes,
NoYes::Yes,
NoYes::Yes);
ttscommit;

}

Any help would be really appreciated.

Thanks

Arun Kumar

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Arun,

You need to call the method salesLine.itemIdChanged() after you have filled the ItemId field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

I've tried with salesLine.itemIdChanged() but Price or Amount still showing 0.00 in Sales Order Items form view.

Any idea what I am missing?

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi AKumar,

Do you have any trade agreements setup for this item? When you manually create the line in the sales order form, are the values filled correctly? Did you also try to set a quantity in the code to create the line?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've created sales lines using sales order form and still values are not filled for Price and Amount. Also I've tried with SalesQty filled but no success.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

In that case you are probably missing trade agreements or a price setup on the item form. It's not due to coding.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your suggestions.

I will confirm that.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've confirmed and there are no trade agreements setup on the items.

Can you please provide me steps to achieve this. How can I update the Price fields using code?

Thanks in advance.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Try to setup some prices and see if the code suggestion "salesLine.itemIdChanged()" will work then.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Why you don't want to set price and qty in your code ?

salesLine.PriceUnit = 1050.00;

salesLine.SalesQty = 10;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I've checked and prices are already setup for item under Inventory Management- > Item Details -> Price.

When sales line created by code Unit Price field is populating for Item but not Price or Amount field on Sales Order form.

Was this reply helpful? Yes No