{"id":1662,"date":"2014-06-26T14:13:08","date_gmt":"2014-06-26T13:13:08","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1662&lang=en"},"modified":"2015-12-11T16:06:48","modified_gmt":"2015-12-11T15:06:48","slug":"general-year-end-balance","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1662","title":{"rendered":"General Ledger Year End balance"},"content":{"rendered":"

General Ledger Year End Balance:<\/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> =”60<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 60 is for general ledger period<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
<GLPeriodName><\/GLPeriodName><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nPeriod name<\/td>\n<\/tr>\n
<GLAccountNumber><\/GLAccountNumber><\/span><\/td>\nChar(50)<\/td>\nY<\/td>\nGL account number<\/td>\n<\/tr>\n
<GLYEBalanceCurrency><\/GLYEBalanceCurrency><\/span><\/td>\nChar(10)<\/td>\nY<\/td>\nBalance currency<\/td>\n<\/tr>\n
<CyStartBalance><\/CyStartBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nStart balance in transaction currency<\/td>\n<\/tr>\n
<StartBalance><\/StartBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nStart balance in capital currency<\/td>\n<\/tr>\n
<ACStartBalance><\/ACStartBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nStart balance in capital second currency<\/td>\n<\/tr>\n
<CyCTotal><\/CyCTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of credit movements in transaction currency<\/td>\n<\/tr>\n
<CTotal><\/CTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of credit movements in capital currency<\/td>\n<\/tr>\n
<ACCTotal><\/ACCTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of credit movements in second capital currency<\/td>\n<\/tr>\n
<CyDTotal><\/CyDTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of debit movements in transaction currency<\/td>\n<\/tr>\n
<DTotal><\/DTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of debit movements in capital currency<\/td>\n<\/tr>\n
<ACDTotal><\/ACDTotal><\/span><\/td>\nDouble<\/td>\nY<\/td>\nSum of debit movements in second capital currency<\/td>\n<\/tr>\n
<CyEndBalance><\/CyEndBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nEnd balance in transaction currency<\/td>\n<\/tr>\n
<EndBalance><\/EndBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nEnd balance in capital currency<\/td>\n<\/tr>\n
<ACEndBalance><\/ACEndBalance><\/span><\/td>\nDouble<\/td>\nY<\/td>\nEnd balance in second capital currency<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

General Ledger Year End Balance: Name Type Mandatory Description <Record Type =”60“> Long Y Type of object to import. 60 is for general ledger period <DBId><\/DBId> Long Y Database Id in DeMaSy. It is displayed in Utilities <GLPeriodName><\/GLPeriodName> Char(50) Y Period name <GLAccountNumber><\/GLAccountNumber> Char(50) Y GL account number <GLYEBalanceCurrency><\/GLYEBalanceCurrency> Char(10) Y Balance currency <CyStartBalance><\/CyStartBalance> Double […]<\/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":[30,15,12],"class_list":["post-1662","post","type-post","status-publish","format-standard","hentry","category-utils","tag-general-year-end-balance","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1662","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=1662"}],"version-history":[{"count":15,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1662\/revisions"}],"predecessor-version":[{"id":5026,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1662\/revisions\/5026"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}