B1UP - B1 Dashboards do not show data for first Fiscal Year

[Legacy note] This version is not supported anymore, if you have this issue, please upgrade the B1UP installation.

If you activate B1 Dashboard in a database that is still in its first Fiscal year and is running a B1UP version lower than 2017.11 you might see that the dashboard is not displaying any values.

This is due to an SAP bug where some expected values are in table OACP.

If you have not made any modifications to your dashboards yourself then the easiest way to fix this is to upgrade to B1UP 2017.11 or higher and restore to default dashboards.

If you have customized dashboards or for some reason can't upgrade you can also replace the SQL that find the start and end of the Fiscal year with the following SQL:

DECLARE @CurrentFinanceYear DATETIME = (select MAX(FinancYear) as financYearStart from OACP where FinancYear<= GETDATE())
DECLARE @PreviousFinanceYear DATETIME = (select MAX(FinancYear) as financYearStart from OACP where FinancYear< @CurrentFinanceYear)
DECLARE @StartOfCurrentFinancialYear DATETIME = (SELECT MIN(T1.F_RefDate) FROM OACP T0 JOIN OFPR T1 ON T0.PeriodCat = T1.Category WHERE T0.FinancYear = @CurrentFinanceYear)
DECLARE @StartOfPreviousFinancialYear DATETIME = (SELECT MIN(T1.F_RefDate) FROM OACP T0 JOIN OFPR T1 ON T0.PeriodCat = T1.Category WHERE T0.FinancYear = @PreviousFinanceYear)
DECLARE @EndOFCurrenctFinancialYear DATETIME = (SELECT MAX(T1.T_RefDate) FROM OACP T0 JOIN OFPR T1 ON T0.PeriodCat = T1.Category WHERE T0.FinancYear = @CurrentFinanceYear)
DECLARE @EndOfPreviousFinancialYear DATETIME = (SELECT MAX(T1.T_RefDate) FROM OACP T0 JOIN OFPR T1 ON T0.PeriodCat = T1.Category WHERE T0.FinancYear = @PreviousFinanceYear)