Difference between revisions of "How do I Create a Rate Table?"

From Catalyst
Jump to: navigation, search
(Bulk update)
 
Line 3: Line 3:
  
 
== More Information ==
 
== More Information ==
 +
A rate table will allow you to select the rate to apply to a job; either manually or based on key information.
 +
 
Go to {{Menu|{{TI}}|Maintenance Options|Rate Table Amendments}}.
 
Go to {{Menu|{{TI}}|Maintenance Options|Rate Table Amendments}}.
  
 
* In the {{DataPrompt|Table}} field, enter in a code for the new table and then press {{KeyPress|S-F10}} to enable you to add a description to the code.
 
* In the {{DataPrompt|Table}} field, enter in a code for the new table and then press {{KeyPress|S-F10}} to enable you to add a description to the code.
  
−
=== Automation ===
+
=== Settings ===
−
If you wish to automate this rate table follow the steps below:
+
If you wish to enable automation for this rate table follow the steps below else skip to [[How do I Create a Rate Table?#Line and Column Details|Line and Column Details]]:
  
 
* Select the {{Tab|Settings}} tab.
 
* Select the {{Tab|Settings}} tab.
  
−
If automated, the table may itself select the appropriate line or column used dependent on information entered. This selection to line or column may be linked to any of three aspects of a logistics job (area, text or quantity) or to carriage charges for quantity only in stock control.
+
Automation allows the table to detect the line and column from which to take the Rate/Total value to apply to the job. As soon as the relevant details are entered within the job, the automation will be applied and the job rate or total populated.  
 +
 
 +
The three aspects available for use are :
 +
* {{DataValue|Area}} - read an Area Code entered on the {{Tab|Load}} tab of a job.
 +
* {{DataValue|Text}} - read key words entered within a specific Text Box on a job.
 +
* {{DataValue|Quantity}} - read the Quantity field on a job.
  
−
* Select the appropriate drop down box in {{DataPrompt|Line}} and {{DataPrompt|Column}}.
+
Once you have decided how to create your table :
−
* Select the appropriate block and line for the text in the drop down boxes.
+
* Select the appropriate drop down box for {{DataPrompt|Line automation by}} and {{DataPrompt|Column automation by}}.
−
* Specify how you want to search for matches between the text block on the job and the search words on the rate table.
+
** If you select {{DataValue|Area}} or {{DataValue|Quantity}} there are no further options.
 +
** If you select {{DataValue|Text}} you then need to specify which {{DataValue|Block}} to read, i.e. which of the three text blocks on the right of the job screen, and if you wish to read {{DataValue|All}} lines in the block or a specific line, e.g. {{DataValue|Line 1}}.
 +
*** Specify how you want to search for matches between the text block on the job and the search words on the rate table.
 
** {{DataPrompt|Alphabetically}} will search through the rate table in alphabetical order until it finds the first match for your text.
 
** {{DataPrompt|Alphabetically}} will search through the rate table in alphabetical order until it finds the first match for your text.
 
** {{DataPrompt|Sequentially}} will search through the rate table for an exact match between the defined search words and the first word of the text block line. If you choose to use {{DataValue|All}} of the text block, this mode will look for a match on line 1 first, then line 2 and so on. This mode is useful when using numbers in your search text.
 
** {{DataPrompt|Sequentially}} will search through the rate table for an exact match between the defined search words and the first word of the text block line. If you choose to use {{DataValue|All}} of the text block, this mode will look for a match on line 1 first, then line 2 and so on. This mode is useful when using numbers in your search text.
 
** {{DataPrompt|For Postcode}} will look at the end of the text block or text lines and look for the best match in the search words.
 
** {{DataPrompt|For Postcode}} will look at the end of the text block or text lines and look for the best match in the search words.
  
−
* Press {{KeyPress|ESC}} and {{KeyPress|Accept}}.
+
{{Example|text=A table set to aLine automation by All Lines within Text Block 3 and to Column automation by Quantity would do the following.
 +
 
 +
When creating a job; Enter a City to deliver to into Text Block 3 and apply a Quantity of 10 to the job.
 +
 
 +
The system would apply this information to the Rate Table and locate the Line containing the City and read across to the Column linked to that Quantity.
 +
 
 +
It would then take the value entered for that intersect and apply that to the Rate or Total on the job.
 +
 
 +
The above is dependent on the details entered when creating the Lines and Columns.}}
 +
 
 +
 
 +
* Press {{KeyPress|Esc}} and {{KeyPress|Accept}}.
 +
 
 +
{{Warning|text=If you intend to use automation then you must complete the above steps before moving onto the next section to ensure the correct fields are enabled.}}
 +
 
  
 
=== Line and Column Details ===
 
=== Line and Column Details ===
Line 29: Line 52:
 
In the {{DataPrompt|Line Descriptions}} box that pops up, enter the required information:
 
In the {{DataPrompt|Line Descriptions}} box that pops up, enter the required information:
  
−
* {{DataPrompt|Brief Description}} : Enter a brief line description e.g. LEI
+
* At {{DataPrompt|Brief Desc}} enter a brief line description which will appear to the left of the line in the table, e.g. LEI.
−
* {{DataPrompt|Detailed Description}} : Enter a more detailed line description e.g. LEICESTER.
+
* {{DataPrompt|Detailed Desc}} : Enter a more detailed line description, e.g. LEICESTER. This will be displayed at the top of your screen when viewing the Rate Table.
−
 
+
If you are using automation for lines, enter the required information for the prompt shown (the prompt you see will depend on the settings you have chosen to use):
−
If you are using automation for lines, enter the required information for the prompt shown:
+
** {{DataPrompt|Upper Limit}} - Enter the upper value for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
−
** {{DataPrompt|Upper Limit}} : Enter the upper amount for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
+
** {{DataPrompt|Area}} - Enter the area code for this line.
−
** {{DataPrompt|Area}} : Enter the area code for this line.
+
*** Press {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through existing Area codes or press {{KeyPress|S-F10}} to create a new area code e.g. LE6.
−
*** Press {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through Area codes or press {{KeyPress|S-F1}} to create a new area code.
+
** {{DataPrompt|Search Words}} - Enter search text to allow the system to identify this line from text entered onto a job e.g. DERBY.
−
** {{DataPrompt|Search Words}} : Enter search text to allow the system to identify this line from text entered onto a job.
+
* {{DataPrompt|Value Type}} - Each cell in the rate table contains a value. This setting determines which of the two Job fields are to be populated: {{DataPrompt|Rate}} or {{DataPrompt|Total}}. You may enter either {{DataValue|R}} or {{DataValue|T}} here as appropriate.
−
* {{DataPrompt|Value Type}} : Each cell in the rate table contains a value. This value may either represent the rate for the job or the total price of the job. You may enter either {{DataValue|R}} or {{DataValue|T}} here as appropriate for your needs.
+
* When finished, press {{KeyPress|Esc}}.
−
* When finished, press {{KeyPress|ESC}}.
 
  
 
==== Column Details ====
 
==== Column Details ====
Line 45: Line 67:
 
In the {{DataPrompt|Column Descriptions}} box that pops up, enter the required information:
 
In the {{DataPrompt|Column Descriptions}} box that pops up, enter the required information:
  
−
* {{DataPrompt|Brief Description}} : Enter a brief column description e.g. MAN
+
* At {{DataPrompt|Brief Desc}} enter a brief column description which will appear above the column in the table, e.g. MAN.
−
* {{DataPrompt|Detailed Description}} : Enter a more detailed description e.g. MANCHESTER
+
* {{DataPrompt|Detailed Desc}} : Enter a more detailed column description, e.g. MANCHESTER. This will be displayed at the top of your screen when viewing the Rate Table.
 +
 
 +
If you are using automation for columns, enter the required information for the prompt shown (the prompt you see will depend on the settings you have chosen to use):
 +
** {{DataPrompt|Upper Limit}} - Enter the upper value for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
 +
** {{DataPrompt|Area}} - Enter the area code for this column.
 +
*** Press {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through existing Area codes or press {{KeyPress|S-F10}} to create a new area code e.g. LE6.
 +
** {{DataPrompt|Search Words}} - Enter search text to allow the system to identify this column from text entered onto a job e.g. DERBY.
 +
* {{DataPrompt|Value Type}} - Each cell in the rate table contains a value. This setting determines which of the two Job fields are to be populated: {{DataPrompt|Rate}} or {{DataPrompt|Total}}. You may enter either {{DataValue|R}} or {{DataValue|T}} here as appropriate.
 +
* When finished, press {{KeyPress|Esc}}.
  
−
If you are using automation for lines, enter the required information for the prompt shown:
+
Once you have finished amending the Line and Column details, press {{KeyPress|Esc}} and {{KeyPress|Accept}} to save the table.
−
** {{DataPrompt|Upper Limit}} : Enter the upper amount for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
 
−
** {{DataPrompt|Area}} : Enter the area code for this column.
 
−
*** Press {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through Area codes or press {{KeyPress|S-F1}} to create a new area code.
 
−
** {{DataPrompt|Search Words}} : Enter search text to allow the system to identify this column from text entered onto a job.
 
−
* {{DataPrompt|Value Type}} : Each cell in the rate table contains a value. This value may either represent the rate for the job or the total price of the job. You may enter either {{DataValue|R}} or {{DataValue|T}} here as appropriate for your needs.
 
−
* When finished, press {{KeyPress|ESC}}.
 
  
−
Once you have finished amending the Line and Column details, press {{KeyPress|ESC}} and {{KeyPress|Accept}} to save the table.
+
See [[How do I Use Rate Tables in Logistics Planning?]] for the next steps.  
  
 
== Copying an Existing Table ==
 
== Copying an Existing Table ==
Line 66: Line 90:
 
* If required, enter the automation details as per the instructions above.
 
* If required, enter the automation details as per the instructions above.
 
* Click {{Button|Done}} and {{Button|Accept}}.
 
* Click {{Button|Done}} and {{Button|Accept}}.
−
* Press {{KeyPress|ENTER}} then press {{KeyPress|F8}}.
+
* Press {{KeyPress|Enter}} to move onto the first field within the table and press {{KeyPress|F8}}.
−
* Enter the code for the table you wish to copy. {{KeyPress|F1}}/{{KeyPress|S-F1}} will scroll through your current tables.
+
* Enter the code for the table you wish to copy.  
−
* Press {{KeyPress|ENTER}} to copy the table.
+
** {{KeyPress|F1}}/{{KeyPress|S-F1}} will scroll through your current tables.
−
* Edit the new table as required then press {{KeyPress|ESC}} and {{Button|Done}}.
+
* Press {{KeyPress|Enter}} to copy the table.
 +
* Edit the new table as required then press {{KeyPress|Esc}} and {{Button|Done}}.
 +
 
 +
== Updating a Rate Table ==
 +
If you wish to update prices within a table you may use the option to Inflate or Deflate prices by a percentage. Alternatively you may manually overtype prices.
 +
 
 +
{{Warning|text=This option cannot be reversed so please ensure you follow the steps carefully. If unsure please use the option to copy your table prior to amending it to provide you with values to refer back to.}}
 +
 
 +
* To update by a percentage go to {{Menu|{{TI}}|Maintenance Options|Rate Table Amendments}}.
 +
* Find your table by entering the code or using {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through your current tables.
 +
* Press {{KeyPress|Enter}} to move onto the table.
 +
* Press {{KeyPress|F7}}
 +
* Enter your percentage to increase by or enter the minus sign to decrease.
 +
* Press {{KeyPress|F2}} to apply the change to the entire rate table.
 +
* Press {{KeyPress|Esc}} and {{Button|Done}}.
 +
 
  
 
== See also ==
 
== See also ==

Latest revision as of 12:38, 6 January 2023

Summary

The following article explains how to create a rate table in Logistics Management.

More Information

A rate table will allow you to select the rate to apply to a job; either manually or based on key information.

Go to " Logistics Management Maintenance Options Rate Table Amendments".

  • In the "Table" field, enter in a code for the new table and then press <Shift+F10> to enable you to add a description to the code.

Settings

If you wish to enable automation for this rate table follow the steps below else skip to Line and Column Details:

  • Select the [Settings] tab.

Automation allows the table to detect the line and column from which to take the Rate/Total value to apply to the job. As soon as the relevant details are entered within the job, the automation will be applied and the job rate or total populated.

The three aspects available for use are :

  • 'Area' - read an Area Code entered on the [Load] tab of a job.
  • 'Text' - read key words entered within a specific Text Box on a job.
  • 'Quantity' - read the Quantity field on a job.

Once you have decided how to create your table :

  • Select the appropriate drop down box for "Line automation by" and "Column automation by".
    • If you select 'Area' or 'Quantity' there are no further options.
    • If you select 'Text' you then need to specify which 'Block' to read, i.e. which of the three text blocks on the right of the job screen, and if you wish to read 'All' lines in the block or a specific line, e.g. 'Line 1'.
      • Specify how you want to search for matches between the text block on the job and the search words on the rate table.
    • "Alphabetically" will search through the rate table in alphabetical order until it finds the first match for your text.
    • "Sequentially" will search through the rate table for an exact match between the defined search words and the first word of the text block line. If you choose to use 'All' of the text block, this mode will look for a match on line 1 first, then line 2 and so on. This mode is useful when using numbers in your search text.
    • "For Postcode" will look at the end of the text block or text lines and look for the best match in the search words.
A table set to aLine automation by All Lines within Text Block 3 and to Column automation by Quantity would do the following.

When creating a job; Enter a City to deliver to into Text Block 3 and apply a Quantity of 10 to the job.

The system would apply this information to the Rate Table and locate the Line containing the City and read across to the Column linked to that Quantity.

It would then take the value entered for that intersect and apply that to the Rate or Total on the job.

The above is dependent on the details entered when creating the Lines and Columns.


  • Press <Esc> and <Accept>.
If you intend to use automation then you must complete the above steps before moving onto the next section to ensure the correct fields are enabled.


Line and Column Details

Line Details

Move to the line to amend then press <F5>.

In the "Line Descriptions" box that pops up, enter the required information:

  • At "Brief Desc" enter a brief line description which will appear to the left of the line in the table, e.g. LEI.
  • "Detailed Desc" : Enter a more detailed line description, e.g. LEICESTER. This will be displayed at the top of your screen when viewing the Rate Table.

If you are using automation for lines, enter the required information for the prompt shown (the prompt you see will depend on the settings you have chosen to use):

    • "Upper Limit" - Enter the upper value for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
    • "Area" - Enter the area code for this line.
      • Press <F1>/<Shift+F1> to scroll through existing Area codes or press <Shift+F10> to create a new area code e.g. LE6.
    • "Search Words" - Enter search text to allow the system to identify this line from text entered onto a job e.g. DERBY.
  • "Value Type" - Each cell in the rate table contains a value. This setting determines which of the two Job fields are to be populated: "Rate" or "Total". You may enter either 'R' or 'T' here as appropriate.
  • When finished, press <Esc>.

Column Details

Move to the column to amend then press <F6>.

In the "Column Descriptions" box that pops up, enter the required information:

  • At "Brief Desc" enter a brief column description which will appear above the column in the table, e.g. MAN.
  • "Detailed Desc" : Enter a more detailed column description, e.g. MANCHESTER. This will be displayed at the top of your screen when viewing the Rate Table.

If you are using automation for columns, enter the required information for the prompt shown (the prompt you see will depend on the settings you have chosen to use):

    • "Upper Limit" - Enter the upper value for this cell. This may be a quantity (e.g. Kilos for carriage charges) or a distance depending on how your business operates.
    • "Area" - Enter the area code for this column.
      • Press <F1>/<Shift+F1> to scroll through existing Area codes or press <Shift+F10> to create a new area code e.g. LE6.
    • "Search Words" - Enter search text to allow the system to identify this column from text entered onto a job e.g. DERBY.
  • "Value Type" - Each cell in the rate table contains a value. This setting determines which of the two Job fields are to be populated: "Rate" or "Total". You may enter either 'R' or 'T' here as appropriate.
  • When finished, press <Esc>.

Once you have finished amending the Line and Column details, press <Esc> and <Accept> to save the table.

See How do I Use Rate Tables in Logistics Planning? for the next steps.

Copying an Existing Table

Go to " Logistics Management Maintenance Options Rate Table Amendments".

  • In the "Table" field, enter in a code for the new table.
  • Press <Shift+F10> to enable you to add a description to the code.
  • Select the [Settings] tab.
  • If required, enter the automation details as per the instructions above.
  • Click [Done] and [Accept].
  • Press <Enter> to move onto the first field within the table and press <F8>.
  • Enter the code for the table you wish to copy.
    • <F1>/<Shift+F1> will scroll through your current tables.
  • Press <Enter> to copy the table.
  • Edit the new table as required then press <Esc> and [Done].

Updating a Rate Table

If you wish to update prices within a table you may use the option to Inflate or Deflate prices by a percentage. Alternatively you may manually overtype prices.

This option cannot be reversed so please ensure you follow the steps carefully. If unsure please use the option to copy your table prior to amending it to provide you with values to refer back to.
  • To update by a percentage go to " Logistics Management Maintenance Options Rate Table Amendments".
  • Find your table by entering the code or using <F1>/<Shift+F1> to scroll through your current tables.
  • Press <Enter> to move onto the table.
  • Press <F7>
  • Enter your percentage to increase by or enter the minus sign to decrease.
  • Press <F2> to apply the change to the entire rate table.
  • Press <Esc> and [Done].


See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
rate, table, create, job planning, price per job
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_do_I_Create_a_Rate_Table%3F&oldid=43783"