{"id":1644,"date":"2014-06-26T13:11:43","date_gmt":"2014-06-26T12:11:43","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1644&lang=en"},"modified":"2016-03-24T15:09:46","modified_gmt":"2016-03-24T14:09:46","slug":"1644","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1644","title":{"rendered":"General Ledger Movement"},"content":{"rendered":"

General ledger movement:<\/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\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record<\/span> Type<\/span> =”21<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of transaction to import<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase ID in DeMaSy<\/td>\n<\/tr>\n
<Ref><\/Ref><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nUnique Reference by accounting entry<\/td>\n<\/tr>\n
<Desc><\/Desc><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nDescription which can be used in the entry editor used to validate entries<\/td>\n<\/tr>\n
<EntryNumber><\/EntryNumber><\/span><\/td>\nLong<\/td>\nY<\/td>\nEntry number<\/td>\n<\/tr>\n
<GLMovDate><\/GLMovDate><\/span><\/td>\nDate\/Time<\/td>\nY<\/td>\nDate of the entry
\n(YYYYMMDD)<\/td>\n<\/tr>\n
<C D><\/C D>
\n<\/span><\/td>\n		Char(1)<\/td>\nY<\/td>\nD for Debit \/ C for Credit<\/td>\n<\/tr>\n
<GLMovementCurrency><\/GLMovementCurrency><\/span><\/td>\nChar(10)<\/td>\nY<\/td>\nTransaction currency<\/td>\n<\/tr>\n
<CurrencyRate><\/CurrencyRate><\/span><\/td>\nDouble<\/td>\nN<\/td>\nCurrency rate (not mandatory if amount is provided)<\/td>\n<\/tr>\n
<CyAmount><\/CyAmount><\/span><\/td>\nDouble<\/td>\nY<\/td>\nAmount in transaction currency<\/td>\n<\/tr>\n
<Amount><\/Amount><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAmount in capital currency<\/td>\n<\/tr>\n
<GLAccountNumber><\/GLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nAccount Number [*]<\/td>\n<\/tr>\n
<Description><\/Description><\/span><\/td>\nChar(255)<\/td>\nY<\/td>\nDescription of the accounting entry<\/td>\n<\/tr>\n
<VATCode><\/VATCode><\/span><\/td>\nChar(20)<\/td>\nY<\/td>\nBlank if no VAT
\nVAT code if VAT (must match VAT code in DeMaSy)<\/td>\n<\/tr>\n
<VATRate><\/VATRate><\/span><\/td>\nDouble<\/td>\nY<\/td>\nVAT rate (0 if no VAT or rate if VAT)<\/td>\n<\/tr>\n
<BankStatment><\/BankStatment><\/span><\/td>\nLong<\/td>\nY<\/td>\nBank statement number if accounting entry on a bank otherwise 0<\/td>\n<\/tr>\n
<BankAccountNumber><\/BankAccountNumber><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nBank account number if entry on a bank account [*]<\/td>\n<\/tr>\n
<CyVATValue><\/CyVATValue><\/span><\/td>\nDouble<\/td>\nY<\/td>\nVAT Value in transaction currency<\/td>\n<\/tr>\n
<VATValue><\/VATValue><\/span><\/td>\nDouble<\/td>\nN<\/td>\nVAT Value in capital currency<\/td>\n<\/tr>\n
<PLCenterCode><\/PLCenterCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nProfit and Loss Center (must match in DeMaSy)<\/td>\n<\/tr>\n
<LineNumber><\/LineNumber><\/span><\/td>\nLong<\/td>\nN<\/td>\nLine of the entry<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

This table contains information of miscellaneous accounting entries.
\nAn accounting entry will always consist of a minimum of one debit and one credit records.<\/p>\n

In order to ensure these operations will be properly dealt with, it is required to either:
\n– Provide DeMaSy with debit and credit account numbers.
\n– Assign each possible operation a code allowing to setup account keys (to be evaluated separately)<\/p>\n

[*] In DeMaSy there is a link between an account of the chart of account and a bank account.
\nOne must have one or the other.<\/p>\n

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

General ledger movement: Name Type Mandatory Description <Record Type =”21“> Long Y Type of transaction to import <DBId><\/DBId> Long Y Database ID in DeMaSy <Ref><\/Ref> Char(255) N Unique Reference by accounting entry <Desc><\/Desc> Char(255) N Description which can be used in the entry editor used to validate entries <EntryNumber><\/EntryNumber> Long Y Entry number <GLMovDate><\/GLMovDate> Date\/Time […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[431,15,12],"class_list":["post-1644","post","type-post","status-publish","format-standard","hentry","category-utils","tag-general-ledger-movement","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1644","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=1644"}],"version-history":[{"count":46,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1644\/revisions"}],"predecessor-version":[{"id":5348,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1644\/revisions\/5348"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}