sales analysis report by invoice number

[Former Member]

I'm trying to get a sales analysis report listed by invoice number. but we only have options of either by part number or by customer name. please let me know how to get a report by invoice number. thanks

[former_member187989]

Try this user query.

SELECT T0.DocNum AS 'AR Invoice No.', T0.DocDate,T0.CardName as 'Customer Name', T1.ItemCode, T1.Dscription as 'Item Description',T1.Quantity,T1.Price as ' Price ', T1.LineTotal AS 'Sale Value' FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE 
(T0.DocDate > = '[%0]' AND T0.DocDate < = '[%1]'') AND 
(T1.TargetType <> 14)
ORDER BY T0.DocNum

Jeyakanthan

[former_member583013]

Hi Vanessa,

The Sales Analysis Report does not have Invoice number as a selection parameter if this is what you are asking.

I am not sure how valuable the report would be if it has to be run by a Certain Invoice Number range.

Please tell me if your question meant something else

Suda