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.

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.

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