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.
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 |
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 |
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, ...
Updated on: 09/09/2026
Thank you!