Description |
Add fields to stock details towards the end.
S.dblUnitOnHand - L.dblReorderPoint "Nearing Reorder By", L.dblMinOrder "Minimum Order"
Move Reorder point field right before these fields.
--query for reference.
select I.strItemNo "Item No", I.strDescription "Item Name", CL.strLocationName "Loaction"
, S.dblUnitOnHand "On Hand", L.dblReorderPoint "Reorder Point", S.dblUnitOnHand - L.dblReorderPoint "Nearing Reorder By", L.dblMinOrder "Minimum Order", L.dblSuggestedQty "Suggested Quantity"
from tblICItemStock S join tblICItem I on I.intItemId = S.intItemId
join tblICItemLocation L on S.intItemId = L.intItemId and S.intItemLocationId = L.intItemLocationId
join tblSMCompanyLocation CL on CL.intCompanyLocationId = L.intLocationId
where L.dblReorderPoint > 0
order by I.strItemNo
|