topic Re: Partial Payments in Application Development and Automation Discussions

Partial Payments

kiran_k8 — Tue, 09 Mar 2010 03:48:25 GMT

Hi Folks,

I have a scenario wherein I need to identify Partial Payments for a Vendor/Customer.

Vendor:-

Vendor should always be in credit (ie Payment is made) and still if any item showing debit in open items tables is treated as a partial payment or advance payments.If it is advance payment this line item having special G/L indicator.

This is what the input I got from FC but I am expecting more refined inputs.

Do anyone here can throw some light on the above.

Thanks,

Kiran.

Re: Partial Payments

manthanraja — Tue, 09 Mar 2010 05:13:15 GMT

It seems like you have to Create a replica of F-53 transaction ..

Why don't you create a Recording of the said transaction and add a user exit ...

this [THREAD|]

has all the user exits listed for F-53 ..

Manthan.

Re: Partial Payments

nirajgadre — Tue, 09 Mar 2010 05:27:05 GMT

Hi,

1. I guess when the partial payment is made for the any of the open item for the customer or vendor invoice the data is present in the BSIK and BSID table.

2. to identify the the partial payment line item you can use the invoice reference invoice number field (REBZG) and fiscal year (REBZJ). this to fields are contain the invoice number for which the partial payment is made.

3. when the inovice will get fully paid all the entries of the partial payments are moved from BSIK ,BSID table to BSAK and BSIK table.

Re: Partial Payments

kiran_k8 — Tue, 09 Mar 2010 06:23:00 GMT

So,first check if there are entries available in BSAK/BSAD (Vendor/Customer) -ie Entries available means Payment is done

then for the same check if any more entries available in BSIK/BSID w.r.t the Invoice number,Vendor,and fiscal year.Entries available means Partial Payment else not.Am I right ?

Thanks,

Kiran

Re: Partial Payments

nirajgadre — Tue, 09 Mar 2010 07:03:41 GMT

Hi,

you are right...

1. To get the partial payments for fully paid inovices search the BSAK and BSAD with REBZG and REBZJ field.

2. To get the partial payments of inovice which is still not fully paid, serach the BSIK and BSID with REBZG and REBZJ fields.

Re: Partial Payments

kiran_k8 — Tue, 09 Mar 2010 08:26:00 GMT

Do anyone here have an idea about an FM which can provide me the above details ?

Can we make use of this FM BAPI_BKK_ACCNT_GET_BALANCE

Thanks,

Kiran