Stock Aging report in SAP Business One

[Former Member]

Greetings,

I don't think this issue has been raised successfully on the forums (i checked, there's no real resolution at the moment).

The end user requires some form of stock aging that their auditors deem important but there's no such feature within SAP B1.

Their basic requirements would be:

Stock Code | Description | Date of Purchase | Current Month (qty) | 30-90 Days (qty) | 91-120 Days (qty) | 120 days and above (qty)

I'm wondering if this is even possible with the end user using multiple warehouses to stock their inventory, and some items are marked as serial items and others are marked as batch.

Any ideas?

[former_member186095 · Accepted solution]

I wonder why SAP did not provide inventory aging. In SAP B1 2005A, there is inventory audit report. It might be different with inventory aging but as a tool for stock audit for certain criteria available there, it could be helpful.

An addon from valogix that has inventory aging feature is available. Browse this link:

http://209.85.175.104/search?q=cache:EVgg8Mj8l0kJ:spain.valogix.com/pdf/Valogix_Parts_Planner_v4SE_%...inventoryaging%2BSAP&hl=id&ct=clnk&cd=8&gl=id&client=firefox-a

or this link:

http://209.85.175.104/search?q=cache:sWv0YCCf2y4J:www.valogix.com/Pdf/SAP/Valogix_Inventory_Planner_...inventoryaging%2BSAP&hl=id&ct=clnk&cd=9&gl=id&client=firefox-a

for more clear.

Rgds,