How to eliminate zeros while creating the TB report in DM as the total records exceeds the limit — Cloud Customer Connect
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

How to eliminate zeros while creating the TB report in DM as the total records exceeds the limit

in Account Reconciliation 3 comments

We are currently facing an issue where we are unable to generate a Data Management (DM) report for a Rule using the epmautomate runDMreport command. The report includes approximately 330,000 records, which exceeds the system's processing limit of 100,000 to 150,000 rows for DM reports.

The report is based on the Trial Balance (TB) format, and while we do require zero-balance records to be loaded into ARCS as part of our integrations, we would like to exclude zero records only during report generation to reduce the overall volume and stay within system limits.

The command currently in use is:

epmautomate runDMreport "$reportName" "Period=$period" "Category=$category" "Location=$location" "Rule Name=$ruleName" "Report Output Format=$outputFormat"
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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