90 Minds Community

Need some help with this formula for displaying the item description on the sales order invoice form:

UDF_DESC_SALES but if blank then

ExtendedDescriptionText but if blank then

ItemCodeDesc

 

Currently the formula setup in Item Code Desc is {SO_InvoiceWrk.UDF_DESC_SALES}<> MAKEARRAY("","")

And Extended Desc Text is {SO_InvoiceWrk.ExtendedDescriptionKey}<> MAKEARRAY("","0000000000")

And no formula for UDF_DESC_SALES

------------------------------
Shannon Stanley
Sage 100 Consultant
Ardent Consulting LLC
704-839-6697
------------------------------

Tr this:
local stringvar desc := "";
If Len(Trim({SO_InvoiceWrk.UDF_DESCSALES})) > 0 then
    desc := {SO_InvoiceWrk.UDF_DESCSALES}
Else If Len(Trim({SO_InvoiceWrk.ExtendedDescriptionText})) > 0 then
    desc := {SO_InvoiceWrk.ExtendedDescriptionText}
Else
    desc := {SO_InvoiceWrk.ItemCodeDesc};
desc

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------