{"id":1935,"date":"2014-07-11T10:41:31","date_gmt":"2014-07-11T09:41:31","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1935&lang=en"},"modified":"2021-02-11T11:39:23","modified_gmt":"2021-02-11T10:39:23","slug":"supplier-invoice-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1935","title":{"rendered":"Supplier invoice Text"},"content":{"rendered":"

SUPPLIER INVOICE (header)<\/span><\/b><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;Number;SupplierName;InvoiceDate;InvoiceFCurrency;CurrencyRate;Description;Type;
\nSupplierNumber;IntraComVATNum;DocumentPathFileName;PaidByCreditCard<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 24 is for supplier invoice<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy<\/td>\n<\/tr>\n
3<\/td>\nRef<\/span><\/td>\nChar(255)<\/td>\nInternal reference<\/td>\n<\/tr>\n
4<\/td>\nDesc<\/span><\/td>\nChar(255)<\/td>\nInternal description<\/td>\n<\/tr>\n
5<\/td>\nNumber<\/span><\/td>\nChar(50)<\/td>\nNumber of the invoice<\/td>\n<\/tr>\n
6<\/td>\nSupplierName<\/span><\/td>\nChar(75)<\/td>\nSupplier Name (has to match existing supplier name)
\nNB: If the unique supplier file number is provided the name can be omitted<\/td>\n<\/tr>\n
7<\/td>\nDate<\/span><\/td>\nDate\/Time<\/td>\nDate of the invoice (YYYYMMDD)<\/td>\n<\/tr>\n
8<\/td>\nCurrency<\/span><\/td>\nChar(10)<\/td>\nCurrency used in the invoice<\/td>\n<\/tr>\n
9<\/td>\nCurrencyRate<\/span><\/td>\nDouble<\/td>\nCurrency rate if the used currency is not capital currency<\/td>\n<\/tr>\n
10<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription of the invoice<\/td>\n<\/tr>\n
11<\/td>\nType<\/span><\/td>\nInteger<\/td>\nType of transaction:
\n1 = Invoice \/ 8 = Credit Note
\n3 = Permanent order \/ 6 = Initial
\n7 = Advance payment
\n9=WriteOff<\/td>\n<\/tr>\n
12<\/td>\nSupplierFileNumber<\/span><\/td>\nDouble<\/td>\nSupplier Number (mandatory is no name specified)<\/td>\n<\/tr>\n
13<\/td>\nIntraComVATNum<\/span><\/td>\nChar(50)<\/td>\nIntra-community VAT Number<\/td>\n<\/tr>\n
14<\/td>\nDocumentPathFileName<\/span><\/td>\nChar(255)<\/td>\nFile Name of the Document<\/td>\n<\/tr>\n
15<\/td>\nPaidByCreditCard<\/span><\/td>\nInteger<\/td>\nIs the invoice already paid by Credit Card ?
\n1 = True \/ 0 = False<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

SUPPLIER INVOICE (details)
\n<\/span><\/b><\/h3>\n\n\n\n
RecordType;DBId;Ref;Desc;InvoiceFNumber;InvoiceFDetailCurrency;ArticleCode;CyArticlePrice;ArticlePrice;ArticleNumber;CyAmount;
\nAmount;VATCode;VATRate;CyVATValue;VATValue;Description;DGLAccount;CGLAccount;PLCenterCode<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 25 is for supplier invoice detail<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy.<\/td>\n<\/tr>\n
3<\/td>\nInvoiceNumber<\/span><\/td>\nChar(50)<\/td>\nInvoice number linked to the detail<\/td>\n<\/tr>\n
4<\/td>\nArticleCode<\/span><\/td>\nChar(50)<\/td>\nArticle Code<\/td>\n<\/tr>\n
5<\/td>\nCYArticlePrice<\/span><\/td>\nDouble<\/td>\nUnit price (transaction currency)<\/td>\n<\/tr>\n
6<\/td>\nArticlePrice<\/span><\/td>\nDouble<\/td>\nUnit price (capital currency)<\/td>\n<\/tr>\n
7<\/td>\nArticleNumber<\/span><\/td>\nDouble<\/td>\nQuantity of article<\/td>\n<\/tr>\n
8<\/td>\nCyAmount<\/span><\/td>\nDouble<\/td>\nAmount (transaction currency)<\/td>\n<\/tr>\n
9<\/td>\nAmount<\/span><\/td>\nDouble<\/td>\nAmount (capital currency) – optional<\/td>\n<\/tr>\n
10<\/td>\nVATCode<\/span><\/td>\nChar 20<\/td>\nVat Code<\/td>\n<\/tr>\n
11<\/td>\nVATCodeRate<\/span><\/td>\nDouble<\/td>\nVAT Rate<\/td>\n<\/tr>\n
12<\/td>\nCYVATValue<\/span><\/td>\nDouble<\/td>\nVAT Value (transaction currency)<\/td>\n<\/tr>\n
13<\/td>\nVATValue<\/span><\/td>\nDouble<\/td>\nVAT Value (capital currency) – optional<\/td>\n<\/tr>\n
13<\/td>\nCyTotal<\/span><\/td>\nDouble<\/td>\nTotal with VAT<\/td>\n<\/tr>\n
14<\/td>\nDescription<\/span><\/td>\nChar(255)<\/td>\nDescription<\/td>\n<\/tr>\n
15<\/td>\nDGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nDebit Account (empty = supplier default)<\/td>\n<\/tr>\n
16<\/td>\nCGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nCredit Account (empty = supplier default)<\/td>\n<\/tr>\n
17<\/td>\nPLCenterCode<\/span><\/td>\nChar(50)<\/td>\nProfit and Loss center code<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n
  1. If an article code is specified, an article price and an article number must be specified.<\/li>\n
  2. The Amount must be equal to the ArticleNumber * ArticlePrice<\/li>\n
  3. The CyAmount must be equal to the ArticleNumber * CyArticlePrice<\/li>\n
  4. The VATValue must be equal to the Amount * VATCodeRate \/ 100.<\/li>\n
  5. The CyVATValue must be equal to the CyAmount * VATCodeRate \/ 100.<\/li>\n
  6. The CyTotal must be equal to the CyAmount + CyVATValue or CyAmount + (CyAmount * CyVATRate \/ 100)<\/li>\n
  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 .<\/li>\n
  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 .<\/li>\n
  9. If the 2 Accounts are specified, one of the two accounts must be the supplier general ledger account.<\/li>\n
  10. If there is no account specified the system will use as the following defaults:
    \nInvoice: D = default expenses account \/ C = supplier account
    \nCredit Note: D = supplier account \/ C = default expenses account.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1935","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1935","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1935"}],"version-history":[{"count":11,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions"}],"predecessor-version":[{"id":11299,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1935\/revisions\/11299"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}