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

ACDC

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?

Mallikarjuna Kuppauru-Oracle

@Ramamurthy Shankarachetty-Oracle Any inputs/suggests here?

Nandini Krishnan-Oracle

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.