Description |
Create a Grid view instead of stock report. Need this for CAB.
Otherwise all CAB users have to create dashboard panels for their login. This is troublesome considering the time frame of cab sessions.
+ *Item Stock* +
Select tblICItem.strItemNo, tblICItem.strDescription, tblICItemStock.intItemLocationId, tblSMCompanyLocation.strLocationName, tblICItemStock.dblUnitOnHand, tblICItemStock.dblOrderCommitted, tblICItemStock.dblOnOrder, tblICItemStock.dblBackOrder,
tblICItemLocation.intLocationId, tblICItemPricing.dblLastCost, tblICItemPricing.dblAverageCost, tblICItemPricing.dblStandardCost
From tblICItemStock
Inner Join tblICItem On tblICItem.intItemId = tblICItemStock.intItemId
Inner Join tblICItemLocation On tblICItemLocation.intItemLocationId = tblICItemStock.intItemLocationId And tblICItemStock.intItemId = tblICItemLocation.intItemId
Inner Join tblICItemPricing On tblICItemStock.intItemId = tblICItemPricing.intItemId And tblICItemStock.intItemLocationId = tblICItemPricing.intItemLocationId
Inner Join tblSMCompanyLocation On tblSMCompanyLocation.intCompanyLocationId = tblICItemLocation.intLocationId
+ *Lot Details* +
Select tblICItem.strItemNo, tblICItem.strDescription, tblSMCompanyLocation.strLocationName, tblSMCompanyLocationSubLocation.strSubLocationName, tblICStorageLocation.strName, tblICLot.strLotNumber, tblICLot.dblQty, tblICLot.dblWeight,
tblICUnitMeasure.strSymbol, tblICLot.dblWeightPerQty, tblICLot.dblLastCost
From tblICLot Inner Join tblICItem On tblICLot.intItemId = tblICItem.intItemId
Inner Join tblICItemUOM On tblICItemUOM.intItemUOMId = tblICLot.intItemUOMId And tblICItem.intItemId = tblICItemUOM.intItemId
Inner Join tblICUnitMeasure On tblICUnitMeasure.intUnitMeasureId = tblICItemUOM.intUnitMeasureId
Inner Join tblICItemLocation On tblICItemLocation.intItemId = tblICItem.intItemId And tblICItemLocation.intItemLocationId = tblICLot.intItemLocationId
Inner Join tblSMCompanyLocation On tblSMCompanyLocation.intCompanyLocationId = tblICItemLocation.intLocationId
Left Join tblSMCompanyLocationSubLocation On tblSMCompanyLocation.intCompanyLocationId = tblSMCompanyLocationSubLocation.intCompanyLocationId And tblICLot.intSubLocationId = tblSMCompanyLocationSubLocation.intCompanyLocationSubLocationId
Left Join tblICStorageLocation On tblICLot.intStorageLocationId = tblICStorageLocation.intStorageLocationId
|