Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!