How To set Up Carrier to TMS .doc
New TMS carrier setup.
SupplyStream UAT: https://ss-ihub-uat-web.azurewebsites.net/
SupplyStream Live: https://www.supplystream.com/
Log into SupplyStream using an admin account.
Select Admin>Carriers>Carrier List
Click Create New button.
Enter the Carrier Code and Description/Carrier Name then click Save button.
Now add the carrier to all relevant customers.
Select Admin>Carriers>Carrier Company Access.
Click Create New button.
Select the company who need access to the carrier then click Add & Close button.
Next step is need to be done back end.
- Create a CarrierService for the carrier.
- Create to CarrierProviderCarrierServiceTypeMapping.
- Create to CarrierProviderCarrierMapping.
Notes:
Change the below parameter:
INSERT INTO @Temp SELECT 'TESTINTERNATIONAL', 'TESTINTERNATIONAL' = Enter the Carrier Service Name and Carrier Service Code.
@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
Run the below script.
SET NOCOUNT ON
DECLARE @Temp TABLE(ServiceName nvarchar(max), ServiceCode nvarchar(max))
INSERT INTO @Temp SELECT 'TESTINTERNATIONAL', 'TESTINTERNATIONAL'
DECLARE @CarrierCompanyName nvarchar(max), @CarrierCompanyCode nvarchar(max), @CarrierCompanyID uniqueidentifier, @CarrierProvider nvarchar(max), @CarrierProviderID uniqueidentifier, @CarrierServiceTypeID uniqueidentifier, @ReleaseProfile int, @NEWID1 uniqueidentifier, @NEWID2 uniqueidentifier, @NEWID3 uniqueidentifier, @UserID uniqueidentifier
SET @CarrierCompanyCode = 'TESTNL'
SET @CarrierCompanyName = 'TEST NL'
SET @CarrierProvider = 'Indigina TMS'
SET @ReleaseProfile = 0 --0-QA/UAT 1-Live
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
IF NOT EXISTS(SELECT * FROM CarrierServiceType WHERE ServiceCode IN (SELECT ServiceCode FROM @Temp))
BEGIN
INSERT INTO CarrierServiceType(CarrierServiceTypeID, CarrierID, ServiceCode, ServiceName, CreateDate, CreateUserID, DisableLevel, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID1, @CarrierCompanyID, ServiceCode, ServiceName, GETUTCDATE(), @UserID, 0, GETUTCDATE(), @UserID FROM @Temp
SELECT TOP 1 @CarrierServiceTypeID = CarrierServiceTypeID FROM CarrierServiceType WHERE ServiceName IN (SELECT ServiceName FROM @Temp)
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 FROM @Temp
INSERT INTO CarrierProviderCarrierMapping (CarrierProviderCarrierMappingID, CarrierProviderID, CarrierID, CreateDate, CreateUserID, DisableLevel, MappedCode, ReleaseProfile, LastModifiedDate, LastModifiedUserID)
SELECT @NEWID3, @CarrierProviderID, @CarrierCompanyID, GETUTCDATE(), @UserID, 0, @CarrierCompanyCode, @ReleaseProfile, GETUTCDATE(), @UserID
END
ELSE
BEGIN
SELECT 'ServiceCodes already exist!!!'
END
MANUAL ADD PROVIDER SETTING / RULES
Notes: This is just an optional if customer requested for carrier.
...
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
TMS 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 Studios
AFG Morphsuits
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 button
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(pencil) icon beside customer AFG Morphsuits – Enter Access Key for carrier Omni Parcel
Access Key: C56F6896C67B00232AD7A64D092C994808D9719BB7689E07C9
Click the tick icon
click the save button
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.
(check), to save changes.
Click the Save button to apply overall changes.
That’s it for the TMS carrier setup in TMS site.