Skip to main content

Import purchase orders: CSV, EDI and order candidates

Here is how you import purchase orders via CSV or electronic formats and process order candidates after the import.

With the import, you create purchase orders in the Scopevisio Client from files, for example from the order confirmation of an online shop. You start the import in the purchase order overview in the ribbon under Procurement → Orders.

This article applies to users in purchasing with the right to the Purchase order form. How to create a purchase order manually is described in the article Create, send and approve purchase orders.

When is importing purchase orders worthwhile?

For large suppliers where you have to place orders in the online shop, it is advisable to write the purchase order with the order confirmation. This saves effort and ensures consistent processing. You can also import documents that were not created by Scopevisio. This keeps Scopevisio up to date with external systems of partners or suppliers.

Steps: Import a purchase order via CSV

  1. In the purchase order overview, instead of Add, open the multibutton Per CSV importieren. A new form opens.

  2. Check the import settings.

  3. Select the CSV file.

The file name of the import file follows this convention:

<Kontakt-Master-ID>_<Belegdatum>_<Belegnummer>.csv
  • <Kontakt-Master-ID> (optional): The master ID of a contact that corresponds to a supplier

  • <Belegdatum> (necessary): The date of the purchase order in basic ISO-8601 format (YYYYMMDD)

  • <Belegnummer> (optional): The (external) document number of the purchase order

Minimal representation:

20230530.csv

If Scopevisio cannot recognise the format, enter yourself:

  • The contact that corresponds to a supplier (required)

  • The document date (required)

  • The external document number (optional)

The Location is preset by default. You can adjust it in the form.

Import purchase orders via electronic formats (EDI, XML, EDIfact, iDoc)

Scopevisio supports structured data formats to import purchase orders efficiently. The data service brings your supplier's source data to the target format cost-effectively. Once set up, Scopevisio writes order confirmations as purchase orders in Scopevisio. If you want to use this, ask in the chat to be connected with the support team.

Scopevisio assigns product and unit data consistently or marks them as order candidates if no assignment is possible. The assignment runs via:

  1. Product supplier number

  2. Product supplier EAN/GTIN

  3. Product EAN/GTIN

  4. Unit

  5. Product SKU

If Scopevisio finds no unique assignment, it creates an order candidate.

This gives you:

  • Consistent data throughout the entire process of order confirmation, processing of the goods receipt and invoice verification

  • Correct display of inventory prices without manual intervention

  • Cost-effective connection of your main suppliers

If you regularly place extensive purchase orders, the Professional Service team will advise you. It checks the possibilities of data transfer for your requirements. You can find out from your contact person which suppliers are already connected as standard.

Process order candidates after the import

Order candidates arise when Scopevisio encounters differences in the master data when importing a purchase order, for example when a product is not yet part of your master data in Scopevisio.

Note: If there are order candidates, Scopevisio shows a warning in the purchase order overview.

Order candidates show all line information that Scopevisio has received. You can change lines using the commands Add and Remove.

Create unknown products from the order candidate

Previously unknown products are shown in black in the description, not grey. The button Produkt hinzufügen zum Produktstamm is active. You can create unknown products directly from this view, using the rules of the products or at least using all available information from the supplier. This way, you take the information directly into the product and minimise the effort for master data maintenance. Here you can define a base unit and a delivery unit and thus control the process seamlessly.

Assign existing products with different units in the order candidate

Products that the supplier communicates in a unit other than the one stored so far can be assigned via an alias. Example: You manage a product as KT (carton), your supplier uses the unit BX (box). You can assign this once without changing your master data, so that the supplier's next order confirmation arrives directly. This is possible for base units and for delivery units.

  1. Select the corresponding line in the order candidate.

  2. Select Einheit als Alias für die Liefereinheit or Einheit als Alias für die Basiseinheit.

A message confirms the assignment.

Handle returns on the order confirmation in the order candidate

If returns have already been recorded on your supplier's order confirmation, Scopevisio can take these over as well. In the order candidate step, you decide:

  • Ignore the line

  • Create a return directly from this data, so that in the invoice verification view you find and can assign both delivery and return

Update product suppliers when importing purchase orders

When importing purchase orders and goods receipts, Scopevisio can create or update the product suppliers. This way, for example, you always have price changes up to date via the import of the order confirmation. You control this with a procurement setting that is reachable in two places and edits the same setting in both:

  • In the Scopevisio Client under Settings → Funktionsbereiche → Procurement → Import: setting Beim Import von Bestellungen/Wareneingängen (Produktlieferanten)

  • In the ribbon Organization → Stammdaten → Procurement → Settings, card Importeinstellungen: setting Produktlieferanten beim Import von Bestellungen/Wareneingängen

The following selection is available:

  • Produktlieferanten erzeugen/aktualisieren: Scopevisio creates or updates the product suppliers during the import.

  • Produktlieferanten weder erzeugen, noch aktualisieren: Scopevisio does not change the product suppliers during the import. This is the default.

The import reports which variant applies. Further import settings are described in the article Procurement settings.

Related articles about importing purchase orders

Did this answer your question?