FIFO - Need to Know Correct Cost of Item
JAYESH
Member Posts: 290
HI Experts,
I have set up system as FIFO. So on the item card the Item Cost is Average Cost for the Item.
I want to know the Correct Cost for the ITEM as FIFO.
How can i get that ?
Thank you
I have set up system as FIFO. So on the item card the Item Cost is Average Cost for the Item.
I want to know the Correct Cost for the ITEM as FIFO.
How can i get that ?
Thank you
JAYESH PATEL
0
Comments
-
The system will calculate it for you on an outbound entry based upon teh open transactions when the adjust cost item entry is run. You can then see it on the item ledger entries and view the make up from teh value ledger entries.The art of teaching is clarity and the art of learning is to listen0
-
When you drill down on the item ledger, you'll be able to see the exact cost for each transaction layer.
I think there is a little confusion on what FIFO means. FIFO is only used when the item is sold, consumed, or negative adjusted. When this happens, the amount that's posted to your COGS is taken out based on FIFO.
So you don't look at your "value" in FIFO, in addition, Navision will show you the proper cost for each incoming transaction irregardless of the costing method you're using.
Hope this clears it up for you.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
-
COGS = Cost of Goods sold
Value = Inventory ValueConfessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
-
no problem.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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