Supplier Invoice (TXT)

SUPPLIER INVOICE (header):

 

RecordType;DBId;Ref;Desc;Number;SupplierName;InvoiceDate;InvoiceFCurrency;CurrencyRate;Description;Type;SupplierNumber

 

Nr Name Type Description
1 RecordType Long Type of object to import. Type 24 is for supplier invoice
2 DBId Long Database ID in DeMaSy
3 Ref Char(255) Internal reference
4 Desc Char(255) Internal description
5 Number Char(50) Invoice number
6 SupplierName Char(75) Supplier name (has to match existing supplier 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 SupplierFileNumber Double Supplier number
(mandatory if no name specified)

 

SUPPLIER INVOICE (details):

RecordType;DBId;Ref;Desc;InvoiceFNumber;InvoiceFDetailCurrency;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. 25 = Supplier 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 ArticleName Char(50) Article name
8 CyArticlePrice Double Unit price (transaction currency)
9 ArticlePrice Double Unit price (capital currency)
10 ArticleNumber Double Quantity of article
11 CyAmount Double Amount without VAT (transaction currency)
12 Amount Double Amount without VAT (capital currency) – optional
13 VATCode Char 20 VAT Code
14 VATCodeRate Double VAT Rate
15 CyVATValue Double VAT value (transaction currency)
16 VATValue Double VAT value (capital currency) – optional
17 Description Char(255) Description
18 DGLAccountNumber Char(50) Debit account number (empty = client default)
19 CGLAccountNumber Char(50) Credit account number (empty = client default)
20 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.