NAV2017 - Aged Inventry Reprt shows very old stock. How does Nav decide what is old stock?

DvDowling

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

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]