---
title: "Action: Non-stock entries (services)"
description: "Imports non-stock entries (such as services or text lines) into Sapera, matched on external reference and line number."
url: https://support.sapera.io/en/articles/597-action-non-stock-entries-services
collection: "SyncTool"
updated: 2026-09-25
language: en
alternates: [da]
---

# Action: Non-stock entries (services)

Imports non-stock entries (such as services or text lines) into Sapera, matched on external reference and line number.

Imports non-stock entries (such as services or text lines) into Sapera, matched on external reference and line number.

## How to use the action

1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import.

Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated.

## How matching and updating works

Used to record **non-stock entries** – e.g. services, text lines or consumption that is not managed as physical stock.

-   Each line is identified by **external reference + line number** (ExternalReference + LineNumber), so repeated runs do not create duplicates.
    
-   A line can point to a product, variant, instance, supplier/customer plus quantity, cost and sales price, discount and registration date. Direction: from file/SQL into Sapera.
    

## Key parameters

<table data-id="1095516c-5471-4949-a03e-d30cf82a1e24" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="924ce05d-fc1a-4b42-bd26-1d1d59fde93f" style="text-align: left;"><strong>Parameter</strong></p></td><td colspan="1" rowspan="1"><p data-id="f3c0b7f2-c2c7-408e-bd5f-79983c5733eb" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="c0cc3c10-bd23-40b8-b92a-77425bf0111d" style="text-align: left;">AllowCreate</p></td><td colspan="1" rowspan="1"><p data-id="89f8136b-b28c-43f0-936b-3997377eab2d" style="text-align: left;">Allow creating new non-stock entries for rows that do not yet exist.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="dc318173-a415-4c74-9041-83c7ef9fca05" style="text-align: left;">AllowUpdate</p></td><td colspan="1" rowspan="1"><p data-id="92e7e0b1-c383-445b-8af5-a0f068518a5c" style="text-align: left;">Allow updating existing non-stock entries when a matching row is found.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="a08b0c3a-e217-4130-a8b5-77a9c5a50c6f" style="text-align: left;">DefaultProductIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="4bd6fbc1-c4be-4bad-9b05-ad55b5822083" style="text-align: left;">Product identifier used when a row has no product identifier of its own.</p></td></tr></tbody></table>

## Source fields

<table data-id="cc0d77c5-af4e-4eeb-ab16-940ab8095f28" style="min-width: 50px;"><colgroup><col style="min-width: 25px;"><col style="min-width: 25px;"></colgroup><tbody><tr><td colspan="1" rowspan="1"><p data-id="7ee59718-1d0e-411a-a6eb-e7e33183a7b9" style="text-align: left;"><strong>Field</strong></p></td><td colspan="1" rowspan="1"><p data-id="2f615625-c440-47ba-875d-aa074d7811c9" style="text-align: left;"><strong>Explanation</strong></p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="b9971de0-059f-4376-bbe2-50987c9a9770" style="text-align: left;">CostPrice</p></td><td colspan="1" rowspan="1"><p data-id="de9cefaf-1522-44c8-ad2e-307703c87e97" style="text-align: left;">Cost price recorded on the entry.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="17e3c26c-2259-4de1-9320-9a95445d3f90" style="text-align: left;">CustomerIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="74dcea7f-8dbe-4fd0-8693-8dc3f9d9f58e" style="text-align: left;">Identifier of the customer linked to the entry.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="46d53973-5c0e-4c36-a9ae-6e768cddf143" style="text-align: left;">Description</p></td><td colspan="1" rowspan="1"><p data-id="81151437-b2ea-4117-abc6-9e33e4bf3b88" style="text-align: left;">Free-text description stored on the entry.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="ba347942-b6c9-45a4-ab85-de41f9b63727" style="text-align: left;">ExternalReference</p></td><td colspan="1" rowspan="1"><p data-id="4eda58af-cd30-4688-9b3d-94dd99794839" style="text-align: left;">External reference identifying the source document; part of the row identifier.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="fb4556dc-7052-4ae2-b2e4-1e5fd3454f84" style="text-align: left;">LineNumber</p></td><td colspan="1" rowspan="1"><p data-id="04ce80b7-223b-4686-b40a-9195311a0d36" style="text-align: left;">Line number within the external reference; part of the row identifier.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="de98c6a7-6f3a-497d-a8f4-363011eefb73" style="text-align: left;">OrganizationalUnit</p></td><td colspan="1" rowspan="1"><p data-id="9be5dc8e-6350-47b1-ac79-de17950f36cd" style="text-align: left;">Organizational unit the entry belongs to.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="16a54be4-51a8-4706-99dc-f161ecdf1f29" style="text-align: left;">ProductIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="cade3e6a-ad6c-42ba-8a1d-a38982db3957" style="text-align: left;">Product identifier the entry applies to.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="c3894c5a-7aef-4a89-802a-1c9acc131f14" style="text-align: left;">ProductInstanceIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="e181a7c6-8eb1-43a8-9980-69176531a9ac" style="text-align: left;">Identifier of the specific serial-number item the entry applies to.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="00f74690-f6af-477e-a943-bf889f826860" style="text-align: left;">Quantity</p></td><td colspan="1" rowspan="1"><p data-id="3f581e3b-532c-4790-8de2-329603ccffb3" style="text-align: left;">Quantity recorded on the entry.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="a4b91427-97b3-455a-ada2-4f4f783f9a77" style="text-align: left;">RegistrationDate</p></td><td colspan="1" rowspan="1"><p data-id="09a323cd-09ae-4beb-ac3c-a3c8251c7451" style="text-align: left;">Date the entry is registered.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="956c3989-8e17-4b4d-ab4e-aafe4615a37d" style="text-align: left;">SalesPrice</p></td><td colspan="1" rowspan="1"><p data-id="db80839d-5d4d-469c-928f-dfe10617776a" style="text-align: left;">Sales price recorded on the entry.</p></td></tr><tr><td colspan="1" rowspan="1"><p data-id="86c0d273-cae1-4915-9c68-b1312f7169a7" style="text-align: left;">SupplierIdentifier</p></td><td colspan="1" rowspan="1"><p data-id="3a45bcc2-fe6d-4c6c-a70d-2f034c062398" style="text-align: left;">Identifier of the supplier linked to the entry.</p></td></tr></tbody></table>

* * *

See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md).

* * *

**Want to know more?**

Read more in these related articles:

[

Standard parameters for all actions

The general parameters available on most SyncTool actions: step control, error handling, timeout, etc.

](https://support.sapera.io/en/articles/648.md)
