Temp Projects

Rijas P wrote:

Please see the attached Stock transfer Picklist - Transfer from "GRV Retail" to "Euro Warehouse". Showing Wrong Stock Qty in Picklist for Items EU19192,EU19194. The stock Qty showing in picklist should be "Qty on hand-Qty Intransit".

In addition, not showing reference No. in picklist.

PFA - Stock transfer Picklist & Stock Valuation Stock details.

Done

diff ../stockTransferPickList.jrxml stockTransferPickList.jrxml
512c512
< mmovement poreference,
---

mmovement.description poreference,

538c538
< round(coalesce(sum(mstorage.qtyonhand),0) - (select coalesce(sum(qtyreserved),0) from c_orderline tol join c_order too on tol.c_order_id = too.c_order_id where too.ispicklistprinted='Y' and tol.m_product_id = mproduct.m_product_id and too.ordertype='POS Order' and tol.ad_org_id = mmovement.ad_org_id),0) as currentstock
---

round(coalesce(sum(mstorage.qtyonhand),0) - (select coalesce(sum(qtyreserved),0) from c_orderline tol join c_order too on tol.c_order_id = too.c_order_id where too.ispicklistprinted='Y' and tol.m_product_id = mproduct.m_product_id and too.ordertype='POS Order' and tol.ad_org_id = mmovement.ad_org_id and tol.m_warehouse_id=mmovement.m_warehouse_id),0) as currentstock