Clearing Configuration

[Former Member]

Hi,

Through clearing variant configuration i wan to configure below rules, please help me out how to acheive,

1) Security deposit should get cleared first irespective of due date

2) all other item should be cleared based on due date i.e. oldest due date should clear first

3) Any open item with deferral date in future should not be cleared unless excess payment is made i.e. payment cover all other open item and remaining should be applied to open item having deferral date in future.

I know I can enahce  FQEVENTS 110 but I wan to acheive through configuration.

[AmlanBanerjee · Accepted solution]

Hi Vinod,

Please try the following configuration-

First Step-SD clearing

Grouping String-

(a) 018-Document No.

Sorting String-

(a) 004-Main Transaction-

     Rank Should be 1

     Give the the main transaction of the SD line item followed by other main transactions in the      "Alternate Sorting of Characteristics values"

Group Rule-

Amount rule-0

End of clearing Step-

Payment Rem vari-blank.

End of Assignment-3.

Second Step-Oldest Due First

Grouping String-

(a) 015-Contract Account no.

(b) 011-Item is due

Sorting String

(a) 024-Due date with deferal

(b) 004-Main Transaction.

Group Rule-

Amount rule-0

End of clearing Step-

Payment Rem vari-blank.

End of Assignment-3.

Hope it works for you.

Thanks,

Amlan

[Former Member · Accepted solution]

Hi Amlan,

Many thanks for ur inputs, I got the security deposit working where it is clearing first

But unfortunately documents with future deferral dates are still getting cleared  where as there are other open and overdue items are there at ca

could you please help in that?  May be it requries me to raise OSS note

[AmlanBanerjee · Accepted solution]

Hi Vinod,

Add the following step apart from what I have mentioned in my previous post.

Third Step-Clearing of Items Not due.

Grouping String-

(a) 015-Contract Account no.

Sorting String

(a) 024-Due date with deferal

(b) 004-Main Transaction.

Group Rule-

Amount rule-0

End of clearing Step-

Payment Rem vari-blank.

End of Assignment-3.

Hope it will solve your issue.

Thanks,

Amlan

[Former Member · Accepted solution]

Hi Amlan,

Thanks fo ur inputs, I implemented above but unfortunately its NOT working,

anything else we can do about this?

[AmlanBanerjee · Accepted solution]

Hi Vinod,

First, try to add the document number in the grouping string of the third step mentioned in my previous posts, apart from contract account.

So the third step now becomes-

Third Step-Clearing of Items Not due.

Grouping String-

(a) 015-Contract Account no.

(b) 018-Document no.

Sorting String

(a) 024-Due date with deferal

(b) 004-Main Transaction.

Group Rule-

Amount rule-0

End of clearing Step-

Payment Rem vari-blank.

End of Assignment-3.

If it works, then its fine, otherwise,you can add a custom FM to achieve your requirement.

So in that scenario third step-

Third Step-Clearing of Items Not due.

Grouping String-

(a) 015-Contract Account no.

(b) 018-Document no.

Sorting String

(a) 024-Due date with deferal

(b) 004-Main Transaction.

Group Rule-

Amount rule-blank

Clearing rule- 8

In the customer module, plug in a custom FM, which will sort the document no.s based on their deferral due date and pass it on to the T_FKKCL structure.

End of clearing Step-

Payment Rem vari-blank.

End of Assignment-9

Hope it helps.

Thanks,

Amlan

[william_eastman]

vinod:

these can all be met. but you should show what you have done - what is working and what is not - before asking others.

regards,

bill.

[Former Member]

Ok, I have created two clearing step as below

in first clearing step

grouping string

1) 015 Contract Account

2) 019  Statistical Indicator  char value as H, group rule 3

in the section "end of clearing step"

payment re. var ZPY/2

in second clearing step

grouping string

1) 015 Contract Account

2)  028 Due item (with deferral)

end of assignment 9

i tried whole lot of other combination also like 024, creating third clearing step for 011 as well but nothing worked