Query to generate a report for incoming pending payments as per Item Group!

[Former Member]

Dear All,

I need a Query to generate a report for incoming pending payments through Item Group.

Please provide me the same.

Thanks in advance..........................

Edited by: Param Deshwal on Nov 22, 2011 7:11 AM

[Former Member]

Hi

try this

SELECT T0.[DocNum] as 'Invoice Number', T0.[DocDate] as 'Invoice Date', T0.[CardName], T0.[DocTotal] as 'Invoice Amount', T0.[PaidToDate] as 'Paid Amount',(T0.[DocTotal]-T0.[PaidToDate]) as 'Pending Amount',T3.[ItmsGrpnam] FROM OINV T0 Inner join inv1 t1 on t0.docentry=t1.docentry inner join oitm t2 on t2.itemcode=t1.itemcode inner join oitb t3 on t3.[ItmsGrpcod]=t2.[ItmsGrpcod] where T3.[ItmsGrpnam]=[%0]  

Regards,

sudhir B.

Edited by: B.sudhir on Nov 22, 2011 7:28 AM

[Former Member]

Thanks a lot....

[Former Member]

hi ,

kind information

if your problem solved give the points to that person.

thanks & Regards

B.Lakshmi narayanan