{"action":"created","issue":{"url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/7016","repository_url":"https://api.github.com/repos/Dolibarr/dolibarr","labels_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/7016/labels{/name}","comments_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/7016/comments","events_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/7016/events","html_url":"https://github.com/Dolibarr/dolibarr/issues/7016","id":236156070,"number":7016,"title":"SPEC: virtual account within chart of accounts","user":{"login":"kellogsgit","id":25719361,"avatar_url":"https://avatars3.githubusercontent.com/u/25719361?v=3","gravatar_id":"","url":"https://api.github.com/users/kellogsgit","html_url":"https://github.com/kellogsgit","followers_url":"https://api.github.com/users/kellogsgit/followers","following_url":"https://api.github.com/users/kellogsgit/following{/other_user}","gists_url":"https://api.github.com/users/kellogsgit/gists{/gist_id}","starred_url":"https://api.github.com/users/kellogsgit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kellogsgit/subscriptions","organizations_url":"https://api.github.com/users/kellogsgit/orgs","repos_url":"https://api.github.com/users/kellogsgit/repos","events_url":"https://api.github.com/users/kellogsgit/events{/privacy}","received_events_url":"https://api.github.com/users/kellogsgit/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-06-15T11:15:43Z","updated_at":"2017-06-16T15:59:53Z","closed_at":null,"body":"## Title\r\nThis is a discussion to support/adapt OpenERP notion of virtual account. Which could be translated in French as \"compte de regroupement\" as virtual account as several children accounts.\r\n\r\n## Present behavior\r\nDolibarr allows to use both solutoins : create a single 401 account and create dedicated children-accounts to 401. With the arrival of FEC rules, it becomes necessary to export FEC data each of fiscal year and this may (or may not) impact Dolibarr chart of accounts.\r\n\r\nFrench administration welcomes a single 410 client account or \"few of them\" in the FEC export.  But remember, this is only for verification purpose. \r\n\r\nOn the converse, a company might be interested in creating as many as 401 children accounts as possible, to have fine-grain client management. Also, in some countries, it might be illegal to run a middle-size company using a single 410 account. So a solution is needed to allow all solutions and still rely on a rock-solid SQL database allowing direct accounting queries.\r\n\r\n## Proposed behavior\r\n\r\nWe propose to adapt OpenERP solution,which is to tag each account as \"virtual\" or \"real\" within the chart of accounts using a binary value \"True\" or \"False\". \r\n\r\nA \"real\" account speaks for itself. If 410 is tagged \"real\", then all transactions should occur on 410.\r\n\r\nA \"virtual\" account is an account with one or several children. In the example of 410 account, it will create a sub account name 410 000000 which is in fact the default 410 account. Each new client can have a dedicated client account within the 410 range.\r\n\r\nAs a consequence, the chart of accounts should also store the lenght of children accounts. The lenght is the total number of alphanumaric values, i.e. 410 000000 is 6+3=9. Just an example. It should also be possible to use alpha values, as proposed by the administation.\r\n\r\nTo query the 410 account, you only need to run a \"SELECT sum()\" on all 410 children.\r\nAlso, when doing a FEC export/import, only the 410 reference is exported to follow the administration guidelines.\r\n\r\n# Discussion\r\nPlease discuss this proposal and I will modify the SPECs accordingly."},"comment":{"url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/comments/309065015","html_url":"https://github.com/Dolibarr/dolibarr/issues/7016#issuecomment-309065015","issue_url":"https://api.github.com/repos/Dolibarr/dolibarr/issues/7016","id":309065015,"user":{"login":"kellogsgit","id":25719361,"avatar_url":"https://avatars3.githubusercontent.com/u/25719361?v=3","gravatar_id":"","url":"https://api.github.com/users/kellogsgit","html_url":"https://github.com/kellogsgit","followers_url":"https://api.github.com/users/kellogsgit/followers","following_url":"https://api.github.com/users/kellogsgit/following{/other_user}","gists_url":"https://api.github.com/users/kellogsgit/gists{/gist_id}","starred_url":"https://api.github.com/users/kellogsgit/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kellogsgit/subscriptions","organizations_url":"https://api.github.com/users/kellogsgit/orgs","repos_url":"https://api.github.com/users/kellogsgit/repos","events_url":"https://api.github.com/users/kellogsgit/events{/privacy}","received_events_url":"https://api.github.com/users/kellogsgit/received_events","type":"User","site_admin":false},"created_at":"2017-06-16T15:59:53Z","updated_at":"2017-06-16T15:59:53Z","body":"I double checked \"Memento Pratique Françis Levebvre\" (2010, old but still good):\r\n334 Structure décimale des comptes\r\n410 include all accounts from 411 to 418\r\n419 is not a children of 410 but is for depreciation.\r\n\r\nAs a result, we cannot use 410 to store client, 710 for sales, etc ..\r\nThose are really virtual accounts, which are only calculted summing children accounts from 1 to 8."}}
{"actor":{"display_login":"kellogsgit"}}