(English) VAT on payment treatment with OpenERP

Tags: • • •

Ci spiace, ma questo articolo è disponibile soltanto in English.

Facebook Twitter Linkedin Digg Delicious Reddit Stumbleupon Tumblr Posterous Email Snailmail

Written by on lunedì, ottobre 15th, 2012

Lorenzo Battistini
OpenERP addicted
GitHub profile: https://github.com/eLBati
Launchpad profile: https://launchpad.net/~elbati
Linkedin profile: http://www.linkedin.com/in/elbati
------------------------------------------------
Agile Business Group
  • R T

    hi, are you updating this module for v7?

  • Togar Hutabarat

    Awesome!!
    Perfect just like what I need, guys.. Thank you..

    If there anybody who have tested these modules, and found anything wrong (bugs) with the modules, please let eLBati himself know.. And since I am also a developer, I’ll be happy to know the bugs too.

    Best regards.

    • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

      Hello Togar, Thanks for the feedback!
      Are you using it on OpenERP 7 ?

      • Togar Hutabarat

        I have tested the module on both v6.1 and v7.0, and it works well.
        You’re welcome Lorenzo 🙂

        #update
        I mean it works well without any changes on v6.1. But for v7.0, we have to do some modification on XML file since OpenERP v7.0 have different XML structure.

  • Ian Going

    Hi,

    This is exactly what I’m looking for! Thank you. However, I seem to be having some problems (which I’m hoping are due to something missing in the set-up):

    Firstly, I am using the community edition of odoo 8, running on Ubuntu – and I have intstalled the latest account_vat_on_payment module. Now for the set-up (following your guide).

    I have created 4 shadow accounts SCoA, DS, PSS, TRS. SCoA is a view under the main Company View (I quickly found that it odoo couldn’t post journals with SCoA not nested). Is this correct?

    Your guide mentions setting the ‘real’ accounts for PSS & TRS, but not DS – is this deliberate?

    I then created the 3 tax codes: ‘shadow root’ (without parent), ‘shadow taxable sales’ and ‘shadow tax received’.

    I created the shadow payment Journal, and linked it to the Bank journal. The shadow journal now appears in the Payment list (when paying an invoice), is this expected? I think this is because the type is Banks and Checks – should this be changed?

    OK (and now for my issue). When I create an invoice with VAT on payment treatment, I get the shadow entries on the Journal, but when I register the payment, I only get a journal debiting DS and crediting Bank. There are no entries for the ‘real’ tax to be paid. There is also no ‘reversing’ journal to correct and balance the shadow accounts. What have I done wrong?

    Thanks for any help!

    Best Regards.

    • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

      Hello Ian,
      could you provide some screenshots (or even a video) of the journal entries you get?

      • Ian Going

        Hi Lorenzo,

        I replied earlier that this issue was resolved – my issue was being caused by creating an invoice for zero amount. When I created an invoice for a positive amount, and received a payment, all entries are present.

        However, my payments are received by Bank Statement, not Customer Payments, so although I was able to generate the correct entries during testing with Customer Payments, I am not able to get the correct entries using the Bank Statement method. Is this correct? Or should I see the ‘reversing’ journal to correct and balance the shadow accounts?

        Thanks in advance

        Ian

        • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

          Bank statements support is under revision and tests at
          https://github.com/OCA/account-payment/pull/54

          You can download the module at
          https://github.com/feketemihai/account-payment/blob/vat_on_payment/account_vat_on_payment/README.rst

          Feedbacks are obviously welcome

          • Ian Going

            Thank you Lorenzo.

            Forgive my ignorance, but is there a guide for downloading and installing the module from github?

          • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

            You can download using git with

            git clone https://github.com/feketemihai/account-payment.git -b vat_on_payment

            or download zip file from https://github.com/feketemihai/account-payment/archive/vat_on_payment.zip

          • Ian Going

            Thank you!!

            Now I have downloaded,do I need to uninstall the existing module or can I upgrade directly?

            Should I copy the account-payment folder to the odoo add-ons folder?

            (Sorry for all the questions)

            Your help is much appreciated.

          • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

            Just replace your account_vat_on_payment folder with the downloaded one (account_vat_on_payment only), restart odoo and upgrade the module

  • Romain Ferraton

    First a really strong bravo for this job ! Thanks a lot ! VAT on payment should be included in main branch of odoo in my opinion…

    I use odoo V8 (linux)
    I follow your guide but for a French accounting.

    I think that create views accounts up to a top root view account is very useful to clean charts accounts.

    A graph with shadow account mapping and parent/child account relationships for customer invoices scope is attached to my post, may that will help french users. The same needs to be done for supplier invoices scope…

    The list of my shadows accounts (for the moment) is also attached (French accounting / comptabilité française)

    I think i will write a more complete article on the subjet on my website : http://www.polymorphe.org in a few days

    hope that helps !

    Romain

    • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

      Thank you Romain, just added an update to the post

      • Romain Ferraton

        Sure !

  • Pendouss

    Hii ,
    good job for this module! is there a version for odoo 9?

    • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

      Hi, in odoo 9 this functionality is already handled by core module account_tax_cash_basis https://github.com/odoo/odoo/tree/9.0/addons/account_tax_cash_basis

      • Romain Ferraton

        Hello Lorenzo, is there a method, guide or tools when migrate from 8 with vat on payment module to v9 or v10 with cash bases taxes ?

        • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

          AFAIK, no

  • Michele Pellegrini

    Buongiorno Lorenzo,
    sto cercando un modulo VAT sull’incassato/pagato ma per la versione 10 di odoo (per la Svizzera).
    Ho visto che avete creato il modulo ma le versioni precedenti. C’è già qualcosa per la versione 10 ?
    Ringrazio e buona giornata, saluti Michele

    • http://it.linkedin.com/in/elbati/ Lorenzo Battistini

      Buongiorno Michele,
      dalla versione 9, la gestione dell’IVA per cassa è inclusa in odoo standard: direttamente nelle imposte puoi trovare il campo ‘Use Cash Basis’

      • Michele Pellegrini

        Grazie Lorenzo, ma a livello di reportistica, come posso visualizzare il dettaglio del rendiconto che vado a fare ? In primo luogo dove posso recuperare i saldi da mettere nei rispettivi rendiconti, in secondo luogo dove posso vedere il dettaglio di questi saldi (in CH si chiamano riassuntivi IVA). Grazie in anticipo! Michele Pellegrini