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

• 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 ...

• CPSLSDSK Customer Order Processing Sales Desk

  Sales Desk Application Overview Sales Desk is designed for companies who need versatile order entry functions and improved customer service. It is designed to be used by salespersons, order entry personnel and telemarketers. Sales Desk is extremely ...

• CP0102 Customer Order Processing Copy Order

  Copy Order Application Overview Copy Order is designed for customers who do business with department stores where a typical purchase order is sent with the same contents, but shipped to hundreds of different stores. With Copy Order, you do not have ...

• Avalara - Copy/Consolidate Orders

  Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the following changes will take effect in Copy/Consolidate Orders. Copy/Consolidate Orders must be run under version 8.6. If the user attempts to run the ...

• CPIMPMNU Customer Order Processing Sales Order Import

  Sales Order Import Application Overview The Sales Order Import module is designed to import a pre-defined ASCII file to create COP sales orders. It is intended to provide an easy way for developers to create add-on solutions for creating sales ...