콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
1 회신
1192 화면

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


아바타
취소
작성자 베스트 답변

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,]+)
아바타
취소