Sage 100

**Fyi, Extended Item Descriptions - suppression** Just upgraded client from 4.40 --> v2017, and the item descriptions weren't printing on certain forms. Turns out it's because of the suppression formula that's already in place, relative to an apparent change with the ExtendedDescription**Key** field. Prior to the Upgrade their suppression was based on whether the ExtendedDescription**Key** field was blank ("" "") or not. However, now (at least with v2016 and higher) that field contains '0000000000' if no Extended Desc exists, so I just needed to update the formulas. I don't recall running into this previously but I'm wondering if that's because most of the time the suppression formula is based on whether the ExtendedDescription_**Text**_ field is blank or not.

I have been running into this a lot @BrettZimmerman . This edit seems to be a requirement on all the custom forms that has a formula that use the ExtendedDescriptionKey as suppression logic. In all cases the resolution is to replace KEY with TEXT. #whatapain

Thanks Zip.

There's a KB article on this somewhere, with the default key value changing (from blank to the string of 0's) in a recent release. The stock reports are updated properly, but anything custom with formulas based on the key will need to be corrected manually.

Here's the formula for the PO form: if {@PrintExtItmDesc} = ""Y"" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> ARRAY("""", ""0000000000"") then formula = {PO_PurchaseOrderWrk.ExtendedDescriptionText} else formula = {PO_PurchaseOrderWrk.ItemCodeDesc} end if

Thanks @BarbaraGoldstein