Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to filter for accounting entries without taxes for sales and or puchases?

By
michel Guénard
on 6/17/14, 9:11 AM 1,012 views

Does anyone know how to list those entries in the P/L accounts (expenses or revenues) for which no tax (recoverable or payable) has been recorded?

This is an audit need to make sure the accounting books are kept in accordance with tax regulations.

0

Els Van Vossel (evv)

--Els Van Vossel (evv)--
2008
| 6 3 7
Belgium
--Els Van Vossel (evv)--

Author of some OpenERP / Odoo books

Els Van Vossel (evv)
On 6/17/14, 9:35 AM

Go to Accounting > Journal Entries > Journal Items. Select the required journal (e.g. Sales or Purchases) and period (or empty it) and search for the corresponding P/L account in the filter box. In the Advanced Search option of the filter box, select Tax Account is not set. 

Thanks; I got the list of entries for accounts that have no tax being set but accounting entries are showing taxes; I would like a selection of the accounting entries themselves (debit and credit and no tax account entry)! Seems out of range for Odoo.

AD LIBITOM, michel Guénard
on 6/17/14, 10:10 AM
Try the filter Tax account is not set to display journal items with no tax account entry.

On 06/17/2014 04:10 PM, Ad Libitom wrote:
<blockquote cite="mid:1403014217.095232009887695.030620848691853-openerp-54574-forum.post@openerp.v7.openerp.com" type="cite">

Thanks; I got the list of entries for accounts that have no tax being set but accounting entries are showing taxes; I would like a selection of the accounting entries themselves (debit and credit and no tax account entry)! Seems out of range for Odoo.

La musique sans limite

Sent by OpenERP S.A. using OpenERP. Access your messages and documents in Odoo
Els Van Vossel
on 6/17/14, 10:15 AM

@Evv: in addition to my request, what are the consequences for the accounting when a tax code is missing a book account declaration? I am facing this situation (forgot to declare an account on a tax code); entries have been made and I suspect that no tax have been recorded; this is my issue.

AD LIBITOM, michel Guénard
on 6/17/14, 10:21 AM

I don't know the exact situation for France, but you should be able to post a correction entry and then declare the correction with the next VAT return.

Els Van Vossel (evv)
on 6/17/14, 10:25 AM

Try the filter "Tax account is not set" to identify journal items without tax.

Els Van Vossel (evv)
on 6/17/14, 10:26 AM
of course, yes a correction is allowed; but the issue is to identify what needs to be corrected; thanks for your time
Le 17/06/2014 16:25, Els Van Vossel (evv) a écrit :
<blockquote cite="mid:1403015120.398921012878418.271360866449121-openerp-54574-forum.post@openerp.v7.openerp.com" type="cite">

I don't know the exact situation for France, but you should be able to post a correction entry and then declare the correction with the next VAT return.

--
Els Van Vossel (evv) Sent by OpenERP S.A. using OpenERP. Access your messages and documents in Odoo
AD LIBITOM, michel Guénard
on 6/17/14, 12:07 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/17/14, 9:11 AM
Seen: 1012 times
Last updated: 3/16/15, 8:10 AM