on 05-04-2012 1:22 AM
Dear all
Can u plz let me know FMS formatted searchhttp://screencast.com/t/sXbfsHrL0 for this
actually i want BOM(ITT1) column data on sale order column plz let me know
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Try the below:
select distinct t1.test from OITT t0 inner join ITT1 t1 ON T0.Code = T1.Father where t0.Code = $[rdr1.itemcode]
Thank for ur reply
I have same query but in child item it is not running watch screen shot http://screencast.com/t/t9IrCVRk
I have this query
SELECT T0.[ItemName] FROM OITM T0 INNER JOIN OITT T1 ON T0.ItemCode = T1.Code WHERE T0.[ItemCode] = $[$4.1]
Please help me out
anybody master mind who can suggest how to get data from BOM to sale order
If I understand your issue correctly you try to run a FMS on document lines, don´t you?
That is not possible. The FMS will only take the first line, nothing more.
Hi
Sorry for late reply.
Try this:
select max(t1.test) from OITT t0 inner join ITT1 t1 ON T0.Code = T1.Father
where t0.Code = $[rdr1.itemcode]
This will return only on value if all the value in the rows are same
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.