Summary
Extended descriptions no longer print on Purchase Orders after upgrading to Sage 100 2016. This issue occurs because Sage 100 2016 uses a different default extended description key value.
Cause
Default extended description keys now use "0000000000" instead of a blank field.
Resolution
Update the Crystal Reports formula
- Open your Purchase Order form in Crystal Designer by clicking the Designer button.
- Note: Install Crystal Reports and obtain the required permissions to use the Designer button.
-
- In both Details C and Details D, right-click the @ItemDescription formula, and then select Edit Formula.
- Note: Use Detail C when you don't select Allow Entry of Expanded Item Codes in Common Information Options.
- Note: Use Detail D when you select Allow Entry of Expanded Item Codes in Common Information Options
-
- Select the existing formula, delete it, and replace it with the following formula:
if {@PrintExtItmDesc} = "Y" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> ARRAY("", "0000000000") then
-
- formula = {PO_PurchaseOrderWrk.ExtendedDescriptionText}
else
formula = {PO_PurchaseOrderWrk.ItemCodeDesc}
end if
- formula = {PO_PurchaseOrderWrk.ExtendedDescriptionText}
1. Click Save and Close button.
2. Select File, Save.
3. Close Crystal Designer.
4. Print the Purchase Order form and verify that the extended descriptions print correctly.
DocLink: Extended description isn’t printing on purchase order
DocLink: How to print Extended Descriptions on Purchase Order Form
Need more help?