Hi Colin, Yes that would of course be one possible solution. Although in the form of a bolt-on fix. 2640 (in my case) is the account where VAT IN is collected via the automatic tax functions so the report would be correct if tailored to simply fetch everything on this account.
But I would be much more comfortable if I could somehow utilize the standard functions. This would also keep the tax "graph" in openerp intact. The easiest solution would be if a could configure an account with a default tax CODE/Account rather than a default tax. The Journal Entries gives me the possibility to tag with a tax account, rather than a tax. I cannot see why this is not made possible on the actual account configuration. Maybe it could be added with a module but I would have to make sure that the tax move only happens during manual journal entries and not the automatic ones, to ensure that I dont get double tax transfers on automatic entries that effect the 2640 account. The easiest solution would be to alter the journal entry form so that when account 2640 is chosen the tax account is automatically set to 48 (in my case). Dont know if this is possible Regards david -- David Rinnan Business Consultant ASPIRIX AB email: [email protected] 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....@lists.launchpad.net > > [openerp-expert-accounting-bounces+colin=publicus-solutions....@lists.launchpad.net] > On Behalf Of David Rinnan [[email protected]] > Sent: 12 May 2011 13:14 > To: [email protected] > 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: [email protected] > 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: [email protected] >> 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 : [email protected] >> Unsubscribe : https://launchpad.net/~openerp-expert-accounting >> More help : https://help.launchpad.net/ListHelp > > > _______________________________________________ > Mailing list: https://launchpad.net/~openerp-expert-accounting > Post to : [email protected] > Unsubscribe : https://launchpad.net/~openerp-expert-accounting > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openerp-expert-accounting Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-expert-accounting More help : https://help.launchpad.net/ListHelp
