Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 3.02 » View Incident Report |
Serious |
Reported By: Alan Questell Reported On: 10/1/2001 For: Version 3.01 Build 1 |
SELECT Model, COUNT(WhSkids.Model) AS RecordCount, SUM(CurrentQty) AS CurrentQtyTotal, SUM(CurrentQty/CasePack) AS CurrentQtyCartonsTotal, SUM(ReservedQty) AS ReservedQtyTotal, SUM(ReservedQty/CasePack) AS ReservedQtyCartonsTotal, SUM(CurrentQty-ReservedQty) AS AvailableQtyTotal, SUM((CurrentQty/CasePack)-(ReservedQty/CasePack)) AS AvailableQtyCartonsTotal FROM WhSkids JOIN WhActiveInventoryTest ON WhSkids.Model = WhActiveInventoryTest.Model WHERE WhSkids.Model = 'L12/925/3099006' GROUP BY WhSkids.Model
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |