Skip to Content
avatar image
Former Member

SAP B1 print Open lines only

Please can someone tell me if there is an easy way to print a Sales order but with open Lines only in the Line Status using the PLD?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jan 26, 2017 at 02:15 PM

    Hi,

    Not sure about PLD, you can try with crystal layout.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 04:25 PM

    Hello,

    you can developed the customized crystal report with below query..

    SELECT T0.DocNum,T0.DocDate,T0.CardCode,T0.CardName,T1.ItemCode,T1.Dscription,T1.OpenCreQty,T1.Price FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry=T1.DocEntry WHERE T0.DocNum=804350 AND T1.OpenCreQty>0

    Regards

    BHanu

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2017 at 05:25 PM

    Yes.

    Make a field formula and link the field to the other fields.

    In the formula check for status of the line, closed or open.

    There are many post about this, try to find it.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 27, 2017 at 08:04 AM

    Take a look here:

    Your question

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2017 at 09:22 AM

    Thank you for your useful comment, all works fine. Appreciated.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 27, 2017 at 09:32 AM

    Please close this thread by correct answer/helpful answer.

    Add comment
    10|10000 characters needed characters exceeded