Custom Report AR Aging by Employee Not Working in 2023 R2

In your joins, the “ARInvoice” table is used a parent table before it was actually joined into the report through the “CustomerMaster” table.- this should cause an error when trying to run the report. You need to join that table into the report before using as a parent table.

 I would also check your “filters” tab as it seems your braces don’t match up and would be causing unexpected results.

If neither item above works, can you attach what error message you are receiving?

Hi @mbridges00 , thank you for taking your time in looking into this. The table screenshot above was only showing the lower part (additional tables added on top of the originals) of it, but here’s the full table joins:

On Filters, the only line added is:

EPEmployee.UserID Equal @UserID

Hence, no brackets were modified from the original filters.

There is no error message appearing when running the report, but rather there are no records displaying at all.

If you remove the last line (EpEmployee.UserID = @UserId) from the filters tab, does the report populate?

Yes, the report is populated with records, but now it will show all salesperson’s AR Aging instead of the logged in user. I have confirmed that both the values from the parameter and the one in DAC is the same as shown below:

Parameter:

DAC source data:

I’m puzzled as to why the system failed to equate these two values.

Hi @ericklasimin61 were you able to find a solution? Thank you!

Hi @Chris Hackett , unfortunately, the issue has yet to be resolved even after updating to Build 23.214.0020.

I have tried raising a case to the principal, but they dismissed the case under the pretext of “The report has been customized.” and suggested me to create this post. What worked without any issues previously suddenly stopped working without knowing the reasons why. I do hope they can shed some light on this issue.

Thank you for sharing your solution with the community @ericklasimin61!