Credit note Querry

[Former Member]

Hi Experts

Can i get a querry report to give a list of credit notes that have been created for a customer with a period of time

Thanks

[former_member218051]

Hi Isaac,

This query executed well at my place.

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName] FROM ORIN T0 WHERE T0.[DocDate] >=[%0] and  T0.[DocDate] <=[%1] and  T0.[CardCode] =[%2]

Thanking You

Malhaar

[KennedyT21]

Hi Isaac,

Close the tread you , you have got answer with correct and helpful answer..

Regards

Kennedy

[former_member209066]

Hi,

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[VatSum], T0.[DocTotal], T0.[Comments] FROM ORIN T0 WHERE T0.[DocDate] >='[%1]' and  T0.[DocDate] <='[%2]'

Thanks,

Nithi

[Former Member]

Hi,

Try:

SELECT T0.CardCode,T0.CardName,T0.docnum, T0.docdate,

T0.DocStatus,T0.DocTotal  from orin T0

where T0.docdate>= [%0] and T0.docdate<= [%1] and T0.cardName like '%[%2]%'

Order By T0.CardName, T0.DocDate

Thanks,

Gordon

[KennedyT21]

Hi

Try This

select T0.docdate,T0.CardCode,T0.CardName,T0.docnum, 

DocStatus,DocTotal  from orin T0

where T0.docdate>= [%0] and T0.docdate<= [%1] and to.cardcode= [%2]

Regards

Kennedy

[Former Member]

Printing error, onl;y fields in the repetitive area can have sums/ averages is the error i get when i run the querry

[KennedyT21]

HI Issac,

Can you post the screen shot....

Regards

Kennedy

[Former Member]

[KennedyT21]

HI Isaac,

Try This

select T0.docdate,T0.docnum, T0.CardCode,T0.CardName, T0.DocStatus,T0.DocTotal  from orin T0

where T0.docdate>= [%0] and T0.docdate<= [%1] and T0.cardcode= [%2]

order by T0.docdate,T0.docnum

Regards

Kennedy

[KennedyT21]

Does the above query executes..If ok close the Tread with correct answer and helpful answer..

Regards

Kennedy