Optimal routing — delivery of equipment and work crews

How can you optimize the routes of vehicles that need to deliver equipment and / or installation teams to the place of work? A few years ago, we were given such a task by a client specializing in the delivery and installation of metal-plastic windows.

The bottom line of the case is that such a vehicle, upon arrival at the place of work, does not need to wait for their completion. After unloading the equipment and instruments, the vehicle can return for the next team and batch of equipment.

The client, in addition to the minimum mileage, also needed to receive in the calculations the number of trips that vehicles can do during the day.

An important condition is the loading time of vehicles in the warehouse, which is 1 hour on the average. This parameter must be written  in the properties of the warehouse, the Working hours tab:

For example, add 4 vehicles (that’s how many cars our client uses). Field Break, min — change to 0 i.e. the break between flights is the loading time at the warehouse, which was previously written.

One car per one trip delivers only one team and a set of equipment for installation, respectively, in the vehicle parameters in the SP Limit  field, specify 1.

It was also important for the user to receive a cost estimate, which includes the cost of fuel and the hourly payment to the driver. Tariffication is entered in the subordinate box of each vehicle in the Rate tab:

Pay attention! The driver’s working day is 10 hours and includes travel time, loading time at the warehouse and unloading time at points.
 

In the Logistics+ options, select the Calculating Formula Type of Cost per Route — Given the tariffs per km and hour, and make sure that in the Always recalculate the time of the next trips — field, Yes is selected:

And the last settings: the parameters of the Logistics tab. In this case, the main parameter — Penalty coefficient for exceeding the SP limit — is set to the maximum. Other parameters do like in the example:

Load applications, indicating in points the average unloading time — 60 minutes. Start the calculation, select the vehicles available for planning, in the Vehicles tab in the Multi-flight routes field 1, select Yes and not forget to indicate the average speed of vehicles 2. In our example for Kyiv, this is 25 km/h:

An important condition that must be observed is that the latest departure from the warehouse is allowed no later than 14:00 (this is due to the fact that the equipment have to be unloaded from the client and proceed to the installation). From the list of routes, we can see that the last route that can leave with a slight deviation is route number 9 with a departure time of 08:00. The unloading end time at the client is 16:52. The subordinate box of the route also displays its cost:

It is better to delete other routes that start from number 10, and do the calculation for the points of the application the next day.

Pay attention! If the route is intercity, as in example number 4, you need to select route 1, go to the Delivery groups 2 directory, select additional parameters 3, and uncheck the box Average speed 4, recalculate route 5.

The order of the described actions must be carried out with all intercity routes, if any.

Download the following applications and select vehicles available for planning. The vehicle code column shows the time when they finish their previous trips. In the additional parameters, do not forget to specify the average speed for your city, after that you can do the calculation:

As you can see, the use of ANT-Logistics in organizing the work of its transport service allows our client to calculate not only the best routes, but also the cost of delivery, arrival time, as well as the number of cars and flights needed. If it is impossible to reach the customer «today» — his order can be transferred to the beginning of the route of the next working day, or additional vehicles can be involved in the delivery.

If you are interested in the described functionality, we are ready to demonstrate its operation, do the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Optimal Routing — Distribution

 The majority of our clients are distribution companies. For such kind of companies, while planning routes, it is necessary to take into account — in various combinations — the following parameters:

  •  Vehicle type;
  •  Vehicle load capacity, kg;
  •  Vehicle volume, m3;
  •  Capacity, pcs;
  •  SP groupings by type;
  •  SP groupings by geo-zones;
  •  Product groups and their compatibility;
  •  Loading / unloading time at delivery points;
  •  Calculation of costs and prime cost;

We decided to put together all the information on setting the listed parameters, supplementing them with the missing material  in this article.

Let us start with:

Vehicle type

In the system, you can specify what type of vehicle is yours: truck or passenger car. If delivery is carried out within the city by trucks, while planning, it is necessary to take into account the fact that some roads or even districts may be closed to truck traffic. If the delivery is carried out by cars up to 3.5t. — such cars do not belong to the prohibition and are type of passenger cars. You can select the vehicle type by opening the vehicle properties:

Carrying capacity, capacity, volume

While planning routes, it is necessary to take into account the restrictions associated with the capacity of vehicles. These are such units of measurement as: kg, m3, pcs. These values ​​can be used individually or in any combination. First, you need to add the required units of measure to the properties of the machines, for which you need to click on the Service — Settings — Accounting tab. Opposite the needed values,you have to select Yes:

After clicking OK, the selected values ​​will be added to the vehicle properties. Then you can set the capacity of vehicles, enter data about the number of products delivered to the points, and the system will calculate routes taking into account the specified restrictions.

SP groupings by type

A common situation for distributors is the delivery of large batches of products to supermarkets, and small batches to small shops. From the first type of outlets we should deliver by larger vehicles that can take on board more goods and for which the supermarket has a place to park. From the second type of outlets we can deliver by small vans, which are easier to maneuver and park on congested streets. In the service, we divide outlets into 2 groups, for example: supermarkets and minimarkets. For each group of them, we assign vehicles, for example, trucks for supermarkets and vans for minimarkets, then we start the calculation. As a result, trucks will go to supermarkets, and vans to small shops. Detailed instructions in the article Routes by delivery groups. Set up once and use.

SP grouping by geo-zones

Another way of the most common planning methods is SP grouping by geo-zones with a specific vehicle or group of vehicles assigned to each zone. This planning method allows drivers to thoroughly learn the service area and establish contacts with receivers, which generally speeds up the delivery process. Do not forget that before the introduction of automatic systems, logisticians send cars to certain districts — i.e. this method also contributes to faster learning to work in the service, since it involves the automation of a model already worked out by the logistician, who only needs to draw zones on the map and start the calculation. How to start drawing geo-zones on a map and how to create routes by zones, we considered in the webinar Geo-zones and their use in planning.

Product groups and their compatibility

For the transportation of certain groups of goods, specialized vehicles are required, in which it is impractical or impossible to transport other groups (for example, frozen products). If your distribution activity involves the delivery of different product groups, then you can find instructions with step-by-step settings in the article Calculating of routes by product groups.

Loading/unloading time at delivery points

While calculating routes, it is also necessary to take into account the time spent by the vehicle at the point of delivery, which is required for loading / unloading products. In the system, such an administrative time spent at a point consists of 2 parts:

1. Fixed — the time required for the car to park, fill out documents, etc. This time is set in the parameters for all points, or imported into each specific application, taking into account possible changes;

2. Variable — the time required to unload products, that depends

on the amount of products to be unloaded or loaded. It sets in the properties of product groups for each group of goods, separately for loading and for unloading;

In this example, the loading/unloading speed is set to 10 m3/min:

I.e. If a car needs, for example, 10 minutes to park at a point, and it has to unload 2m3, then the administrative time spent at the point will be 30 minutes (10+10+10). Thus, the service automatically calculates the unloading / loading time for each point, depending on the size of the shipped products, and takes this time into account while building the route.

Calculation of costs and prime cost

While calculating routes, the service allows you to get not only mileage and time, but also the cost part. Tariffs are registered in the subordinate box of the car, Tariff tab:

If you specify several tariffs, they will all be summed up and at the end of the calculation the total cost for the route and the cost per point will be displayed.
If, while importing, you specify how much you can earn delivering goods to a either point (Profit field), then after the calculation, profit will be displayed for the route and points:

The cost price can be displayed in 2 versions: costs are proportional to the points (as in the previous example), or taking into account the tariffs per km and hour — while choosing this formula, the cost of the points will be calculated according to the formula:

Point cost = total mileage/number of points* pare per km + total travel time/amount of points*pare per hour + time at the point*pare per hour.

You can select the type of prime cost calculation formula in the parameters, Logistics+ tab:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Photos of points — as an addition to the address

 To create a route to a delivery point, you need its address. But it often happens that the delivery point at the specified address is a small store in a shopping center, or a small architectural form among many of its kind, or a place in the market. Therefore, the search for such «secret» addresses takes a lot of time, especially for new forwarders. ANT-Logistics greatly facilitates the search for such points due to the ability to take, store and display their photos. The courier,who arrived at the address, opens a photo album in which he sees what the required point looks like in the photo, and, if it is necessary, the passages to it.

This functionality can be divided into several blocks:

  1. Types of photos, adding and viewing them in the mobile application;
  2. Types of photos, adding and viewing them on the service;
  3. Displaying photos in the analytical module;
  4. Uploading photo links via API;

Everything is quite simple. Links to photos can be uploaded via an API or a web service, after which they will be displayed in the photo albums of points both on the website and in the mobile application. Photos can also be uploaded to the ANT-Logistics cloud directly from a mobile device or PC. There is a diagram that gives a visual understanding of how the described functionality works below :

To add a photo of a point in the mobile application, you need to long press the required point from the route list and select photos in the menu that opens 1. Then click the camera icon 2, and from the pop-up list select the method of photo loading 3: phone gallery,cloud storage or take a photo with a camera. As you add photos, they will appear in the point’s photo album.

When the photo is marked with a cloud icon 4, it means that the photo has already been added to the ANT-Logistics storage. The cross allows the user to delete the photo. And finally, if there is at least one photo in the photo album of a point, such point will be highlighted with image symbol in the list 5:

Then, if this point is selected and the photo button is pressed in the directory by the service administrator 1, the photo album of the point will open, in which photos are taken by the forwarder will be displayed (transmitted via the Internet channel). By selecting either photo, you can edit its position 2 or delete it:

The service administrator can also add photos by clicking the + button. It is possible to either upload a photo as a file, or save a link to the photo:

After adding photos by the service administrator, the photos are displayed in the point’s photo album. In the mobile app, new photos are displayed after the route is updated:

Pay attention! Photos added by the service administrator cannot be deleted by the mobile application user.

Photos of the point can also be displayed in the analysis module. To do this, open the Directories section in the analytics and select the Photos of points report. If the point has photos, they will be displayed in the Photos field:

If the required report does not exist, it has to be created. Create a new report, select Data Mart — Report: Points lookup, fields — as in the image.

A list of points with links to their photos can be downloaded using the API method. A description of the desired method can be found by clicking on this link.

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

How not to fall into the «minus»? — Monitoring the cost-effectiveness of routes

 In the webinar Calculate the cost of routes, we showed how the cash calculation model works, in which the service first of all selects vehicles with lower tariffs for planning.

The «financial» capabilities of the system are not limited to this. The user can also calculate the profitability of routes. This calculation allows you to exclude unprofitable points from the route or calculate additional profit for them, which will always allow you to get the most profitable routes.

First of all, you need to set the calculation  per money model in the parameters, set the tariffs for vehicles and load the delivery points with the Profit field filled in:

We will calculate the profitability of routes in 3 different versions, and having determined the optimal one for ourselves, we will copy the route to the main one. Before the calculation, do not forget to copy the calculation parameters from the «Basic» version to other versions in order to obtain objective results.

So, we will choose Version 1. In this version, the route will be calculated taking into account profitability. To do this, in the Additional parameters box, go to the Calculation modes tab, in the Calculation of profitability field, select Do not exclude unprofitable points from routes. Save the changes OK and start generating routes:

As a result, we got a route in which the Expenses are 4649 monetary units higher than the Profit received from the points, which makes this route unprofitable. Below, in line № 2, the number of unprofitable points is displayed, the total profit of which is less than the Expenses. Lower, in the subordinate route box, unprofitable points are marked with the corresponding icon:

Pay attention! The columns Expenses and Profit in routes, and Profit and Extra profit are displayed using the Table Settings directory.

For the next calculation option, select Version 2. In the Routes formation box, select the same vehicle. In this case, in the Calculation of profitability field, select Exclude unprofitable points from routes:

In this calculation, the system excluded all unprofitable points from the route, calculating the route only for 1 point. The profit from delivery to which exceeds the Expenses:

Version 3. In this calculation option, we will offer the system itself to determine the extra profit that needs to be received from unprofitable points so that the route turns out to be profitable.

In the Routes formation box, select the same vehicle, and in the Calculation of profitability field, select Add to profitability:

In contrast to the first version of the calculation, the profit in this route is 18 units higher, which makes it profitable, while, unlike the second version, there were not any points excluded from the route. The system determined the amount of extra profit (in other words, how much more money you need to take from the client for delivery) to make this route profitable:

So there are 3 calculation options:

  1.  The system calculated the route for all points, indicating at the same time which of them are unprofitable in this transport task;
  2.  The system calculated the route only for cost-effective points, the remaining points are excluded from the route;
  3. The system calculated the route for all points, while additional profit was calculated for unprofitable points;

Which option to choose? — of course, it depends on the processes established in your company. If, for example, the 3rd option is more suitable for you, just copy the routes into the main version of the calculation:

After copying, the routes will be displayed in the Main version, and the order points will be marked as those for which the routes have already been calculated, i.e. will not be active for calculations.

Now let’s complicate the task. We will load 120 delivery points and calculate the profitability. In this case, the system has calculated 2 routes and it is already more difficult to find points for which additional profit is calculated:

And if the calculation is performed for 600 points, then manually sorting out 20 or more routes becomes even more problematic. However, it is not difficult to filter such points in the analytical module. Go to the Analytics module, select Analysis — Profitability, set the desired range and you will see a clear picture of the routes as a whole, as well as a list of points with additional profit.

An example of a report in the form of a table:

Pay attention! If you didn’t find the corresponding report — it needs to be created. If you are our client — contact support and we will add a report to your account.

Let’s summarize. The calculation of profitability gives an understanding of whether your transport service is working to «plus» or «minus». If the expenses in most cases are greater than the profit, this indicates that it is time not only to look for new ways to optimize costs, but also to revise the cost of delivery.

 

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Routes by delivery groups. Set up once and use.

 Previously, we described how to use the Delivery Groups tool, link vehicles to a specific service area, and calculate routes for different geo-zones. This is convenient, but not in all cases.

For example, for the delivery of large-sized goods, it is necessary to use trucks, while targeted deliveries of small-sized goods are handled much more efficiently by more maneuverable and economical cars. Also, there are often situations when it is not necessary to do the division into routes — it has already been done in another program and you just need to correctly display real routes, calculate time and mileage.

In this article, we will look at how to use delivery groups in combination with sales point groups and calculate routes for these groups. We consider that the division into routes is made in the user program and uploaded to the  sales point group field . We need to take into account this division on the ANT-Logistics service.

In the directories, select Sales point groups, then press +, in the field that appears, enter the caption, for example, TMS group, indicate the opening hours for the point groups and the desired figure, then press OK:

In the same way, we will create 2 more groups: AFT group and TCP group.

Then, you need to add machines, how to do this can be seen here. In this case, I’ve added 3 vehicles: cargo — MAN 1 and cars — Mercedes and Mersedes 2:

Let’s create delivery groups. To do this, open the DirectoresDelivery groups+, specify the name, OK:

 I’ve added 2 more groups: Group 1 and Group 2.

 Now we need to link a car to each delivery group. To do this, we press the desired group, select the Vehicles tab at the bottom, +, specify the vehicle, OK, check the «Select» checkbox:

Link 2 more vehicles to other delivery groups in the same way.

The last step in the settings is linking a point groups to a delivery group. Press the desired group, open the Groups tab at the bottom, +, select the desired group of points, OK:

Now link 2 more point groups to the rest of the delivery groups.

 All settings are completed, so you can export delivery points.

 To generate an Excel file, you have to fill in the CompGroup_Name column, in which, opposite each address, you must put the name of the desired point groups:

Open Directories — Delivery groups, open Requests

Pay attention — the inscription Delivery groups must be green. If the inscription is red — open Requests.

Click on General and click Distribute by SP groups:

The points are divided into groups according to the names of the delivery groups. The list of points of a particular delivery group can be seen below by clicking on the desired group:

Specify the groups for which you want to generate routes and click Generate routes:

Routes are generated at the same time.

Go to Routes, click Compare routes, select all routes:

Routes by delivery groups are clearly presented on the map.

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Calculation of routes by product groups

In November 2017, a new service feature was added — calculation of routes with the condition of distributing groups of goods by vehicles assigned to them. For example, goods of the «frozen» group have to be transported only by vehicles specially equipped for this purpose, nevertheless other goods should not get into the refrigerator. 

Start setting — go to SettingsAccounting tab, opposite the Use Product Groups field, select Yes and save the changes:

Create product groups in the Product Groups directory. In our example, two groups are created: Frozen and Fruits and vegetables — a group that does not require special transportation conditions.

Then go to the Products directory 1 and add the necessary products. When adding record in the  Name  field 2, select a product group from the drop-down list (in our example, it is Frozen or Fruits and vegetables):

Let’s go to the Vehicle directory 1, select the vehicle and open the Prod.Group  tab 2 in the subwindow. From the drop-down list, select the product group that this car will transport 3 :

In the same way, we will link product groups to other vehicles from the directory. If it’s necessary, you can select several product groups for the machine by adding product groups using the + button on the control panel for the elements of the directory 1:

Prepare an Excel file for importing delivery points. To do this, add the following columns to it:
  • Product_Id 1 — product code. Here you can specify the code of the product that needs to be delivered to this point. If several goods need to be delivered there, the point must be duplicated the required number of times .
  • Request_Num 2 – request number. This field specifies the request (order) number for the delivery point.
Pay attention! For goods of the same product group which are delivered to the same point, the request number must match. But for different points or for different product groups, the request number must not match.

Upload the file to the server, click Generate routes, and in the Additional parameters select the Compatibility 1 tab. Then, in the Control rule for product groups 2 field, set the required parameter:

  • The option Consider the compatibility of points and vehicles — while forming routes, distributes product groups by vehicles intended for them. This option allows you to transport several groups of goods in one car, if this option is specified in the vehicle settings. For example, if the product groups Frozen and Documents are specified for a refrigerated truck in the vehicle settings, then if the Consider the compatibility of points and vehicles option is enabled, the service can place both product groups in this vehicle at the same time.
  • The Separate and account for compatibility parameter must be activated if it is required to transport strictly only one product group in each vehicle, even if the vehicle settings indicate the possibility of transporting several product groups. For example, if for a refrigerated truck the Frozen and Documents product groups are specified in the vehicle settings, then if the Separate and account for compatibility option is enabled, the service will place only one product group (either frozen or documents) in this vehicle.

After calculating the routes, it is clear that the product groups are distributed strictly according to the vehicles assigned to them:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Loading sheet — accounting of goods

Let’s talk about the Loading Sheet today. This functionality is indispensable for distributors or companies involved in the distribution of bottled water.

So what is a Loading Sheet and why it is needed?

A Loading sheet is a functionality in the ANT-Logistics mobile application that allows you to keep track of the amount of goods loaded into a vehicle from a warehouse and unloaded at sales points.

Using the Loading sheet, you can see the list and quantity of products in the vehicle at the moment and, based on this information, plan the possibility of visiting additional points.

The Loading sheet table includes:

1. Data on goods (1) :

  • Product group;
  • Product code;
  • Product code string;
  • Product name.

2. Data on the quantity of goods:

  • Order Quantity, Order Weight, Order V, m3 2 — total quantity of goods for all points of the route (calculated field — these values ​​are calculated automatically by the service);
  • Loaded Quantity, Loaded Weight, Loaded V,m3 3 — quantity of goods loaded into the vehicle in the warehouse (this value is filled in by the user);
  • New quantity, New weight, New V, m3 4 — the total quantity of goods currently shipped to the visited points (calculated field);
  • Remaining Quantity, Remaining Weight, Remaining V, m3 5 — the amount of goods that is in the vehicle. This is a calculated field, calculated by the service according to the formula: Balance = Loaded — New quantity;
  • Reserve Quantity, Reserve Weight, Reserve V, m3 6 — reserve quantity of goods loaded into the vehicle in the warehouse. Calculated by the service according to the formula: Reserve = Loaded — Order + Quantity of goods not shipped at the visited points.

Pay attantion! In the loading sheet, fields with data on the quantity of goods are displayed depending on the selected units for accounting 1 (weight, quantity, volume, or their combinations ) in the Accounting  tab 2 of the Settings box 3. In the example below, accounting is only in pieces, therefore The following fields are displayed in the Loading sheetOrder Quantity, Loaded Quantity, New Quantity, Remaining Quantity, Reserved Quantity.

It’s vital to note that the service has the ability to customize the display (Show / Hide) and the width of the fields in the Loading sheet. To do this go to the Table Settings Directory 1, select Documents/Loading Sheet 2. A list of fields that can be edited will open in the sub-box: hide 3 or change the width.

In order for drivers to be able to use Loading sheets, it is necessary to enable the use of this functionality. To do this, go to the Service, Settings 1. In the Mobile App tab 2 in the Type of  loading list used  field 3, select the required value. Save changes — OK.

Then add applications with goods to the Requests’ Directory to create a route.

After that, when a driver enters the mobile application using his login, the generated route will be available to him.The actions of the driver in the mobile application for working in the Loading sheet :

The driver clicks on the route and selects the Settings button 1 in the quick access menu that opens.  If the Loading button is not in the quick access menu or additional menu, they can be added in Settings 2 by ticking the required item 3.

After loading the products into the truck, the driver fills in the Loaded field 1 in the Loading sheet. To do this, he must click on the line with the goods and in the Editing box that opens, enter the actual value of the quantity of loaded goods. You can also click the Loaded all button 3 — after confirmation, the values ​​from the Order field 4 will be copied to all empty Loaded fields. Lines in which the Loaded field is filled are displayed in bold. If goods that are not in the order were loaded into the vehicle, then such goods can be added to the Loading sheet using the Add button 5.

The Warning icon can be displayed in the Product Name field in the following cases:

  • If the quantity of the goods loaded into the vehicle is less than the quantity of the ordered goods (i.e. the value of the Loaded field < the value of the Order field).
  • If the Order field for the item is empty.

Further, in the process of bypassing points, the driver enters data on the number of goods issued. To do this, he enters the Products of point . In the list that opens, by clicking on the line with the goods, the driver calls up the Editing box and enters the issued quantity of products.

When the point is marked visited by 1, the Loading sheet will update the data on the shipped quantity and the remaining goods 2,3.

Thus, in the process of visiting points, the driver will always see how much goods are still in the car, and will be able to quickly make decisions on the possibility of supplementing the route with new requests without returning to the warehouse for the missing products.

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Tank trucks. Distribute products by vehicle sections

Recently, we faced a non-standard task — our client, a large manufacturer of cheeses and other dairy products, needed to build routes taking into account the distribution of goods by sections of vehicles. According to the client’s requirements, while calculating routes, it was necessary to take into account the carrying capacity and number of sections in vehicles, the specific order of filling sections, as well as industry rules for mixing products.

As a result of solving the task, a new functionality appeared in ANT-Logistics, which allows you to build traffic routes, taking into account the most efficient distribution of goods among vehicle sections. This option will be useful for companies involved in the transportation of petroleum products, liquid food products, chemical products and other cargoes, for which vehicles with a division of the cargo compartment into sections are used.

To understand how the new functionality works, let’s take the following example.

The company has a fleet of Milktrucks divided into sections of different carrying capacity. When collecting milk from points, it is necessary to separate different types of milk into different sections of vehicles. Milk is divided into 3 types:

  1. milk of the 1st category;
  2. milk of the 2nd category;
  3. skimmed milk.

To distribute products by vehicle sections and calculate routes, perform the following actions:

1. Let’s go to Service-Settings. On the Accounting tab 1, in the Use product groups field 2 , select Yes. Then, in the Keep records in kg (weight) field, specify Yes, in the fields Keep records in units (pcs) and Keep records in m3 (volume) — No 3.

Pay attention! While calculating using sections, it is always necessary to select accounting for goods by weight, even if the actual goods are not by weight and are measured, for example, in liters.

2. In the Product Groups  Directory 1, using the +  button 2, create several groups: Milk 1, Milk 2, Skimmed Milk. For each group, we indicate a separate type of product 3 (not Auto).

3. In the Products Directory 1, we will create a product, assigning each of them a product group 2.

4. Add a warehouse to the Directory Warehouses 1 — in our example, this is Factory.

5. In the Vehicle Directory , we will add vehicles. For each Milktruck, in the General 2 tab, we indicate the Load capacity (in accepted units — in our case, in liters). 

6. In the subwindow of the Vehicle Directory in the Sections 1 tab, using the buttons of the control panel 2, we will enter sections for each vehicle, indicating their capacity 3.

Pay attention! The total load capacity of the sections can either coincide with the load capacity of the vehicle or exceed it. In any case, when filling sections with goods, the service controls that the total load capacity of the machine is not exceeded. For example, with a total vehicle capacity of 10,000 accounting units and a carrying capacity of three sections of 5,000 accounting units, the goods can completely fill two sections of 5,000 accounting units or partially fill three sections so that in total they do not exceed 10,000 accounting units.

7. Go to the Editing Record window for each created vehicle and in the Loading sections 1 tab, enter all valid templates for filling sections 2. In the templates, specify the order in which sections are filled using the numerical designations of the sections and the “-” sign between them. For example, 1-3-2 means that section #1 will be loaded first, then section #3, and section #2. In our example, for a three-section Milktruck, we will indicate all possible loading options: 1-2-3, 1-3-2, 2-1-3, 2-3-1, 3-1-2, 3-2-1.

If the section filling patterns are specified incorrectly, the service will generate an error at the route calculation stage.

Pay attention! While calculating, a section is considered conditionally filled if at least one product in any volume falls into it. For example, if section № 1 with a capacity of 3000 liters gets a product with a volume of 10 liters, then the next section can already be filled (according to the templates). In the future, section № 1 can be supplemented with goods of the same type. It should also be noted that a product from one application can occupy several sections.

Prepare an Excel file for importing delivery points by specifying the weight and product code (QtyW, Product_Id):

Pay attention! If there is a need to pick up different types of products from one point, then it is necessary to create several requests — table rows (as in our example it is indicated for WRE1,WRE4,WRE11).

9. Upload the file to the server. When generating routes, inAdditional parameters1, select the Compatibility tab 2. In the Vehicle section control rule 3 field, select Separate and  account for compatibility.

10. In the Additional parameters on the General tab, the selected settings for generating routes will be displayed:

11. While forming routes, the service will distribute the goods among milk trucks, taking into account the types of goods at points, the number and load capacity of sections of vehicles, as well as patterns of filling sections. 

In the above example, routes were calculated with the distribution of goods into sections based on the basic settings of the service. But to solve practical problems, the presented new functionality is successfully combined with all the other features of ANT-Logistics: profitability calculation, creation of geo-zones, etc.
 
It should also be noted that the settings specified in the example are performed once, and the routine process of importing applications is significantly accelerated after integration with the user’s accounting system.
 
If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.

Integration between ANT-Logistics and other services using ApiX-Drive

Integration with the connector service ApiX-Drive allows you to create applications in ANT-Logistics using data from other systems. For example, you can transfer requests from your CRM, website, landing page or Google Sheets to ANT-Logistics. It efficiently and easily automates work processes and saves a lot of time.

ApiX-Drive is easy and intuitive to use. And the main feature of the service is that integration settings can be performed independently without programmers. To get to know the service, all new users are given free trial access for 14 days. A special bonus — our partner offers a 10% discount on the first payment using the blackfriday promo code «blackfriday» (offer valid until November 31, 2022).

In this article, we will look at exactly how to set up the integration with ANT-Logistics using ApiX-Drive.

In the ANT-Logistics service, select the menu Service — Settings – Accounting. In the field Type of SP code mapping set the value «text».

Next, we perform the integration settings on the ApiX-Drive website.

We configure the Data Source in ApiX-Drive. Data source is the system from which you want to collect data and transfer information to ANT-Logistics (CRM, website, Google Sheets, etc.). The settings are made in the section Connection. Please  use ApiX-Drive service help. In our case, for example, we used the CRM service SalesDrive as a Data source.

Then we configure the Data Destination. We choose ANT-Logistics. Click the Continue button.

Indicate what action will be performedSelect Import DEX. Click Continue:

Fill in the fields:

  • User — login for entering the ANT-Logistics web service.
  • Password — password for entering the ANT-Logistics web service.

Information will appear that the account has been successfully connected. Click Continue:

Attention! If an inscription appears that the account is configured with an error, check the correctness of the login and password on the ANT-Logistics service.

Then edit settings. We assign the necessary variables from the Data Source to the fields in ANT-Logistics.

Important fields to fill in:

  • The date of the general list of orders – a field with the date of application delivery is assigned;
  • Internal string code of point — the field uniquely identifies the point of sale. If such a code is already in the service, then the order is added to the existing point, if there is no code, a new point is created;
  • Delivery point name – a field is assigned with the name of the delivery point or the client’s name;
  • Address (or Latitude and Longitude) – delivery address (or coordinates of the delivery point);
  • Application number — the field uniquely identifies the application.

Select the necessary values in the field Should orders coordinates (latitude and longitude) be updated or not, if they are imported from the accounting system:

  • Yes – the coordinates will change when loading orders to points that are already in the ANT-Logistics database;
  • No – the coordinates do not change when loading orders to points that are already in the ANT-Logistics database.

To fill in the fields, you can use not only variables from the Data Source, but also System data and manually written data.

The format for filling in fields in ANT-Logistics can be found in the API. Since the format of the fields in the Data Source does not always correspond to the required format of the fields of the Data Destination (ANT-Logistics), you can use the Data formatting in ApiX-Drive. Data formatting easily modifies the data transmitted from the Date source. Mathematical operations functionality is used to perform mathematical operations on the Data source and then transfer these modified data to the Data Destination.

After specifying the necessary fields, click Continue.

Test data will appear on the screen. To upload data to ANT-Logistics, click Send test data to ANT-Logistics. A test application will appear in the ANT-Logistics service on the selected date. If the settings suit us, click Next. If you need to change the settings, click Edit:

Next, we can enable auto update of data. To set up auto update, press the gear and specify the update interval.

To manually unload orders, go to the Connection 1 and click the Manual start 2:

Example of unloaded orders:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave an application on the ANT-Logistics website.

Route correction. Сhange the order of detour of delivery points

Consider the situation: the route is ready, but you need to first deliver an important order to two stores that are somewhere in the middle of this route.

For this you need:

  • select these two objects,
  • set the order of their visit,
  • fix these stores
  • create a new route.

 For example, first you need to visit TPT 9 and TPT 1, and only after that the rest of the points. To do this, select TPT 9 1, click Move Record 2, and click on the line to which you want to move store (for example, line 2). In the same way, we will move TPT 1 to the third line:

As you can see, stores TPT 9 and TPT 1 have moved to 2nd and 3rd line:

Then, in order for the program to correctly optimize the new route, these points need to be fixed. To do this, you need to select one of the moved points (in this example TPT 9), click on the button in the form of a lock and select Capture the point 3:

This point (as well as all other points that are above the fixed one) will be fixed (highlighted in gray). Now feel free to click «optimize the route». The program will calculate a new optimal route maintaining the order of detour of the fixed delivery points:

If you are interested in the described functionality, we are ready to demonstrate its operation, perform the necessary settings and provide access to the service. To do this, leave a request on the ANT-Logistics website.