Question:
Hi there,
I'm in a Retail environment.
I'm using 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to fill an InfoCube and have the monthly stocks.
Quantities and valuation at purchase value are correct.
As I want to add to my report the valuation at retail value for each month, I've added 2LIS_40_REVAL.
But now I see this kind of things in the report :
Plant | Material | Month | Quantity | Purchase Value | Sales value
Plant1 | Material1 | Month1 | 0PC | 0EUR | 2EUR
Plant1 | Material1 | Month2 | 1PC | 1EUR | 0EUR
Plant1 | Material1 | Month3 | 1PC | 1EUR | 2EUR
So, there is a sales value that appears for Month1 (for which I don't have any stock).
And this value is actually the sales value that should appear on Month2...
I can see this kind of shift for some materials (and only on historical months, not current month).
Can anybody experienced with this extractor tell me where I have done a mistake ?
Thanks in advance and best regards,
David
Answer:
If you already worked with this extractor, I would need a tip.
Maybe the way we load data with it have to be different than the way we do it with BX, BF and UM...
Answer:
I'm still waiting for somebody to help...
How is it possible to have a validity table going from 11.2005 to 01.2006 and a query showing data for 10.2005 ???
David