RDD on ap aging report

I am trying to find the source of the APAgng RDD.. there is no source, no BAQ, no LINK tables.. trying to understand how this work..

i found a bug when export to CSV.. and need to correct it.. but NO DATA SOURCE is showing..
help

Is the bug because you’re exporting it? But then on the normal report printed PDF, it’s fine?

the PDF is fine, the csv format (detail) is fine.. but csv format - summary is wrong..it’s not adding the detail column (excel or pdf) for the summary total

variable : TxtSumAgeCurAllGrp3

shwoing the last line of the detail (for the summary version).. total of 2092.55 instead of 5651.84

1 Like

Did you throw in a ticket?

Also robert, I think you can get to the report rdl itself and change it there in the designer.

In other words, I think it’s more the design of the report right? It’s not the RDD, right? I mean the data is all there, you’re just saying what it’s displaying is the wrong data right?

when I ran the report in XML version, I save and look at the SQL data directly (APDTLS table).. and the numbers were wrong for the summary version, not the detail.. so I need to know how the data is being calculated when running the summary.. it’s not adding the columns correctly

Robert, great, sounds like you know how to get to the data that the report is using.

Can you just make a summary report style yourself using the detail settings?

In other words, just make a report style labeled DETAIL Summary and then just know you run the report in detail mode, but the report style itself does the grouping and summarizing so that what ends up coming out is just that- a summary. In other words, stop trying to use the summary selection on the report parameters and just use the detail version but modify the report .rdl so that it summarizes things as you wish.

Also report this behavior if you’re finding it’s a bug.

1 Like

it’s a good idea.. I can do this..
thanks

1 Like

Please consider marking it as a solution if you feel it is. And also please consider reporting this bug to Epicor.

1 Like