Contributors mailing list archives
Re: How to import old invoices from legacy systemby
Akretion France, David BEAL
I think that a good approach to bring legacy data in Odoo is to create a model like in your case account.move.imported or account.invoice.imported.
In this table you'll create some of important fields to use for comparison with new data.
Don't set too many constraints on these fields even if you can setup many2one.
After imported data, you can create sql views (query in init function of the new model including the 2 previous ones) in which you can aggregate the two models with Union sql
With this you can have real statistics on whole history without too many headaches on import
You may customize functions used in Smart Buttons to have a real count or create new ones to have the 2 stats
My 2 cents.
Le jeu. 9 juin 2022 à 14:02, Dominique k <email@example.com> a écrit :
importing old and paid invoices is complicated.you need to import invoicesand the payment entries. then you would need to reconcile them. consequently, they won't appear any longer in your list of unpaid invoicesnext 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 <firstname.lastname@example.org> 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:email@example.com > Unsubscribe: https://odoo-community.org/groups?unsubscribe