My view to prepare a report for all completed PO numbers with or without open invoice
We know we can get all types of purchase report from ME2N/ME2M/ME2L etc. But these all reports are considering as per line item. These reports will show you result line item wise when you run with your criteria (like as Selection parameter).
When you want to get a report for completed POs with consider all line items. When you want a report only for these PO numbers, whose are having delivery complete for all line items. You will not consider these POs as complete if GR will be pending (or partial GR) for any line item.
In short, you want a report with the indicator as “Fully Delivered” in Header – Status tab.
As an example,
You have a PO with 2 line items, GR has fully completed for first line item but your second line item has the partial GR. So when you will consider this PO as incomplete PO as second line item has some GR pending.
You will find more information in this discussion List of completed POs with compare all line items. I had posted the query but didn’t find any standard solution. Experts says, I have to go with development. Somehow, I’ve prepared this report with the field delivery complete indicator (EKPO) and Ms Excel.
I want to share my experience so that it can be helpful for others.
Actually my boss had given the task to me. We have one vendor and we are doing invoice when the PO for this vendor will be totally completed. My boss asked me to give the all completed PO numbers with open invoices, so that he can calculate the quantity for open invoices.
But before doing this you might have to know some important notes:
You will need to make this report when you will agree to pay invoices only when all line items of a single PO number are totally completed.
As you can see the report will be made by some work which is outside from SAP (as MS excel), so if you are agreed with to do an extra work analysis outside SAP.
If your PO is containing multiple line items, since if your some data (like as material, plant etc) are not same for multiple line items, then you can’t combine these lines into one.
You can’t do this when your vendor will give you invoice as per line item and vendor says you will not get rest material until you pay his sent invoices for another line item (which has completed).
You can’t do this when your vendor says he will give you some discount if you pay him for another line item which has completed and you will not able to get this discount if you will wait for the whole PO complete (all line items). Then it is suggestible to make the invoice and payment as per line item.
PO number 4500013608 contains 3 line items.
PO number 4500013609 contains 2 line items.
GR pending only for 3rd line item for PO number 4500013608. Hence I just need the report which will contain only PO number 4500013609 because only this PO number get fully completed.
Create a selection parameter as delivery complete tick indicator and delivered = Ordered. So that we can get all these line items whose are having filly GR completed.
IMG path : SPRO-IMG-Materials Management-Purchasing-Reporting-Maintain Purchasing Lists-Selection Parameters-Define Selection Parameters.
It will be much better to create your own selection parameter. You can create by coping a standard, then you have to make the changes as below:
Save the selection parameter.
Then take the all completed PO numbers (completed as per line item) with from ME2N with selection parameter ZDEV and ALV layout. It brings 4 entries (2 line items for PO number 4500013608 and 2 line items for PO number 4500013609)
Export it to excel.
Then copy these PO numbers and take the DCI indicator from EKPO table (DCI will be flagged only for these line items which has GR completed and also be sure your system has the option set delivery indicator automatically activated).
Export it into another excel sheet and replace the blank with value A (You can use A to W – alphabetically below than X). Then sort the DCI field. You can see the A will be appeared first.
You can see my one PO number has two DCI indicator as A and X. I have sorted this because we know excel will take the first value for formula V-Lookup when source contain different value.
Now I have two excel sheets. First is exported from ME2N and second is exported from EKPO table. I’ve done V-Lookup and take the DCI indicator from second excel to first excel.
Now our first excel will look like as below:
Now here, delete the line item which will contain the value A in DCI field.
After delete the line items, you will get the line item which will contain only value X for the field DCI.
It is thereport for all PO numbers which has completed GR in header status.
It means I get the PO number which are having GR as fully cleared for all line item.
I can compare this PO in SAP system as Header – Status as “Fully Delivered”
Here, in your excel sheet, you’ve got these PO numbers which are having GR fully delivered.
Now if you want to check the Invoice has already done yet or not for these PO numbers, then just go to ME2N report and filter these PO numbers with selection parameter “RECHNUNG”. You will get the result for all PO numbers with header status as “Fully Delivered” and “Not yet invoice”.