Price Codes

(A new wiki page is under construction, click here to see if it's available.)

This module looks at the use of Price Codes within Workbench.

OVERVIEW:

One of the Billing options within Workbench is Input Based billing. This allows the sale of transactions on what is typically called a Time and Materials basis.
Every Cost transaction within Workbench is allocated a Retail Value at time of original Data Entry.

The Retail Value calculated follows a priority of possible Retail Values for that type of transaction governed by a set of pricing rules contained within the Price Code attached to the Job.

This Retail value once calculated is used specifically for Input Based Costing of jobs, where the transactions are billed at a Retail Rate. In this billing process, the Retail Rate defaults as the recommended Selling Rate, but can be changed.

On Job Transactions we hold 3 retail values: (Note that every cost transaction within Workbench is held in this JobTransaction table)

  • Standard Retail: this is the Retail Rate that applies before the application of any Price Code rules. This is held on the tables, but is not displayed on screen. (This is available for reporting purposes only).
  • Retail: this is the Retail Rate after the application of the Price Code rules. This is the value displayed when the 'Retail' selection is ticked on the Job Enquiry Transactions selection screen. This is the default value utilised in 'Get Sales' when Invoicing Jobs with a Billing Type of Input Based.
  • Selling: this is the actual Rate that the transaction was sold for. This defaults to the Retail Rate, but can be changed. The value is 0.00 until the transaction has been invoiced. This is the value displayed when the 'Selling' selection is ticked on the Job Enquiry Transactions selection screen

There are rules and priorities as to where this 'Retail' value comes from at the time of data entry.

These 'Pricing Rules' also apply:

  • Where the Repricing utility is run against Jobs.
  • When the Quote is being entered or the Repricing of a Quote is initiated.

Note that the Retail price on transactions is generally calculated on exit from the data entry subform.

Another point worth noting in the overview is that Job Adjustments do NOT go through a Pricing regime as the Retail Value is specified in the data Entry screen. It is manually entered, not calculated.