Report to view purchase orders and corresponding invoice due date

[former_member1344486]

Hi All

I've given up trying to find a standard report and am turning to all you clever people for some help please! I'd like a standard report to view all purchase orders with their corresponding invoices to date, along with the invoice due dates.

The best I can come up with is ME80FN, and then I change the view to Purchase Order History which then gives me the invoice numbers but not the invoice due date. Does anyone have a suggestion?

Or, if I could view a vendor open item report that includes the PO number, I could cross reference these 2 reports - but I can't find an open item vendor report that has a Purchase Order number field.

Please help!

Thank you

[former_member233510 · Accepted solution]

Hi Tanya,

There is no standard reports provide you Purchase orders with invoice to date and invoice due date. You've to use the report "MIR5" for checking baseline dates from which the due date is calculated and use the report "ME80FN" for checking Purchase orders with invoice details.

If you want both the information in a single report, enhancement is the answer.

BR, Rosh.

[former_member1344486 · Accepted solution]

Thank you! I'll do that

[AD211]

Hello, 

I am not sure if you got this answer, but this is the best you can do with your standard access. 

Like mentioned by others you might need to download multiple reports. 

ME2N - PO Report 

ME80FN - Invoice Document Number 

FBL1N - Invoice received Date, Invoice Posted Date, Invoice due Date, Payment date and Ne Due date according to your payment setup with the Supplier (for this you need Vendor account number, not the Vendor code used while creating a PO) 

Combination of these three will give you what you need, if you are going to doing this report frequently, I would suggest creating a custom report. 

Hope this helps 

[Former Member]

According to me, you can go for SQVI reports and make table join and you can also set T-code for the SQVI report.

[former_member1344486]

Hi Shri,

Unfortunately I don't have user access to tables etc. Which is why I'm hoping to find a standard report that can help me!

Thanks

[Former Member]

Hi,

In ME2N t-code select selection parameter as we103(Open goods receipt) and enter Purchase order number, you will get open quantity for PO.Please check if it meets your requirement.

[former_member1344486]

Hi,

No. I'm looking for invoices already received against a PO, and the due date of those invoices.

Example:

PO for £2000     GRN     £500          Invoiced on inv no. XXX £500

                           GRN     £1500      - not inv'd yet -

Does that make sense?

Thanks!

[ajitkumar]

check this for due date analysis for vendors;   S_ALR_87012078 and S_ALR_87012168 for customers

[former_member1344486]

Hi Ajit,

How can I see the purchase order number if I use S_ALR_87012078?

I need either:

1) A report that shows the Purchase Order with the invoices against that PO and their due date OR

2) An vendor open item report that shows the Purchase Order number.

I've tried FBL1N and adding the Order field, and Purch Doc field but these are blank

Thanks