web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Is there anyway I can ...

Small and medium business | Business Central, N...

Answered

Is there anyway I can readjust my unit cost in Navision 2018?

(0) Share

Report

Report

Posted on by joshtechsolutions

4,947

Hi,

May I ask is there anyway I can readjust my unit cost in Navision 2018?

Thank you!

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

RE: Is there anyway I can readjust my unit cost in Navision 2018?

Josh,

Why? If you posted an incorrect Unit Cost for an Item it depends. Is the Invoice to the Vendor incorrect so you can do a Purchase Return Order and remove the Invoice and Item and then create a new PO and receive and invoice. If this is solely a Unit Cost mistake, you can use Revaluation Journal to take the Item Ledger entry that is not correct and correct that specific Item Ledger Entry layer.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,758 Super User 2025 Season 2 on at

Like (0)

Report

RE: Is there anyway I can readjust my unit cost in Navision 2018?

Hi, as Steve said, you cannot adjust the unit cost of the posted documents in NAV, you need to create Credit Memo, and then create a new document.

But If you want to appreciate or depreciate an item or a specific item ledger entry, you can use the revaluation journal.

https://docs.microsoft.com/en-us/dynamics-nav-app/inventory-how-revalue-inventory

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,366 Super User 2025 Season 2 on at

Like (0)

Report

RE: Is there anyway I can readjust my unit cost in Navision 2018?

Use Revaluation Journal.

docs.microsoft.com/.../inventory-how-revalue-inventory

Was this reply helpful? Yes No
joshtechsolutions 4,947 on at

Like (0)

Report

RE: Is there anyway I can readjust my unit cost in Navision 2018?

Hi Steve,

Actually, my purchasers were saying that in the business point of view, the Unit Cost shouldn't be change unless our suppliers tell us so. Otherwise, chances are the changes by the system will fall either below or above the actual price, even if its only 0.1 cents.

If you look at it in bulk. 1 unit is 0.1 cents, 600 units will be around $60 loses to us.

So on this point i'm not sure why Navision system will do this kind of calculation.

If its due to Costing Method, which for my business we have selected FIFO, am I selected the wrong costing method?

As you can see in the screenshot. The unit price is 23.25893, which is not the unit price we have inserted previously.

Hence purchaser have to change the Direct Unit Cost Excl GST, which reflects here as $23.26.

Although in terms of figures, it is the same pretty much, but overall on the PO if it appear as $23.25893, it is incorrect.

Please advise if possible.

Thank you!

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Is there anyway I can readjust my unit cost in Navision 2018?

Josh,

Let me take a moment to explain the Unit Cost field in the Item Card and Last Direct Cost field.

Last Direct Cost - Is the latest direct unit cost from the Direct Unit Cost field in the Purchase Line table when you post an order as invoiced. If you use journals, the program copies the direct unit cost from the Unit Amount field on item journal lines of the Purchase entry type.

Unit Cost - We sometimes describe the Unit Cost on the Item Card as the “weighted average cost of the remaining inventory”. If we look at the Invoicing Tab on the Item Card, we see that the Unit Cost is 42.80.

The question is, how did Dynamics NAV calculate that number? To understand how Microsoft Dynamics NAV calculates Unit Cost, one has to understand NAV’s Item Ledger Entries and NAV’s Value Entries. When an inventory transaction is recorded in NAV, an Item Ledger Entry and an associated Value Entry are automatically entered into the NAV database. The Value Entry reflects the cost of that transaction, whether positive or negative. Additional Value Entries may later be added by adding an Item Charge or the adjust cost program. Dynamics NAV calculates the unit cost by finding the Value Entries for the item and then adds up the Cost Amount (Expected) and Cost Amount (Actual) to get the total cost. It then adds up the Item ledger Entry Quantity and then divides the total of the costs by the total of the Item Ledger Entry Quantity to get the Unit Cost.

The Unit Cost is the sum of the cost amounts divided by the total of the Item Ledger Entry Quantity

On last thing, an item’s unit cost is the actual value of any receipt of the item, selected by the FIFO rule. In inventory valuation, it is assumed that the first items placed in inventory are sold first.

I do not see an issue overall but I hope the above give you and your finance team more information.

Thanks,

Steve

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Rishabh Kanaskar 4,327

#2

Sumit Singh 2,734

#3

Nimsara Jayathilaka. 2,599

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans