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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.