[Updated Title:] Aged Payables report. Where in the Heck is APDtl_GUID coming from?

I’m somewhat new to Epicor and to SSRS reports. Hoping this is obvious to someone else here.

We have some data showing on the Aged Payables report for payments due, but the payments are already made. I am struggling to figure out how the data is pulled.

It’s a built-in SSRS report (AgdPay). The SSRS Dataset named APDTLS references the table APDtls_, which contains the InvoiceDate, InvoiceNum and a bunch of calculated fields.

I’ve looked in Report Data Definition, and I see the data source, but I have no idea where the fields are coming from.

APDtls is shown as the Primary table, and it has “System Table” checked. But there isn’t an ERP.APDtls table in the database.

What am I missing? Any help appreciated.

Those are probably calculated fields based on tables APTran and APInvHed (and maybe APInvDtl).

Greg,

It’s probably APInvDtl table and they just renamed it that in the dataset itself.

I appreciate the responses.

Is it completely hidden then, and we are left to “probably”?

Some portions of stock reports are black boxes.
Some tables are generated in the background and won’t always directly correspond with a real table.

Thanks, Kevin.

It’s either a data issue or a bug in the report, but impossible to track down if I can’t see how it’s being calculated. I’ll open a support ticket and see what they say.

I appreciate your verifying that it can be hidden from us. Being new, I thought maybe there was somewhere else to look and I just didn’t know it.

Thanks again.

Sometimes there is. Always ask!

1 Like

Just a follow-up here. I opened a support case.

They requested a baq of the APInvHed table for the offending invoices, so they could create a data fix.

I sent them the data; they sent the fix; I ran it, and the problem was resolved.

Thanks for the replies on this case. It helped push me toward the solution!

1 Like