AutoReconciliation using Date and Import
Dear Community
Is it possible to run Autoreconciliation using date and transaction amount for matching reconcilation purposes?
The process we have is described as follows:
1.- Download bank statement from bank webpage (.txt or csv depending on bank statement)
2.- Upload bank statement file through custom loader program that populates interface tables
3.- Go to EBS Cash Management and Import Bank Statement
4.- When reviewing the imported bank statements in Cash Management Transaction Number is not populated for 90% of transactions. This is expected hence bank statement does not contain transaction number, transaction number is internal use only except for issued checks with bank institution.