[om_account_bank_statement_import, v16] Import error

quyetvk commented 1 year ago

Hi

I tried to import bank statement but it always shows error:

Please upload in specified format ! 
date, payment reference, reference, partner, amount, currency !

I tried some samples such as: <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Date | Label | Reference | Partner | Amount | Currency -- | -- | -- | -- | -- | -- 2020-12-01 | Test 1 | Ref 1 | odoo mates | 30 | KWD 2020-12-01 | Test 2 | Ref 2 | odoo mates | 40 | KWD

date | payment_ref | partner_id | amount | Statement -- | -- | -- | -- | -- 11/07/2022 | Customer payment 1 | | 1000 | S2-7th Nov 2022

Thanks for any support!

gexiaut commented 1 year ago

Same issue

crispyduck00 commented 1 year ago

Same here.

crispyduck00 commented 1 year ago

I added some debug lines and maybe it is not really the module causing the problem: So the def create_statement(self, values): gives following error:

You can't create a new statement line without a suspense account set on the Exchainge journal.

But strange as I only have on currency.

crispyduck00 commented 1 year ago

Fu** the solution was just one click away posted as pull request by @Naz1137 https://github.com/odoomates/odooapps/pull/95/commits/33b37776d32829b0bf12db9e82d40f31c960671e

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

weldd1601 commented 1 year ago

still not working? has any one figured out his?

nagybal commented 1 year ago

I belive @crispyduck00 @weldd1601 You need https://github.com/OCA/account-reconcile/tree/16.0

imunisasi commented 10 months ago

@odoomates any light on this issue sir ?

hamza-mostafa commented 9 months ago

the solution was just one click away posted as pull request by @Naz1137 33b3777

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

fix as the above and make sure the date is like the below format '%Y-%m-%d'

hamza-mostafa commented 9 months ago

for reconciliation check this video -> https://www.youtube.com/watch?v=VxM7krqxG-s

imunisasi commented 6 months ago

@hamza-mostafa do you have xlsx and csv example for this, trying many times always

Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

cgomeznt1 commented 6 months ago

Does anyone have a solution to this module that does not import the csv file? still giving the same error

Please upload in specified format ! date, payment reference, reference, partner, amount, currency !

odoomates commented 6 months ago

hi @cgomeznt1 , could you share the file you have used to import

imunisasi commented 2 months ago

@crispyduck00 can you share your csv / xlxs format , thanks

imunisasi commented 2 months ago

@odoomates we use sample file inside om_account_bank_statement_import/sample_file Import_Sample.csv Import_Sample.xlsx

it never success

ermias576 commented 2 days ago

Fu** the solution was just one click away posted as pull request by @Naz1137 33b3777

Now import works. But still don't know how to reconcile in odoo 16 ce with Odoo Mates

This is the solution all of us are looking for, but how the reconciliation works is the main question.

odoomates / odooapps

[om_account_bank_statement_import, v16] Import error #98