Invantive Control has formulas to retrieve Exact Online company information such as city using the unique division code. However, often there are more unique aspects to search Exact Online company information by such as Chamber of Commerce number. This article explains how to use use other aspects to retrieve company information.

Instructions

Perform the following steps:

  1. Start Excel.

  2. Log on to Exact Online.

  3. Enter the formula without parameters (red 1 in picture): I_EOL_DIV_NAME()

  4. Or use the Building Blocks selector in the Modeler ribbon to select an Exact Online company formula.

  5. Press enter.

  6. Press the function wizard button in Excel.

  7. Enter a city such as “Den Haag“ (“The Hague“) such as red 2 in picture.

  8. The formula evaluates to a list of all names of companies in The Hague (“Den Haag“).

Perform the following additional steps to retrieve the unique division code of a company by the human-readable company number:

  1. Enter the formula (red 3 in picture): I_EOL_DIV_CODE(,14).

  2. Replace “14” by a possibly unique company code such as “14” (these are shown in the partition chooser to the left of the name as shown with red 4 in picture).

  3. Press enter.

  4. The unique division code is shown in the Excel cell.