Skip to Content
0
Former Member
Mar 05, 2009 at 11:29 AM

QPLD for Sales Quotation

22 Views

Hi All,

I am trying to make a QPLD with the following specifications, i need to capture business partner name, item code, item name, Quantity, Price and line total from Sales quotation and the BoM details of that particlar item i.e. the components of the item in sales quotation. The SQL that i have made is as follows;

SELECT T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity],

T1.[Price], T1.[LineTotal], T3.[Code] FROM OQUT T0 INNER JOIN QUT1 T1

ON T0.DocEntry = T1.DocEntry, OITT T2 INNER JOIN ITT1 T3 ON T2.Code = T3.Father

where T3.Father = RTRIM(T1.[ItemCode] )

I just need to be sure that this query is working fine. Can any expert in SQL please validate the same?

Thanks in advance,

Joseph