How to add custom fields for the system's Accounts Payable Aging Report and its corresponding Report Data Definition (RDD)

[thinesh.babu]

How to add custom fields for the system’s Accounts Payable Aging Report and its corresponding Report Data Definition (RDD). I am working to add the ‘PaymentMethod’ on the APAgng system RDD. Could you please explain how to do that. Thanks for advance!!!

[TerryR]

In RDD, check the table’s exclusions, ensure the custom (UD) fields aren’t checked to be excluded.
Then in Report Builder, update the dataset query to pull the new custom fields.

I use the System Monitor to debug failing queries. Really tricky errors may only show up in the SQL server event log. Good luck…!

[thinesh.babu]

Here is my RDD relationships and custom field.

Here is the Report Builder dataset query,

But, Still facing the following problem.

[TerryR]

Oh you added an additional table to the RDD. No custom (UD) fields are shown in your screenshots.

Lots of help online for how to add another table to an RDD. Forum posts, Epicor KB, epicor videos, youtube videos, AI can help…

How to add new table to RDD when the RDD has no tables shown

Hi, Related to this thread, which contains a query that I don’t think I’ll be able to fix, how does one join a new table to a definition that has no visible tables? We would like to add customer PO and order numbers to the commission report, but it seems Epicor makes this a complicated task with the way the RDD’s have no tables shown. Thanks in advance. [image]