Why SYSDATE Parameter is not working in Data Management to pull TM balances till date?
The Clients wants to have a Daily Load of Reconciliation Compliance and Transaction Matching profiles. (Format used is Account analysis with Transaction Matching).
The RC is having a direct integration with ERP and hence pulls the data up to the date of load. The TM transactions are pulled from the custom report created in ERP, which has date parameter.
In order to pull in both the data simultaneously, and have an unexplained balance of "Zero", we need to have to pull data until the same time. Initially we pulled in TM using system date minus 1 but that did not help in matching upto the GL balances as GL loads balances till today. We want to use System date to pull in TM balances. However, we tried the same, but it was not matching with the GL balances again. Need to understand how to pull the TM transactions till date from ERP to ARCS.