Clearing requirement

[Former Member]

Hello Experts,

We have currently configured the clearing rules for payments with sorting character as

1. 019 Statistical indicator with sort checked and

2. 010 Due date

This enables payment to clear based on due date (older debt first).

Now we have 2 requirements:

1. If a customer has dunning lock reason 2 for example at Contract account level, with an indefinite lock (lock until 31.12.9999), then if a payment is posted to this customer then it should clear the current Invoice (2011-2012) instead of the old debt first. For other customers, payment should clear the oldest debt first as it currently does.

2. If a customer has a dunning lock reason 4 for example at Contract account level, with an indefinite lock (lock until 31.12.999), then if a payment is posted to this customer then it should clear as below:

£13.60 (Fixed) to clear oldest debt

Balance to clear against the current Invoice (2011-2012)

Example: If a payment is received for £25, it should clear £11.40 against the current charge and £13.60 should clear against the oldest debt (debt other than 2011-2012 Invoice)

Is this possible through clearing control configuration?

Your expert opinion is appreciated.

Regards

Jude

[ivor_martin]

Hi jude,

You could use FICA Event 0110, where you can programmatically distribute the amount of the clearing between open items, and inspect for Lock reasons, etc...

Keep in mind that this will pretty much bypass your Clearing configuration, so troubleshooting clearing issues will be more challenging.

Regards,

Ivor Martin

[Former Member]

Hello Bill and Martin,

Thanks both for your immediate response. We will try the suggestions and will let you know if it worked.

Thanks

Jude

[william_eastman]

Jude:

Since your business process is using a field for a purpose it was not intended (dunning lock has no bearing on clearing), the requirements cannot be met with configuration. You can investigate adding new characteristics and providing your own logic for them (see template FM ISU_SAMPLE_TFK116). You might also need to create logic in an initial clearing step with a customer module, using FM FKK_SAMPLE_TFK115 as template.

regards,

bill.