SAP B1 Print Layout Designer

[former_member1003570]

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

[former_member312729]

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

[former_member1003570]

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?

[former_member312729]

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.