When I make automatic bank reconciliation
System takes all transactions with same amount on specific date as duplicate transactions.
Is there a way system can compare by date,amount and reference?
When I make automatic bank reconciliation
System takes all transactions with same amount on specific date as duplicate transactions.
Is there a way system can compare by date,amount and reference?
Hi Ramadhan
Can you please paste a screenshot on this chat on what you observe?
Is it your expectation/requirement here that you should view it as per the following example?
Transaction Date Amount Reference
12/11/2022 500.00 Ref001
12/11/2022 500.00 Ref005
Or exactly how, by using the above example?
Kind regards
Bennie .
As per your request
Bank statement file shows entries in red color are on the same date, same amount but different reference
The rest have different amount each of them
Sage Response on automatic reconciliation
All transaction with different amount have been ticked as reconcilled
Those two transaction with same amount 500 on the same date even though have different reference sage take them as duplicated
I think this is a bug
Thanks for the detailed feedback, Ramadhan
No, I disagree with you: This is not a software bug at all.
If there are are two transaction with the same date and same amount, but different reference numbers, they must display separately.
Even though they appear as duplicated, they are not because the the different reference numbers clearly separate them
So, Evolution works perfectly as per design.
Do you agree? Or am I missing something obvious here?
Kindly refer to images attached on my response above. Two transactions with the same amount, same date but different reference sage term them as duplicate. As you can see Ref001 and Ref005 terms as duplicate on sage reconciliation.
Hi Ramadhan
They may appear to be duplicated but they are not duplicate records at all.
Evolution MUST separate them as they are in fact two different transactions, with different reference numbers.
Do you actually expect to have only one transaction for 1000 (500 + 500)?
No what I expect is system to reconcile transaction by reference, date and amount. I wonder why when more than one transaction on the same date with same amount system treat them as duplicated. As it shown on example above. Kindly try to have more than one transaction on same date with same amount on your side and make automatic reconciliation then observe it. You will get a picture of it
Thanks for the detailed explanation, Ramadhan. I understand a bit better now.
The best way forward here is to log this query with Evolution Support using the link below so that a detailed investigation on this matter can be done
https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465
You're welcome to request that this query be addressed for my attention.
I wish I can give you a simple, easy answer but i suspect there may be either company data or a software issue involved here as the cause of your query.
Thanks for the detailed explanation, Ramadhan. I understand a bit better now.
The best way forward here is to log this query with Evolution Support using the link below so that a detailed investigation on this matter can be done
https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465
You're welcome to request that this query be addressed for my attention.
I wish I can give you a simple, easy answer but i suspect there may be either company data or a software issue involved here as the cause of your query.
*Community Hub is the new name for Sage City