Feature - Added the Ability to Copy the Ship-To Contact Phone Number to the Country Field

Release date: 4/19/2022

Version: 8.5 and Up

The purpose of this feature is to map the imported ship-to contact phone number to Elliott's Sales Order Country field. This assumes your sales order ship-to addresses are inside the USA only.  Hence, the Country field in the order header has no use. In this case, we need to print the contact phone number on shipping documents such as the pick ticket, packing slip, or shipping labels.  This can be important for drop-ship consumer orders when carriers need to contact the consumer directly for the delivery.

A Customer EDI Profile flag was added to screen 7 to control if the ship-to contact phone number should be copied to the Country field.

The following is a sample ship-to XML segment we received from SPS:

        <Address>
            <AddressTypeCode>ST</AddressTypeCode>
            <LocationCodeQualifier>92</LocationCodeQualifier>
            <AddressLocationNumber>DS</AddressLocationNumber>
            <AddressName>COSMOPOLITAN @ RESTON TOWN CTR</AddressName>
            <Address1>1855 ST FRANCIS ST</Address1>
            <City>RESTON</City>
            <State>VA</State>
            <PostalCode>201900000</PostalCode>
            <Country>US</Country>
            <Contacts>
                <ContactTypeCode>BD</ContactTypeCode>
                <PrimaryPhone>703-707-9640</PrimaryPhone>
            </Contacts>
        </Address>

The Elliott SPS Service will take the ship-to address and contact information and place them in Attribute records in the import file of a sales order.

The Attribute records, indicated with an "I" in the first column, have predefined codes for SPS that begin with an underline (_).  The first Attribute record is _ADDRESS01 and the next column is a qualifier of ST.  This indicates a ship-to record.  The next two Attributes are the address and contact for the ship-to.  The contact Attribute is _ADDRESS01CT01, and the third column over is the phone number: 703-707-9640.  When the EDI Profile flag is set to Y, this value will be copied to the Country field of the ship-to.  The Country field is 20 characters, so there is plenty of room for the formatted phone number.

The Import Edit List and Journal prints the ship-to address before the contact can be evaluated, so the phone number will not print in the Country section.  A message will appear just below it to indicate the phone number will be stored in the Country field.

Order Inquiry can prove the imported order has the phone number in the Country field  Test all scenarios from label printing to creating outbound EDI documents to make sure the phone number does not cause a problem.

 

Modified Programs: ARCUSEXT.FD, ARCUSEDI, CPORDIMP

MAD

• Related Articles

• Feature - Country Validation

  Release Date: 9/6/2022 Version: 8.5 and Above The feature allows the user to enable country validation. A new A/R Global Setup option has been added to enable this feature: Global Setup-> Acct-> A/R Global Control-> 32. Validate Country. 32. Validate ...

• Contact Name, Email, and Phone Number Show in Order Comments

  Release Date: 04/30/2023 Version: 8.2 & Up Q - All of a sudden, the contact's name, e-mail address, and phone number shows up in the order comments and prints on the invoice. See sample screen below. What may cause this to happen? A - It seems that ...

• Feature - Country Maintenance

  Release Date: 5/17/22 Version: 8.5 and Above This application supports add, change, delete and list functions for the country file. The application is available from System Files Setup-> Maintenance-> Country File. The primary purpose is to add ...

• Feature - Drop Ship Enhancement

  The purpose of this feature is to add the ability to input, process and ship drop-ship orders to consumers for our customers while adhering to already existing business rules. This support is implemented through the use of the Customer Type File ...

• Feature - Drop Ship Enhancement

  The purpose of this feature is to add the ability to input, process and ship drop-ship orders to consumers for our customers while adhering to already existing business rules. This support is implemented through the use of the Customer Type File ...