NAV2017 - Aged Inventry Reprt shows very old stock. How does Nav decide what is old stock?
DvDowling
Member Posts: 7
Inventory Report (Aged) shows many items with stocked inventory well over 400 days old...this is NOT the true case.
ALL ITEMS USE "STANDARD COSTING"
simply stated: " How can I force Navision to consume Items in a FIFO style when costing method is set to STANDARD COSTING and LOT numbers are NOT used?"
Items (Factory Supplies, Raw materials, Packaging etc) are purchased and consumed in our plant. 'Some' items are tracked by LOT number and those are Great (no problems). Larger majority of items are just purchased and consumed without LOT tracking. The "flesh & bone" staff in the plant are very careful to check expiration dates and consume the inventory oldest first.
Production Work Orders & Consumption Journals when created and posted only Track the LOT controlled items. The rest of the items are simply listed in the journal and consumed. My expectation is that Navision should somehow be watching purchase dates and consuming the oldest inventory first. However, this is not the case.
Running an Inventory Report (Fin>Invent> Invent Report) shows items with posting dates (days Aged) back as far as 2014 with Qty Remaining (an extreme case)....meanwhile that very same items purchased in 2019 are consumed and removed from inventory.
How does Nav 2017 post a consumption journal and decide what date inventory to deplete? Our auditors are after us to consume old inventory and we are forced to use journal entries to adjust the item inventory removing Aged inventory which truly was used a long time previously.
Your help and ideas would be greatly appreciated.
Cheers,
DvD...
ALL ITEMS USE "STANDARD COSTING"
simply stated: " How can I force Navision to consume Items in a FIFO style when costing method is set to STANDARD COSTING and LOT numbers are NOT used?"
Items (Factory Supplies, Raw materials, Packaging etc) are purchased and consumed in our plant. 'Some' items are tracked by LOT number and those are Great (no problems). Larger majority of items are just purchased and consumed without LOT tracking. The "flesh & bone" staff in the plant are very careful to check expiration dates and consume the inventory oldest first.
Production Work Orders & Consumption Journals when created and posted only Track the LOT controlled items. The rest of the items are simply listed in the journal and consumed. My expectation is that Navision should somehow be watching purchase dates and consuming the oldest inventory first. However, this is not the case.
Running an Inventory Report (Fin>Invent> Invent Report) shows items with posting dates (days Aged) back as far as 2014 with Qty Remaining (an extreme case)....meanwhile that very same items purchased in 2019 are consumed and removed from inventory.
How does Nav 2017 post a consumption journal and decide what date inventory to deplete? Our auditors are after us to consume old inventory and we are forced to use journal entries to adjust the item inventory removing Aged inventory which truly was used a long time previously.
Your help and ideas would be greatly appreciated.
Cheers,
DvD...
0
Answers
-
[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]
Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 75 General
- 75 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions