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

Customize Receivables Aging by General Ledger Account DM

in Receivables & Collections

Summary:

We have a Requirement to Create an AR Aging Report. Out of Box "Receivables Aging by General Ledger Account" is a close match for our requirement , however, customisation involves adding additional fields to data model like Collection Agent Name, Invoice Name, Outstanding Invoice count etc. On inspection of the data model, we noticed the data model uses a package and not tables.

How to customize these kind of DM?

Also, if we write a query on base tables and derive this output, there are two challenges we see

1. Deriving the Outstanding Amounts correctly

2. performance of report.How can these be handled?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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