Skip to Content
Menu
This question has been flagged
1 Reply
765 Views

Hello

I do not succeed to extract the data necessary for accounting the total amount and commission amount as they are provided by the imported bank statement (in the reconciliation process)

The template from my bank is

/REMISE CB /14/04 R73237 CT373142: 8001BT 111,00E COM 1,20E

and i need to extract 111,00 and then 1,20 using the regex syntax as provided by the reconciliation process from the accounting app.

The help window is saying : see screen capture below; I tried this without success!
does some of you know how to use the regex function in Odoo?

Thanks for any help


Avatar
Discard
Author Best Answer

Below the set up for the reconciliation template for credit card payment , using regex syntax to extract the total amount of the credit card (the sales amount) 

AND the bank commission

All these data being imported from the bank account  as a separate line  as follows

/REMISE CB /14/04 R73237 CT373142: 8001BT 111,00E COM 1,20E



Contreparties

Compte512105\ \ CB\ à\ encaisser
Type\ de\ montantDepuis\ les\ étiquettes
Taxes
SociétéAd\ Libitom
Libellémontant\ brut\ de\ la\ remise
Montant\ à\ partir\ du\ libellé\ \(expression\ régulière\)BT\ \(\[\d,\]\+\)
Séparateur\ décimal,
Compte668000 Commissions CB
Type de montantDepuis les étiquettes
Taxes

Étiquette de pièceCommission CB

Deuxième montant de l'étiquette (regex)    COM ([\d,]+)
Avatar
Discard