Upload your suppliers' activity codes in one file

What’s new

From Purchases, Suppliers management, there is now an Upload activity codes button that lets you assign CNAE or SIC codes to every supplier in a single file instead of editing them one at a time.

The file only needs four columns: supplier name, country, activity code and code type (CNAE or SIC). If a code does not exist in the framework you picked, the row is flagged and Submit stays disabled, so you cannot save a half-imported file.

For holdings, an optional Company column routes each supplier to the right subsidiary, so one file can cover the whole group. Single-company accounts never see that column.

Why it matters

In spend-based purchases, the emission factor comes from the supplier’s activity sector. An uncoded supplier, or one coded to the wrong sector, moves the whole category. Uploading codes in bulk turns what used to take a supplier-by-supplier effort into a single file.

Good to know

If a supplier already had a different code, its purchases were costed against the old sector. Right after the upload, Dcycle offers to recalculate the affected purchases in the background and tells you how many are affected.

The upload prompt is currently the only entry point for bulk assignment. If you choose ‘Not now’, the way back is editing suppliers one by one, so it is worth confirming unless you have a reason not to.