{"id":1419,"date":"2014-05-21T13:32:46","date_gmt":"2014-05-21T12:32:46","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1419&lang=en"},"modified":"2020-08-18T13:25:19","modified_gmt":"2020-08-18T12:25:19","slug":"client-invoice","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1419","title":{"rendered":"Client Invoice (XML)"},"content":{"rendered":"

CLIENT INVOICES (header)<\/span><\/b><\/h3>\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>=\u201d22<\/span>\u2033><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. Type 22 is for invoice headers<\/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>\nInvoice Number<\/td>\n<\/tr>\n
<ClientName> <\/ClientName><\/span><\/td>\nChar(75)<\/td>\nY<\/td>\nClient Name (has to match existing client name)
\nNB: If the unique client file number is provided the name can be omitted<\/td>\n<\/tr>\n
<Date><\/Date><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nInvoice date (YYYYMMDD)<\/td>\n<\/tr>\n
<Currency> <\/Currency><\/span><\/td>\nChar(10)<\/td>\nY<\/td>\nCurrency (ISO code)<\/td>\n<\/tr>\n
<CurrencyRate><\/CurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nCurrency rate<\/td>\n<\/tr>\n
<Description><\/Description><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nDescription<\/td>\n<\/tr>\n
<Type><\/Type><\/span><\/td>\nInteger<\/td>\nY<\/td>\nType transaction:
\n1 = Invoice \/ 8 = Credit note
\n3 = Permanent Order \/ 6 = Initial
\n7 = Advance payment
\n9 = Write Off<\/td>\n<\/tr>\n
<ClientFileNumber><\/ClientFileNumber><\/span><\/td>\nDouble<\/span><\/td>\nY<\/td>\nClient number
\n(mandatory if no name specified)<\/td>\n<\/tr>\n
<ReminderDate><\/ReminderDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nReminder date (YYYYMMDD)<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

CLIENT INVOICES (details)<\/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\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
< Record<\/span> Type<\/span>=\u201d23<\/span>\u2033><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 23 = Client 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<\/td>\n<\/tr>\n
<ArticleCode> <\/ArticleCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nArticle code<\/td>\n<\/tr>\n
<ArticleName> <\/ArticleName><\/span><\/td>\nChar(50)<\/td>\n\/<\/td>\nArticle name<\/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 without VAT (transaction currency)<\/td>\n<\/tr>\n
<Amount><\/Amount><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAmount without VAT (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 number (empty = client default)<\/td>\n<\/tr>\n
<CGLAccountNumber><\/CGLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nCredit account number (empty = client 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

If an article code is specified, an article price and an article number must be specified.
\nThe Amount must be equal to the ArticleNumber * ArticlePrice
\nThe CyAmount must be equal to the ArticleNumber * CyArticlePrice
\nThe VATValue must be equal to the Amount * VATCodeRate \/ 100.
\nThe CyVATValue must be equal to the CyAmount * VATCodeRate \/ 100.
\nIf the DGLAccountNumber is specified and not the CGLAccountNumber the CGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
\nIf the CGLAccountNumber is specified and not the DGLAccountNumber the DGLAccountNumber will be replaced by the Client General Ledger account specified in the options.
\nIf the 2 Accounts are specified, one of the two accounts must be the Client General Ledger account.
\nIn the following block, a detail will be generated for the invoice number 00001 with only an amount and a VAT.<\/p>\n

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

CLIENT INVOICES (header) Name Type Mandatory Description <Record Type=\u201d22\u2033> Long Y Type of object to import. Type 22 is for invoice headers <DBId><\/DBId> Long Y Database ID in DeMaSy <Number><\/Number> Char(50) Y Invoice Number <ClientName> <\/ClientName> Char(75) Y Client Name (has to match existing client name) NB: If the unique client 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":[237],"tags":[428,15,21,12],"class_list":["post-1419","post","type-post","status-publish","format-standard","hentry","category-interface-utils","tag-client","tag-interface","tag-invoice","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1419","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=1419"}],"version-history":[{"count":39,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1419\/revisions"}],"predecessor-version":[{"id":11927,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1419\/revisions\/11927"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}