Price Codes
Overview:
For a broader overview of pricing in Workbench, see Price Code & Input Billing Overview.
Price Codes are used to determine Retail rates (or sell rates) for the purposes of Input Based Selling. Every Job or Quote must have a Price Code attached to it, and you can have several Price Codes to choose from.
Screen Guide:
Initial List:
All existing price codes (minus Inactive ones due to the filter) are displayed here. You can click the Price Code field to open up the detailed popup window and edit existing codes, or click + New Price Code to create a new one.
Create/Edit Price Code:
The Details tab is shown first with various informational fields.
Copy From Price Code allows you to select an existing Price Code to copy from. Search for the code and click Copy to bring the lines into this Price Code. This is useful for when you need to create a new code that is similar to an existing one.
Price Code must be unique and should be a short identifier of this Price Code.
Description is the longer description of this code.
Inactive can be ticked to make the price code inaccessible for future Jobs. Existing jobs using this code will need to be changed manually.
Details are used for optional expanded details about this code. This is useful when you have multiple similar codes and need to distinguish their purposes.
Import can be used to easily maintain large and complex Price Codes. Each tab (Plant, Labour and Material) have its own import.
The import updates existing lines and adds new ones. It does not delete any lines. The combination of these fields are used to identify that a line already exists and should be updated rather than a new line created:
Labour: Activity, Employee Class, Person, Time Code.
Materials: Activity, Item.
Plant: Price Group, Plant Code, Rate Code.
Fields that can be updated with the import are: Reference, Priority, Use Rate, Sell Rate, MU%.
When importing, either Activity code or Item code can have value but not both.
The Labour tab
The Labour tab is designed for you to specify exactly how you want your Timesheet transactions to be sold. When you sell time-based transactions you will generally want to display the basis that they are being billed on the invoice. With that in mind, you will want to choose between Activity, Employee Class, and Person with combinations of these being rare.
For more information on time pricing priorities, see Time Transaction Pricing in the Knowledge Base.
Foreign Currency Time Billing is the currency that these labour lines should be billed in.
Activity allows you to choose specific Activities to be billed at a rate or mark up.
Employee Class allows you to sell Employee Classes at a different rate to their default sell rate.
Person selects from your employees to sell their time at a specific rate, irrespective of their class or activity used.
Reference is text use for reporting purposes only.
Priority allows you to set what line takes precedence over others, choosing between High and Low. For more detail on priorities, see Time Transaction Pricing.
Time Code is the Time Code that will trigger the Sell Rate or MU%.
Use Rate when ticked enables the Sell Rate field to be used. If it is unticked, MU% will be used.
Sell Rate is the rate that this line will be sold at per hour of time entered.
MU% is the percentage (entered as a decimal, e.g. 0.1 for 10%) increase to the Cost rate of the transaction. For example, if the cost rate of the entry is $100, and the MU% is 10%, the resulting sell rate is $110.
Material tab
Activity allows you to choose specific Activities to be billed at a rate or mark up. Only activity types Purchase, Stock, Disbursement and Subcontract are allowed here. In the case that the Plant module is not being used, the occasional hire of a Plant Item's Sell rate could be recorded on a job by using a Disbursement activity.
Item lets you choose from Catalogues' item lists to override the sell rate or markup for each item. Note that you can only select Activity or Item per line.
Use Rate when ticked enables the Sell Rate field to be used. If it is unticked, MU% will be used.
Sell Rate is the rate that this line will be sold at per hour of time entered.
MU% is the percentage (entered as a decimal, e.g. 0.1 for 10%) increase to the Cost rate of the transaction. For example, if the cost rate of the entry is $100, and the MU% is 10%, the resulting sell rate is $110.
Price Group looks at the Plant Groups with a Type of Plant Price Group. This is different from a normal Plant Group. Entering rates for a line with this field will apply to all plant items attached to the price group.
Plant Code allows you to pick from all existing Plant Items to specifically price each item you will be selling.
Rate Code is a mandatory field as each Plant item can have multiple Plant Rate Codes. This is useful for differentiating between hourly/daily hire or dry/wet hire.
Use Rate when ticked enables the Sell Rate field to be used. If it is unticked, MU% will be used.
Sell Rate is the rate that this line will be sold at per hour of time entered.
MU% is the percentage (entered as a decimal, e.g. 0.1 for 10%) increase to the Cost rate of the transaction. For example, if the cost rate of the entry is $100, and the MU% is 10%, the resulting sell rate is $110.
Next Steps:
If you are creating a new Price Code, simply Save Price Code and then apply the code to the desired Jobs in Job Maintenance.
If you are editing an existing Price Code, the change will apply to any transactions that are made after the price code is saved. If you need to reprice transactions that were entered before the change, the System Administrator can use the wbRepriceTransactions utility from Utilities.