Price Table

The Price Table function is based on a 24 Hour day unit, and recalculates the day rate based on the number of days, i.e. the Qty/Units column in the Invoice screen. The price for the day rate is calculated using a Multiplier that you set for various day ranges. Setting the Calculation Type column, forces the Multiplier to adjust the day rate prices based on either the Unit Price or the Line Total. Some examples are given in the Calculation Type section further down in this article.

Create a new Price Table selling unit

  1. From the main menu strip at the top, go to Setup > Item Related > Selling Units.
  2. Click the New Selling Unit at the top.
  3. Enter a Unit Description, for example; DayRate
  4. Enter 24 in the Time Span field.
  5. Select Hour from the Interval dropdown.
  6. Click the Save New button towards the bottom.
    You will be redirected back to the Selling Units List screen.
  7. Click the new DayRate unit in the list to edit.
  8. From the Options button dropdown at the top right, click Use Price Table.
  9. In the Item Price Table screen, the Selling Unit will be auto-populated.
    Enter numeric values in the Day From and Day To fields, along with a relevant Multiplier.
  10. Select the Calculation Type as either Unit Price or Line Total (more about this in the Calculation Type section below).
  11. Click the + Add New Line link at the bottom left of the table to add a new row as required.
  12. Click the Save Changes button at the bottom right once you have completed setting up the price table.

Calculation Type

The Calculation Type column in the Price Table can be set to Unit Price or Line Total, which determines how the Multiplier column affects the DayRate price on the Sales record. This is explained using the simple examples below.

Unit Price

Day From

Day To

Multiplier

Calculation Type

1

3

1

Unit Price

4

5

.8

Unit Price

Invoice Autocalc Results (Unit Price)

As shown below, the base price is $100 per day, so days 1 to 3 will stay at $100 per day, and days 4 to 5 will calculate at 0.8 X $100, i.e. $80 per day.

Unit

Qty/Units (Days)

Each

Total

DayRate

1

100.00

100.00

DayRate

2

100.00

200.00

DayRate

3

100.00

300.00

DayRate

4

80.00

320.00

DayRate

5

80.00

400.00

Line Total

Day From

Day To

Multiplier

Calculation Type

1

3

1

Line Total

4

5

.8

Line Total

Invoice Autocalc Results (Line Total)

In the same example, the base price is $100 per day. Using the Line Total calculation type, days 1 to 3 will adjust the Each (per day) price so that the Total remains at $100. Days 4 to 5 will adjust the Each (per day) price so that the Total calculates at 0.8 X $100 Total, i.e. $80 Total.

Unit

Qty/Units (Days)

Each

Total

DayRate

1

100.00

100.00

DayRate

2

50.00

100.00

DayRate

3

33.3333

100.00

DayRate

4

20.00

80.00

DayRate

5

16.00

80.00

Auto calculating prices on a sales record

Adding an item to the sales record

When you add an item to a sales record, and that item has a day rate selling unit with a price table, the price will be auto calculated as normal. It's always best to work through the sales record from top to bottom, so that the booking dates are entered before you get to the line items. When you add the line items, the Each and Total columns will be calculated accurately.

Auto calculate after changing the Booked/Hired dates

See The AutoCalc Popup doc for details on recalculating a sales record when Booked/Hired dates are altered.


Did this help?


Powered by HelpDocs (opens in a new tab)