How to update the Unit Cost according to the Last Unit Cost

(0) Share

Report

Posted on by Community Member

Hey guys!

So just like the tittle says..how do I do that? We are using average method, and it happens that both costs differ quite a lot, is there then a way to update the items Unit Cost according to the Items Last Unit Cost??

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Rabin 2,976 on at

Like (1)

Report

Hi Pollux,

As a rule, the value in the Unit Cost field on the item card is based on the standard cost for items with costing method standard. For items with all other costing methods, it is based on the calculation of the inventory available (invoiced costs and expected costs) divided by the quantity on hand.

When you sell items, the unit cost is copied from the Unit Cost field on the item card to the sales line or the item journal line.
When you purchase items, the value in the Last Direct Cost field on the item card is copied to the Direct Unit Cost field on a purchase line or to the Unit Amount line on an item journal line.

//----

You just need to define the Costing Method as FIFO, LIFO, SPECIFIC, OR AVERAGE (which you have already defined).

If you goto the Item Card then you can check the related Ledger Entries and when you drill down the entries you can see all the transaction made on that item and according to costing method selected you will get the Calculated Cost.

Was this reply helpful? Yes No
Suggested answer

Rabin 2,976 on at

Like (1)

Report

You have to select LIFO - LAST IN FIRST OUT, because the one that you are selecting "Average" will always average the value and hence you are getting that value...

Eg: let say you have 3 Transactions 10$, 20$ 60$ hen According to Average calculation: it will be (10+20+60)/3 = 30$ which is is not a nearby value to your last transaction i.e 60$. It is calculating the Average value. So if you want the Last value then Select LIFO as costing method.

Thanks.

Was this reply helpful? Yes No
Verified answer

Cheikh FAYE 45 on at

Like (1)

Report

Hi Pollux

As the average method is the one you definitely choose , the only way to update the item unit cost is to divide the total cost of items by the total quantity of items.

Thanks a lot.

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (1)

Report

This is an autocalculated field which you cannot edit manually in the item card. Unit cost = inventory value of items on hand (expected cost + invoiced cost) / quantity on hand.

Here is a good short article explaining how it is calculated:

www.archerpoint.com/.../how-microsoft-dynamics-nav-calculates-unit-cost-item-card

However, there are cases, when it can be updated to the Last Direct Cost.

During the posting of purchase invoices, output, or positive adjustment if one of the following conditions is true:

- The net invoiced quantity of the item changes from negative or zero to positive.

- The current unit cost is zero.

If one of these conditions is true, then the Unit Cost field is updated with the value in the Last Direct Cost field on the item card.

Refer more: msdn.microsoft.com/.../hh169034(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok, yes, thanks thats what I thought. The Units costs are correct for most of the items, but some, as there were some wrong bookings at the beginning of our fiscal period , have wrong costs. I guess that in practical terms doesnt have an impact on our daily business, nevertheless that gets our staff confused

Was this reply helpful? Yes No