Odoo Addons (MOVED TO GITHUB)

[7.0] Wrong entry generated on expenses

Bug #1181283 reported by Frederic Clementi - Camptocamp on 2013-05-17

This bug affects 4 people

	Status	Importance	Assigned to
Odoo Addons (MOVED TO GITHUB)	New	Undecided	OpenERP Publisher's Warranty Team
OpenERP Community Backports (Addons)	Status tracked in 7.0
7.0	Fix Released	Undecided	Unassigned

Bug Description

Wrong entries generated if on you expenses you have a product with a vat 'tax included' or tax 0% (even with no tax code set up on vat amount ... only on base amount)

please see my print screen attached

Tags:

Related branches

lp:~openerp-dev/openobject-addons/7.0-opw-596243-han

Ready for review for merging into lp:openobject-addons/7.0

Vincent Renaville@camptocamp (community): Needs Fixing on 2013-11-21

Naresh(OpenERP): Pending requested 2013-08-27

lp:~camptocamp/ocb-addons/7.0-fix-1181283

Superseded for merging into lp:ocb-addons

Yannick Vaucher @ Camptocamp: Needs Fixing (differ from opw) on 2013-11-06

Holger Brunn (Therp): Needs Information on 2013-10-14

lp:~camptocamp/ocb-addons/ocb-addons-hr_expense-tax_vre

Merged into lp:ocb-addons at revision 10002

Yannick Vaucher @ Camptocamp: Approve on 2014-03-13

Holger Brunn (Therp): Approve (code review) on 2013-12-02

lp:~arthru/ocb-addons/fix-1181283

Rejected for merging into lp:ocb-addons

Yannick Vaucher @ Camptocamp: Disapprove on 2014-03-13

Holger Brunn (Therp): Needs Information on 2014-02-10

Revision history for this message

Frederic Clementi - Camptocamp (frederic-clementi) wrote on 2013-05-17:

1.png Edit (243.2 KiB, image/png)

Revision history for this message

Frederic Clementi - Camptocamp (frederic-clementi) wrote on 2013-05-17:

EXPENSES_ENTREIS.ods Edit (20.8 KiB, application/vnd.oasis.opendocument.spreadsheet)

Please see the entry that should be generated in ods doc attached

Revision history for this message

qdp (OpenERP) (qdp) wrote on 2013-05-22:

hello,

i just fiexd one issue, thanks to the vigilence of camptocamp, regarding the amount on payable account when the tax is included.

But there is a second bug in the print screen of Frédéric: the tax amount is in the wrong column (credit instead of debit) and, unfortunatelly i'm not able to reproduce this bug. I wonder if it's not simply a configuration error as i checked at my side and i'm having the same results as for a supplier invoice using the same tax.

Can you check or provide more info on the tax used? are you sure this tax is correct and give the expected results in a supplier invoice?

Thanks

Changed in openobject-addons:
status:	New → Incomplete

Revision history for this message

Frederic Clementi - Camptocamp (frederic-clementi) wrote on 2013-05-31:

Camptocamp global expenses fix Edit (2.8 KiB, text/plain)

the c2c patch...

In case someone need it

Revision history for this message

Frederic Clementi - Camptocamp (frederic-clementi) wrote on 2013-05-31:

but for this specific issue lets close the bug report

Thanks quentin

Revision history for this message

Twinkle Christian(OpenERP) (tch-openerp) wrote on 2013-06-03:

Hello Frederic,

As per your comment #5, I am closing this issue.

Thanks for your answer.

Changed in openobject-addons:
status:	Incomplete → Invalid

Revision history for this message

Frederic Clementi - Camptocamp (frederic-clementi) wrote on 2013-07-08:

VAT_expenses_problems.odt Edit (226.2 KiB, application/vnd.oasis.opendocument.text)

J'ai toujours des problèmes au niveau des notes de frais.

Je viens de faire un test sur : http://7-0-14300.runbot.openerp.com/?db=7-0-14300-base&ts=1372081698142#id=12 avec l10n_fr installé.

la param des TVA TTC me semble juste et pourtant j'ai une écriture complètement fausse -> jetes un oeil au fichier odt attaché.

En plus, la note de frais ignore le type de tva sur le produit que je choisi (ex: car travel a une TVA taxes excluded mais au niveau de l'expense line, il n'en tient pas compte)

Merci

Naresh(OpenERP) (nch-openerp) on 2013-07-09

tags:

added: maintenance

Revision history for this message

Martin Trigaux (OpenERP) (mat-openerp) wrote on 2013-07-23:

Hello Frederic,

Related to your last message, I don't think there is a problem in your screenshot. The tax is computed when generating accounting entries, it is not reflected on the expense lines.

My tests showed nothing wrong about the generated entries. Could you check again and tell me more what you believe is wrong ?

Regards

Revision history for this message

Franck Blettner (franck-blettner) wrote on 2013-08-31:

#10

Hi Martin, Frederic,

I've the same problem than Frederic, accounting entries are incorrect (Credit instead of debit). I've find a workaround by creating Expense Tax based on the same account than Purchase Tax. (Copy ACH-19.6 to FR-19.6... for all taxes) but change the sign of the coef (1 instead of -1)
This is a workaround but for me there is a bug in the expense module when generetad accounting entries.

Franck

Revision history for this message

Yannick Vaucher @ Camptocamp (yvaucher-c2c) wrote on 2013-09-04:

#11

I am reopenning this bug report as it was followed through OpenERP support ticket