Skip to Content
0
Former Member
Nov 18, 2008 at 05:20 PM

Cal Yr/mth variable with intervals to show beggining & ending stock balance

19 Views

Hi All,

I have a report for which we show beginning and ending stock balance per calendar yr/month. The variable used is single entry.

Users wish to input calendar yr/month interval such that they get the same view for several months.

For example currently, the user can just enter say 08/2008 and he gets to see the report as:

Beginning balance | Goods Receipt | Goods Issue | Ending Balance

Required is:

User Entry: 08/2008 - 10/2008

08/2008 . 09/2008 . 10/2008

BB | GR | GI | EB . BB | GR | GI | EB . BB | GR | GI | EB

The issue that happens here is:

The stock quantities (all fields above) are restricted by the calendar yr/month. However it is a bit differernt in case of Beginning Balance. It has to be restricted by an offset of cal yr/month. In the current scenario (where user enters only one cal yr/month) if user enters say 08/2008, the BB is calculated based on previous month's ending balance and so for that in the key figure BB, we have to restrict it by '-1' offset for cal yr/month.

The interval variable messes up the report altogether if I restrict all the above fields by the interval variable instead of single entry. How do we apply same behaviour when the user inputs an interval?

Please provide any suggestions on this.

Thanks.

Edited by: BI Quest on Nov 18, 2008 6:24 PM

Edited by: BI Quest on Nov 18, 2008 6:43 PM

Edited by: BI Quest on Nov 18, 2008 6:48 PM

Edited by: BI Quest on Nov 18, 2008 6:49 PM

Edited by: BI Quest on Nov 18, 2008 6:50 PM