FP05 Auto Clearing using document number only

[former_member527270]

Hi - question on FP05 payment lot clearing.

Requirement from business is to clear items based on document number.

i.e.

These are the open items (amounting to total of 62.97 open receivable):

100006376 2000006816 110060795 0100 0011 30.11.2017 30.11.2017 35.39
100006376 2000006816 110060795 0100 0031 30.11.2017 30.11.2017 23.29
100006376 2000006816 110060795 0100 0071 30.11.2017 30.11.2017 4.29

In FP05, requirement is to post 63 payment by clearing the 3 line items, and creating a payment on account for .03 difference.

Can you please help?

[former_member245270]

Hi Erika,

Based upon your requirement if yon want to touch the event functionality , advise you to don't go for 110 event as its a master event for clearing amount distribution & rather you can made your z event for sample function module FKK_SAMPLE_TFK115 & code it in your incoming payment clearing variant.

Regards

Sachin Singh

[former_member527270]

Hi William -

What are you suggesting then?

I read some events but quite not sure if it can be applied, do you think FQEVENT 110 Clearing: Amount Distribution will apply?

Do you think this can be used?

Thanks,

Erika

[william_eastman]

To do what? Grouping by document number will NOT work for incoming payment scenarios. I suggest removing it as a grouping criteria.

[former_member527270]

Hi William,

I tried to create a grouping (contract account and contract) with grouping string (contract and due date) without doc number as grouping criteria.

It is still not clearing and only being posted as another line item when I'm transacting fp05. Can you advise any suggestions how can I auto clear?

Thanks,

Erika

[william_eastman]

You cannot use document number as a grouping criteria for payments. the incoming payment will not have the same grouping as the open receivables in that scenario. IMO the only time document number is valid as grouping criteria in clearing is for account maintenance as a first step leading to many other steps

[former_member527270]

Hi Sachin,

Thanks for your reply. Already updated grouping string Contract Account, Document Number and Contract. Sorting string with Document number and Due Date.

Amount rule and Clearing rules = blank

Incoming payment specifications for payment lot is already set to

1- post on account if contract account can be uniquely determined.

Still didn't work, thanks for your input though.

Regards,

Erika

[former_member245270]

Hi Erika,

Just create a clearing variant in clearing control as per your requirement if you have not configured the same earlier ( i.e. taking company code/business partner as the grouping string & due date as the sorting string).

check what clearing variant have you assigned to the clearing type payment lot (05) & in the incoming payment specification for payment lot - on account - select ( 2- post on account if contract account can be uniquely determined ).After doing this if you post a payment through payment lot , after assigning the payment amount of 62.97 to open receivables it post rest 0.03 as payment on account to the contract account.

Hope this helps.

Regards

Sachin Singh