> ## 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 incoming invoices

For the import of the [incoming invoices](https://support.robaws.com/en/article/incoming-invoices-general-explanation-unv556/), the tabs **'incominginvoices' and 'incominginvoiceslines'** are used. The connection is made on the basis of the 'NR' column. This has to be the same on both tabs so the lines are linked to the right incoming invoice. 

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

## Incoming invoices

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the incoming invoice |
| DATE | Date |
| EXPIREDATE | Due date |
| SUPPLIERNR | Supplier number,  has to be the same as the 'NR' column on the suppliers tab |
| SUPPLIERNAME | Supplier name, has to be the same as the 'NAME' column on the suppliers tab |
| STATUS | Status |
| TYPE | If it is a credit note, you fill in 'CREDIT' here |
| INVOICENR | Original invoice number |

|| The 'NR' column on 'incominginvoices' has to contain a unique value, otherwise the import is stopped.

## Incoming invoice lines
The 'NR' column is always mandatory because it is what makes the link with the incoming invoice. 

### Column titles
| Column title | Field in Robaws |
| ---- |
| NR | Number of the incoming invoice, has to be the same as the 'NR' column on the incominginvoices 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, ... ) |

### Line type

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