Event Dime
Inventory Movement - Pivot - with Opening Balance
- When:
- June 10, 2026 ยท 8:20 AM
- Where:
- Metabase Discussion
- Source:
- Metabase Discussion
**Sorry for late reply SELECT** DTL.CompCode, DTL.OrgID, DTL.LocationID, DTL.ItemID, DTL.BatchNo,DTL.SerialNo,DTL.VariantCode, DTL.ItemVCost LPP, DTL.ItemLandedCost WAC_WH, DTL.ItemWtAvgCost WAC, (**CASE** **WHEN** **Convert**(**Date**,DTL.TxnDate) = @**FROM** **AND** **Convert**(**Date**,DTL.TxnDate) = @**FROM** **AND** **Convert**(**Date**,DTL.TxnDate) = @**FROM** **AND** **Convert**(**Date**,DTL.TxnDate) = @**FROM** **AND** **Convert**(**Date**,DTL.TxnDate) = @**FROM** **AND** **Convert**(**D