Skip to the main content.

 

FREE ASSESSMENT

StarShip

 


Paya Nuvei Logo 2

 

AvidXchange Logo USE

 

1 min read

Sage 100 ERP (MAS 90): How to Print Long Sales Order Inventory Descriptions

Sage 100 ERP (MAS 90): How to Print Long Sales Order Inventory Descriptions

Question:  Mike, we own Sage 100 ERP (formerly Sage MAS90), we have lengthy inventory extended descriptions, how can we get these to print on sales orders?

Answer:  First of all Extended Descriptions are the characters on Inventory Items, Sales Order Items and Purchase Order Item beyond the first 30 characters. In the screenshot below you can see them in the white box. The first 30 characters is the Item Code Description which is shown to the right of the Item Code.

Long Inventory Descritiopns resized 600

Second on the Standard out of the box Crystal Reports Sales Order form only the Item Code Description is printed. To get the Extended Description to print it must be added to the Crystal Form and the Item Code Description needs to be suppressed if there are Extended Descriptions.

To add the Extend Description to the Crystal Form: 

  1. Open the Sales Order Printing window.
  2. Click the Designer button to launch Crystal Designer.
  3. Click the Field Explorer button and add the field ExtendedDescriptionText to the Crystal Form.
  4. Extended Description resized 600Suppress the item code description: 
    • Right click the ItemCodeDesc  field.
    • Click the Common tab.
    • Click the Suppress check box.
    • Click the x-2 formula button.
    • Enter the formula:
    • {SO_SalesOrderWrk.ExtendedDescriptionKey}<>””
Sage 100 ERP Extended resized 600
Save and close and then test the report 

Written by Mike Renner, Partner WAC Consulting, Owner at Computer Accounting Services

Mike is and expert on Sage 100 ERP with over 25 years in the accounting software industry. Mike is also a Sage Certified Trainer and a recognized leader in the design, implementation and support of ERP systems, including Sage.

Specialties

Sage 100 ERP (formerly Sage MAS90/200), Sage 100 Fund Accounting (formally MIP Non Profit Software), Sage Grant ManagementSage Online Fundraising, QuickBooks Enterprise and Point of Sale VAR.

 

ERP Implementation Partner Selection Tips and eBook

ERP Implementation Partner Selection Tips and eBook

How to Find the Right ERP Implementation Partner Working with the right ERP implementation partner will be critical to the success of your ERP...

Read More
Are You Outgrowing Your ERP Manufacturing Software?

Are You Outgrowing Your ERP Manufacturing Software?

3 Tips for Finding the Best ERP Manufacturing Software for Your Business If your manufacturing company is outgrowing your software the search for...

Read More
5 Ways a New Manufacturing ERP Helps Your Business Grow

5 Ways a New Manufacturing ERP Helps Your Business Grow

Grow Your Business with a New Manufacturing ERP Solution The economy is constantly changing, and manufacturing companies have been hit hard by recent...

Read More