{"id":1931,"date":"2014-07-11T10:40:06","date_gmt":"2014-07-11T09:40:06","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1931&lang=en"},"modified":"2020-07-30T13:56:29","modified_gmt":"2020-07-30T12:56:29","slug":"gl-year-end-balance","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1931","title":{"rendered":"GL Year end balance"},"content":{"rendered":"

General Ledger Year End Balance:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;GLPeriodName;GLAccountNumber;GLYEBalanceCurrency;CyStartBalance;StartBalance;ACStartBalance;
\nCyCTotal;CTotal;ACCTotal;CyDTotal;DTotal;ACDTotal;CyEndBalance;EndBalance;ACEndBalance<\/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
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 60 is for general ledger period<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nGLPeriodName<\/span><\/td>\nChar(50)<\/td>\nPeriod name<\/td>\n<\/tr>\n
4<\/td>\nGLAccountNumber<\/span><\/td>\nChar(50)<\/td>\nGL account number<\/td>\n<\/tr>\n
5<\/td>\nGLYEBalanceCurrency<\/span><\/td>\nChar(10)<\/td>\nBalance currency<\/td>\n<\/tr>\n
6<\/td>\nCyStartBalance<\/span><\/td>\nDouble<\/td>\nStart balance in transaction currency<\/td>\n<\/tr>\n
7<\/td>\nStartBalance<\/span><\/td>\nDouble<\/td>\nStart balance in capital currency<\/td>\n<\/tr>\n
8<\/td>\nACStartBalance<\/span><\/td>\nDouble<\/td>\nStart balance in capital second currency<\/td>\n<\/tr>\n
9<\/td>\nCyCTotal<\/span><\/td>\nDouble<\/td>\nSum of credit movements in transaction currency<\/td>\n<\/tr>\n
10<\/td>\nCTotal<\/span><\/td>\nDouble<\/td>\nSum of credit movements in capital currency<\/td>\n<\/tr>\n
11<\/td>\nACCTotal<\/span><\/td>\nDouble<\/td>\nSum of credit movements in second capital currency<\/td>\n<\/tr>\n
12<\/td>\nCyDTotal<\/span><\/td>\nDouble<\/td>\nSum of debit movements in transaction currency<\/td>\n<\/tr>\n
13<\/td>\nDTotal<\/span><\/td>\nDouble<\/td>\nSum of debit movements in capital currency<\/td>\n<\/tr>\n
14<\/td>\nACDTotal<\/span><\/td>\nDouble<\/td>\nSum of debit movements in second capital currency<\/td>\n<\/tr>\n
15<\/td>\nCyEndBalance<\/span><\/td>\nDouble<\/td>\nEnd balance in transaction currency<\/td>\n<\/tr>\n
16<\/td>\nEndBalance<\/span><\/td>\nDouble<\/td>\nEnd balance in capital currency<\/td>\n<\/tr>\n
17<\/td>\nACEndBalance<\/span><\/td>\nDouble<\/td>\nEnd balance in second capital currency<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

General Ledger Year End Balance: RecordType;DBId;GLPeriodName;GLAccountNumber;GLYEBalanceCurrency;CyStartBalance;StartBalance;ACStartBalance; CyCTotal;CTotal;ACCTotal;CyDTotal;DTotal;ACDTotal;CyEndBalance;EndBalance;ACEndBalance Nr Name Type Description 1 RecordType Long Type of object to import. 60 is for general ledger period 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 GLPeriodName Char(50) Period name 4 GLAccountNumber Char(50) GL account number 5 GLYEBalanceCurrency Char(10) Balance currency 6 CyStartBalance […]<\/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-1931","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1931","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=1931"}],"version-history":[{"count":3,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1931\/revisions"}],"predecessor-version":[{"id":9331,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1931\/revisions\/9331"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}