# Report builder inventory field

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-03-14 11:40 UTC
**Views:** 312
**Replies:** 2
**URL:** https://www.epiusers.help/t/report-builder-inventory-field/2444

---

## Post #1 by @system

<div id="ygrps-yiv-614497665">Try PartBin or PartTran<br/>
<br/>
Rhonda Cotton<br/>
<a rel="nofollow" target="_blank" href="mailto:rhondac@...">rhondac@...</a><br/>
<br/>
-----Original Message-----<br/>
From: <a rel="nofollow" target="_blank" href="mailto:KRGENT@...">KRGENT@...</a> [mailto:<a rel="nofollow" target="_blank" href="mailto:KRGENT@...">KRGENT@...</a>]<br/>
Sent: Wednesday, March 14, 2001 4:43 AM<br/>
To: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br/>
Subject: [Vantage] Report builder inventory field<br/>
<br/>
<br/>
Goodmorning Vantage Group,<br/>
<br/>
Could someone tell me which field in report builder you can get purchased<br/>
items quanitity in stock. I have found warehouses and bins but can not<br/>
locate<br/>
physical quantity ?<br/>
<br/>
Thank You,<br/>
<br/>
Gary Waldman<br/>
KRG Enterprises<br/>
<br/>
      Yahoo! Groups Sponsor<br/>
<br/>
      Click Here to Find Software Faster<br/>
<br/>
<br/>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.<br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed]</div>

---

## Post #2 by @system

<div id="ygrps-yiv-139977100">Goodmorning Vantage Group,<br/>
<br/>
Could someone tell me which field in report builder you can get purchased <br/>
items quanitity in stock. I have found warehouses and bins but can not locate <br/>
physical quantity ?<br/>
<br/>
Thank You,<br/>
<br/>
Gary Waldman<br/>
KRG Enterprises</div>

---

## Post #3 by @system

<div id="ygrps-yiv-1426337825">I believe you might be looking for PartBin.OnHandQty.<br/>
You might need to design your report to consider whether the same part exists in to different bins. This can throw off your reported Total OnHandQty for a part if you are not careful. <br/>
To tell whether a part is purchased or manufactured, there is a boolean field in Part Table called something like &quot;purchases&quot;. (going by memory here).<br/>
<br/>
<br/>
Troy Funte<br/>
Liberty Electronics<br/>
<br/>
<blockquote><span title="qreply">   ----- Original Message ----- <br/>
  From: <a rel="nofollow" target="_blank" href="mailto:KRGENT@...">KRGENT@...</a> <br/>
  To: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> <br/>
  Sent: Wednesday, March 14, 2001 7:42 AM<br/>
  Subject: [Vantage] Report builder inventory field<br/>
<br/>
<br/>
  Goodmorning Vantage Group,<br/>
<br/>
  Could someone tell me which field in report builder you can get purchased <br/>
  items quanitity in stock. I have found warehouses and bins but can not locate <br/>
  physical quantity ?<br/>
<br/>
  Thank You,<br/>
<br/>
  Gary Waldman<br/>
  KRG Enterprises<br/>
<br/>
        Yahoo! Groups Sponsor <br/>
<br/>
        Click Here to Find Software Faster <br/>
       <br/>
<br/>
  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. <br/>
<br/>
<br/>
<br/>
[Non-text portions of this message have been removed] </span></blockquote></div>

---


**Canonical:** https://www.epiusers.help/t/report-builder-inventory-field/2444
**Original content:** https://www.epiusers.help/t/report-builder-inventory-field/2444