multiple taxes and price difference account

[Diego Guzman]

Hi:

I have this scenario (account_anglo_saxon module installed):

1.Product A:
-Fixed price
-Purchase taxes: tax1, tax2, tax3.
-Price difference account: 7xx

2.Next I create PO, then receive the product and all stock movements are all right.

3.Then I create the invoice but in the account movement created found that the system repeat 3 times (number of taxes) the account of the price difference.

Example:

This is the system's actual behavior:

account........................Debit.....Credit
22xx Vendor account......................233250
23xx Tax1..................................3000
24xx Tax2......................12000
23xx Tax3...................................750
71xx Price diff acc........................2500
71xx Price diff acc........................2500
71xx Price diff acc........................2500
14xx Product..................77500
14xx Product..................77500
14xx Product..................77500

The correct movement should be:

account........................Debit.......Credit
22xx Vendor account........................83250
23xx Tax1..................................3000
24xx Tax2......................12000
23xx Tax3....................................750
71xx Price diff acc.........................2500
14xx Product...................77500

Is this a bug?

DG

[Vinay Rana (OpenERP) (vra-openerp)]

Hello,

Would you please elaborate more the specified example which includes price, tax rates and invoice total.

Thanks.

[Diego Guzman (dguzman)]

Hi Vra:

Product1:
-Supply method: buy
-Procure method: make to stock
-Cost method: standard
-Price difference account: 71010101 (type expense)
-stock input account: 14351002 (type asset)
-stock output account: 14351003 (type asset)
-Price: COL$ 658.oo
Purchase taxes:
-Tax1: account 23654001, rate = -0,035
-Tax2: account 24080201, rate = 0,16
-Tax3: account 23680503, rate = -0,0066

Purchase order:

Vendor:
-account: 22050501 (type cash)
Product1:
-Qty: 10 Meters
-Price: COL$ 656,50
Stock Location:
-Name: XX
-account: 14050501 (type asset)

Stock input movement:

-pack52
-Debit: 6580,oo - account 14050501
-Credit: 6580,oo - account 14351002
O.K.

Invoice:

Purchase journal: type purchase
To pay: COL$ 7342,29
Base: COL$ 6565,00
Taxes: COL$ $777,29 (Tax1: base * -0,035 = -229,78; Tax2: base * 0,16 = 1050,40; Tax3: base * -0,0066 = -43,33)
O.K.

Account movement (WRONG):
-Debit: COL$ 20790,40
Tax2 account 24080201 COL$1050,40
Stock input account 14351002 COL$6580
Stock input account 14351002 COL$6580
Stock input account 14351002 COL$6580

-Credit: COL$ 20790,40
Vendor account 22050501 COL$20472,29
Tax1 account 23654001 COL$229,78
Tax3 account 23680503 COL$ 43,33
Price difference account 71010101 COL$15
Price difference account 71010101 COL$15
Price difference account 71010101 COL$15

If you need more information, please tell me.

Best regards

DG

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello Diego Guzman,

I went through the scenario as you describe above, but could not find the duplicate moves. Here i m attaching a printscreen.
can u please check this with our latest revision!! currently i m closing this bug, if you still getting any problem, please reopen it.

Thanks
PSI

[Diego Guzman (dguzman)]

Hi psi:

You forgot install the account_anglo_saxon module. The problem appears when install the module account_anglo_saxon. If you see the initial description of the bug I said it in parentesis, maybe you see only the second description of the bug.

In order to reopen the bug, I have to rewrite in a new bug descrition or we can continue here?

Thanks a lot!!

DG

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello Diego Guzman,

I checked the scenario with account_anglo_saxon module installed. The price difference account come in action once the account_anglo_saxon module is installed. If you are still getting same error can you provide us dump database for our reference

Thanks

[Diego Guzman (dguzman)]

Hi psi:

Thanks for your response. I send you an internal mail. If you need more information please tell me.

Best regards

DG

[Diego Guzman (dguzman)]

Dump database...

[Purnendu Singh (OpenERP) (purnendu-singh)]

Hello Diego Guzman,

Thanks for your response and support. Will you please tell us the revision no off your addons!! It seems this bug is fixed with the latest addons. So, please update the addons and let us inform if you still getting this bug.

Thanks

[Diego Guzman (dguzman)]

Hi psi:

I downloaded this branch: bzr branch lp:openobject-addons.
Then I update the account_anglo_saxon module but the system don't recognize it because there is no _terp_.py file, instead there is _openerp_.py file.
I renamed the _openerp_.py file with _terp_.py and the system recognize it.
Now I have a new problem: there is a lot of dependencies that are not in the system and other modules don't work, like product module.
Question: If I use any module of the branch: openobject-addons I need to make a special installation of the server? what modules I have to change in order to avoid system crashes?

Best regards

DG

[Anup(SerpentCS) (anup-serpent)]

Hello Diego,

    As you have mentioned that you get the error for the __openerp__.py file, it means that your code is of trunk(6.0) and you have the server of stable(5.0). You have got the branch of 6.0 but you need to have the branch of 5.0 bzr branch lp:openobject-addons/5.0. Please download this branch and recheck the issue.

    I have checked the same with the latest code but I was unable to meet the error with the stable (5.0). And do update your server from the branch lp:openobject-server/5.0.

Please notify if the error still exists at your end.
Thanks.

[Diego Guzman (dguzman)]

Hi Anup:

I downloaded the branch lp:openobject-addons/5.0 but the module account_anglo_saxon is not there. Then I downloaded the branch lp:openobject-addons/extra-5.0 and there is account_anglo_saxon.
The error still exist.
Note: I have installed the module l10n_chart_co (Colombia chart of accounts). What chart of accounts have you been using in your test ?

Best regards

DG

[Diego Guzman (dguzman)]

Hi All:

I made two test:

Test 1:
Tax1, Tax2, Tax3 WITHOUT Base Code and Tax Code assigned in "Tax Declaration" folder.
Test 1 result: The system works OK, the invoice movement is OK.

Test 2:
Tax1, Tax2, Tax3 WITH Base Code and Tax Code assigned in "Tax Declaration" folder.
Test 2 result: The invoice movement is WRONG, for every tax the system creates a line in the invoice movement and for this reason the value of the supplier account is multiply by 3 (because in this test I use 3 taxes).

Is this a bug or is a problem with the configuration of Tax Codes?

Best regards

DG

[Juan (emailkongayon)]

Hi, I'm also encountering this bug. Has it already been fixed? Thanks

[Zaki Reza (zakireza+openerp)]

Has this issue been resolved?

I am facing this issue too - multiple taxes (not child taxes) cause OpenERP to compute base amount multiplied by the number of taxes.

1000 = base amount
11 = Tax 1
12 = Tax 2
13 = Tax 3
------------------------------
1000 = Total
36 = Taxes Total
------------------------------
1036 = Invoice Total

However, after this, what happens is that the BASE amount for this transaction is added thrice to it ends up being 3000 instead of 1000....