Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pull Qty Available with ODBC

Status
Not open for further replies.

evmet

Technical User
Sep 1, 2010
1
US
I am interested in getting the "Qty Available" amount for products based on item number. I have heard that this is not a field in a table but rather it is an equation from numerous fields that are in the tables. Any suggestions on how to get to this number? Or even what fields in what tables are used to get to that number...for ex: where to pull qty backordered, qty on SO, etc... Thanks in advance.
 
You can get that information from the table IM2_InventoryItemWhseDetl ... what you want is the QtyOnHand minus the QtyOnSalesOrder



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg
 
You are correct in that this is a calculation. In the setup options it ask you how you want to calculate this figure.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top