Need help on Parse Rule while importing bank statement
While Importing the bank statement file, we need the Foreign Currency Information (Original Currency, Original Amount , Exchange Rate) to be populated from Additional Entry Information.
In the Additional Entry Information, the first 3 letters would be Currency, followed by Original Amount and Exchange Rate. These details need to be populated in Foreign currency information.
As per the above Screen, EUR should be populated in Original Currency, 1366.62 should be populated in Original Amount and 1.0662 should be populated in Exchange Rate.
Fyi.. The Currency text position would be the same but where as the amount and rate will differ.
We were able to derive the Original Currency by using the below parse rule
Tagged:
0