cancel
Showing results for 
Search instead for 
Did you mean: 

Reason code for short payment received from Customers

Former Member
0 Kudos

Hello

We are on ECC 6.0 without application of any enhancement package.

Requirement is to capture reasons of short payment received from customer and generate a report based on such reason codes.

Reasons of short payment received could be - Adhoc payment; Excess billed; Tax deducted at source (TDS) on freight / service charges and Bank charges etc.

Let me know relevant configuration required.

Would reason codes be captured during incoming payment entry or customer account clearing?

Thanks.

Vimal, India

Accepted Solutions (1)

Accepted Solutions (1)

former_member695461
Contributor
0 Kudos

Hi Vimal

Following is the configuration for Reason code for customer payments. It can be short payment, over payment or discount not allowed.

First step is to define reason code. You do this in Financial Accounting (New >Accounts Receivable and Accounts Payable>Incoming Payments>Incoming Payments Global Settings>Overpayment/Underpayment>Define Reason Codes

Define reason code , short text, long text and assign it to correspondence type. (please note correspondence type settings needs to be done first). There is a column c which is Indicator: Charge off difference via separate account set this if you want to post the difference to seperate account during clearing customer open item.

The second step is to define accounts for payment difference.

Financial Accounting (New >Accounts Receivable and Accounts Payable>Incoming Payments>Incoming Payments Global Settings>Overpayment/Underpayment>Define Accounts for Payment Differences

Assign G/L accounts against reason codes.

The third step is Define Reason Code Conversion Version

Financial Accounting (New >Accounts Receivable and Accounts Payable>Incoming Payments>Incoming Payments Global Settings>Overpayment/Underpayment>Define Reason Code Conversion Version

In this step, you make the default settings you need for the manual incoming payment processing via payment advice notes. If differences between the payment advice item and the total of the allocated open items occur after selecting the open items, you can enter a reason code in the payment advice item. This represents the reason for the reduction of the payment amount specified by the paying person.

Create version 001 and name for it.

For correspondence type create or assign relevant form and print program in global settings> correspondence

Once you have these settings you can insert appropriate reason code while clearing customer open item .

You can print correspondence via T-ode F.62 on a monthly basis or wekly basis.

Hope this helps.

Thanks

Sanjeev

Former Member
0 Kudos

Sanjeev

Thanks for your detailed reply.

We do not wish to charge off difference to Expense A/c in case of charges like DD charges deducted by customer or to a GL A/c in case of tax deducted by customer where he is going to give us TDS certificate.

Thus, short payment received from customer would appear in his Ledger Account displayed through FBL5N. Would your reply be still the same?

Is it possible to generate a report based on reason code? Is it a standard report? Name me t code(s).

Thanks.

Vimal

Edited by: Vimal Kishore Soni on Nov 24, 2009 7:18 AM

former_member695461
Contributor
0 Kudos

Hi yes. it is business process wether you want to charge of difference to different account or do something else with it.

Regadring reports. you assign reason code to correspondence type as mentioned in my earlier reply and from T-code F.62 you print the correspondece.

apart from that you can also look at customer lien item report and sort it out based on reason codes. that should be possible from normal customer line item report.

Hope this helps.

Thanks

Sanjeev

Answers (0)