Skip to Content
0
Former Member
Nov 05, 2012 at 04:55 AM

Query to pull consumption report(Delivery report)

98 Views

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