Bug in Inventory Analysis per dimension

Capone

Hi experts!

A colleague of mine discovered that the Inventory Analysis Per dimension doesn't work as it should in RTC (Dynamics NAV 2009 R2).
I haven't tested it in the 2013.

He found these fixes on the Partner Source but these didn't help:
https://mbs2.microsoft.com/Knowledgebas ... mkmrqqkpxv

https://mbs2.microsoft.com/Knowledgebas ... kuztuvsvyy

The settings he used:
Analysis View Code: Standard
Show as lines: Item
Show as Columns: Location
Date filter: 11-01-01..11-12-31

When showing the matrix the result was blank.

Beware, I had applied the previous bugfixes Before I found this.
When I choose Show Matrix it doesn't show anything and after Deep investigation i found out that it is the date filter that is messed up.

In page 9209, in trigger OnOpenPage the function Findperiod('') is called and after that has been called it the date filter is destroyed.
If the date filter was "Date1..Date2" it is now only "Date2" :bug:

I just unmarked the code in the function and it seemed to work but it seems it should rather be fixed since it is there for a reason

FindPeriod(SearchText : Code[10])
IF DateFilter <> '' THEN BEGIN
  Calendar.SETFILTER("Period Start",DateFilter);
  IF NOT PeriodFormMgt.FindDate('+',Calendar,PeriodType) THEN
    PeriodFormMgt.FindDate('+',Calendar,PeriodType::Day);
  Calendar.SETRANGE("Period Start");
END;
PeriodFormMgt.FindDate(SearchText,Calendar,PeriodType);
Item.SETRANGE("Date Filter",Calendar."Period Start",Calendar."Period End");
IF Item.GETRANGEMIN("Date Filter") = Item.GETRANGEMAX("Date Filter") THEN
  Item.SETRANGE("Date Filter",Item.GETRANGEMIN("Date Filter"));
InternalDateFilter := Item.GETFILTER("Date Filter");
IF (LineDimOption <> LineDimOption::Period) AND (ColumnDimOption <> ColumnDimOption::Period) THEN
  DateFilter := InternalDateFilter;

Any ideas on how it should be corrected?

suciani

it might be your colleague forgot to click "Update" in the analysis view list inventory. it just a guess :idea: