Create A Report with for Customer short payment in SAP

[former_member182339]

I have a requirement where i have to create a report to identify customers with short pay every day/weekly, It may be a query or a report.

Would something like this be possible where the document # could show the value, then payment applied, and if not equal to 100% show those documents?

Example:  Invoice 90623643 is for $1600 and payment posted against it is only $1535.  Lockbox just posts this as a partial payment and we aren’t aware of the short pay until 60-90 days down the road.

If the query/Report could show this and then we would research and find out they short paid pricing and get a PC entered and credit issued or reason for denial of claim on a timely basis.

Please review my comments and advise your thoughts. 

Thank You

Hrusikesh

[Lakshmipathi]

Moved from SAP ERP SD Billing to SAP ERP Financials

G. Lakshmipathi

[eduardo_hinojosa]

Hi

Research a financial tool. Check tcode F.27 (see the documentation). It uses the report RFKORD10 (run it with SE38 and read the documentation) and research the flags with a red frame in my screenshot

I hope this helps you

Regards

Eduardo

[former_member182339]

what i want to see is in the report and it should be track daily

Posting Date      invoice number      invoice amount      Payment      difference amount     due date

  05/25/2013       000001                    1600                    1535               65                         01/06/2013

Thank You

[former_member205178]

Hi,

Check the FI Standard Reports on Customer Balances. You might not get the perfect one but you might at least find 90 % requirement met without custom report. .

Else you can create a query in SQVI table join using -> VBAK, VBRK, BSEG, BKPF, Etc. Do understand that you should query for lesser periods / documents for data.