Skip to Content
avatar image
Former Member

redundent stock listing

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 23, 2008 at 09:04 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.