-->
Welcome, Guest
Username: Password: Remember me

TOPIC: Error creating financial account in v7.0.3

Error creating financial account in v7.0.3 1 week 4 days ago #34055

  • com4WEB
  • com4WEB's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
hello,

I create a new chart of account model [ DE_SKR04 - SKR 03 - DE - activ ]

(dolibarr/htdocs/accountancy/admin/accountmodel.php?id=31&mainmenu=accountancy&leftmenu=accountancy_admin)

and want to add financial accounts to this chart of account
(dolibarr/htdocs/accountancy/admin/account.php?mainmenu=accountancy&leftmenu=accountancy_admin)

with account-no like '100', '200' or '1000'
but dolibarr cuts off the NULL 'x000' -> 'x'

Any idea?

Can I edit this direct in llx_accounting_account (e.g. with phpmyadmin)
or is there more necessary?
The administrator has disabled public write access.

Error creating financial account in v7.0.3 1 week 4 days ago #34056

  • yves57
  • yves57's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 46
  • Thank you received: 8
  • Karma: 2
Hello,
I think this is a feature.
Even if the code is stored by trimming the right 0, the code is still displayed with 0 filled until the specified number for the length of the code (6 by default).
Do you need anything else?
The administrator has disabled public write access.

Error creating financial account in v7.0.3 1 week 3 days ago #34057

  • com4WEB
  • com4WEB's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
hello,


it is not a feature, because every tail with '0' is cut.
and i can not edit this.

but we need
#100
#200
#1000
,,,
The administrator has disabled public write access.

Error creating financial account in v7.0.3 1 week 3 days ago #34058

  • com4WEB
  • com4WEB's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
I see now in debug mode:

Warning: fopen (//www/dolibarr/htdocs/install/mysql/data/llx_accounting_account_de.sql): failed to open stream: No such file or directory in \\www\dolibarr\htdocs\core\lib\admin.lib.php on line 141


it exists no llx_accounting_account_de.sql file

and in llx_accounting_abc.sql is no area for Germany


Is this the problem?
The administrator has disabled public write access.

fix llx_accounting_abc.sql for germany 1 week 3 days ago #34059

  • com4WEB
  • com4WEB's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
Is it possible to edit llx_accounting_abc.sql
and add something like this:

-- Description of chart of account DE SKR-03
INSERT INTO llx_accounting_system (fk_country, pcg_version, label, active) VALUES ( 5, 'DE-SKR03', 'SKR 03', 1);


and than run dolibarr upgrade
or what is the way?
The administrator has disabled public write access.

Error creating financial account in v7.0.3 1 week 3 days ago #34060

  • com4WEB
  • com4WEB's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 16
  • Karma: 0
hello,

if I type in account number
e.g. 12300
than dolibarr cut it off to 123

but if I type
12300_ ( _ = space bar)
it works
Attachments:
The administrator has disabled public write access.
Time to create page: 0.074 seconds