CLIENT INVOICE (header):
| RecordType;DBId;Ref;Desc;Number;ClientName;InvoiceDate;InvoiceTCurrency;CurrencyRate;Description;Type;ClientNumber;ReminderDate |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. Type 22 is for invoice headers |
| 1 | DBId | Long | Database ID in DeMaSy |
| 2 | Ref | Char(255) | Internal reference |
| 3 | Desc | Char(255) | Internal description |
| 4 | Number | Char(50) | Invoice Number |
| 5 | ClientName | Char(75) | Client Name (has to match existing client name) NB: If the unique client file number is provided the name can be omitted |
| 6 | Date | Date/Time | Invoice date (YYYYMMDD) |
| 7 | Currency | Char(10) | Currency (ISO code) |
| 8 | CurrencyRate | Double | Currency rate |
| 9 | Description | Char(255) | Description |
| 10 | Type | Integer | Type transaction: 1 = Invoice / 8 = Credit note 3 = Permanent Order / 6 = Initial 7 = Advance payment 9 = Write Off |
| 11 | ClientFileNumber | Double | Client number (mandatory if no name specified) |
| 12 | ReminderDate | Date/Time | Reminder date (YYYYMMDD) |
CLIENT INVOICE (details):
| RecordType;DBId;Ref;Desc;InvoiceNumber;ArticleCode;CyArticlePrice;ArticlePrice;ArticleNumber; CyAmount;Amount;VATCode;VATRate;CyVATValue;VATValue;Description;DGLAccount;CGLAccount;PLCenterCode# |
| Nr | Name | Type | Description |
|---|---|---|---|
| 1 | RecordType | Long | Type of object to import. 23 = Client invoice detail |
| 2 | DBId | Long | Database ID in DeMaSy |
| 3 | Ref | Char(255) | Internal reference |
| 4 | Desc | Char(255) | Internal description |
| 5 | InvoiceNumber | Char(50) | Invoice number |
| 6 | ArticleCode | Char(50) | Article code |
| 7 | CyArticlePrice | Double | Unit price (transaction currency) |
| 8 | ArticlePrice | Double | Unit price (capital currency) |
| 9 | ArticleNumber | Double | Quantity of article |
| 10 | CyAmount | Double | Amount without VAT (transaction currency) |
| 11 | Amount | Double | Amount without VAT (capital currency) – optional |
| 12 | VATCode | Char 20 | VAT Code |
| 13 | VATRate | Double | VAT Rate |
| 14 | CyVATValue | Double | VAT value (transaction currency) |
| 15 | VATValue | Double | VAT value (capital currency) – optional |
| 16 | Description | Char(255) | Description |
| 17 | DGLAccountNumber | Char(50) | Debit account number (empty = client default) |
| 18 | CGLAccountNumber | Char(50) | Credit account number (empty = client default) |
| 19 | PLCenterCode | Char(50) | Profit and loss center code |
If an article code is specified, an article price and an article number must be specified.
The Amount must be equal to the ArticleNumber * ArticlePrice
The CyAmount must be equal to the ArticleNumber * CyArticlePrice
The VATValue must be equal to the Amount * VATCodeRate / 100.
The CyVATValue must be equal to the CyAmount * VATCodeRate / 100.
If the DGLAccountNumber is specified and not the CGLAccountNumber the CGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
If the CGLAccountNumber is specified and not the DGLAccountNumber the DGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
If the 2 Accounts are specified, one of the two accounts must be the Client General Ledger account.
In the following block, a detail will be generated for the invoice number 00001 with only an amount and a VAT.