Average cost and unit cost
hansika
Member Posts: 373
Hi
What is the exact difference between Average cost and unit cost field in Item card.
Because I created a new item , costing method is FIFO ,
I purchased items with different costs .
When it goes to the fields the both fields have same values like Average cost ( Lcy) = 156.66667 Unit cost = 156.66667
Could any expert throw what is exact dffernce between the fields.
Is there any chance to differ both values . ?
Even I gone through the F1 Help, I could not understand .
Better to throw one example when the costs will differ.
What is the exact difference between Average cost and unit cost field in Item card.
Because I created a new item , costing method is FIFO ,
I purchased items with different costs .
When it goes to the fields the both fields have same values like Average cost ( Lcy) = 156.66667 Unit cost = 156.66667
Could any expert throw what is exact dffernce between the fields.
Is there any chance to differ both values . ?
Even I gone through the F1 Help, I could not understand .
Better to throw one example when the costs will differ.
hansika
0
Comments
-
hi
Average cost is a cost which calculate sum of cost amout(Actual) and Cost Amount (expected) in value entry table the amount of this field is divided by total qty on item ledger entry qty field while unit cost is depend on the costing method which is you selected in fifo method Unit Cost = Inventory Value of items on hand (expected cost + invoiced cost) / Quantity on Handajay k tripathi
Functional Consultants0 -
& don't forget to run your adjust cost batch job0
-
Thanks experts,
Even I run the batch job Adjust item cosat entries.
still it is showing the same values.
Let me know the exact difference . :-khansika0 -
You need to process items through and begin to understand.
Load a purchase order, receive it, invoice it, load another PO for the same item, receive it at a different cost. start to track the unit cost at each stage.The art of teaching is clarity and the art of learning is to listen0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 323 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions