Skip to Content
author's profile photo Former Member
Former Member

error

Hi,

Pls look at this query this query is running successfully and giving desired output.. but using this query when i design the qld

sap is getting closed.. pls help experts.

select DelNo,CardName,ItemCode,Dscription,Price,Sales,Stock,Stock-Sales Excess,(Stock-Sales)/Sales Variance,Price*Sales TotAmt from

(SELECT T1.docentry DelNo, T1.[ItemCode], T1.[Dscription],sum(T1.[Quantity]) Sales, T1.[Price] ,T0.[CardName],

(select (S_OITM.[OnHand]) + sum(S_DLN1.[Quantity]) from DLN1 S_DLN1

inner join OITM S_OITM ON S_DLN1.ItemCode = S_OITM.ItemCode

where S_DLN1.DocEntry >= T1.DocEntry and S_DLN1.[ItemCode]=T1.[ItemCode] group by S_OITM.[OnHand]) Stock FROM ODLN T0

INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry

Group By T1.docentry,T1.[ItemCode], T1.[Dscription] , T1.[Price],T0.[CardName]

) AA

regards,

RV

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2011 at 11:47 AM

    Hi

    Actually I have tried to Create QLD for Same Report and I got Correct Result,

    I think Some Internal Error might occur when you tried to execute that QLD

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2011 at 10:37 PM

    Hi,

    Your query is no problem in creating QPLD. You may delete anything you have done for it. Recreate a new QPLD.

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.