cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Order To Invoice

Former Member
0 Kudos

Hi All ,

I Used follwoing Query to get Sales Order to Invoice

SELECT

Distinct


    T0

.[DocNum] as 'SO Num',T2.SlpName as 'Sales Person',T0.DocStatus AS 'Order Status' , T0.[DocDate] as 'SO Date', T0.[DocDueDate] as 'SO Commit Date',


   T0

.[CardCode] as 'Party Code', T0.[CardName] as 'Party Name', T0.[NumAtCard]as 'Customer Po Num', T1.[ItemCode], T1.[Dscription],


   T1

.[Quantity] as 'Order Qty',  (T1.Quantity*(T1.[Price]* T0.DocRate)) AS ' Ordered Value ', T1.[OpenQty] as 'Pending Order Qty',


  

(T1.OpenQty *(T1.[Price]* T0.DocRate)) AS 'Open Ordered Value ',T4.[Quantity] as 'Delivered Qty',(T4.Quantity*(T4.[Price]* T5.DocRate)) AS ' Delivered Value ',


   T6

.[Quantity] as 'Invoiced Qty',(T6.Quantity*(T6.[Price]* T7.DocRate)) AS ' Invoiced Value '


FROM ORDR T0  INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry


Left

Join DLN1 T4 On T1.DocEntry=T4.BaseEntry And T1.LineNum=T4.BaseLine


LEFT

JOIN ODLN T5 On T4.DocEntry=T5.DocEntry LEFT JOIN INV1 T6 On T4.DocEntry=T6.BaseEntry And T4.LineNum=T6.BaseLine


LEFT

JOIN OINV T7 On T6.DocEntry=T7.DocEntry


INNER

JOIN OSLP T2 ON T1.SlpCode  = T2.SLPCode

In the above Query When Quantity of Sales Order is delivered Partially then Lines are repeating  What to do if i dont want to repeat the Lines

Ashish Gupte

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

dear Ashish,

I'm also the same problem like you. It's coz of text line problem. You need to use tmsp_doclinetypelayout stored procedure to solve repeating line problem. If you have any question, please let me know.

best regards,

zzymt (myanmar)

Former Member
0 Kudos

Please provide tmsp_doclinetypelayout stored procedure

Former Member
0 Kudos

hi ashish,

It's already provided by SAP.

best regards,

zzymt

Former Member
0 Kudos

Dear zzymt

Please let me know How to execute that from front end

Ashish Gupte

Former Member
0 Kudos

dear ashish,

let me know your email address. I will send the sample report to you.

best regards,

zzymt

Former Member