hi guys ....i´ve used the 2LIS_03_BF BX for calculate stocks in BW i've made an initialization and load historically material movements and activate the delta ...but i have a problem..i review my querys and the "in" stock movement and "out" stock movement are OK but the Total Stock Value are not OK i run the reports MMBE MB5B in R3 in order to validate the values but the Total Stock Value is not the same....
There`s any specific report in R3 for view that information ...........or maybe there another key figure for Total Stock ....i follow the "How to" pdf for inventory management and i have made complete loads....but i cant validate that value
Regards
Message was edited by: Oscar Diaz
4 Answers
-
Best Answer
Former MemberPosted on Oct 20, 2006 at 07:03 AMHi,
Have you compressed BX init request with Marker updae?
Have you compressed BF init request with out Marker updae?
Have you compressed UM init request with out Marker updae?
Have you compressed BF Delta load(if any) request with Marker updae?
Have you compressed UM Delta load(if any) request with Marker updae?
and also Restrict the Valuated Stock Kf with Stock category = # in BW side .
With rgds,
Anil Kumar Sharma .P
Add a comment
-
Former MemberPosted on Oct 20, 2006 at 07:10 AM
Thanks for your answer
I have compressed BX init request with Marker update
I have compressed BF init request(init delta with records) without Marker update
I have not load UM but it only affects valuated stocks values and not quantities and i not used values ...noly quantities
I load Deltas for BF but i have not compressed them yet,i supossed that not compressed deltas works the same that compressed ones
I only want to see the stock value for a plant-material in a specific warehouse in a specific date.
Message was edited by: Oscar Diaz
Message was edited by: Oscar Diaz
Add a comment
-
Former MemberPosted on Oct 20, 2006 at 08:29 AM
Ok, the 0TOTALSTOCK value is the total number of peices of both valuated stock and non-valuated stock.
For instance, if you run (in R/3) MB5L for the plant/valuation area/material in question, for either the current period, ending last period, or end of previous year, you get some values, of valuated stock.
If you look in MMBE, you may see valuated and non-valuated stock, that is what your TOTALSTOCK should agree with.
Compare this with BIW...are they the same for the same period? If so, the quantities almost have to be correct. But for TOTALSTOCK, it is a bit different, TOTALSTOCK includes all VALUATED STOCK, but with the addition of items that you don't valuate, maybe containers, project stock or other types of stock.
First I would validate your valuated stock. Let me know how that number looks. If it is correct, you may want to search OSS, I remember some notes about the 0TOTALSTOCK value and how you may have to change (update rules) according to some specific requirements.
Also, remember, you want to exclude Comsumption values (in the update rules you should be deleting these, unless you created KF's to keep these figures!).
Cheers!
/smw
Add a comment
Add a comment