Skip to Content
0
Former Member
Mar 04, 2010 at 08:38 PM

Beginning of Month Inventory

58 Views

Hi all,

I am on BW 3.5. I have an inventory cube which uses the BX,BF and UM extractor to populate. It is working fine (or as well as those extractors ever work). However, when I run a report by month, it shows me inventory totals for the end of the month. What I want is beginning of them month. For example:

Current

Material Month Inv Qty

6001 01/2009 50

6001 02/2009 75

6001 03/2009 90

What I want is:

Material Month Inv Qty

6001 02/2009 50

6001 03/2009 75

6001 04/2009 90

Same data - just the calmonth has been incremented. Is there anyway to do this?

Thanks.

Dave