Microsoft Dynamics AX (Archived)

Item cost rounding method

(0) Share

Report

Posted on by Cam Phung

997

Dear All,

When I go to on-hand (release product), I see item cost that show 2 decimal, but it is rounded.

Item cost = 13.819

0218.cost1.png

I print Inventory value report. Item cost show 2 decimal.

Item cost = 13.818,79

1374.cost2.png

I try create a sales order, and I would like to revenue = consumption, show I get unit price = cost price. I sell 10kg.

I check in view sales order totals. I see margin is 2. Cost value do not use cost item in on-hand form (13.819), it use cost item that is not rounded to record.

This is set up in rounding currency.

Question: Please help me to explain this strange?

Thank you

Phung Luong

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (3)

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

Like (0)

Report

Hi Phung,

The currency roundings are 1. This is the reason why AX will not use decimals for postings.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Phung Luong,

I cannot see a problem from the screenshots you show above.

You setup rounding in a way to round to whole $.

The only screenprint that shows decimal places is the inventory value report and here only the average unit cost Price Information. The amount you see there is not rounded according to the currency rounding rules. It is simply calculated by dividing the amount by the quantity.

Please note that AX uses more than 2 decimal places for calculations. That's why you can get the effect that you see in the total form for your sales order.

Best regards,

Ludwig

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

Hi André,

Our currency (VND) rounding are 1. However, amount that record COGS use item cost to calculation with not rounding.

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

Hi Ludwig,

You mean I can not edit item cost with no decimal (rounding are 1) for calculation.

I want to create a sales order with sales price = item cost. That mean margin does not occur.

Thank you

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Phung Luong,

In your case the sales Price is 13189. The internal "running average" cost Price is 13818,79.

That's why you get the 2$ difference.

Is this an intercompany sales order or are there any other reasons why you don't want to make a profit?

If this is an intercompany sales order you can specify cost Price = sales price in the intercompany setup parameters.

Ludwig

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

I am not functional. But, i think it works like 13819 - 13818.79 = 0.21.

0.21 is displaying as 2 in margin.

Try with 13818.79 in sales order, it may change margin to 0.

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

Hi Phung,

You can type the total sales amount (138188) in the Net amount field. The Unit price then will be set empty, but the margin become 0 and the sales invoice can be posted.

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

Hi Ludwig Reinhard,

This is not an intercompany sales order. In Vietnam, when I transfer inventory between 2 location that is not in a province, I have to create an invoice with not revenue. So I try to create a sales order with COGS = revenue to the final transaction is

Dr summary account

Cr Issue

Cr Sales tax payable

Was this reply helpful? Yes No
Verified answer

Cam Phung 997 on at

Like (1)

Report

Dear all,

I change something in customer setup.

I create sales order without price unit and net amount. I get the result that I expect.

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Useful information.

Was this reply helpful? Yes No