Skip to Content

FP05 Auto Clearing using document number only

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Oct 03, 2017 at 07:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 04, 2017 at 12:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 04, 2017 at 12:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 04, 2017 at 01:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 05, 2017 at 07:29 AM

    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

    Add comment
    10|10000 characters needed characters exceeded