• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Skip to footer
  • Business Central
  • Dynamics NAV
    • NAV 2018
    • NAV 2017
    • NAV 2016
    • NAV 2013
  • Others
    • About
    • Privacy Policy
    • Disclaimer
    • Contact Us

Navision Planet

This Blog is intended to help Microsoft Dynamics NAV / Business Central ERP developers as well as users. If you just go through these blogs you will understand what I have told is correct. The Blog will continuously get update with latest news. This Blog is handled by a group of Microsoft Certified Partners as well as Business Solution Specialists in Microsoft Dynamics NAV and Dynamics 365 Business Central. Feel free to mail us for any doubts.

  • LS Retail
  • Help Topics
    • Finance Module
    • Manufacturing Module
    • Warehouse Module
    • Administration
  • Navision Developer
  • GST
  • D365 Business Central
  • CU Update
    • Download Business Central

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))

Reader Interactions

Comments

  1. PA says

    November 20, 2020 at 3:06 pm

    Can we edit Last Direct Cost?

    Reply
    • JUBEL THOMAS says

      July 23, 2021 at 4:51 pm

      You may edit the same.

      Reply

Leave a Reply Cancel reply

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

Primary Sidebar

Subscribe

  • Email
  • Facebook
  • Twitter

Our Topics

Administration Analysis Reports Business Central Developer Toolkit Docker Dynamics NAV Beta Download Dynamics NAV Release Error Message Finance Module GST Human Resource Login Error LS Retail LS Retail 2013 Manufacturing Module Microsoft Certified Trainers (MCTs) Microsoft Dynamics Business Central Microsoft Dynamics NAV 2009 Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2015 Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2018 MSDyn365BC NAV 2016 Navision Certification Navision Developer Navision Introduction Navision Modules Navision Retail Navision Tips And Tricks Powershell Purchase Order Sales Module SQL Server Useful Sites Visual Studio Code Warehouse Module

Footer

Recent Post

  • Dynamics NAV Versions List
  • Business Central Complete Version List and Direct Download
  • Learn NAV Programing Language

Search

Contact : support@navisionplanet.com for Microsoft Dynamics NAV (Navision ) and LS Retail Development or Functional support for any modules

 

Editors News Letter


New Microsoft Dynamics NAV Technical Blog opened the Navision Planet Team

MIBUTECH

https://www.mibutech.blogspot.com

Copyright © 2023 Navision Planet