Sage 100

Does anyone know if Sage Alerts & Workflow can perform address validation on sales orders and alert if there's an issue? 

Even if I find a way to detect missing street numbers or names, the end user could potentially enter an incomplete address such as "12600 St." which may not get caught since it would detect a number and letter in the address field. 

I'm not familiar with web API but perhaps there's an option there?

Thank you~

------------------------------
Dana Halpin
Vrakas/Blum Computer Consulting, Inc.
------------------------------

SAW is a reasonable solution. So is BPI from Fisher Tech. A small script would be fired off a SO querying one of the services available to provide address checking. The service is polled from Sage 100 instance. The correct address would overwrite the one entered. 

You should pull somebody who is competent with SAW/BPI and polling web data sites. The web site's service is not free. What is the value to the customer of removing this problem?

------------------------------
Jerry Norman
Smartbridge Partners
(512) 653-7498
------------------------------

Do you need sales tax reporting?  Address validation is included with Avalara.

Below is a script posted to the Yahoo Resellers group (predecessor of 90M.  I doubt think it works anymore but is an example of a possibility.

Address Verification Button for V4.1

----- Original Message ----

From: Myron Stevenson <myron@clearisconsulting.com>

To: sageresellers@yahoogroups.com

Sent: Wednesday, March 7, 2007 4:06:10 PM

Subject: [sageresellers] Time to give back

Over the past year, I have received more assistance from this forum that

I have given back. Here are a couple "enhancements" I've recently done

that add "WOW" to MAS 90/200.

The attached file shows two buttons that have been added to Customer

Maintenance. They are as follows for 4.10:

1. USPS Verify

(I can't take credit for this as it is from Slade, though updated for

4.10). Here is the VB script attached to the button.

----- Start Verify Customer Maintenance Address -------

' language VBScript

'

' form variables

' AR_Customer_ bus_AddressLine1

' AR_Customer_ bus_AddressLine2

' AR_Customer_ bus_AddressLine3

' AR_Customer_ bus_City

' AR_Customer_ bus_State

' AR_Customer_ bus_ZipCode

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +AR_Customer_ bus_AddressLine1 &_

"&address2=" +AR_Customer_ bus_AddressLine2 &_

"&city="+AR_ Customer_ bus_City &_

"&state="+AR_ Customer_ bus_State &_

"&zip5="+AR_ Customer_ bus_ZipCode

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- End -------

Not only has this button been added to the Customer Maintenance window,

but also to Contact and Ship to windows as well. Here are those

scripts:

----- Contact Verify Start ------

'

' language VBScript

'

' form variables

' AR_CustomerContact_ bus_AddressLine1

' AR_CustomerContact_ bus_AddressLine2

' AR_CustomerContact_ bus_AddressLine3

' AR_CustomerContact_ bus_City

' AR_CustomerContact_ bus_State

' AR_CustomerContact_ bus_ZipCode

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +AR_CustomerCont act_bus_AddressL ine2 &_

"&address2=" +AR_CustomerCont act_bus_AddressL ine1 &_

"&city="+AR_ CustomerContact_ bus_City &_

"&state="+AR_ CustomerContact_ bus_State &_

"&zip5="+AR_ CustomerContact_ bus_ZipCode

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- Contact Verify End ------

----- Ship To Start ------

' form variables

' SO_ShipToAddress_ bus_ShipToAddres s1

' SO_ShipToAddress_ bus_ShipToAddres s2

' SO_ShipToAddress_ bus_ShipToAddres s3

' SO_ShipToAddress_ bus_ShipToCity

' SO_ShipToAddress_ bus_ShipToState

' SO_ShipToAddress_ bus_ShipToZipCod e

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +SO_ShipToAddres s_bus_ShipToAddr ess1 &_

"&address2=" +SO_ShipToAddres s_bus_ShipToAddr ess2 &_

"&city="+SO_ ShipToAddress_ bus_ShipToCity &_

"&state="+SO_ ShipToAddress_ bus_ShipToState &_

"&zip5="+SO_ ShipToAddress_ bus_ShipToZipCod e

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- Ship To End ------

Well there you go. Three buttons to verify address with USPS and a

script to "quick print" a label on a Dymo printer. The label script has

also been added to the Contact and Ship To windows as well, so if you

want them just ask and I'll post. If there is a request, I will post

this scripts up on the group at Yahoo!.

Enjoy.

Myron Stevenson, CPA

Clearis Consulting, Inc.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------

Original Message:
Sent: 01-10-2024 10:21
From: Jerry Norman
Subject: Sage alert for address validation

SAW is a reasonable solution. So is BPI from Fisher Tech. A small script would be fired off a SO querying one of the services available to provide address checking. The service is polled from Sage 100 instance. The correct address would overwrite the one entered. 

You should pull somebody who is competent with SAW/BPI and polling web data sites. The web site's service is not free. What is the value to the customer of removing this problem?

------------------------------
Jerry Norman
Smartbridge Partners
(512) 653-7498
------------------------------

Thank you for all the replies on this. Customer does not need Avalara and since discovered that root cause for the invalid ship to address was the 5th address line, which is rarely used and it was not mapped to come into their system via EDI. We're updating the EDI mapping.

I did find out that you could possibly use the SAW API to call software like Address Autofill - Mapbox  (https://www.mapbox.com/insights/address-verification) that then fills the appropriate fields in Sage, and there may be an ISV has built an add on for it.

------------------------------
Dana Halpin
Vrakas/Blum Computer Consulting, Inc.
------------------------------

Original Message:
Sent: 01-10-2024 13:50
From: Jeff Schwenk
Subject: Sage alert for address validation

Do you need sales tax reporting?  Address validation is included with Avalara.

Below is a script posted to the Yahoo Resellers group (predecessor of 90M.  I doubt think it works anymore but is an example of a possibility.

Address Verification Button for V4.1

Original Message ----

From: Myron Stevenson <myron@clearisconsulting.com>

To: sageresellers@yahoogroups.com

Sent: Wednesday, March 7, 2007 4:06:10 PM

Subject: [sageresellers] Time to give back

Over the past year, I have received more assistance from this forum that

I have given back. Here are a couple "enhancements" I've recently done

that add "WOW" to MAS 90/200.

The attached file shows two buttons that have been added to Customer

Maintenance. They are as follows for 4.10:

1. USPS Verify

(I can't take credit for this as it is from Slade, though updated for

4.10). Here is the VB script attached to the button.

----- Start Verify Customer Maintenance Address -------

' language VBScript

'

' form variables

' AR_Customer_ bus_AddressLine1

' AR_Customer_ bus_AddressLine2

' AR_Customer_ bus_AddressLine3

' AR_Customer_ bus_City

' AR_Customer_ bus_State

' AR_Customer_ bus_ZipCode

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +AR_Customer_ bus_AddressLine1 &_

"&address2=" +AR_Customer_ bus_AddressLine2 &_

"&city="+AR_ Customer_ bus_City &_

"&state="+AR_ Customer_ bus_State &_

"&zip5="+AR_ Customer_ bus_ZipCode

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- End -------

Not only has this button been added to the Customer Maintenance window,

but also to Contact and Ship to windows as well. Here are those

scripts:

----- Contact Verify Start ------

'

' language VBScript

'

' form variables

' AR_CustomerContact_ bus_AddressLine1

' AR_CustomerContact_ bus_AddressLine2

' AR_CustomerContact_ bus_AddressLine3

' AR_CustomerContact_ bus_City

' AR_CustomerContact_ bus_State

' AR_CustomerContact_ bus_ZipCode

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +AR_CustomerCont act_bus_AddressL ine2 &_

"&address2=" +AR_CustomerCont act_bus_AddressL ine1 &_

"&city="+AR_ CustomerContact_ bus_City &_

"&state="+AR_ CustomerContact_ bus_State &_

"&zip5="+AR_ CustomerContact_ bus_ZipCode

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- Contact Verify End ------

----- Ship To Start ------

' form variables

' SO_ShipToAddress_ bus_ShipToAddres s1

' SO_ShipToAddress_ bus_ShipToAddres s2

' SO_ShipToAddress_ bus_ShipToAddres s3

' SO_ShipToAddress_ bus_ShipToCity

' SO_ShipToAddress_ bus_ShipToState

' SO_ShipToAddress_ bus_ShipToZipCod e

'

'*********** ********* ********* *********

'

' Create the IE Object

Set ie=CreateObject( "InternetExplore r.Application" )

'

' Set IE Properties

ie.Top=0

ie.Left=0

ie.Height=700

ie.Width=800

ie.AddressBar= false

ie.MenuBar=false

ie.ToolBar=false

'

' Build Form Data

data="/zip4/ welcome.jsp? selection= 1" &_

"&address1=" +SO_ShipToAddres s_bus_ShipToAddr ess1 &_

"&address2=" +SO_ShipToAddres s_bus_ShipToAddr ess2 &_

"&city="+SO_ ShipToAddress_ bus_ShipToCity &_

"&state="+SO_ ShipToAddress_ bus_ShipToState &_

"&zip5="+SO_ ShipToAddress_ bus_ShipToZipCod e

' Set the Navigation

ie.Navigate "http://zip4.usps.com/"+data

'

' Unhide the browser

ie.visible=True

----- Ship To End ------

Well there you go. Three buttons to verify address with USPS and a

script to "quick print" a label on a Dymo printer. The label script has

also been added to the Contact and Ship To windows as well, so if you

want them just ask and I'll post. If there is a request, I will post

this scripts up on the group at Yahoo!.

Enjoy.

Myron Stevenson, CPA

Clearis Consulting, Inc.

------------------------------
Jeff Schwenk
Bottomline Software, Inc.
(540) 221-4444
------------------------------


Original Message:
Sent: 01-10-2024 10:21
From: Jerry Norman
Subject: Sage alert for address validation

SAW is a reasonable solution. So is BPI from Fisher Tech. A small script would be fired off a SO querying one of the services available to provide address checking. The service is polled from Sage 100 instance. The correct address would overwrite the one entered. 

You should pull somebody who is competent with SAW/BPI and polling web data sites. The web site's service is not free. What is the value to the customer of removing this problem?

------------------------------
Jerry Norman
Smartbridge Partners
(512) 653-7498