redundent stock listing

[Former Member]

Is there a way in SAP B1 to produce a redundent stock listing. Items that have had no movement or purchases in a given time frame? We at RHG need to provide a list of stock items that have had no movement to them in the last 12 months. I would need a list with Stck code/description/wh/qty/cost each/total cost

Has any one seen a script or query like this?

Thanks

Martin

South Africa Radio Holland

[Former Member · Accepted solution]

Check, Inventory -> Inventory Reports -> Inactive Items.

This report shows all the items that do not appear in any of the selected sales documents since the specified date.

[Former Member · Accepted solution]

Hi Sridharan.

The only problem with this function is that it will not show costs. Unless one exports it and manualy enters costs. Also it will show new items that have just been entered and purchased.

rgds

Martin

[Former Member · Accepted solution]

HI

You can try out a query from OINM - Whse Journal table. All the Item Transactions are recorded in this table.

[Former Member · Accepted solution]

Hi

Many thanks but I'm a bit dumb with querys. Is ther a place to find a query of this sort? Or a start in the right direction on creating one? I'll play around with it and see what I come up with.