topic Partial Payments in Application Development and Automation Discussions

Partial Payments

Former Member — Thu, 04 Jun 2009 07:25:26 GMT

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

Re: Partial Payments

Former Member — Thu, 04 Jun 2009 08:09:35 GMT

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.

Re: Partial Payments

Former Member — Thu, 04 Jun 2009 10:22:31 GMT

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.

Re: Partial Payments

kanishakgupta1 — Thu, 04 Jun 2009 11:12:11 GMT

Hi,,

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

thanks

kanishak

Re: Partial Payments

Former Member — Mon, 08 Jun 2009 12:32:05 GMT

Thanks For all.