How to Retain Deleted Sales Orders in Sage 100 ERP

By | November 4, 2013

Many a times, ERP user needs to refer the historical orders for Customer and for sales analysis. It gives an idea on which historical date a particular Sales Order was issued which helps us to get a track on number of Sales Order and Sales Quote activities in previous years.

By default, historical and deleted orders are not retained in Sage 100 Company Database.
So in order to keep the historical and deleted sales orders and sales quote into Sage 100 company database, we need to follow below mentioned steps.
Open Sage 100 Company and go at Sales order àSetup àSales order options

Here you can see the options are unchecked which might have done while setting company configuration.

GUMU™ Sage 100 Integration Trial | Video | Blog

Years to Retain Sales History Option
1. Enter the number of years to retain sales history for all customers and product lines. You can retain between two and 99 years of sales history. Sales history is retained until it is purged using the Purge Sales history utility.

sage 100 sales order

2. Now check the status ON of ‘Retain Sales Orders/Quote history option.Once we check the above check box option, we can see the below two drop-downs  becomes editable. 

sales order options
There are 3 options against ‘Retain Deleted orders /Quotes ‘in drop-down. The below screen will appear select NO option from both drop-downs I’e “Retain Deleted Orders/Quotes and Retain Deleted lines for Orders/Quotes” (Refer the above screenshot) then also you can see the orders in sales order history.
  • Yes: If the above checkbox is checked and YES option is selected from both the drop-down I.e. “Retain sales Orders/Quote History”, then Sales order will not be displayed in Sales History.
  • Prompt : If “Prompt” option is selected from both the drop-downs i.e. “Retain sales Orders/Quote History” ; then it will prompt you to save the deleted order in History.

About Us
Greytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix has some unique solutions of Sage 100 integration with Sage CRM, and along with Sage 100 Migration from Sage 50 USSage IntacctQuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 100 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

For more details on Sage 100 Services, please contact us at We will be glad to assist you.