Skip to Content

Contributors

Re: How to import old invoices from legacy system

importing old and paid invoices is complicated.

you need to import invoices
and the payment entries. then you would need to reconcile them. consequently, they won't appear any longer in your list of unpaid invoices

next you need to reverse them: let me explain. as you enter old invoices, they would generate revenue and the yearly balance will go to accumulated profit on the balance sheet. But this will be double counted when you will import your actual opening accounting balances. so.. the easiest method would be to reverse (to zero-ise) the entries so that you start with a clean balance sheet.

hope this helps

On Thu, 9 Jun 2022 at 6:27 PM, Radovan Skolnik <radovan@skolnik.info> wrote:
That makes sense but I guess this will enter into "accounting" and affect many 
things (accounting-wise). These are invoices spanning more than 15 years and 
have been "processed" (for the lack of better term on my side). Also not sure 
I am able to create those balanced entries. So I guess I'd stick with Sale 
Orders.

Best regards

	Radovan

On štvrtok 9. júna 2022 12:17:26 CEST Pedro M. Baeza (Tecnativa) wrote:


> You have to create the whole `account.move` with `line_ids` one2many totally


> filled and balanced.


> 


> 


> Regards.


> 


> 


> _______________________________________________


> Mailing-List: https://odoo-community.org/groups/contributors-15


> Post to: mailto:contributors@odoo-community.org


> Unsubscribe: https://odoo-community.org/groups?unsubscribe




_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

--
Dominique KON-SUN-TACK  [Project Manager]
Odoo Gold Partner, best Odoo Partner 2014 for APAC

Mobile: + 65 8502 2399
Skype: dominique_elico



by dominique.k - 02:00 - 9 Jun 2022

Reference

  • How to import old invoices from legacy system
    Hello,
    
    I would kindly ask if there is some guide on how to import old invoices from a legacy system. These were processed and paid long time ago so I just need them to be able to see customers' history. However accounting features get in my way when I attempt to import Journal Items (account.move.line) saying "Cannot create unbalanced entry". I guess this has to do with Journal Entries (not) being created as they'd normally do.
    
    Is there a way to do this somewhat easily? Or should I better map the data into Sale Orders? Any advice is greatly welcomed.
    
    Thank you. Best regards
    
    	Radovan Skolnik
    
    
    

    by Radovan Skolnik - 11:25 - 9 Jun 2022