> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing sales invoices

The import of the sales invoices is split into invoices and credit notes. For the **invoices** you use the tabs **'invoices' and 'invoicelines'**. For the **credit notes** these are **'credits' and 'creditlines**' . Both options use the 'NR' column to link the lines to the correct invoice/credit note. The columns are the same in both cases.

| Make sure you also read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws.

## Sales invoices

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the invoice/credit note |
| DATE | Date |
| EXPIREDATE | Due date |
| CLIENTNR | Customer number, has to be the same as the 'NR' column on the clients tab |
| CLIENTNAME | Customer name, has to be the same as the 'NAME' column on the clients tab |
| STATUS | Status |
| CLIENTREF | Customer reference |

|| Use a unique value in the 'NR' column on 'invoices' and 'credits'. There is no technical block on duplicate numbers: with a duplicate 'NR' a second invoice/credit note is created and the lines are linked to the most recent match. So make sure yourself that the numbers in your source file are unique, to avoid wrong links.

## Sales invoice lines
The 'NR' column is always mandatory because it is what makes the link with the invoice/credit note. 

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the invoice/credit note, has to be the same as the 'NR' column on the invoices/credits tab |
| AMOUNT | Quantity |
| UNITTYPE | Unit |
| LINE_TYPE | Line type - You have to enter a specific value for this. (see below)
| PRICE | Price |
| COSTPRICE | Cost price |
| BTWTYPE | VAT tariff |
| DESCRIPTION | Description |
| EXTRADESCRIPTION | Extra description |
| CHAPTER | Post number |
| ACTIVITY | Activity |
| PROJECTNR | Project number, has to be the same as the 'NR' column on the projects tab |
| ARTICLENR | Item number, has to be the same as the 'NR' column on the articles tab |
| AGREEMENTTYPE | Type (SOG, FH, ... ) |
| MATERIALNR | Equipment number or serialnumber of the equipment, has to be the same as 'BARCODE' on the materials tab |
| INSTALLATIONNR | Installation number or serialnumber of the installation, has to be the same as 'BARCODE' on the materialsinstallation tab |
| CUSTOM_PRICE | *not applicable* |

### Line type

* Line: P
* Title: H
* Total: T
* Quantity: A
* Check: C
* Variant: V
* Text: Tx
* Chapters: H1, H2, H3, H4, ...