Skip to Content
This question has been flagged
reconciliationinvoicingv14
1 Reply
2537 Views
Avatar
PCS

Hello!

After spending about 3 months with Odoo Support trying to find an answer, I thought I would try on here to see if anyone knows a solution to my problem.


Situation: We implemented Odoo 13 in 2020 and we use Invoicing app (but not accounting app!), in odoo 13 we could apply the reconciliation feature of the Invoicing app to match payments received in the bank (online synchronization of the bank statements set!) with the related invoices. 

Then we migrated to Odoo 14, and without being aware of  that in advance, Odoo 14 no longer has the option for reconciliation in the  Invoicing app. Apart from that, there was a bug in the migration script, causing issues with the bank journals, which got fixed ultimately but while doing that the bank journals got duplicated.    


According to Odoo Support, my situation is due to 'exceptional use of Invoicing app' (not  true as far as I'm concerned, after all I was just using a normal feature in Odoo 13!! & when we bought Odoo in summer 2020 we have repeatedly emphasized that this was how we want to use Odoo, without the Accounting app!). They advised I should somehow change my settings on the bank journal to allow for immediate reconciliation, but they have failed to demonstrate this or show me what that looks like. So I wasn't able to get this done still.



Problem: 

- how can I get rid of my duplicate bank journals, so that I only have 1 bank journal left (which includes ALL bank statements since October 2020, instead of having this scattered across 3 bank journals)?

- how to adjust my bank journal settings to allow for payments received to match with invoices sent, and thus the invoice to be marked as 'Paid'.

- Odoo Support referred to this 'solution' - but that page doesnt exist: https://github.com/odoo/upgrade/commit/fc437ea2141444e13548e35605d0a53e09c42144; does anyone know how I can find the right link? Obviously I asked Odoo Support but no reply .... 


I would be very much willing to pay for adequate advice, but so far I was simply unable to find anyone who can help me;-)


looking forward to input of you experienced fellow-Odoo'ers!!


Margriet

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

>> how can I get rid of my duplicate bank journals, so that I only have 1 bank journal left (which includes ALL bank statements since October 2020, instead of having this scattered across 3 bank journals)?


I would archive the Journal(s) you no longer use.  This won't deal with the scattered Bank Statements but will prevent the Journal(s) being used for anything moving forward.



>> how to adjust my bank journal settings to allow for payments received to match with invoices sent, and thus the invoice to be marked as 'Paid'.


1. Add your User to the group Show Full Accounting Features.


2. Visit each Bank Journal you want to skip the IN PAYMENT state for and set the two Outstanding accounts on the Payments Configuration tab to match the Bank Account on the Journal Entries tab.     

 


You may find with the Accounting Features now available that you can access Bank Statements and merge them but I have not worked with the Invoicing App alone - just Accounting.   Bank Statements don't appear to be visible without membership of this group so perhaps you don't need to worry about them (just remove membership to the group once you have setup your Bank Journals).

P.S. Please email me - ray [at odoo with the Ticket Number so I can share this post with the Support Team.

Avatar
Discard
PCS
Author

Thanks, Ray! Have sent you a message per email.

Basically, I did already what you suggest in your reply. What I fail to see is what the next step should be: How to reconcile all the payments currently in my suspence account (or to be in my bank journal directly from now on) with outstanding invoices? Do I choose 'register payment'? I can't find a video or any documentation showing me what the regular flow should be like.

Should there be anyone else out there who can explain how to do this - much appreciated if you share it! I can't believe we are the only ones 'suffering' from this change after migrating from v13 to v14?

Related Posts Replies Views Activity
Cash discount question Odoo 14
reconciliation v14
Avatar
Avatar
Avatar
2
Nov 21
1304
Create an invoice from sale order (odoo 14)
invoicing v14
Avatar
0
Aug 21
1764
Doubt in the conciliation models
reconciliation v14
Avatar
0
May 21
778
Best practices for setting up Stripe and doing Payment Reconciliation? v14 Solved
reconciliation Stripe v14
Avatar
Avatar
Avatar
Avatar
Avatar
7
May 24
9800
Additional Entries created during Invoicing.
invoicing Community v14
Avatar
0
May 22
946