Skip to Content
avatar image
Former Member

How a customer billing document was paid

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Jul 17, 2012 at 07:33 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 18, 2012 at 04:26 AM

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

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2012 at 06:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2012 at 05:35 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

    • 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