# Old Parts

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2000-08-02 09:35 UTC
**Views:** 445
**Replies:** 0
**URL:** https://www.epiusers.help/t/old-parts/652

---

## Post #1 by @system

<div id="ygrps-yiv-520871465">We&#39;ve tried unsuccessfully to produce a Report Builder report  for <br/>
&quot;slow-moving&quot; or &quot;dead inventory&quot;.<br/>
<br/>
We want the report to show parts that have these filters (date filter <br/>
optional for previous history):<br/>
On-hand qty greater than zero, and<br/>
No current or previous Sales Orders, and<br/>
No current  or previous Jobs, and<br/>
Not used as an assembly in a current or previous job, and<br/>
Not used as material in a current or previous job.<br/>
<br/>
We think the data has to come from these tables:<br/>
Part, PartBin, PartDtl, OrderDtl, JobAsmbl, JobMtl.<br/>
<br/>
So, if anyone can figure out how to join all of these, please let us know!</div>

---


**Canonical:** https://www.epiusers.help/t/old-parts/652
**Original content:** https://www.epiusers.help/t/old-parts/652