Skip to Content
author's profile photo Former Member
Former Member

AP register report with PO and related invoices

Hi SAP gurus,

Business wants a AP register report, listing all processed invoices related to a PO.

Basically they want to see the PO no. and invoices on the same report.

I have tried to find a std report but couldnt. Please suggest if there is any such report or if not how I can get it thru may be SAP query. Also please give me step by step procedure to right a SAP query.

Thanks a million, in advance. I will reward point promptly.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Nov 29, 2007 at 03:34 PM

    What is the purpose of this report. There are multiple invoices possible for every item in the PO. These are visible in the PO History.

    EKBE is the table, you may play around the PO history category to get various invoices.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 07:40 PM

    If you want to do this from Finance an idea is to make sure the PO number is being written to the assignment field of the Vendor line item.

    This can be done simply by making the correct selection for the sork key of the recon account for Vendors.

    Once you are happy that the PO number is being added into the field, you can run an open item report per Vendor and sub total it by Assignment, thus giving you a break down by PO number.

    Please award points if this is helpful.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.