Skip to Content
avatar image
Former Member

SAP B1 Print Layout Designer

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 22, 2017 at 01:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 23, 2017 at 01:15 PM

    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?

    Add comment
    10|10000 characters needed 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.