Purchase Order Report of PO with Balances

[Former Member]

Hi Experts,

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

Thanks,

Matt

[phelo-gijana]

Hi Matt,

So after seeing the balance quantities on the PO invoices, what do you do with the same PO’s stuck in transit holding up the stock?

[moshenaveh]

Hello, While we're happy that you've come to SAP Community to get an answer to your question, you posted your question as an answer in an old thread.
I've converted your answer to a comment, but even so -- posting in older threads is not the best way to get guidance.
If you're looking for help, you should ask a new question: https://answers.sap.com/questions/ask.html.
Here are some tips to help you craft an effective question for our community: https://community.sap.com/resources/questions-and-answers, https://developers.sap.com/tutorials/community-qa.html, https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a....
I encourage you to follow this guidance, as I'd really like to see you get a solution to your problem.
I hope you find this advice useful!

[Former Member · Accepted solution]

Hi,

Try this.

Transaction - ME2M

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

Regards,

R.S

[Former Member · Accepted solution]

Hi R.S.,

Thank you,

Matt

[kailas_ugale]

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

[Former Member]

HI Kailas Ugale,

Thanks,

Matt

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Use the below reports

ME80FN, MB5S,FS10N,F019

Regards,

Udaya.

[Former Member]

Hi Udaya, thanks for the quick response. I tried to go to the t-codes that you shared but they don't show a report that shows the remaining balance to be paid for the the particular P.O. Maybe we need to have it customized 😃

[Former Member]

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.