2lis_03_bx Negative Values

[Former Member]

Hello experts,

I have done all the necessary steps for the Inventory Management scenario.

1) I ran the 2lis_03_bx and loaded it with Marker Update compression in BW cube.

(Opening stock on 09/10/2008)

2) I ran the 2lis_03_bf for a 3-month period before my opening stock and loaded it Without Marker Update compression in BW cube. (Historical Movements for 07, 08, 09, 10-2008).

So now I have (for example) Material 1xxxx with a stock quantity of 350PC on 09/10/2008. (0totalstck)

I see that values of 0totalstck for dates before the 09/10/2008 are always NEGATIVE and that the system does not calculate stock backwards with respect to my opening date....

I would expect to see a query:

Date 0totalstck

01/09/2008 330

15/90/2008 340

09/10/2008 350

but I get

Date 0totalstck

01/09/2008 -10

15/90/2008 -10

09/10/2008 350

So Instead of getting 330 or 340 as stock quantities for days before my Stock Init I get -10, -10 etc.

Can u please explain what is happening??

Is it necessary to load ALL historical movements to get correct results??

Points will be assigned generously!

Thanx,

Mary

[Former Member]

DTP:

Initial non-cumulative for non-cumulative

[Former Member]

Hello Mary An,

I have the same problem!? ANd it's correct, I a DTP for filling the cube.

Could you explain your answer, pls! I did not get the point.

thanks, thomas

[Former Member]

Hello,

the DTP of the 2lis_03_bx loading must be of extraction mode Initial non-Cumulative for non Cumulative Values.

Regards,

Mary

[Former Member]

Hi Mary,

thanks, that's the solution! but it's nowhere docmented

,thomas