Skip to Content
0

SAP B1 Print Layout Designer

May 20, 2017 at 06:13 PM

69

avatar image

I want to create a condition on the Print Layout Designer for a Sales Order. I have a text field that I want to print when the Total of the Sales order is less than or equal to $2,500.00. I need to know how to set up this condition in the PLD. So if the sales order total is less than or equal to $2,500.00 the text information will print of the form, if the sales order total is greater than $2,500.00 I do not want the text information to print.

Any thoughts

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

2 Answers

Balaji Selvaraj May 22, 2017 at 01:41 PM
1

Hi Dennis,

Create the following field

Field_1 : type : Text , Value : $,2500

Field_ 2 : type : Formula: Field_1<= (The Doc Total field which you want to compare)

Field _3 : tyep : text, Value : the text which you want to display and in this Link to field set the Field_2(Formula Field)

Un check the visible box for Field_1 & Field_2

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Dennis Ferraro May 23, 2017 at 01:15 PM
0

Hi Balaji,

I tried what you sent but does not work. The message prints regardless of the document total.

Can you please clarify the contents for Field_1. On the Properties Content tab I am using Source Type Free Text. Is this correct?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Dennis,

What value prints for Document Total, is it printing only numeric digit with '$' sign or without '$' sign. Try to remove '$' sign from Field_1 and then check.

0