on 09-08-2017 5:53 AM
Hi
I have to built a report to display the open PO's I have excluded the Delivery completion but in the report I am getting the PO details which are already closed in the ECC. As shown in the following table
PO NO Delivery Com. Item
4600035730 10
4600035730 X 10
4600035730 X 10
Last two raws are for the GRN and the MIRO this PO was closed one and I want to know why I am getting the first line in my report though I exclude the delivery completion.
Please help me to solve this problem.
Thank you
can you please tell whats your local and global filter on query?
also you reporting on Backorders Cube of Purchasing?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As i far as i can see the scenario in your case
PO | PO Item | SCL Num | Order Quantity | Confirmed/GR/delivered Quantity | Del. Completed
4600035730 10 1 20 10
4600035730 10 2 5 X
4600035730 10 3 5 X
In your Infoprovider data must be present in this format.
So if you Exclude Order Quantity with X then also It will be visible
Rather work with Confirmed/GR/delivered Quantity and Del. Completed or Formula
In nut shell drag PO item SCL counter and delivery Completion in Report along with All keyfigure for this PO ,you will get the answer
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.