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
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
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
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (