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

Finding Part Payment line items in FBL1N report

Dear Sir,

Client want to know the line items in vendor accounts that are already assigned to some invoice reference but still not cleared. (Part Payment)

For this we mapped Invoice reference field (Column) in FBL1N report.

But here in this column where ever invoice reference field (REBZG) is empty in BSIK table it automatically showing value of Document No field (BELNR) in this column.

As a result we are not getting the Part payment line item differentiated from other line items.

Is there any other way to know part payment detail, other than Z report ?

Thanks in anticipation

Regards

Chirag Shah

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2012 at 07:32 PM

    Hi,

    You can see this in BSEG-REBZG or ib BSID-REBZG. The invoice itself does not get updated, only the new partial posting document. Maybe you want to post as a residual item instead?

    Thanks,

    Jes

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Sir,

      I did the same and I am getting the result but my issue is it is not appearing same as that of data exist in table BSIK (REBZG).

      My question - is there any way in standard SAP to show the Invoice Reference field (column) in FBL1N report

      same as that is appearing in Table BSIK (REBZG)?

      Thanks & Regards

      Chirag Shah

  • Posted on Feb 17, 2012 at 07:48 PM

    In case if your requirement is only for few times or you always export this FBL1N data to excel and make changes there according to your requirement to show to business users, then after exporting fbl1n data to excel, simply remove those doc no value from those records in excel, where the invoice ref doc number is also same as part payment document number.(BELNR).

    In excel you just match original part payment doc no BELNR value with inv ref doc no REBZG, if both are same just remove those rebzg value for those records in excel.

    Else, you can go a head with ABAP/4 query report using table BSIK, which will give same data similar to fb1ln open item list, in the output for this query report, you use the same logic to to hide REBZG value in case if it is same as BELNR. (SQ01&SQ02)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2012 at 08:23 AM

    Dear Experts....

    Awaiting for solution, please!

    Your little time will be of good turn to me...

    Regards

    Chirag

    Edited by: CHIRAG SHAH on Mar 6, 2012 8:59 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 15, 2012 at 11:27 AM

    Hi,

    You can try to add additional field BSEG-REBZT in OBVU. After this you should be able to filter content 'Z' (partial payment) in the open item reports (FBL1N or FBL5N).

    Regards,

    Filipe

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 18, 2012 at 12:13 PM

    Filipe answer is correct. Add the field "Follow-on document type" in your reports layout.

    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.