How to find out the Sales Orders which are Invoiced but not paid

[Former Member]

I got a requirement to sort out the Sales Orders which are Invoiced but not Paid.

Please help me in finding the relevant Tables and Fields.

Thanks

Prasanth Reddy

[former_member186385]

Hi Prasanth,

Get the Accounting documents from VBRK-BELNR using your Billing documents VBELN

now pass this BELNR into BSID table to get the cleared Accounting documents

in BSID all your cleared documents will be available

If any entry is not existing in BSID, it means it is not cleared

thanks

santosh

[Former Member]

Thanks Santosh.

Finished the Task.

[Lakshmipathi]

Program RFITEMAR is having the option to fetch both Open Items and Cleared Items of billing document, in one screen.  Ask your ABAPer to consider this report which will also have billing reference.  For sale order reference, you can find AUBEL from VBRP.  But before going for any enhancement, check with your FI colleagues to find out any standard report.

G. Lakshmipathi

[Former Member]

Thanks Lakshmipathi.

Found the Relevant Tables (VBFA, BSID, BSEG).

Task Completed.

[bsivasankarreddy_reddy]

hi

go to Table BSEG here enter the billing document number (VBELN) , then execute find the clearing date , clearing document(augbl), once document clearing this data available not clearing its comes blank ,

[Former Member]

Thanks Siva.

Task Completed.