Distribution, Manufacturing, and Internet Modules

[MAS200New]

Hi all.

We have MAS v4.05 and use it in conjunction with Starship to do our shipping. We are running into a situation where we are being charged an extra fee by UPS, FedEx etc. for shipments that are going to a residential address. We want to be able to do 2 things in MAS (if possible):

1. Identify a ship to address as residential

2. Have a way to verify if an address is correct when creating a sales order

For #1, we tried to create a UDF and have that appear in the ship to address window but we realized there is no UDF table for ship to addresses (some of our customers have more than 1 ship to address so we can not just add it to the main customer maintenance UDF table. So has anyone out there run into the same problem with not being able to identify a ship to address as residential?

For #2, is there a way to do this or is there a 3rd party software available?

Thank you in advance!

[BigLouie · Accepted solution]

Upgrade to v4.30. There is now a check box in the Ship To to identify it as Residential.  On number two (2) you can create a script to push the info to the USPS web page and check the address.

[MAS200New]

Thanks!

[BigLouie]

Here is some code from the Obe Wan of MAS, Slade, that pushes the address to the USPS web page and allows you to check the address. Just changed the field names to the ones available depending on which panel you are on:

' Slade Hornick
'
' Hardcoded Variables
' ***************************************
' NONE
' ***************************************
'
' Create the IE Object
Set ie=CreateObject("InternetExplorer.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_AddressLine2 &_
"&address2="+AR_Customer_bus_AddressLine1 &_
"&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

[MAS200New]

Thanks Louie, I'll give it a shot, if I have any questions I'll post a question.