If Condition in PLD

[Former Member]

Hi All

Is it Possible to use "If Condition" in Formula Fields in PLD's

Thanks in Advance

[Former Member · Accepted solution]

Hi Madhu,

Is Not possible you can use conditional operator and also

check the thread

Regards

Jambulingam.P

Edited by: Jambulingam P on Aug 3, 2009 1:33 PM

[Former Member · Accepted solution]

thanks for your response

can u give one good example

thanks in advance

[Former Member · Accepted solution]

Hi Raju.........

If you want conditional values then you can set it through formatted serch query on transaction level so that you can directly call that value in your PLD.......

Regards,

[Former Member · Accepted solution]

Hi Madhu,

Sorry, It is not possible in SAP B1 PLD.

'IF' Condition Formula can not use in PLD so you can try to use Link to Option.

Simple Example.

BP Currency(Database Field) - Field_123

->> I want the BP Currency Code in Repetetive Area Header so i'm using Formula and Link to Options.

->> I create 1 Formula field in Repetetive Area and put formula.

Formula Field ID - Field_124 and Text Field ID(Rs.) - Field125_

Field_123=='INR'

->> Select Text Field(Field_125) in Repetetive Area Header then*

*Goto Properties Area Window Click Content Tap Link to - Field_124

Result When will transact the Indian Currency BP at that time will Display the Rs. in Repetetive Area Header.

else Other BP put transact means Other Currency will display.Ex. USD, EURO, etc.,

Regards,

Madhan.

[Former Member]

Hi Madhu,

Check the thread

Regards

Jambulingam.P