Set Default Cost Recalculation Method

There are two ways to set the default cost recalculation method:

1. In Administration → Defaults, go to Supplier Invoicing section where you can set the default option to be displayed when you add a supplier invoice from Ascora web or the default cost recalculation method when you are importing a CSV or PDF supplier invoice document.

2. When you are adding a supplier invoice, you have the option to select the default recalculation method by clicking on each default cost recalculation method option.

How Cost Recalculation Methods Works

Each recalculation method tries to calculate Unit Sell Price or Markup on Job Supply items.

1. Maintain Markup

    Maintain Markup will try to use current Job Supply Markup and Supplier Invoice Unit Cost to calculate Job Supply Unit Sell Price following those scenarios:

• Job Supply Unit Sell Price will be calculated using the following formula:

          Job Supply Unit Sell Price = Supplier Invoice Unit Cost * (1+ Job Supply Markup / 100)

• If Job Supply Markup is empty, Job Supply Unit Sell Price will be calculated as:

          Job Supply Unit Sell Price = Supplier Invoice Unit Cost

• If Job Supply does not exist but the Supplier Invoice Item exists on the Supply list, Job

          Supply Unit Sell Price will be calculated using the following formula:

          Job Supply Unit Sell Price = Supplier Invoice Unit Cost * (1+ Supply Markup / 100)

• If Supply Markup is empty:

          Job Supply Unit Sell Price = Supplier Invoice Unit Cost

2. Maintain Job Sell Price

Maintain Job Sell Price will try to use Job Supply Unit Sell Price and Supplier Invoice Unit Cost to calculate Job Supply Markup following those scenarios:

• Job Supply Markup will be calculated using the following formula:

          Job Supply Markup = 100 * (Job Supply Unit Sell Price / Supplier Invoice Cost - 1)

• If the Job Supply does not exist but the Supplier Invoice Item exists on the Supply list, Job Supply Markup will be calculated as:    

          Job Supply Markup = 100 * (Supply Unit Sell Price / Supplier Invoice Cost - 1)

3. Use Highest

Use Highest means Ascora will calculate Job Supply depending if:

       a. If Job Supply Unit Cost is less than Supplier Invoice Unit Cost, calculate Job Supply Unit Sell Price using “Maintain Markup” option.

       b. If Job Supply Unit Cost is more than Supplier Invoice Unit Cost, calculate Job Supply Markup using “Maintain Job Sell Price”

       c. If there are not a Job Supply, but the Supplier Invoice Item exist on the Supply list, calculate Job Supply item using Supply item and then depending of options a. or b.