Creating individual orders/shipments in OTM is a tedious and time consuming process specially when there are multiple orders/shipments to be created. Transport coordinators / planners have to manage this order/shipments information in excel by entering the data manually which may leads to errors and the process is monotonous. Enforcing business specific validations using OTM standard sometimes create edit screen on each order/shipments is inaccuracy.

To resolve these issues, the SRUJAN team has come up with the ideation of managing the content in widely used MS-Excel and upload into OTM for creation, updation and deletion of orders.

• Allows data to be managed in spreadsheet without being online
• Enable Bulk Operations on OTM objects & reduces data entry time
• Reduces approximately 40% of the time spending on data entry
• Enforces business specific data validations before transmitting to OTM
• Increases data integrity

Creating individual orders in OTM is a time consuming process when there are multiple orders to be created. The transport coordinators / planners manage the orders information in excel and / or manually enter them in OTM. SRUJAN's Mass Order Upload add-in provides the facility to upload orders information via Excel or CSV file format.

Manually adding order/shipment events in OTM is cumbersome process when we have huge number of orders/shipments to add events for non EDI capable carriers. This process will take lot of time for carriers to enter one by one event for order/shipment via OTM carrier portal. This may lead data entry errors which may cause OTM workflow failures.

This tool enables users to release the order base based on required weight/volume/quantity/etc.

Entering individual shipment actuals information in OTM is very time consuming process when there are multiple shipment actuals to be entered.The Suppliers / OTM users can manage the shipment actuals information in MS-Excel.SRUJAN's Mass Shipment Actuals (MSA) application provides the facility to upload shipment actuals information via Excel or CSV file format.

The main purpose for this tool is to edit the selected shipments from OTM regular finder screens to modify the similar data for all shipments. Currently OTM provides the group edit on certain fields on the shipment but not all.

Creating individual Events in OTM is a time consuming process when multiple Events to be created. SRUJAN’s MTEU application will help to manage the Events within the spreadsheet and load into SRUJAN App for Events to create. This application can be used in place of EDI integration messages (ex: 214 / 312 / etc). Customizable data entry elements / fields are possible based on the custom requirements. Event creates in OTM without matching to existing shipment(s), this can be configured if the match process to be done before event create in OTM. The MTEU application provides the SRUJAN mass upload applications standard features like error handling, finder screens, front end & server side validations, etc.

Creating individual Invoices in OTM is a time consuming process when multiple Invoices are to be created. SRUJAN’s MIU application will help to manage the invoices within the spreadsheet and load into SRUJAN App for invoices to create. This application can be used in place of EDI integration messages (ex: 210 / 410 / etc). Customizable data entry elements / fields are possible based on the requirements. Invoice creates in OTM without matching to existing shipment(s), this can be configured if the match process to be done before invoice create in OTM. MIU application provides SRUJAN mass upload applications standard features like error handling, finder screens, front end & server side validations, etc.

OTM provides flexibility to get rates for given search criteria using standard OTM RIQ screens. The limitation with this process is, we can only get rates for one lane at one time.
We questioned ourselves, "Can we export rate inquiry (RIQ) results into spreadsheet by entering specific criteria into OTM for multiple lanes at a time?"

Our Mass RIQ (MRIQ) tool provides the flexibility to load the spreadsheet with configurable RIQ input fields and the tool immediately returns back with results for those lanes in new columns on the same spreadsheet. This is a great tool to use for planners, rate loaders & other OTM users for easy rate verifications.

Using this tool, the rate inquiry results will be displayed within seconds for various lanes.