Starting - Ending Balance

Question

We do manual entry on bank statements, I want to correct some mistakes on earlier bank statements. Is there a simple and faster way to correct subsequent "Starting - Ending Balance" other that doing it manually?

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,
You can export records from bank statements as shown below.

Take the fields on the right side and export. Update the starting and End Balance in the XLS file. Then you can import the file again. Don’t forget to take External ID while exporting the data. I hope this will help you.
Reference Import data:    https://www.odoo.com/documentation/user/14.0/general/base_import/import_faq.html [1]
Hope it helps

[1] https://www.odoo.com/documentation/user/14.0/general/base_import/import_faq.html

Roberto de la Fuente · Answer

Hi, thanks for your reply!
I did follow your approach, my issue came when I wanted to import the records. Unlike other objects (contacts, products, chart of accounts )there is no import tab!, only option is as "Import statement". I am using Odoo 13.0+e.

المنشورات ذات الصلة	الردود	أدوات العرض
bank statement import bank_statement	2 أغسطس 25	1611
Bank Statement in Odoo تم الحل bank_statement	3 يونيو 25	3965
Bank Statement Odoo OnLine. bank_statement	0 نوفمبر 23	1663
Bank statement and reconciliation bank_statement	2 يوليو 23	3675
[14.0] Can not reset “posted” bank statement to “new” \| error “You cannot modify a posted entry of this journal because it is in strict mode” تم الحل bank_statement	3 مارس 23	4487

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!