Microsoft Dynamics AX (Archived)

Difference between net amount and unit price *quantity on Sales Order AX 2012

(0) Share

Report

Posted on by Community Member

Dear All,

I have a Sales Order:

Step1:

Item A: Quantity 25, Unit Price : 375.454 , Net Amount = 9.386.350

Step2: Edit Quantity

Item A: Quantity 50, Unit Price : 375.454 , Net Amount = 9.386.350

Please tell me why Sales order Line don't update Net Amount follow New quantity ?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi,

In the screenshot above, it looks as if you are not in the edit mode and can thus not change anything.

Can you change to the edit mode and modify the lines to a different quantity as stated above?

After doing that try to refresh the lines by hitting F5, which should change the calculations.

Best regards,

Ludwig

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

Like (0)

Report

Hi Tham,

The screenshot is from the bottom of the page which is a short preview of the complete order. You might need to refresh the form to have this summary updated. Did you already check the line quantity on the editable sales line?

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Tham

It's very easy to achieve that if you give the customer a 50% discount on the order line (which you would not be able to see from the Sales order list page view).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

Thanks for Your's answer, but this Sales order had invoiced. In the invoice, net amount = 50 * 375.454= 18.772.700,00

But sales order still net amount = 50 * 375.454= 9.386.350

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Thanks for Your's answer, I checked the line quantity on the editable sales line.

And this Sales order had invoiced. In the invoice, net amount = 50 * 375.454= 18.772.700,00

But sales order still net amount = 50 * 375.454= 9.386.350

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Terry,

This Sales Order have not 50% discount on the order line. I just update quantity from 25 to 50.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Tham,

Is there any other field such as for example a discount field that we cannot see in the screenshot above and that might explain those numbers?

Can you share another screen that shows both of the data you mentioned and compared?

Many thanks

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

With this Sales Order.

In the Invoice Journal: Quantity 50kg, Amount: 18,772,700.00

But, in the Transaction Inventory: Sold 25kg

And in the sales order have not any discount.

Please help me!!

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Tham,

Sales order lines do have several fields for a quantity. There is a sales quantity and also an inventory quantity. Do you have another unit of measure for this sales order line? If the UoM is the same as the inventory unit, then there might be a mismatch between the sales quantity (SalesQty) and inventory quantity (QtyOrdered) which could cause your issue. If the sales invoice is posted correctly, you can consider deducting the on-hand using an inventory journal.

Was this reply helpful? Yes No