Skip to Content
0

SAP B1 print Open lines only

Jan 26, 2017 at 01:34 PM

35

avatar image

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?

jmo
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Nagarajan K Jan 26, 2017 at 02:15 PM
0

Hi,

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

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
Bhanu Pratap Sharma Jan 26, 2017 at 04:25 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Gonzalo Gomez Jan 26, 2017 at 05:25 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Gonzalo Gomez Jan 27, 2017 at 08:04 AM
0

Take a look here:

Your question

Share
10 |10000 characters needed characters left characters exceeded
Jon Morgan Jan 27, 2017 at 09:22 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Jan 27, 2017 at 09:32 AM
0

Please close this thread by correct answer/helpful answer.

Share
10 |10000 characters needed characters left characters exceeded