Balance sheet error

Ashish_Dhingra · August 23, 2016, 9:19pm

I am trying to access the Balance Sheet from the Balance sheet tab in Accounts Module.

Its not opening & giving this error.

nabinhait · August 29, 2016, 6:42am

Seems like nestedset model for account is broken. Can you please run rebuild_tree function from bench console?

frappe/frappe/blob/develop/frappe/utils/nestedset.py#L138


      
          	).run()
          
          
	# shift left rgts of ancestors whose only rgts must shift
          	frappe.qb.update(Table).set(Table.rgt, Table.rgt - diff).where(
          		(Table.lft < doc.lft) & (Table.rgt > doc.rgt)
          	).run()
          
          
	if parent:
          		# re-query value due to computation above
          		new_parent = (
          			frappe.qb.from_(Table)
          			.select(Table.lft, Table.rgt)
          			.where(Table.name == parent)
          			.for_update()
          			.run(as_dict=True)[0]
          		)
          
          
		# set parent lft, rgt
          		frappe.qb.update(Table).set(Table.rgt, Table.rgt + diff).where(Table.name == parent).run()
          
          
		# shift right at new parent

Ashish_Dhingra · August 29, 2016, 7:23am

Can You Please Help out with the detailed command to be processed . I am using Ubuntu 14.04 and my ERPNext is located at /home/frappe/frappe-bench

tkhamdan · September 2, 2016, 11:09pm

@nabinhait sorry for the noob question but how do you run and terminate commands from bench console? What specifically is the sequence to run rebuild_tree?

[root@admin ~]# cd /home/frappe/frappe-bench/
[root@admin frappe-bench]# bench console
Python 2.7.5 (default, Aug 18 2016, 15:58:25)
Type "copyright", "credits" or "license" for more information.

 IPython 4.0.3 -- An enhanced Interactive Python.
 ?         -> Introduction and overview of IPython's features.
 %quickref -> Quick reference.
  help      -> Python's own help system.
 object?   -> Details about 'object', use 'object??' for extra details.

 In [1]:

nabinhait · September 5, 2016, 7:44am

bench --site <your-site-name> console

And run following in the console:

from frappe.utils.nestedset import rebuild_tree
rebuild_tree('Account', 'parent_account')
frappe.db.commit()

Ashish_Dhingra · September 5, 2016, 8:51pm

Already executed these commands but problem still their.

mulyadi-agtechsg · October 27, 2016, 8:58am

Hi @Ashish_Dhingra ,

Did you managed to get this solved? I am having problem on my side too.

Thanks.

Ashish_Dhingra · November 4, 2016, 12:47am

Not Yet

hiousi · April 18, 2017, 5:59pm

I have the same problem.

ERPNext: v8.0.13 (master)
Frappe Framework: v8.0.18 (master)

mulyadi-agtechsg · May 22, 2017, 1:00am

I think one of your accounts type was changed.

For me I had to go into the database and changed the accounts type.

Ensure that all Warehouse accounts are of Asset type.

hiousi · May 29, 2017, 6:24am

Hello,

checked, all my warehouse accounts have type “stock”. Their parent accounts are root type of “asset”

does it have something to do with this thread: [Error] Warehouse balance not matching account balance ?

nabinhait · May 29, 2017, 7:22am

Please check the “Error Snapshot” for the error traceback. And share the trace along with “Locals” value.

hiousi · May 29, 2017, 10:15am

[ERROR] 2017-05-29 12:14:15,411 | /home/frappe/frappe-bench/apps/frappe/frappe/app.py:
Site: site1.local
Form Dict: {
 "cmd": "frappe.desk.query_report.run",
 "filters": "{\"company\":\"o10c\",\"from_fiscal_year\":\"2017\",\"to_fiscal_year\":\"2017\",\"periodicity\":\"Monthly\",\"accumulated_values\":1}",
 "report_name": "Balance Sheet"
}
Request Error
Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/app.py", line 55, in application
    response = frappe.handler.handle()
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 21, in handle
    data = execute_cmd(cmd)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/handler.py", line 52, in execute_cmd
    return frappe.call(method, **frappe.form_dict)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 907, in call
    return fn(*args, **newargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/desk/query_report.py", line 94, in run
    res = frappe.get_attr(method_name)(frappe._dict(filters))
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/balance_sheet/balance_sheet.py", line 16, in execute
    accumulated_values=filters.accumulated_values)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 135, in get_data
    calculate_values(accounts_by_name, gl_entries_by_account, period_list, accumulated_values, ignore_accumulated_values_for_fy)
  File "/home/frappe/frappe-bench/apps/erpnext/erpnext/accounts/report/financial_statements.py", line 156, in calculate_values
    d[period.key] = d.get(period.key, 0.0) + flt(entry.debit) - flt(entry.credit)
AttributeError: 'NoneType' object has no attribute 'get'
[ERROR] 2017-05-29 12:14:15,423 | /home/frappe/frappe-bench/apps/frappe/frappe/utils/error.py:
New Exception collected with id: 2017-05-29 12:14:15.412359-192.168.1.52-26b

is what you need?

nabinhait · May 29, 2017, 10:35am

No, this is not which I was asking. There is “Error Snapshot” document inside the system for logging the error. Just search for “Error Snapshot” from Awesome Bar, the open the relevant record. Then copy the “Locals” value and share.

hiousi · May 29, 2017, 1:01pm

thank you @nabinhait what I get when using search is:

links in “communication” bring me to pages that as no relation with the error I encounter.

nabinhait · May 29, 2017, 1:14pm

Seems like you are not checking from Administrator login. Only Administrator has permissions for Error Snapshot doctype.

hiousi · May 29, 2017, 2:48pm

ok, now with Administrator login I can get it.

Locals

accounts_by_name {u’2 immobilisations - o10c’: {‘parent_account’: u’‘, ‘rgt’: 6L, ‘name’: u’2 i…indent’: 0, ‘account_name’: u’2 immobilisations’}, u’3 stocks et encours - o10c’: {‘parent_account’: u’‘, ‘rgt’: 22L, ‘name’: u’3 …dent’: 0, ‘account_name’: u’3 stocks et encours’}, u’31 mati\xe8res premi\xe8res et fournitures - o10c’: {‘parent_account’: u’3 stocks et encours - o10c’…‘: u’31 mati\xe8res premi\xe8res et fournitures’}, u’311 mati\xe8res premi\xe8res - o10c’: {‘parent_account’: u’31 mati\xe8res premi\xe8res… ‘account_name’: u’311 mati\xe8res premi\xe8res’}, u’312 stock pour e-commerce - o10c’: {‘parent_account’: u’31 mati\xe8res premi\xe8res… 2, ‘account_name’: u’312 stock pour e-commerce’}, u’33 encours de production de biens - o10c’: {‘parent_account’: u’3 stocks et encours - o10c’…ount_name’: u’33 encours de production de biens’}, u’331 produits en cours de production - o10c’: {‘parent_account’: u’33 encours de production de…451.670000000049, u’aug_2017’: 4451.670000000049}, u’35 stocks de produits - o10c’: {‘parent_account’: u’3 stocks et encours - o10c’…nt’: 1, ‘account_name’: u’35 stocks de produits’}, u’351 produits finis - o10c’: {‘parent_account’: u’35 stocks de produits - o10…458565e-12, u’aug_2017’: -1.8189894035458565e-12}, u’4 tiers - o10c’: {‘parent_account’: u’‘, ‘rgt’: 76L, ‘name’: u’4 … Sheet’, ‘indent’: 0, ‘account_name’: u’4 tiers’}, …}
accumulated_values 1
d None
entries [{‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 9, 22)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 9, 30)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 10, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 12, 6)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 18)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 19)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 1, 30)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 1, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…u’No’, ‘posting_date’: datetime.date(2017, 4, 3)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}]
entry {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 9, 22)}
gl_entries_by_account {u’311 mati\xe8res premi\xe8res - o10c’: [{‘account’: u’311 mati\xe8res premi\xe8res - o10…u’No’, ‘posting_date’: datetime.date(2016, 9, 1)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…u’No’, ‘posting_date’: datetime.date(2016, 9, 1)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…u’No’, ‘posting_date’: datetime.date(2016, 9, 7)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…‘No’, ‘posting_date’: datetime.date(2016, 10, 3)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 13)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 17)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 17)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’311 mati\xe8res premi\xe8res - o10…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, …], u’312 stock pour e-commerce - o10c’: [{‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 13)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 17)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 17)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 17)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 20)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 20)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 20)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 22)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 27)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 10, 29)}, {‘account’: u’312 stock pour e-commerce - o10c’,…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’312 stock pour e-commerce - o10c’,…‘No’, ‘posting_date’: datetime.date(2016, 11, 2)}, {‘account’: u’312 stock pour e-commerce - o10c’,…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’312 stock pour e-commerce - o10c’,…‘No’, ‘posting_date’: datetime.date(2016, 11, 7)}, {‘account’: u’312 stock pour e-commerce - o10c’,…‘No’, ‘posting_date’: datetime.date(2016, 11, 7)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 11, 15)}, {‘account’: u’312 stock pour e-commerce - o10c’,…No’, ‘posting_date’: datetime.date(2016, 11, 17)}, …], u’331 produits en cours de production - o10c’: [{‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’331 produits en cours de productio…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, …], u’351 produits finis - o10c’: [{‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 18)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 19)}, {‘account’: u’351 produits finis - o10c’, ‘debit…No’, ‘posting_date’: datetime.date(2016, 10, 20)}, …], u’4011 fournisseurs, achats de biens et prestations de services - o10c’: [{‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 9, 22)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 9, 30)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 10, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2016, 12, 6)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 18)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 19)}, {‘account’: u’4011 fournisseurs, achats de biens…No’, ‘posting_date’: datetime.date(2016, 12, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 1, 30)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 1, 31)}, {‘account’: u’4011 fournisseurs, achats de biens…u’No’, ‘posting_date’: datetime.date(2017, 4, 3)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}, {‘account’: u’4011 fournisseurs, achats de biens…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}], u’4081 Factures non parvenues de biens et services - o10c’: [{‘account’: u’4081 Factures non parvenues de bie…u’No’, ‘posting_date’: datetime.date(2016, 9, 1)}, {‘account’: u’4081 Factures non parvenues de bie…u’No’, ‘posting_date’: datetime.date(2016, 9, 1)}, {‘account’: u’4081 Factures non parvenues de bie…u’No’, ‘posting_date’: datetime.date(2016, 9, 7)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2016, 9, 22)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2016, 10, 3)}, {‘account’: u’4081 Factures non parvenues de bie…No’, ‘posting_date’: datetime.date(2016, 10, 11)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’4081 Factures non parvenues de bie…No’, ‘posting_date’: datetime.date(2016, 11, 28)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2016, 12, 6)}, {‘account’: u’4081 Factures non parvenues de bie…No’, ‘posting_date’: datetime.date(2016, 12, 15)}, {‘account’: u’4081 Factures non parvenues de bie…u’No’, ‘posting_date’: datetime.date(2017, 1, 2)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 1, 30)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 5, 28)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 5, 28)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 5, 28)}, {‘account’: u’4081 Factures non parvenues de bie…‘No’, ‘posting_date’: datetime.date(2017, 5, 28)}], u’41111 d\xe9taillants - o10c’: [{‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…‘No’, ‘posting_date’: datetime.date(2016, 7, 10)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…‘No’, ‘posting_date’: datetime.date(2016, 9, 19)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 21)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 21)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 21)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 21)}, {‘account’: u’41111 d\xe9taillants - o10c’, ‘deb…No’, ‘posting_date’: datetime.date(2016, 10, 21)}, …], u’4452 TVA due intracommunautaire - o10c’: [{‘account’: u’4452 TVA due intracommunautaire - …No’, ‘posting_date’: datetime.date(2016, 12, 18)}], u’44566 TVA d\xe9ductible sur autres biens et services - o10c’: [{‘account’: u’44566 TVA d\xe9ductible sur autres…No’, ‘posting_date’: datetime.date(2016, 12, 18)}, {‘account’: u’44566 TVA d\xe9ductible sur autres…‘No’, ‘posting_date’: datetime.date(2017, 4, 12)}], u’445711 TVA collect\xe9e taux normal 20% - o10c’: [{‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 9, 19)}, {‘account’: u’445711 TVA collect\xe9e taux norma…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’445711 TVA collect\xe9e taux norma…No’, ‘posting_date’: datetime.date(2016, 10, 16)}, {‘account’: u’445711 TVA collect\xe9e taux norma…No’, ‘posting_date’: datetime.date(2016, 10, 26)}, {‘account’: u’445711 TVA collect\xe9e taux norma…No’, ‘posting_date’: datetime.date(2016, 10, 26)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 1)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 3)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 3)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 3)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 3)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, {‘account’: u’445711 TVA collect\xe9e taux norma…‘No’, ‘posting_date’: datetime.date(2016, 11, 4)}, …], …}
ignore_accumulated_values_for_fy False
period {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 1, 31), u’key’: u’jan_2017’}
period_list [{u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 1, 31), u’key’: u’jan_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 2, 28), u’key’: u’feb_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 3, 31), u’key’: u’mar_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 4, 30), u’key’: u’apr_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 5, 31), u’key’: u’may_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 6, 30), u’key’: u’jun_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 7, 31), u’key’: u’jul_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 8, 31), u’key’: u’aug_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), … datetime.date(2017, 9, 30), u’key’: u’sep_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), …datetime.date(2017, 10, 31), u’key’: u’oct_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), …datetime.date(2017, 11, 30), u’key’: u’nov_2017’}, {u’year_end_date’: datetime.date(2017, 12, 31), …datetime.date(2017, 12, 31), u’key’: u’dec_2017’}]

hiousi · May 29, 2017, 4:54pm

I have solved the problem I’ve just edited, without changing anything and then saved all accounts in the chart recursively. What was wrong? I will not know.

thank you @nabinhait, with you I have learned how to use Error Snapshot to know more about an error.

nabinhait · June 2, 2017, 8:47am

If saving the accounts solved the issue, then it might related to lft and rgt values which are used for nested set model. On saving, it reassign those values.