I want to show Accounts Receivable Invoice aging days by Project in FDI

Question

I am trying to build a dashboard in FDI to show Accounts Receivable (AR) aging days and outstanding amount by project/contract etc.

I am using AR Aging subject area which does not provide any information of Project or Invoice.

subject area AR transactions has contracts, remaining amount and some dates but no project information.

subject area Project Invoices does not show remaining amount etc.

When i bring AR aging and Prj invoicing etc, it throws some odd figures as relationships are not valid.

How could i get/calculate invoice aging days by project and Invoice? Which subejct area/s could provide this information?

Nandini Krishnan-Oracle · Answer

Currently the project is at the Invoice distribution level. Depending on the grouping, an Invoice can have multiple projects. Users can see the remaining amount, Contract and Invoice from the AR Transaction subject area. You can add another table with Receivable Number, Contract Number, Project number and the Invoice Amount from the Project Invoice subject area. By passing the contract number, drill down to see the Projects which are part of that contract and Invoice.

Mallikarjuna Kuppauru-Oracle · Answer

@Ramamurthy Shankarachetty-Oracle  Any inputs/suggests here?