Description |
1. Add history button to Lot details.
Select a lot from the grid and press the history button.
2. New window will open with all transactions that happended on the lot. Include following fields
Location Name, Lot Number, parent lot Number, Lot UOM, Lot Wgt/unit,Lot Expiry Date, Transaction Type, Transaction Id, Transaction Description, Vendor/Customer Name depending on transaction type, Transaction Date, Storage Location,Transaction Qty, Transaction Net wgt, Transaction Cost, Transaction Amount, Transaction User Id
Do not add the word 'Transaction' to all column labels.
3. Include hyperlinks to open transactions.
Sample query:
--Lot table
select strLotNumber,intLotId, L.intItemId, I.strItemNo,I.strType,L.intLocationId, L.intItemUOMId, UM.strUnitMeasure,
L.intSubLocationId, L.intStorageLocationId,SL.strName StorageLocation, dblQty, dblLastCost, dblWeightPerQty, L.dblWeight,
L.dblQty*L.dblLastCost*IU.dblUnitQty LotAmount
from tblICLot L
join tblICItem I on L.intItemId = I.intItemId
join tblICItemUOM IU on L.intItemId = IU.intItemId and L.intItemUOMId = IU.intItemUOMId
join tblICUnitMeasure UM on IU.intUnitMeasureId = UM.intUnitMeasureId
join tblICStorageLocation SL on L.intStorageLocationId = SL.intStorageLocationId
where strLotNumber = 'LOT-8176'
order by strLotNumber
|