Finding Part Payment line items in FBL1N report

[Former Member]

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

[Former Member]

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

[former_member190901]

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

[Former Member]

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

[Marssel700]

Hi Chirag,

please check my solution on this discussion

f-53 partial payment net amount display

You will have in the clearing transaction a report to display all referenced documents.

regards

[former_member220489]

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)

[Former Member]

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

[Former Member]

Dear Jessica,

My question is even if the relevant field is empty in table, why isn't appearing as blank in FBL1N report?

Regards

Chirag Shah

[Former Member]

Hi,

The field is invoice reference and it is available as selection output. Just change your layout.

Thanks,

[Former Member]

Hi,

That field in FBL1N is coming from structure RFPOSXEXT, not a direct table.

Thanks

[Former Member]

Yes Mam,

Thanks for your precious time,

By saying "Mapped the field" I wanted to convey the same message, that I have changed my layout using the field "Invoice Reference".

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)?

Regards

Chirag Shah

Edited by: CHIRAG SHAH on Feb 20, 2012 1:52 AM

Edited by: CHIRAG SHAH on Feb 27, 2012 12:29 PM

[Former Member]

Hi Chirag,

After you add the invoice reference by changing the layout. Click on "Save Layout" and save your layout.

Next time when you run FBL1N report select your saved layout in the selection screen and execute the report. The field will appear in FBL1N report output.

Thanks,

Neel

[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