Period activity Balances to load as Ending Balance (Incremental)

Summary:
We need a workaround in ARCS Balance Comparison to load period activity incrementally (adding only new lines to the ending balance) instead of replacing or duplicating existing balances when multiple loads occur.

Content (please ensure you mask any confidential information):

Hello Experts,

In Reconciliation Compliance (Balance Comparison method – Oracle ERP Fusion GL vs Third-Party), we are looking for a workaround to handle period activity loading. Currently, ARCS loads data as an ending balance, which replaces the existing balance. However, our requirement is different the new data should be added to the existing ending balance, not overwrite it.

Since we plan to load data multiple times within the same month, there is a high possibility of repeated lines. For example, if the Third-Party Period Activity Report initially has 30 lines at month-end, these should be loaded and added to the ending balance. Later, if we reload the report with 32 lines (updated data), the system should only add the new 2 lines instead of reloading all 32 and duplicating values.