Unit Cost Calculation In Navision

Unit Cost Calculation

  • Inventory in Navision is valued based on the Value Entries .
  • Cost is recorded in the Cost Amount (Actual) field in Value Entry table.
  • Navision will copy value from Unit Cost (LCY) field on Purchase Line / Unit Cost field on the item journal line to Cost Amount (Actual).
  • Direct Unit Cost Excl./Incl. VAT in Purchase Line / Item Journal Line is copied from Item Card Last Direct Cost.
  • For Item Journal Line, the Last Direct Cost is copied to the Unit Amount field on the item journal line.
  • Unit Cost in the Purchase Line / Journal Line is calculated based on
  1. a) Last Direct Cost
  2. b) Unit Cost
  • Formula to calculate Unit Cost (LCY) field in Purchase Line:Unit Cost (LCY) = (Direct Unit Cost – (Discount Amount / Quantity)) * (1 + Indirect Cost % / 100)) + Overhead Rate
  • Formula to calculate Unit Cost in Item Journal Line:Unit Cost = Unit Amount * (100% + Indirect Cost %) + Overhead Rate
  • For Standard Costing method, Standard Cost in Item Card will be copied to the Purchase Line Direct Unit Cost Ext./Incl. SST.
  • Summary of the flow of cost – Non Standard Cost:

Item Card (Last Direct Cost) –> Purchase Line (Direct Unit Cost Excl./Incl. SST) –> Purchase Line (Unit Cost (LCY) –> Value Entry (Cost Amount (Actual))
Item Card (Last Direct Cost) –> Item Journal Line (Unit Amount) –> Item Journal Line (Unit Cost) –> Value Entry (Cost Amount (Actual))

Leave a Reply

Your email address will not be published. Required fields are marked *

eight + 13 =