Question on Auto Clearing & dunning of negative amounts

[former_member257418]

I have a couple of questions related to Credits which I am encountering in our system :

Whenever credits are transferred from another CA (doc type XF), these are not picked up in auto clearing.

Let me explain this with an example & this typically happens in Bankruptcy cases. If a customer files for Bankruptcy , all the payments made after the bankruptcy filing are moved to new account. All the unpaid bills remain on old account. Suppose  .$ 100 credit was  transferred to new account & the customer was subsequently invoiced , the auto-clearing does not clear the credit against the invoice. Also we see this credit going thru' dunning process though we have set in config that dunning should not occur for less than 60. I see this behavior for Security deposit refunds too , where the credit is on doc type IN. They are not cleared in auto clearing & go thru' dunning.

Where should i look in clearing rules to address the first issue ?

For the -ve amount going thru' dunning process ... do i need to look for any enhancement.

I have attached a couple of screenshot of accounts where Security deposit refund were transferred & example 3 is for recently released Security deposit (docs of this type though having credit go thru dunning)

Appreciate your advise.

[AmlanBanerjee · Accepted solution]

Hi Satish,

There can be many reasons, as why the transfer posting document are not getting picked up in the auto clearing run.

(a) To start with, check in the auto clearing transaction, FPMA, where the document type XF or the clearing reason 03 is being excluded in the custom selections or not.

(b) If everything is fine, check the clearing steps, that is being configured under the clearing variant, in the SPRO node-

SPRO-->Financial Accounting---> Contract Account AR &AP-->Basic Functions--->Open Item Mgmt.-->Clearing Control-->Define Specifications for Clearing Types--->Define Specifications for Account maintenance.

For clearing type 03 and 04.

(c) If you still couldn't find anything, then you have to check the clearing events, like 0110, 0120 etc.

to check if there is any customization that is causing the issue.

With regards to the picking up of the Credit amt in the Dunning run, there is a configuration at the Dunning procedure level, which controls the behavior of credit during the dunning run, which is only applicable for Industry component Insurance.

IMG--->Financial Accounting--->Contract Accounts Receivable and Payable--->Business Transactions--->Dunning--->Dunning by Dunning Procedure-->Configure Dunning Procedure

Select any one of the dunning procedure and click on display.

In there, under the parameters section you will find the "Behaviour of Credit field"

There are three values as follows for this field and is configured as per the business requirement-

0-Dun All Items, Ignore Credit for Dunning Balance

1-Dun All Items, Consider Credit for Dunning Balance

2-Do Not Dun if Credit Exists

Check the value that is set for the Dunning Procedure that is set at the CA level.

Also can you check event 306/309 to see if there is any customisation.

Hope it helps..

Thanks,

Amlan

[former_member257418]

Amlan

Appreciate your detailed response. I think you have helped me in finding the cause for the first issue.

• I see the following selection in FPMA. We have the C flag on a document after a security deposit refund is approved. I think auto clearing is selected only docs with the C Flag.

The config related to clearing seems to be correctly set

Related to 2nd issue... the current setting for "Behaviour of Credit field" is "0". Should this be '2"

Also to clarify what you mean by below statement is to check the dunning procedure set for CA ..right

"Check the value that is set for the Dunning Procedure that is set at the CA level."

Once again thanks a lot for providing guidance.

.

[AmlanBanerjee]

Hi Satish,

The dunning configuration, that I have told you is applicable only for Insdustry solution Insurance.

Can you check if this is happening only for transfer posting Credit documents or any credit which is open is getting picked up in the Dunning run.

Also check event 336, if there is any customisation done.

Hope it helps..

Thanks,

Amlan

[former_member257418]

Hi Amlan

It seems it is picking all credit items for doc type IN & XF. if it is payment doc , it does not happen.

There are no customizations on event 336.

Also i was incorrect in interpretation of the custom selections in FPMA...on closer look the condition set is if payment method is C , than do not select. Based on this it should have selected all other docs.

Is there anything else i can check.

Regards

Satish

[rahul_paldiwal2]

Hello Satish,

Check event 311 and 302 if any customisation around credit amount exists?

Regards,

Rahul

[william_eastman]

Satish:

Are the XF items marked with restriction code?  Beyond that, execute FP06 for the account and choose create proposal to see if the items are selected.  You could also try FPMA eliminating the selection criteria to test if that changes the results.  You havent shown what the clearing variant details are for the 001 entry, if they are the standard or customized.

Additionally - this should be two separate threads so as to avoid confusion.  Please fix this asap.

regards,

bill.

[former_member257418]

Will

My apologies will for having both issue in the same thread.

Do you want to me to create 2 separate threads....

There are no restrictions on transferred documents.I am going to try what you suggested with regards to FP06 & FPMA.

Th clearing variant in the system is as under:

Regards

Satish

[rahul_paldiwal2]

Satish can you please check if any payment or clearing lock is applied to the payment made against the security deposit ?

[william_eastman]

Yes - 2 threads.

[former_member257418]

THIS THREAD HAS BEEN CLOSED & ISSUES POSTED UNDER 2 SEPARATE THREADS