Consignment Pricing Issue
Consignment Pricing Issue
There are many reasons that a consignment may have pricing issues, the most common examples being suburbs not in a zone, the rate card not having a price for the respective consignment route and the consignment details not matching or finding an applicable rate from the relevant rate card.
Let's run through some examples.
Let's run through some examples.
Unknown Zones Issue
In the finance tab of a consignment, you may come across the below error in the rating notes, indicating why the consignment does not yet have a price.
This issue occurs when the suburbs are not enabled for the selected zones.
2. As you can see, there is no customer auto price, and the reason is due to a zone issue.
3. When this error occurs, check that the sending and receiving suburbs are both in zones in the zone list being used by the rate card. To see the rate card details, on finance tab of the consignment do this, enter the current rate schedule by clicking the Rating Notes hyperlink as shown below.
3. Once you click on Rating Notes hyperlink, this will take you into the rate card being used, from here, click on the edit/add zone lists button to go to the zone list being used for the rate card as shown below.
4. Now, you will then arrive at the zone list being used.
If you are not sure about zone(s), then go to consignment detail tab and check the sender and Receiver Information. For the example consignment being used here, the sending suburb is Zetland NSW and the receiving suburb is Melbourne VIC as shown below.
5. Now, check if these suburbs are in zones, simply click on any zone from the list on the left, then click rules by suburb and search for the suburb as shown below.
Sender Suburb
Receiver Suburb
6. As you can see, both suburbs (the sender and receiver) are not in zones being used by the zone list. This means that the system cannot determine where they belong and as a result there is error in the pricing.
7. To resolve the issue, add both suburbs into the appropriate zones in this zone list. Once you do this, wait about 5-10 minutes for the system to update and go back to finance tab for the consignment and click on the reprice button.
8. Once you assign the suburb to the specified zone, your consignment will now have a price and will not display any rating errors as shown below.
8. Once you assign the suburb to the specified zone, your consignment will now have a price and will not display any rating errors as shown below.
No Route in Rate Card causing an Unknown Zones Issue
There is a chance that doing the above from example 1 may not resolve the pricing issue. The reason for this is that the Unknown Zones issue can also refer to the fact that the relevant route is not setup in the rate card.
For example, the above consignment used in example 1 is going from Test 01 to Melbourne as per the zone list being used by the rate card.
1. If you get an Unknown Zone issue it could be due to the fact that the rate card does not have a Test 01 to Melbourne route setup as shown below.
For example, the above consignment used in example 1 is going from Test 01 to Melbourne as per the zone list being used by the rate card.
1. If you get an Unknown Zone issue it could be due to the fact that the rate card does not have a Test 01 to Melbourne route setup as shown below.
2. To see the route, click on Rating Notes hyperlink, you will be redirected to the rate card detail page, and check the step 3 i.e., Route as shown below.
3. You can see in the above that there is a Test 01 to Melbourne route and price. The error of unknown zones would still have been there despite us adding the suburbs to the relevant zones in the zone list.
If a consignment is going from test 01 to Melbourne, you need a test 01 to Melbourne route in the rate card for the relevant service level/freight item!
Handy Tip! If you do not care about the sending location of a consignment or want everything to price as if it were being sent from a single location, you can set a route to be a default in the rate card.
Setting a route as a default, simply means that if the sending suburb of a consignment is not in a zone, use the default zone in the rate card to attempt to price the consignment.
This can help with reducing the number of Unknown Zones issues you encounter, but please ensure this suits you and your business.
This can help with reducing the number of Unknown Zones issues you encounter, but please ensure this suits you and your business.
4. Ensure that all relevant routes are setup in the rate card, then reprice the consignments affected, allowing 5-10 minutes for the system to update. The consignment should now price assuming no other issues are present.
Freight Item Mismatch or Incomplete Rate
Another reason why a consignment may not price correctly could be due to the freight item description on the consignment not matching to the freight items setup in the corresponding rate cards.
This example could also be similar for Service levels; however, this will focus on freight items.
For example:
1. In the above screenshot, you can see that there is an error of Incomplete Rate.
2. Looking at the Consignment Items description section, you can see that this consignment is for Hourly.
Descriptions are linked to freight items in rate cards and there must be a match for the system to find a price!
3. The error seen here suggests that there is a zone match but there is no available price to be found from the rate card; a reason for this could be that there is no hourly freight item present in the rate card.
4. Now, click on the Rating Notes hyperlink, you will be taken to the rate schedule and can see the rate card as shown below.
5. In the above screenshot, as you can see that there is a service level of General, a freight items for Pallet. Oversized pallet, Full Load and Carton, ex zone Brisbane and prices linked to this service level and freight item.
However, there is no freight item of Hourly. As a result of this, the system cannot price the consignment because it is expecting a price for an hourly freight item present in the rate card, but this does not exist.
6. Now, there are three possible ways where you can fix this problem as describe below:
A) The first and easiest solution is to set any of the freight item as the default freight item within the rate card.
1. To make any freight item as default, first click on the drop and down button and then enable the Default Freight toggle and finally click on Update button.
Doing this means that it does not matter what is entered as the item description on a consignment because the system will use the Pallet freight item prices to price every consignment.
B) If the first solution is not a viable option, you could create another freight item called Hours and add in prices for this freight item to the rate card.
1. Click here for further help on rate card setup.
2. Click here for further help on freight item setup.
3. Setting up a Carton freight item means that this example consignment would now price.
C) Another option that may come in handy to resolve an Incomplete Rate error, would be to add in AKAs for a freight item (see section on AKA).
Doing this means that whatever AKA you add in, this will link through to a freight item.
An example of where this could be used would be if you had a freight item of Pallet and had consignments where the item description was Loscam or Chep.
Adding an AKA of Loscam or Chep to the Pallet freight item means that the consignment would price as if it was a Pallet - which is what you are after in this scenario.
Extra Information - Other errors or Issues
This article so far has only listed the most common errors that you may encounter but there are various other reasons that a consignment may not price, again, most are due to configuration issues with rate cards, shadow rate cards or zone lists etc.
1. These can include issues with Step 2 Overrides, shadow rate card configuration issues, rate card schedule date (needs to cover the date of the consignment), etc.
2. Refer below paragraph is a basic checklist to ensure pricing errors are kept to a minimum.
2. Refer below paragraph is a basic checklist to ensure pricing errors are kept to a minimum.
- Ensure that the rate card or rate schedule effective dates are correct. If a consignment does not price it may be due to the consignment date falling outside of the rate card schedule effective dates. Click here for further information on this.
- Ensure that the sending and receiving suburbs of a consignment are in zones in the zone list being used by the rate card.
- Ensure that the route the consignment is taking is setup as an option in the rate card. Without the appropriate route you may encounter an Unknown Zones error because the system is expecting a price from one location to another, but it can't find it in the rate card.
- Ensure that the rate card being used has an applicable service level and freight item. An error of Incomplete Rate typically means that system has found the right route in the rate card, but there is an issue obtaining a price; this could be due to a mismatch in freight items or service levels (your consignment might have a service level of Express, but the rate card only has rates for a general service level). In this event, you need to ensure that there are applicable freight items and service levels in your rate card to match to consignments for pricing.
- If using shadow rates and a consignment price using a shadow (backup) rate card rather than the detailed rates implemented, it may be that the detailed rates do not have an applicable rate setup and the shadow rate is a better match to the consignment, hence the system will use the shadow rate card. Ensure that all applicable rates are setup in both the detailed and shadow rate cards. Click here for further information on shadow rates.
- If using freight item overrides in Step 2 of a rate card, ensure the logic is correct and that the override chain or flow is correct and as expected. If an override takes you to another freight item incorrectly, there may not be any applicable rates setup in the new freight item, meaning the system will not be able to price your consignment. Click here for further information on freight item overrides. This article here may assist if you need help with rate card Data Filter Terms.
3. The below chart may help to illustrate the process that TransVirtual goes through to find a price from a rate card.
4. In the above screenshot, the green boxes are how the system calculates a price for an Express type of consignment containing 4 cartons going from Melbourne VIC 3000 to Brisbane QLD 4000. The process to find a price is systematic as describe below.
a. Does the consignment customer have an assigned rate card; if yes, use that rate card.
b. From there, does the consignment service level exist in the rate card, if yes, use that.
c. Does the freight item description listed on the consignment match a freight item in the rate card, if so, use that and obtain the relevant price for the route the consignment is taking.
c. Does the freight item description listed on the consignment match a freight item in the rate card, if so, use that and obtain the relevant price for the route the consignment is taking.
d. Keep in mind that defaults can be set that ensure the consignments will always have a service level, freight item or route.
e. If the system can't find any of these values, you will likely get a pricing error.
e. If the system can't find any of these values, you will likely get a pricing error.
Related Articles
Standard Consignment Process
This article will detail the standard process used from the point of consignment creation, up until consignment completion. If you are new to Transvirtual this article may help provide you with a better understanding of the best way to run your ...Consignment Details
Consignment Details Consignment details tab helps to see/edit the basic details related to the consignment. 1. To see the consignment details tab, on TransVirtual web portal, go to Transport > Consignment, the consignment page will open as shown ...Consignment Creation
How to Create Consignments Refer the below steps to create a consignment(s). To create a consignment, on Transvirtual web portal, go to Transport > Operational Tasks > Consignment, consignment filter page will display. On consignment filter page, ...Consignment Export
Consignment Export In TransVirtual there is the ability to setup Consignment EDI (Electronic Data Interchange) Exports which are essentially a method of exporting data out from TransVirtual to another location via email, FTP etc. 1. This article will ...Consignment Import
In Transvirtual there is the ability to create EDI (Electronic Data Interchange) Import rules that allow you to create consignments without the need to use the consignment creation page in the Transvirtual Web Portal. This is especially handy for ...