Hi experts,
Version 8.81 PL07.
Scenario.
I want to get the comsumption report to my team.
I worked below query,
SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T1.[TargetType] !='16' and
T0.[CANCELED] ='n' and
T2.[QryGroup1] ='y'
Whereas, since we using features to create goods return and A/P Memo to reverse and open the Purchase order. I
so, the Delivery lines which is reversed through A/P memo should be removed in the report to get the actual consumption report.
HOw to do this ?
Regards,
Dwarak