l10n_chart_us_{general,service} configuration fails withnull value in column "type_tax_use" violates not-null constraint

[Allan Wind]

Both l10n_chart_us_general and l10n_chart_us_service fail to install with the following:

Warning

null value in column "type_tax_use" violates not-null constraint

Based on input from Jan Verlaan and looking at other chart of accounts I added the following to account_tax.xml:

                        <field name="ref_tax_code_id" ref="vat_code_payable"/>
+ <field name="type_tax_use">sale</field>

This is against ~openerp-commiter/openobject-addons/trunk-extra-addons, revno: 3568.

Without a chart of account I don't think the accounting facility is useful to anyone in the us.

[Jay Vora (Serpent Consulting Services) (jayvora)]

This is not the problem of this particular module.
Thanks for the notification.

[Jay Vora (Serpent Consulting Services) (jayvora)]

fixed in rev 2224.
Thanks.

[Philippe Clérié (pclerie)]

I downloaded this chart of account from the branch mentioned above and it still does not work. Adding the field in the xml file did work.

For what it's worth:

1) If a chart of account does not apply correctly during installation, perhaps there should be a way to back out and try another one. As it is, the module does install, or at least it is listed as installed after the configuration failed.

2) I tried to uninstall the module. In fact I removed all the modules that installed together at the time: sales, account_chart, account and l10n_chart_us_general. Then I tried to reinstall them. I got an error. (Darn! Plasma just died on me again while I was trying to retrieve the back trace. But I can tell you it was a list index out of range error while executing line 518 in orm.py. Best I can do for now. Sorry.)

Regards
Philippe

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Philippe,

Make sure you have the latest code for openobject-addons.
This bug does not exist anymore.

Can you tell me the revision no. of openobject-addons you use?

Thanks.

[Syd Alsobrook (syd-ittagteam)]

I have this problem with trunk revision 3598 and 3612.

[Mantavya Gajjar (Open ERP) (mga)]

Hello Syd Alsobrook ,

This is already fixed in trunk addons
by supplying the dault type to the `all` so it will not give the error for this field
'type_tax_use': lambda *a: 'all',

so no need to add any line in to the account_tax.xml, if specially you want to change type from all => sale

[Syd Alsobrook (syd-ittagteam)]

I am not sure if I follow. Here are my steps

1) import module
2) Schedule install
3) Apply Scheduled Upgrades
4) Config wizard
5) On the Gen CoA from Template screen I click create. This is when I receive the error.

"null value in column "type_tax_use" violates not-null constraint"

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hi sys Alsobrook,

This error does not exist anymore.
I request you to check the fields of account.tax.template from the menu Financial Management/Configuration/Financial Accounting/Templates/Tax Templates.

Make sure the field is not empty anywhere.

Thanks.

[Yvan Reichenbach (yvan-netcall)]

This error does not exist anymore??
It does mate!
I had the same problem with l10n_chart_au.
There is no fix yet.

Regards
Yvan

On Fri, 27 Mar 2009 04:38:18 pm Jay (Open ERP) wrote:
> Hi sys Alsobrook,
>
> This error does not exist anymore.
> I request you to check the fields of account.tax.template from the menu
> Financial Management/Configuration/Financial Accounting/Templates/Tax
> Templates.
>
> Make sure the field is not empty anywhere.
>
> Thanks.
>
>
> ** Changed in: openobject-addons
> Status: In Progress => Fix Released

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hi Yvan,

Can you please tell me which revisions do you use for addons?

Thanks.

[Syd Alsobrook (syd-ittagteam)]

That got it. I had to clean out some cruft from previous attempts. Additionally I had to set the Sales Tax type to sales in the path you provided.

[Jay Vora (Serpent Consulting Services) (jayvora)]

No, you dont need to code a single line for this.
Make a fresh install and try it.

[stony (stony-grunow)]

I had the same problem, but downloaded the server, addons, and extra-addons from trunk as suggested.

(I downloaded the web-client using easy_setup because they are changing the configuration right now, and was getting errors when installing that from trunk).

It worked! UK Chart of accounts appeared perfectly.

Thanks Jay