Auto-Update Ship-To-Address for Open Orders in Sage 300 ERP

By | July 18, 2017

Recently we have done a customization on A/R Ship To Locations screen to auto update the Ship-To-Address where our customer was looking for updating the Ship-To-Address for all the open orders when saving the changes for the specific location address of the customer.

New Stuff:  Auto-Update Bill-To-Address for Open Orders in Sage 300 ERP

In this blog, we would be discussing about functionality of auto updating the Ship-To-Address.

Step 1:

User makes some changes in the Address for the customer’s location. We have selected the customer 1200 and Location “WAREHS” from the Sample Database and added the new address line “Address Line 3” and Saved the changes.
While saving the changes the user is prompted for updating all the open Orders.

AR Ship to location

Step 2:

When the user selects the “Yes” from the prompt then the Ship-To-Address for all the open orders with customer “1200” and Ship To Locations “WAREHS” is updated. User is provided the message box with the number of orders updated and the updated order numbers are stored in the LogFile generated with current system date on the displayed path.

Pop Up Message

Step 3:

The update information is displayed in the Log file.

Log File

Step 4:

When we verify the order “ORD000000000001” from the Log file, we can see that the new changes in the Address of the customer’s Ship Location is reflected for the order. User can click on ZOOM button to check for Ship-To-Address besides the Ship-To-Locations.

Order entry screen

So, customization is very useful when the address information for the specific location of the customer is changed and the customer demands to ship the item to the new address for the orders that are still pending.

Also Read:

  1. Update Bill-To-Address and Ship-To Address on OE Order Entry Screen
  2. Migrating Customer Ship to Address from Sage Pro to Sage 300
  3. Automation on OE Order Quantity
  4. Setting default primary Ship to Location in Sage 300
  5. Migrating Customer Ship to Address from QuickBooks to Sage 300 ERP

About Us

Greytrix is 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 have some unique solutions of Sage 300 integration with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services to Sage business partners, end users, and Sage PSG worldwide.

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