Search…
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
Last modified 2mo ago