How to add exactly same transaction for a reconciliation through data management
Summary
When we drill down through "Ending Balance" in a reconciliation. Is It possible to display unique summarized transaction only ?Content
- suppose source file has 3 transaction for 1000-8002 reconciliation.
- Entity,Account ID,Currency Code,Amount,Cost Centre
1000,8002,USD,200000,NSW
1000,8002,USD,100000,NSW
1000,8002,USD,50000,NSW
- Entity,Account ID,Currency Code,Amount,Cost Centre
- Now, in the reconciliation for 1000-8002, the ending balance will populate as "350,000".
- When we drill through ending balance, it displays 3 separate transaction.
- Can we have one summarised row instead of 3 separate rows?
- like 1000-8002 source system NSW 8002 1000 350,000.00
- Can we add similar transaction at data management level to generate one row instead of 3 separate rows?
Kindly, refer the attachment i.e. Business_Requirement.docx for reference
Tagged:
0