How a customer billing document was paid

[Former Member]

I have a billing document which was paid partially several times until it was completely paid. How can I get a report to tell me that a (or more) billing document was paid as follows:

BillDocNo      Amount      date

BillDocNo      Amount      date

BillDocNo      Amount      date

[Former Member]

Thank you for your replies, but from the below data (FBL5N) how can you deduce the payments for  billing 3011018961 and 6110031660

You can say that 800 were used to pay both documents, and later 1200 was used to pay two clearing documents.

Assignment	Document Number	Document Type	Document Date	Posting Date	Amount in local currency	Debit/Credit Ind.	Clearing Document	Clearing date
6110031659	3011018961	RV	24-Jun-12	24-Jun-12	1,000.00	S	1111014154	2-Jul-12
6110031660	3011018962	RV	1-Jul-12	1-Jul-12	1,000.00	S	1111014154	2-Jul-12
6110031660	1111014154	AB	2-Jul-12	2-Jul-12	600.00	S	1111014155	9-Jul-12
6110031659	1111014154	AB	2-Jul-12	2-Jul-12	600.00	S	1111014155	9-Jul-12
20120702	1811008755	DZ	2-Jul-12	2-Jul-12	-800.00	H	1111014154	2-Jul-12
20120702	1111014154	AB	2-Jul-12	2-Jul-12	800.00	S	1111014154	2-Jul-12
20120702	1111014154	AB	2-Jul-12	2-Jul-12	-2,000.00	H	1111014154	2-Jul-12
20120709	1811008756	DZ	9-Jul-12	9-Jul-12	-1,200.00	H	1111014155	9-Jul-12
20120709	1111014155	AB	9-Jul-12	9-Jul-12	1,200.00	S	1111014155	9-Jul-12
20120709	1111014155	AB	9-Jul-12	9-Jul-12	-1,200.00	H	1111014155	9-Jul-12

I am looking for a logic to lead to the following output

3011018960 value: 1000 paid 400 on 2-Jul

3011018960 value: 1000 paid 600 on 9-Jul

3011018961 value: 1000 paid 400 on 2-Jul

3011018961 value: 1000 paid 600 on 9-Jul

Isn't there something standard to give me this output?

[virupasan_balanathan]

Hi

Building a Logic like this is Not that easy. If you are Practicing "Residual Payment" (A residual item results when a payment is made for less than the actual amount outstanding. You clear the original open item, and the system posts a new open item) Method Logic Will be More Complex.

Since Every time You do Part Payment System Will Create New "AB" document. Then "AB" Document Need to Be Settled with Another "DZ" or Other Document.

Anyway You need to Extract the Date From "BSAD (Cleared Items) "  and "BSID (Open items)" Tables and Clearing Document (AUGBL) , Payement Reference (KIDNO) and  Billing Document (VBELN).

We are also Having Smiler Requirement, Sine this is more related to Finance our FI Consultant is Working on this.

Regards

B.Virupasan

[Former Member]

hi,

check the sold to party details through transaction fbl5n.

sales order is maintained in VBAk and for  items select go to table vbap.

for billing documet search VBrk and vbrp.

if payment is not cleared check in in BSAD and if cleared look in BSID

Message was edited by: john tra volta

[Lakshmipathi]

Just check in FBL5N.  You will get the required details.

G. Lakshmipathi

[Shiva_Ram]

Use table VBRK and VBRP in an ABAP query to get the data. If you want to add any preceding document like sales order into it, then use table VBFA.

Regards,