Can I run a sales report by invoice number?

[Former Member]

I am trying to run a sales report by invoice number rather than by customer - can this be done?

[former_member325312 · Accepted solution]

Hi Connie

s u can run sales report by invoice no fot that pls find the query below

i think this will solve ur problem

SELECT T0.[DocNum][SO NO], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T2.[DocNum][Delivery No], T2.[CardName], T3.[ItemCode], T3.[Dscription], T3.[Quantity], T4.[DocNum][Invoice No], T4.[CardName], T5.[ItemCode], T5.[Dscription], T5.[Quantity] FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry, ODLN T2 INNER JOIN DLN1 T3 ON T2.DocEntry = T3.DocEntry, OINV T4 INNER JOIN INV1 T5 ON T4.DocEntry = T5.DocEntry WHERE T5.[BaseRef] = T2.[DocNum] AND T3.[BaseRef] = T0.[DocNum] AND T5.[ItemCode] = T3.[ItemCode]

AND T5.[ItemCode] = T1.[ItemCode] AND T4.[DocNum] = [%0] GROUP BY T0.[DocNum], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T2.[DocNum], T2.[CardName], T3.[ItemCode], T3.[Dscription], T3.[Quantity], T4.[DocNum], T4.[CardName], T5.[ItemCode], T5.[Dscription], T5.[Quantity]

Regards

Jenny

Edited by: Jennifer Anderson on Jul 28, 2010 11:21 AM

[Former Member]

Hi,

it is possible on Query Report so try to create Query Report.

Regards,

Madhan.

[JesperB1]

Hi Connie,

In the standard Sales Analysis Report the document number is not a criteria that can be set, posting date can be chosen.

It would be possible to create a user defined query for this of course.

Thanks,

Jesper