Partial Payments

[Former Member]

Hi Gurus,

If there is any partial payments are made by the customer then that data is also stored in BSAD table. How can i know whether this record in BSAD table is partial payment and full payment for invoice. And how amount he paid?

Thanks

Ravi

[Former Member]

If the invoice has been paid partial still remains into BSID table but the fields REBZG REBZJ REBZZ of the payment document contains the invoice number the year and the line. The fully cleared invoices are stored into BSAD and the fields AUGBL AUGDT contains the clearing document and the clearing date.

[Former Member]

Hi Ravi Kanth,

For the invoice if the total amount is received(cleared) then the record exist in BSAD with clearing document number and clearing date(recent payment date).

If the total invoice amount is not received , partial payment is made for that invoice then you can find the partial payment record in BSID table . Get all the records from BSID table by selecting BSID-ZUONR = Invoice number, and also enter document type BLART like 'DZ' ( customer payment) .Then you will get all the partial payments for that invoice.Sum up the DMBTR(Amount in Local Currency) value .

Regards,

Rajitha.

[kanishakgupta1]

Hi,,

Check for REBZT field in BSAD if it is not empty then it means it is a partial payment

thanks

kanishak

[Former Member]

Thanks For all.