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

By | July 15, 2017

Recently we have done a customization on A/R Customer screen to auto update the Bill-To-Address where our customer was looking for updating the Bill-To-Address for all the open orders when saving the changes in the customer’s address.

New Stuff:  AR Invoice Import Utility

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

Step 1:

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

AR Customer screen

Step 2:

When the user selects the “Yes” from the prompt then the Bill-To-Address for all the open orders with customer “100” 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.

AR Customer message pop up

Step 3:

The update information is displayed in the Log file.

Log File

Step 4:

When we verify the order “ORD000000000092” from the Log file, we can see that the new changes in the Address of the customer is reflected for the order. User can click on ZOOM button to check for Bill-To-Address besides the cutomer number.

OE Order entry screen

So, customization is very useful when the address information for the specific customer is changed and the customer demands to Bill 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. Automation on OE Order Quantity
  3. A/R Customer List Screen
  4. Change Customer Number on Sales order after posting
  5. Auto Vendor / Customer Code Generation in 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.