Page Comparison

How To set Up Carrier to TMS.doc

New TMS carrier setup.SupplyStream UAT:  https://ss-ihub-uat-web.azurewebsites.net/SupplyStream Live: https://wwwtmsuat.supplystream.com/Log into SupplyStream using an admin account.

Select Admin>Carriers>Carrier List

Image Removed

Click Create New button.

Image Removed

Enter the Carrier Code and Description/Carrier Name then click Save button.

Image Removed

Image Removed

Now add the carrier to all relevant customers.

Select Admin>Carriers>Carrier Company Access.

Image Removed

Click Create New button.

Image Removed

Select the company who need access to the carrier then click Add & Close button.

Image Removed

Image Removed

Next step using back end process.

• Create a CarrierService for the carrier.
• Create to CarrierProviderCarrierServiceTypeMapping.
• Create to CarrierProviderCarrierMapping.

Notes:

Change the below parameter:

@CarrierCompanyCode = CompanyCode/CarrierCode

@CarrierCompanyName = CompanyDescription/CarrierName

@CarrierProvider = Indigina TMS

@ReleaseProfile int = 0

If value is 0, This is QA

If value is 1, This is Live

SET @ServiceName = Carrier Service Name
SET @ServiceCode = Carrier Service Code

Run the below script.

DECLARE @CarrierCompanyName nvarchar(max), @CarrierCompanyCode nvarchar(max), @CarrierCompanyID uniqueidentifier, @CarrierProvider nvarchar(max),
@CarrierProviderID uniqueidentifier, @CarrierServiceTypeID uniqueidentifier, @ReleaseProfile int, @ServiceName nvarchar(max), @ServiceCode nvarchar(max),
@NEWID1 uniqueidentifier, @NEWID2 uniqueidentifier, @NEWID3 uniqueidentifier, @UserID uniqueidentifier
SET @CarrierCompanyCode = 'INDNL'
SET @CarrierCompanyName = 'IND NL'
SET @CarrierProvider = 'Indigina TMS'
SET @ReleaseProfile = 0 --0-QA/UAT 1-Live
SET @ServiceName = 'INDTEST'
SET @ServiceCode = 'INDTEST'

SELECT @NEWID1 = NEWID()
SELECT @NEWID2 = NEWID()
SELECT @NEWID3 = NEWID()

SELECT TOP 1 @CarrierCompanyID = CompanyID FROM Company WHERE CompanyDescription = @CarrierCompanyName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate
SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @UserID = UserID FROM Users WHERE UserName = 'SystemDefault' AND DisableLevel = 0 ORDER BY CreateDate

INSERT INTO CarrierServiceType(CarrierServiceTypeID, CarrierID, ServiceCode, ServiceName, CreateDate, CreateUserID, DisableLevel, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID1, @CarrierCompanyID, @ServiceCode, @ServiceName, GETUTCDATE(), @UserID, 0, GETUTCDATE(), @UserID

SELECT TOP 1 @CarrierServiceTypeID = CarrierServiceTypeID FROM CarrierServiceType WHERE ServiceName = @ServiceName

INSERT INTO CarrierProviderCarrierServiceTypeMapping (CarrierProviderCarrierServiceTypeMappingID, CarrierProviderID, CarrierServiceTypeID, MappedID, MappedCode, CreateDate, CreateUserID, DisableLevel, ReleaseProfile, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID2, @CarrierProviderID, @CarrierServiceTypeID, NULL, @ServiceCode, GETUTCDATE(), @UserID, 0, @ReleaseProfile, GETUTCDATE(), @UserID

INSERT INTO CarrierProviderCarrierMapping (CarrierProviderCarrierMappingID, CarrierProviderID, CarrierID, CreateDate, CreateUserID, DisableLevel, MappedCode, ReleaseProfile, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID3, @CarrierProviderID, @CarrierCompanyID, GETUTCDATE(), @UserID, 0, @CarrierCompanyCode, @ReleaseProfile, GETUTCDATE(), @UserID

MANUAL ADD CARRIER TO PROVIDER INTEGRATION

Notes: If the carrier is newly created then it is required to activate TMS dispatch.

DECLARE @CarrierProviderID uniqueidentifier, @CarrierID uniqueidentifier, @NEWID uniqueidentifier, @CarrierName nvarchar(max), @CarrierProvider nvarchar(max)
SET @CarrierName = 'IND NL'
SET @CarrierProvider = 'Indigina TMS'
SET @NEWID = NEWID()

SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @CarrierID = CompanyID FROM Company WHERE CompanyDescription = @CarrierName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate

INSERT INTO CarrierProviderIntegration (CarrierProviderIntegrationID, CarrierProviderID, CustomerID, DCID, CarrierID, CreateDate)
VALUES (@NEWID, @CarrierProviderID, NULL, NULL, @CarrierID, GETUTCDATE())

MANUAL ADD PROVIDER SETTING / RULES

Notes: This is just an optional if customer requested for the carrier.

DECLARE @CarrierProviderID uniqueidentifier, @CarrierID uniqueidentifier, @NEWID uniqueidentifier, @CarrierName nvarchar(max), @CarrierProvider nvarchar(max),
@Setting nvarchar(max), @Value nvarchar(max)
SET @CarrierName = 'P2P NL'
SET @CarrierProvider = 'Indigina TMS'
SET @Setting = 'SendParcelContent'
SET @Value = 'All'
SET @NEWID = NEWID()

SELECT TOP 1 @CarrierProviderID = CarrierProviderID FROM CarrierProvider WHERE Name = @CarrierProvider
SELECT TOP 1 @CarrierID = CompanyID FROM Company WHERE CompanyDescription = @CarrierName AND OwnerCompanyID = CompanyID AND DisableLevel = 0 ORDER BY CreateDate

INSERT INTO CarrierProviderSetting (CarrierProviderSettingID, CarrierProviderID, CustomerID, DCID, CarrierID, Setting, Value, CreateDate)
VALUES (@NEWID, @CarrierProviderID, NULL, NULL, @CarrierID, @Setting, @Value, GETUTCDATE())

Now move on to the TMS site.

URL_UAT:  https://tmsuat.supplystream.com

URL Live:  https://tms.supplystream.com

Notes:  Each client normally has their own set identifiers with the carrier.

Example:

For Interpost Omni Parcel each client has their own "Authentication Access Key"

Hermes has a Child Client ID

...

This will identify the client when creating labels with the carrier.

To Set Up Carrier set up carrier into TMS for customer:

Log into in to TMS site

Example:

My Account - > Default Integration Partner - > Select Indigina iHub - Seko UK

Select client: Ex. Heist StudiosImage RemovedAFG Morphsuits

Image Added

Image Added

Linked the carrier to the client:

System Admin - > Security - > Client Entitlements

Click on customer (ex. Heist StudiosAFG Morphsuits)

Tick Carrier (Ex. HermesOmni Parcel)

Click the Save buttonImage Removed

Image Added

Setup the carrier credentials for the client:

Entity Setup -> Carrier Setup -> Maintain Carriers

Ex. Click on HermesOmni Parcel

Click the Edit icon next to Heist Studios – enter details on the child client ID for Hermes and Authentication key for Interpost (screenshot below is an example for Hermes)

Child Client ID: 018

Child Client Name: Heist Studios

Click the tick icon

click the save button

Image Removed

NOTES: 

These identify Hermes, (Don't change this)

but you can view this at

System Admin -> Settings -> Carrier Provider Settings

Click on Hermes

you will see client id etc. here.

Image Removed(pencil) icon beside customer AFG Morphsuits – Enter Access Key for carrier Omni Parcel

Access Key: C56F6896C67B00232AD7A64D092C994808D9719BB7689E07C9

Click the tick icon (check), to save changes.

Click the Save button to apply overall changes.

Image Added

That’s it for the TMS carrier setup in TMS site.