If... Then... Else... Statement

Greig Burrows

Hello and Happy New Year!
I have a Purchase Order layout in SAP B1. At the moment the design is displaying the Stock Item Code using the below formula:

DocumentRow("ItemCode")

I would like the document to display the Business Partner Catalogue Number instead if one exists.

I can get the BP Catalogue Number to display using the field...

DocumentRow("SubCatNum")

...however, this leave the field blank for items which do not have a BP Catalogue Number.

Can I use an IF Statement to get around this. Something similar to:

IF(DocumentRow("SubCatNum")
="",DocumentRow("ItemCode"),DocumentRow("SubCatNum"))


Thanks
Greig

Philipp Knecht

Hi Greig

Happy New Year too :)
You were pretty close. Just use an iif(...) and it should work.

hth