Question:
Hello,
With Version 2.x one of the problems with Bex was that if you performed a calculation ie min( x, x+y-z) calculation it was impossible to get it to work out the correct result at a sales document level.
for example
Sales Document 1.
Line 10 Ordererd 10 cases (x), increased the order by 5 cases (y) and then rejected 2 cases (z).
Line 20 Ordered 10 cases, no changes, rejected 1 case
If you run the query using the calculation above min(x, x+y-z) the total you will get at document level would be
Min (20, 20 + 5 - 3) = 20.
However if you run the report showing sales doc item you would get
Line 10 Min (10, 10+5-2) = 10
Line 20 Min (10, 10-1) = 9
Which would give a total of 19 cases
I have been told by someone that you can fix this problem using the cell editor in Version 3. However, I can't get it to work! Can anyone help me please
Answer:
Not sure how you would like to "solve" this via the Cell Editor... I guess what you wish to do is show 20 on the Result line on Order Header level?
If that's the case, then you would have to define a "special" formula on the result line (which I'm not able to do here as I don't get my result lines 3.0B SP8).
Also, you can only use the cell editor if you have 2 structures (if I recall correctly).
cheers,
El Belgio
Answer:
The result I would want would be 19. In short what i am want to do is perform a calculation at sales doc item level without having to view all the sales doc items in the report.
Answer:
Ok, now I know what you're trying to do...
Try it this way (haven't tried it myself, but had a quick look):
- Create a structure containing both your Sales Order and your Item
- Hide the Item
- now start the Cell Editor
- here your 2 levels are available
cheers,
El Belgio
Answer:
tried that and it doesnt work.
any other ideas?