I am looking for an example for direct creation of cost units / cost centres from within Excel into Exact Online. It concerns solely code and description.
You can find a sample in the knowledge base at Maintain Cost Units from Excel using Invantive Control blocks using flexible blocks and an Excel entry form.
The approach works for all other Exact Online tables that support insert and update. The approach also works for other platforms such as visma.net.
You can also use Invantive SQL statements such as “insert into uploadxmltopics” or:
insert into exactonlinerest..costunits (code, description) values ('x', 'y')
There is currently no built-in Excel function to upload cost units into Exact Online.