openerp-expert-accounting team mailing list archive

[David Rinnan <david@xxxxxxxxxx>]

Terribly sorry to spam. 

My alternative solutions failed since taxes added on accounts as a default tax does not work at all in manually added journal entries. 

I added a tax of 100% to an account called 2640 which is the incoming vat balance account. 
I made a manual entry where I debited the account and nothing happened. 

I.e. default taxes on accounts do not come into effect during manual journal entries. So it was much worse than I thought. 
as far as I can see no way to solve it other than via hacks or manual tax code and tax base value entries. 

a) skip openerps TAX functions and simply have your own report that fetch data from account in your book keeping 
b) manually enter tax account and tax base amount for each manual journal transaction that should generate tax in the report 

Solution a) is probably the only one acceptable for a bookkeeper. It just hurts my technical brain to abandon existing functionality


Regards
david 


--
David Rinnan
Business Consultant

ASPIRIX AB
email:    david.rinnan@xxxxxxxxxx
phone:  +46 707 16 38 00
skype:   david.rinnan
twitter:   davidrinnan

Open Source Business Solutions

12 maj 2011 kl. 15.04 skrev David Rinnan:

> An alternative, 
> 
> account 2640 is the balance account where all incoming VAT is stored. 
> I can create a tax called 100% and add that 100% tax as a default tax on the account 2640. 
> It would solve my problem but I am worried that automatic taxes (via supplier invoices) that via the tax module generate a move towards 2640 would be doubled. 
> Do the taxes work like that, making a double entry or even worse an infinite loop? 
> 
> An alternative would be to ask the bookkeepers to use an account called 2641 for manual journal entries. That account would have the 100% tax configured on it self. So in essence would automatically be transferred in full to account 2640 and tagged with the correct tax account/code for the tax report. 
> 
> Thoughts? 
> 
> /david  
> 
> --
> David Rinnan
> Business Consultant
> 
> ASPIRIX AB
> email:    david.rinnan@xxxxxxxxxx
> phone:  +46 707 16 38 00
> skype:   david.rinnan
> twitter:   davidrinnan
> 
> Open Source Business Solutions
> 
> 12 maj 2011 kl. 14.19 skrev Colin MacMillan:
> 
>> Hello David,
>> 
>> Unfortunately I think the only solution is to modify the report so your 'manual bookings' are taken into account.
>> 
>> I have encountered a similar problem with the default debtors/creditors reports when trying to handle customer ledgers entered with an opening journal.  The report is unable to distinguish the correct balances.
>> 
>> Kind regards,
>> Colin
>> 
>> 
>> ________________________________________
>> From: openerp-expert-accounting-bounces+colin=publicus-solutions.com@xxxxxxxxxxxxxxxxxxx [openerp-expert-accounting-bounces+colin=publicus-solutions.com@xxxxxxxxxxxxxxxxxxx] On Behalf Of David Rinnan [david@xxxxxxxxxx]
>> Sent: 12 May 2011 13:14
>> To: openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>> Subject: Re: [Openerp-expert-accounting] VAT in manual bookings
>> 
>> I am sorry to bump this but I am a little bit desperate to find a solution. I am assuming that I am not the first person who have had this issue.
>> 
>> We have configured our taxes to work on products rather than accounts. This is great for supplier and customer invoices generated via the respective modules/forms.
>> 
>> However, once we want/need to make manual bookings (journal entires) it becomes a problem.
>> 
>> It could be a collection of various petty costs or supplier invoices that for some reason will be booked manually.
>> We list each cost entry and towards the end of the journal entry we add the VAT in one lump sum. The VAT amount will end up in the balance sheet correctly on the given account (in our case 2640) but it will not show up on the tax report.
>> 
>> Is there some way to make it so that the amounts forwarded to the account (2640 in our case) also ends up on the tax report without having to manually add tax code each time on the journal entry.
>> 
>> Regards
>> david
>> 
>> 
>> 
>> 
>> 
>> --
>> David Rinnan
>> Business Consultant
>> 
>> ASPIRIX AB
>> email:    david.rinnan@xxxxxxxxxx
>> phone:  +46 707 16 38 00
>> skype:   david.rinnan
>> twitter:   davidrinnan
>> 
>> Open Source Business Solutions
>> 
>> 10 maj 2011 kl. 17.33 skrev David Rinnan:
>> 
>>> When I sell or purchase via customer and supplier invoices the VAT works great.
>>> 
>>> But when I create a manual journal entry I have x number of items which constitutes costs and then one single entry which, in my case, is booked on account 2640. that whole amount, manually calculated, is VAT for all items in the journal entry. Nothing goes to the tax report, of course, since the account in question has not been configured.
>>> 
>>> If I were to add the 25% VAT I use for supplier invoices only 25% of the amount moved to 2640 would be generated to the tax report.
>>> 
>>> Also, the above tax (25%) is configured to take the VAT amount and move it to account 2640 so I suspect I would be caught in an infinite loop.
>>> 
>>> 
>>> the problem would be solved if I could tie an account to a tax code rather than the full tax entity. This is possible to do on the journal entry but will then have to be done every-time I book something against that account.
>>> 
>>> 
>>> Do I have to create a new tax called 100%?
>>> 
>>> 
>>> In desperate hope of a reply :)
>>> 
>>> Cheers
>>> david
>>> 
>>> --
>>> David Rinnan
>>> Business Consultant
>>> 
>>> ASPIRIX AB
>>> email:    david.rinnan@xxxxxxxxxx
>>> phone:  +46 707 16 38 00
>>> skype:   david.rinnan
>>> twitter:   davidrinnan
>>> 
>>> Open Source Business Solutions
>>> 
>>> 
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~openerp-expert-accounting
>>> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
>>> More help   : https://help.launchpad.net/ListHelp
>> 
>> 
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openerp-expert-accounting
>> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
>> More help   : https://help.launchpad.net/ListHelp
> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-expert-accounting
> Post to     : openerp-expert-accounting@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-expert-accounting
> More help   : https://help.launchpad.net/ListHelp