Match partial paid invoice with customer payment

Advertisement

Hi all,
My company FI user told me that those partially paid invoice will still shown full amount in the FBL5N report and also Statement of Account (F.27). Besides that, the customer payment that used to knock off the partially paid invoice also will shown to deduct the already paid amount.
But the user said that both of the FBL5N and F.27 are not link the partially paid invoice and customer payment together or don't have a key field to indicate which payment is refer to which partially paid invoice. When the next time they receive another payment and want to knock off the outstanding invoice amount, they are not sure that which invoice should they knock off.
For example, we have the list of invoice and payment below:
01/02/07 Inv001 $1000
02/02/07 Inv002 $2000
10/02/07 Inv003 $4000
11/02/07 Inv004 $5000
01/03/07 pay001 $1000 - knock off the Inv001
01/04/07 pay002 $3000 - knock off the Inv003 partially
So in FBL5N and F.27, the list is shown as below:
02/02/07 Inv002 $2000
10/02/07 Inv003 $4000 (still shown as full amount instead of outstanding $1000 only)
11/02/07 Inv004 $5000
01/04/07 pay002 $3000-
So when FI user receive another $3000 payment, they should knock off the Inv003 outstanding amount $1000 first then only knock off the Inv002.
But in the FBL5N and F.27, we can't find the relationship or key field to match the old payment (pay002) to the invoice that knocked off by it. Due to our invoice list may very long, such as more than 50 invoices per customer, so we need to spent a lot of time to trace back all invoice.
So the FI user requested I to modify the F.27 statement to match the payment and partially paid invoice. But I already search through many tables, such as BSID, BSEG, BSAD, etc and still not able to get the information that requested by the user.
Can anyone tell me that which table, which field should I refer to or any method to get the information?
Thank you.

Advertisement

Hi,
Check field BSID-REBZG. When you create a partial payment this field will have original invoice number.
- Let's say you have invoice INV#1 with amount 100.00.
- You create a Partial payment of amount 45.00 and the payment doc is PAY#1.
- Now if you look at the table BSID, there will be two entry in this table
  1. BELNR = INV#1, WRBTR = 100.00, REBZG = 'Blank'.
  2. BELNR = PAY#1. WRNTR = 45.00, REBZG = INV#1.
This will help you determine the partial payment. I hope this will help you find solution your problem.
Regards,
RS

October 11, 2015

Match partial paid invoice with customer payment

Hi all, My company FI user told me that those partially paid invoice will still shown full amount in the FBL5N report and also Statement of Account (F.27). Besides that, the customer payment that used to knock off the partially paid invoice also will

AR Invoice with Installment Payment Terms

Hi to All, We have an invoice where the payment terms are based on installment. The installment is for 18 months.  Automatic cash receipts have been applied correctly for Installment 1 and Installment. Our situation is this where we want to apply an

Automatic Invoicing with CC Payments

Has anyone ever seen or knows of a way to set up automatic invoicing using CC payments AND have them as a recurring invoice every month? I have tried Document Wizard and I can get the invoice created from a Sales Order using the CC, but how can I set

Dear Customer Service Team,  I bought a twelve-month Dreamweaver CC program with monthly payment that I have paid via bank transfer and there would be a question about the activation. How could I get the license key with which I can activate my account? I

Dear Customer Service Team, I bought a twelve-month Dreamweaver CC program with monthly payment that I have paid via bank transfer and there would be a question about the activation. How could I get the license key with which I can activate my accoun

Match Bill Of Lading With invoice for payment

HI All, In my current project, client is using 3PL (third party logistics) for transportation of goods from one plant to another plant. We are creating Bill of Lading but not using Transportation component of LE. Client has a requirement to use the b

Import Incoming Payments that is partially paid (DTW)

Hi, I would like to know how to import Incoming Payments with DTW when the invoice that is partially paid? ThanksSuda, I dont want to import any invoices for the B1. I want to import only the incoming payments from the invoices that were not already

To find Invoice Open or Partially Paid

Hi friends, I have open invoices and iam displaying AMOUNT BSID-WRBTR in my report. a) Now i have to find out the invoice is fully open or partially paid. b) If partially paid what is the amount which is paid and what is the due amount.. what are the

Customer Paid invoice aging report.

Hi Experts, Our client want to know how many days customer took to pay the invoice, we have checed in the customer payment history here we can see the total amount it includes the dedution and the cash discounts he want to know the amount by excludin

Error in clearing - Payment with residual items in invoices with defer $1

Hi I did customer advance with service tax. Entry: Bank A/c... Dr 52000    To Advance Rs.50000    To service tax interim Rs.2000 Now i ran F.38 and Rs.2000 got transferred to service tax final A/c I did FB70 (for total amount of Rs.150000 + 4%) Entry

How to Post Customer invoice and Incoming Payment?

Hi, Please give me some inputs for the below scenario. Please help me where i can do this..I could not find the T.Codes.. 1. Customer Invoice 2. Customer Payment at Desk 3. Down payment 4. Down Payment Clearing I could able to find the t.code for Dow

FPCOPARA - Don't print invoices with payment method in contract account

Hi!!! We are trying to print several invoices with transactio FPCOPARA but if the payment method in contract account is filled, it does not print them. Is this normal?? Is there another way to print them? Thanks for your help, Regards, Antonio.Hi , F

Vendorpayment: netting of closing invce with down payment no customer scena

Hello, I am doing the following. create down payment F-48: D 29 A vendor 100 EUR C 50 bank account 100 EUR create vendor invoice FB60: D 40 cost account 250 EUR C 31 vendor 250 EUR clear down payment F-54 D 26 vendor 100 EUR C 39 A vendor 100 EUR If

Proforma Invoice for down payment

hi, please what is meant by proforma invoice for down payment and steps for that please help me.   Thanking you,   MadhuH, An invoice that is created on paper for exported goods to provide the customs authorities with evidence of the cost of the good

Posting Customer Payment Term Discount Separately

Hello Gurus, I have configured the system for the Customer Payment Terms in SAP but I am having hard time showing that correctly in FBL5N. For Example: Invoice Value $100 Payment Term 2% Discount Customer Pays on time $98 In FBL5N main display screen

Customer payment: voided check. still in clear items

Gurus... We paid a customer with two checks sent out last month. The checks were returned to us and we voided and stop-paid them. However it's still showing in the system as "paid" in the customer detail. that is in FBl5n its in cleared items. S

Collection of Fully Paid Invoices from AR to Incentive Compensation

Hello. We have a requirement to calculate commission on fully paid invoices only. In Compensation we are able to collect invoices but there is no restriction on submitting an invoice to calculation when it is not fully paid. For example: I have an AR

Credit Management with advance payment

Hi, We have credit management scenario with advance payment. In most cases the customer pays an advance. This advance may / may not be against a specific Sales order. At the time of checking the Credit limit, the system has to check the customer adva

How to clear the down payment against the vendor invoice in the payment program?

A down payment is made $25 Later an invoice is posted for $100 Now i want to Pay $75 to Vendor But the Automatic payment program  is not clearing the down payment against the vendor invoice. Could you please help how to clear the down payment against

Customer payment method

Hi all, I need to find how customer is paid in last transaction ( payment method), any tables that hold customer payment history information? I did check KNB4 but it doest tell Payment method. I can check KNB1 for payment method but master data can c

Invoices or Incoming payment appear several times

Hello We see on some customers statement invoices with the same amount and same document number twice and incoming payments same amount, same doc num three times We sue SAP 2007 SP00 PL 39 What could be the issue because customer statement is obvious