FDI - Modify 'Financials - AP Invoices' to allow all Historic Invoice Dates to appear

HamishVickers

We have recently gone live with ERP and FDI on 1st Dec 2025, and will have several more go lives for other departments in the next few years.

In ERP the first active Fiscal Period was set to July-2023.

There are some valid AP Invoices that are coming into ERP that are dated before July-2023.

—These Invoices appear in the main AP subject area's in OTBI, without issue, all data shows, including Invoice Date.

—These Invoices appear in FDI's subject area Financials - AP Invoices - but break when any field from the 'Time' folder is added, or when any field from the 'Invoice Date' folder is added.

This is due to the join at the logical SQL level being a hard join from the invoice table to the fiscal calendar table.

Because the fiscal calendar table only has data back until July 2023 — the join cannot happen from the invoice table using Invoice Date (01 Jan 2023 example) to the fiscal calendar table. As such when those fields are added, the Invoices disappear from any workbooks.

Being an OOTB FDI Subject Area, this is not good enough, and is causing our AP Invoice reporting to be inaccurate.

While we do not wish to have AP Invoices come into ERP that are older than July 2023, there are valid scenarios where some unpaid invoices dated prior to July 2023 are still coming in as we continue our go live roll out to more departments.

If there was a way this could be amended to allow accurate AP Invoice reporting in FDI - then customers can have more confidence in the FDI product.