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.
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 Mike Lewis 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
- Thread starter evmet
- Start date
- Moderator
- #2
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
Just my 2¢
"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."
--Greg
- Status
Similar threads
- Locked
- Question
- Locked
- Question