You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!