we need to update the warehouse in order lines by sql report function via b1up.
this is my query for the update:
select 'N' as [check],
t1.linenum,
t0.DocNum,
t1.ItemCode,
t1.Quantity,
'1' [ChangeWHS],
t3.OnHand-t3.IsCommited [OnHand1]
from ORDR t0
inner join RDR1 t1 on t0.DocEntry = t1.DocEntry and t1.WhsCode = '29'
inner join OITM t2 on t1.ItemCode = t2.ItemCode
inner join OITW t3 on t2.ItemCode = t3.ItemCode and t3.WhsCode = '1' and t3.OnHand-t3.IsCommited >= t1.Quantity
where t0.Series = '2286'
and t0.DocEntry = $[ORDR.DocEntry]
order by 1
In the "select data target" we inserted- ;;;;$[$38.24.0.2];
We need to update all the lines that we checked as 'Y' in column "check" but for now we can only update one row at a time.
Do anyone have an idea how to do it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.