Skip to Content

Purchase Order Report of PO with Balances

Hi Experts,

Is there a report to view Purchase Orders that still have balances (not yet received and not yet fully paid)?

Thanks,

Matt

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 08, 2011 at 10:48 AM

    Hi,

    Try this.

    Transaction - ME2M

    Selection parameter - WE101 --> open purchase order quantity, RECHNUNG - open invoices, WE103 - open goods receipt

    Regards,

    R.S

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2011 at 10:40 AM

    Hi,

    Use the below reports

    ME80FN, MB5S,FS10N,F019

    Regards,

    Udaya.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Matthew Jameson Chua

      PO balance, you have the standard reports. here you know balance amount. and already billed amt.

      PO paid or not paid is to look at Invoice verification document. Not by PO. From invoice verification reports, you can tell what is balance amt to be paid. So, you have PO already billed amt - IR bal amt + PO bal amt = bal amt for PO to be paid.

      You need a customized report to consolidate that information required. If not, user have to run 2 reports to give figure.

  • avatar image
    Former Member
    Dec 08, 2011 at 10:45 AM

    Hi

    there is no such report in sap where you can find payment against Po to vendor after MIRO

    still check following t-code

    Click open items(OI) in MIR4 invoice document is cleared.

    or

    Use t.code FBL1N with cleared items option

    oR

    Use t.code S_ALR_87012103 with cleared items option.

    OR

    you have to develop such report for advance payment and actual pay so you can get balance report

    FI consultant will help you to solved this

    and take a help of ABAP consultant to develop it use following table to develop it

    EKKO=Po headr

    EKPO=PO item

    EKBE=PO history

    RBKP=Invoice Header Table

    BKPF=FI Invoice document table

    BSEG=FI table

    BSAK+vendor payment table

    check following link

    [http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13838] [original link is broken] [original link is broken];

    Regards

    Kailas Ugale

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2011 at 10:44 AM

    Hi Matt,

    You can have open PO quantities but not the balances.

    Please correct me if I am wrong.

    at the time of Invoice only theere are chances that Balances are left.

    Hope it helps uou.

    regards,

    Yawar Khan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Yawar Khan,

      Thank you for your response. I tried looking at ME2N, the remaining balance in quantity is shown there as well as the balance of the amount. I think that would do for us. The actual payment cannot be seen in ME2N.

      Thanks again! =)

      Matt