In TransVirtual it is possible to create RCTI (Agent or reverse) Invoices based on driver Runsheets.
You may, for example, have an Agent that you pay hourly. This agent may work off Runsheets and thus need to get these 'signed' off every day, so that they can be paid.
This process is based on the concept of creating a linked consignment generated from a Runsheet which is essentially a 'summary' consignment of all of the items/freight on a Runsheet.
The below will show you how to set this and get this working.
The above setting is found under Settings > General > Global Setup > Zone Directory Mapping
In step 1 of the rate card, click the hyperlink that says 'edit/add service levels'. This will take you to the screen where you will need to click to add a new Service Level. For this scenario the new service level MUST be Runsheet:
Note: Once you create a new Service Level it will be available to choose from within the rate card. However, it may take around 5-10 minutes to sync across and appear.
4. Make sure you add this new Service Level to step 1. Once you do this, you need to add a Freight Item. The freight Item MUST be 'Hours' as below:
Again, if this freight item does not yet exist, you will need to add it using the blue hyperlink 'edit/add freight items'. Same process as with Service Levels, with one added step-enabling the freight item:
Once you create the freight item it will appear in the list in orange. You simply need to click on it and toggle enable freight item to yes and then click update on the right.
5. The next step is to setup the route(s) this Agent Driver will be utilizing. Sending Headport will most likely be the location they are located, then setup any receiving headports required etc:
So, in above example, Agent Driver is located in zone 2-hence the sending zone is 2.
6. The next thing to setup is the rate in step 4. This will be setup as a quantity rate. So, whatever this Agent Driver charges per hour is what you should enter as the quantity rate value.
7. The next thing to do is setup pricing exceptions. This will be done in Settings > General > Global Setup > Consignment Related Rules > Scroll down to the bottom and toggle the below to Pricing Exceptions:
This is important as you need to tell the system when not to price consignments.
For this particular setup we need to ensure that consignments for this driver do not normally price.
How this process works is that based on the above setup, the system will automatically create a consignment linked to a Runsheet which will automatically add to the Agent Driver's current open Invoice. This linked consignment will be a summary of all the consignments on the Agent Runsheet, and as a result, we ONLY want to price the linked consignment and NOT the original consignments-so as to avoid duplicates etc.
So, what we need to add to the pricing exceptions data filter above is similar to the below:
We need to add some logic that says when the Consignment Number starts with RNXX and the Agent is blank, do not price. This is where the linked consignment does not have an agent assigned to it. We do NOT want this to price.
We also need to say if the Agent is 'x' (the agent you are setting this up for) and the customer of the consignment is not Runsheet, do not price. The reason we don't want to price for this scenario is because we only want to price the consignment linked to the Runsheet:
Note: Ensure you use the drop down selectors to add the correct logic to your pricing exceptions. Be careful and ensure that the logic is correct-keeping in mind correct usage of 'and' / 'or' etc.
8. Once all the above is setup, the Agent Driver can now be paid based on their Runsheets. The Agent Driver scans or is assigned freight as per normal. The system then starts the clock from the start of the first Runsheet they do, and stops the clock at the end of the last Runsheet they do-as this user may do/complete more than one Runsheet per day.
As long as all of the above is setup, the system will automatically calculate and apply the correct hourly rate against this Agent Driver.
Note: The time calculation is from start of first Runsheet (Runsheet creation) to end of last Runsheet (last drop on Runsheet
OR when driver clicks Return depot button within delivery page of the app):
Clicking this will prompt driver to confirm they are returning to depot:
Clicking yes will add the end time as Return Depot:
Vehicle Type
If you require, it is possible to charge differently based on vehicle type.
To do this, you would simply need add in different freight items. The format of these freight items would need to be Hours Vehicle Type; see below example:
In the above the rate for a 1 Pallet 1 Tonne vehicle is $48/hour.
If required, you could setup other freight items with varying rates. Just ensure that each freight item starts with 'Hours' and is then followed by the vehicle type; 10 Pallet 10 Tonne for example.
This then works in the same manner as the above setup.
Number of Deliveries/Pickups
Additionally information regarding the number of deliveries and pickups from the runsheets will be stored as the length and width of the associated consignment
e.g. If the driver performed 4 deliveries and 4 pickups the length will be 4 and width will be 4.
If you are displaying in cm's this will appear as below as 400 but will be treated as 4 by the rate card which uses metres.