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 GreigHappy New Year too :)
You were pretty close. Just use an iif(...) and it should work.
hth
0
Please sign in to leave a comment.
Comments
0 comments