‎2010 Mar 09 3:48 AM
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.
‎2010 Mar 09 5:13 AM
‎2010 Mar 09 5:27 AM
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.
‎2010 Mar 09 6:23 AM
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
‎2010 Mar 09 7:03 AM
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.
‎2010 Mar 09 8:26 AM
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