Supplier invoice Text

SUPPLIER INVOICE (header)

RecordType;DBId;Ref;Desc;Number;SupplierName;InvoiceDate;InvoiceFCurrency;CurrencyRate;Description;Type;
SupplierNumber;IntraComVATNum;DocumentPathFileName;PaidByCreditCard
Nr Name Type Description
1 RecordType Long Type of object to import. 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) Number of the invoice
6 SupplierName Char(75) Supplier Name (has to match existing supplier name)
NB: If the unique supplier file number is provided the name can be omitted
7 Date Date/Time Date of the invoice (YYYYMMDD)
8 Currency Char(10) Currency used in the invoice
9 CurrencyRate Double Currency rate if the used currency is not capital currency
10 Description Char(255) Description of the invoice
11 Type Integer Type of transaction:
1 = Invoice / 8 = Credit Note
3 = Permanent order / 6 = Initial
7 = Advance payment
9=WriteOff
12 SupplierFileNumber Double Supplier Number (mandatory is no name specified)
13 IntraComVATNum Char(50) Intra-community VAT Number
14 DocumentPathFileName Char(255) File Name of the Document
15 PaidByCreditCard Integer Is the invoice already paid by Credit Card ?
1 = True / 0 = False

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 is for supplier invoice detail
2 DBId Long Database Id in DeMaSy.
3 InvoiceNumber Char(50) Invoice number linked to the detail
4 ArticleCode Char(50) Article Code
5 CYArticlePrice Double Unit price (transaction currency)
6 ArticlePrice Double Unit price (capital currency)
7 ArticleNumber Double Quantity of article
8 CyAmount Double Amount (transaction currency)
9 Amount Double Amount (capital currency) – optional
10 VATCode Char 20 Vat Code
11 VATCodeRate Double VAT Rate
12 CYVATValue Double VAT Value (transaction currency)
13 VATValue Double VAT Value (capital currency) – optional
13 CyTotal Double Total with VAT
14 Description Char(255) Description
15 DGLAccountNumber Char(50) Debit Account (empty = supplier default)
16 CGLAccountNumber Char(50) Credit Account (empty = supplier default)
17 PLCenterCode Char(50) Profit and Loss center code
  1. If an article code is specified, an article price and an article number must be specified.
  2. The Amount must be equal to the ArticleNumber * ArticlePrice
  3. The CyAmount must be equal to the ArticleNumber * CyArticlePrice
  4. The VATValue must be equal to the Amount * VATCodeRate / 100.
  5. The CyVATValue must be equal to the CyAmount * VATCodeRate / 100.
  6. The CyTotal must be equal to the CyAmount + CyVATValue or CyAmount + (CyAmount * CyVATRate / 100)
  7. If the DGLAccountNumber is specified and not the CGLAccountNumber the CGLAccountNumber will be replaced by the supplier account specified in the options. As counterpart the expenses account will be used according to the default logic for the supplier expenses account .
  8. If the CGLAccountNumber is specified and not the DGLAccountNumber the DGLAccountNumber will be replaced by the supplier account specified in the options. As counterpart the expenses account will be used according to the default logic for the supplier expenses account .
  9. If the 2 Accounts are specified, one of the two accounts must be the supplier general ledger account.
  10. If there is no account specified the system will use as the following defaults:
    Invoice: D = default expenses account / C = supplier account
    Credit Note: D = supplier account / C = default expenses account.