Old Parts


(system) #1
We've tried unsuccessfully to produce a Report Builder report for
"slow-moving" or "dead inventory".

We want the report to show parts that have these filters (date filter
optional for previous history):
On-hand qty greater than zero, and
No current or previous Sales Orders, and
No current or previous Jobs, and
Not used as an assembly in a current or previous job, and
Not used as material in a current or previous job.

We think the data has to come from these tables:
Part, PartBin, PartDtl, OrderDtl, JobAsmbl, JobMtl.

So, if anyone can figure out how to join all of these, please let us know!