{"id":1422,"date":"2014-05-21T13:34:18","date_gmt":"2014-05-21T12:34:18","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1422&lang=en"},"modified":"2019-03-11T12:30:00","modified_gmt":"2019-03-11T11:30:00","slug":"supplier-invoice","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1422","title":{"rendered":"Supplier invoice"},"content":{"rendered":"

SUPPLIER INVOICES (header)<\/span><\/b><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record<\/span> Type<\/span>=”24<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 24 is for supplier invoice<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase ID in DeMaSy<\/td>\n<\/tr>\n
<Number><\/Number><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nNumber of the invoice<\/td>\n<\/tr>\n
<SupplierName><\/SupplierName><\/span><\/td>\nChar(75)<\/td>\nY<\/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
<Date><\/Date><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nDate of the invoice (YYYYMMDD)<\/td>\n<\/tr>\n
<Currency><\/Currency><\/span><\/td>\nChar(10)<\/td>\nY<\/td>\nCurrency used in the invoice<\/td>\n<\/tr>\n
<CurrencyRate><\/CurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nCurrency rate if the used currency is not capital currency<\/td>\n<\/tr>\n
<Description><\/Description><\/span><\/td>\nChar(255)<\/td>\nY<\/td>\nDescription of the invoice<\/td>\n<\/tr>\n
<Type><\/Type><\/span><\/td>\nInteger<\/td>\nY<\/td>\nType of transaction:
\n1 = Invoice \/ 8 = Credit Note
\n3 = Permanent order \/ 6 = Initial
\n7 = Advance payment
\n9=WriteOff<\/td>\n<\/tr>\n
<SupplierFileNumber><\/SupplierFileNumber><\/span><\/td>\nDouble<\/span><\/td>\nY<\/td>\nSupplier Number (mandatory is no name specified)<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

SUPPLIER INVOICES (details)
\n<\/span><\/b><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record <\/span>Type<\/span>=”25<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 25 is for supplier invoice detail<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase Id in DeMaSy.<\/td>\n<\/tr>\n
<InvoiceNumber><\/InvoiceNumber><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nInvoice number linked to the detail<\/td>\n<\/tr>\n
<ArticleCode> <\/ArticleCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nArticle Code<\/td>\n<\/tr>\n
<CyArticlePrice><\/CyArticlePrice><\/span><\/td>\nDouble<\/td>\nN<\/td>\nUnit price (transaction currency)<\/td>\n<\/tr>\n
<ArticlePrice><\/ArticlePrice><\/span><\/td>\nDouble<\/td>\nN<\/td>\nUnit price (capital currency)<\/td>\n<\/tr>\n
<ArticleNumber><\/ArticleNumber><\/span><\/td>\nDouble<\/td>\nN<\/td>\nQuantity of article<\/td>\n<\/tr>\n
<CyAmount><\/CyAmount><\/span><\/td>\nDouble<\/td>\nY<\/td>\nAmount (transaction currency)<\/td>\n<\/tr>\n
<Amount><\/Amount><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAmount (capital currency) – optional<\/td>\n<\/tr>\n
<VATCode><\/VATCode><\/span><\/td>\nChar 20<\/td>\nY<\/td>\nVat Code<\/td>\n<\/tr>\n
<VATCodeRate><\/VATCodeRate><\/span><\/td>\nDouble<\/td>\nY<\/td>\nVAT Rate<\/td>\n<\/tr>\n
<CyVATValue><\/CyVATValue><\/span><\/td>\nDouble<\/td>\nY<\/td>\nVAT Value (transaction currency)<\/td>\n<\/tr>\n
<VATValue><\/VATValue><\/span><\/td>\nDouble<\/td>\nN<\/td>\nVAT Value (capital currency) – optional<\/td>\n<\/tr>\n
<Description> <\/Description><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nDescription<\/td>\n<\/tr>\n
<DGLAccountNumber><\/DGLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nDebit Account (empty = supplier default)<\/td>\n<\/tr>\n
<CGLAccountNumber><\/CGLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nCredit Account (empty = supplier default)<\/td>\n<\/tr>\n
<PLCenterCode><\/PLCenterCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nProfit and Loss center code<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/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. 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
  7. 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
  8. If the 2 Accounts are specified, one of the two accounts must be the supplier general ledger account.<\/li>\n
  9. 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

    PDF version<\/a>
    \n    Excel version<\/a>
    \n    Excel version (combined)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    SUPPLIER INVOICES (header) Name Type Mandatory Description <Record Type=”24“> Long Y Type of object to import. 24 is for supplier invoice <DBId><\/DBId> Long Y Database ID in DeMaSy <Number><\/Number> Char(50) Y Number of the invoice <SupplierName><\/SupplierName> Char(75) Y Supplier Name (has to match existing supplier name) NB: If the unique supplier file number is provided […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67],"tags":[15,66,12],"class_list":["post-1422","post","type-post","status-publish","format-standard","hentry","category-technical","tag-interface","tag-supplier-invoice","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1422","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=1422"}],"version-history":[{"count":35,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1422\/revisions"}],"predecessor-version":[{"id":7004,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1422\/revisions\/7004"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1422"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1422"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}