Need Query for Which item not using the Financial year

[VinoKR]

Dear Experts,

In My client When creating a new item master data and mentioned which customer buy this product that customer name will be enterd into UDF Field And name is U_Customer.More than 200 items will be creating a Particular customer.Some of the items only they selling the paticular customer for this financal year.Now they asking which of the items not selling or using the paticular customer for this financial year.Please give the solution for this ASAP.

Thanks&Regards

VinothRaj K

[kothandaraman_nagarajan]

Have you tried my query?

[VinoKR]

Hi Nagarajan

Sorry I am not checking Your query ,after checking i will tell  whether it is ok or not

Thanks

Vinoth raj K

[kothandaraman_nagarajan]

No problem.

[Former Member]

Hi VinothRaj ,

What is their financial year? Is it the same as calendar year?

Thanks,

Gordon

[VinoKR]

Hi Gordon

Yes i want same financial year

Thanks

Vinoth Raj

[kothandaraman_nagarajan]

Hi,

Try:

SELECT T0.[ItemCode], T0.[ItemName], T0.[OnHand] FROM OITM T0  left JOIN INV1 T1 ON T0.ItemCode = T1.ItemCode  left JOIN OINV T3 ON T1.DocEntry = T3.DocEntry WHERE T1.[Quantity] is null and  T0.[U_Customer] = T3.cardname and T3.docdate between [%0] and [%1]

GROUP BY T0.[ItemCode], T0.[ItemName], T0.[OnHand]

Thanks & Regards,

Nagarajan