The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category "Performance". This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly. If you enjoyed this blog, you might like to check out our collection of Development Blogs, as well as our “How To” blogs for practical advice on using Microsoft Dynamics NAV. If you would like to discuss this or any other Dynamics NAV costing or inventory valuation topics, please contact ArcherPoint. 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.įigure 2 – The Unit Cost is the sum of the cost amounts divided by the total of the Item Ledger Entry Quantity Additional Value Entries may later be added by adding an Item Charge or the adjust cost program.ĭynamics 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. The Value Entry reflects the cost of that transaction, whether positive or negative. When an inventory transaction is recorded in NAV, an Item Ledger Entry and an associated Value Entry are automatically entered into the NAV database. To understand how Microsoft Dynamics NAV calculates Unit Cost, one has to understand NAV’s Item Ledger Entries and NAV’s Value Entries. The question is, how did Dynamics NAV calculate that number? If we look at the Invoicing Tab on the Dynamics NAV 2013 Item Card, we see that the Unit Cost is 42.80.įigure 1 – Invoicing Tab on the Dynamics NAV 2013 Item Card We sometimes describe the Unit Cost on the Item Card as the “weighted average cost of the remaining inventory”. It seems like a simple question, but in large part the answer is not well known. From time to time we get the question, “How is the Unit Cost on the Dynamics NAV Item Card calculated?”
0 kommentar(er)
