# Inventory w/bins report
**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-01-08 14:33 UTC
**Views:** 445
**Replies:** 1
**URL:** https://www.epiusers.help/t/inventory-w-bins-report/1884
---
## Post #1 by @system
Wendy,
This is a pretty simple report. Start with the Part Table. Join that to
the PartBin table with a Left Outer Join. This will give you the inventory
for each part, in each bin. If there is a ? for a value, that means that
there
is no record in the Part Bin table (0 Inventory). Good Luck
Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Wendy Bowen (Pursche)" <wpursche@...>
To: "Vantage egroups list" <vantage@egroups.com>
Sent: Monday, January 08, 2001 1:30 PM
Subject: [Vantage] Inventory w/bins report
> I know this has been asked before, so forgive me for the repetition! But,
does anyone have a Report Builder report that shows inventory status with
bins? I noticed a Crystal Report on the Egroups list, but unfortunately we
don't have a ODBC driver, so it needs to be a Report Builder report.
>
> Wendy Bowen (Pursche)
---
## Post #2 by @system
I know this has been asked before, so forgive me for the repetition! But, does anyone have a Report Builder report that shows inventory status with bins? I noticed a Crystal Report on the Egroups list, but unfortunately we don't have a ODBC driver, so it needs to be a Report Builder report.
Wendy Bowen (Pursche)
Network Administrator
Schmald Tool & Die, Inc.
(810) 743-1600 ext.323
wpursche@...
[Non-text portions of this message have been removed]
---
**Canonical:** https://www.epiusers.help/t/inventory-w-bins-report/1884
**Original content:** https://www.epiusers.help/t/inventory-w-bins-report/1884