Maintain Cost Units from Excel using Invantive Control blocks

You can also use Invantive Control to download data from Exact Online, change the data and upload them again. You can also add new rows. This article explains you how.

Attention! Make a backup of Exact Online before you start, make sure you know how to restore the backup to an acceptable environment without data loss. Even better: use a test account. These instructions can dramatically change the contents of your Exact Online companies.


In this sample, you will download cost units from Exact Online, have the option to alter them and upload the changes back to Exact Online using Invantive Control.

Change one or more Cost Units

  1. Download the sample spreadsheet Exact Online - Maintain Cost Units.xlsx
  2. Start Excel and log on to Exact Online using Invantive Control.
  3. Open the spreadsheet.
  4. Change the Exact Online company to a number from your partition chooser in the Invantive Control ribbon.
  5. Press the Sync button.
  6. The old cost units are removed and your cost units appear.
  7. Change a description.
  8. The shopping cart will change it’s format to indicate unsynchronized changes are present.
  9. Press Sync again.
  10. Check Exact Online. The description has changed.



Add new Cost Units

In a similar way, you can also add new cost units as follows:

  1. Execute the steps above up to 7.
  2. Locate your cursor in the green area.
  3. The button “Add Row” lights up.
  4. Press it.
  5. Add a new cost unit code and description.
  6. Press Sync again.
  7. Check Exact Online. The new cost unit has been added.



The logic of uploading cost units into Exact Online from an Invantive Control for Excel model requires some background on the product, Exact Online and SQL. A training is recommended when not available.

The essentials are that a model is defined using the ribbon “Modeler” (Dutch: Modelleur) as follows:

Block - General

Block - Facts

Block - Fields

Blocks - Presentation