# Dynamics C5

Moment has added support for export of invoices to Microsoft Dynamics C5.

## Export configuration

Configuration of export is to be done following the standard [configuration](https://docs.milientsoftware.com/help/moment-by-topic/integrations/file-exports/..#accounting-export).

Dynamics C5 requires two additional fields to be configured:

* Customers code
* Invoices

These fields are used to define the code that will be used first on the lines in. See more information in the Files section.

![](https://497021537-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LsGm2gYUXX6xCfrrWgU%2F-MfgJ6QfEDwj_iDkn_7h%2F-MfhFNb81n6SKB8HvhbI%2Fimage.png?alt=media\&token=7e3d1b17-f49d-43a4-955d-fb5afd9110ab)

## File

The files provided are CSV files using ; (semi-colon) as separator. The file contains both customers and invoices. The first column/field on each row defines the type of row.

### Customers

| Field          | Description                               |
| -------------- | ----------------------------------------- |
| Line type code | Customers code - defined in configuration |
| Account number | Customer number                           |
| Name           |                                           |
| Name2          |                                           |
| Address        |                                           |
| ZipCode/Place  |                                           |
| Country        | ISO-2 code                                |
| Group          | Hardcoded = 1                             |
| Payment        | Hardcoded = 30dg                          |
| Attention      |                                           |
| Mobile         |                                           |
| Email          |                                           |
| EAN            |                                           |
| VAT            | Hardcoded = 2                             |
| Approved       | Hardcoded = 1                             |
| Currency       | Hardcoded = DKK                           |
| Language       | Hardcoded = Standard                      |
| VAT Type       | Hardcoded = DK:CVR                        |
| VAT Number     |                                           |

### Invoices

| Field            | Description                                                           |
| ---------------- | --------------------------------------------------------------------- |
| Line type code   | Invoices - defined in configuration                                   |
| Invoice date     |                                                                       |
| Invoice number   |                                                                       |
| Line type code   | Set to "F" on credit rows, set to "D" on debit rows                   |
| Account          | Invoice line account on credit rows, customer number on debit rows    |
| Balance          |                                                                       |
| Credit amount    |                                                                       |
| Debit amount     |                                                                       |
| Tax code         | Set to 2 for credit rows, not defined on debit rows.                  |
| Description      | Contains invoice number and project number in double quotation marks. |
| Invoice          |                                                                       |
| Plus sag         |                                                                       |
| Plus medarbeider |                                                                       |
| Plus art         |                                                                       |

#### Format

* Date format: YYYY-MM-DD