Stop cross child account clearing during autoclear

[NikhilKohli23]

Hi All,

In our sap system, cross child accounts clearing is allowed when auto-clear runs with collective parent BP.

We have been trying to stop the cross child account clearing. I explore clearing rules, variants in spro for the same but couldn't find out the solution.

Main problem - System will take all the CB and payment documents sitting at the parent level for clearing and one CB document may have multiple child contracts. Say IN1 posted at C1, IN2 posted at C2 with a same due date. One CB document is generated by the system. Manual adjustment credit MA1 posted at C1 and having corresponding parent document.

If autoclear (FPMA) runs, it should clear MA1 with IN1, not with IN2.

During autoclear, only parent level documents are coming.

Please suggest.

Thanks

NK

[NikhilKohli23 · Accepted solution]

Solution ->

***SAP doesn't provide any standard solution to stop the cross child clearing among collective accounts***

The sequence of events and technical object during Collective account auto clear:

1. Event 110 (Clearing: Amount Distribution)

2. Z** clearing variant (Parent account line items) [customise variant]

3. VTREF grouping (FM Z**) [incorrect grouping characteristic - you can use another] - Fetch child items of CB. Group CB and payment docs based on the child contracts. Set e_zreg_te516 to 2 to eliminate the items which can't be grouped.

4. Clearing rule ( FM Z**) - Gets called for each group created hence the allocation will be easy for the amount by comparing the contract. Here we don’t have the visibility of collective bill items, hence the amount check will happen here whether to allocate the full amount or partial. Amount can be allocated using field 'e_augbw_e115' and set the indicator 'e_xaktp_e115' to 'X'. Debit to be populated as the sum of credit allocated.

5. Event 120 (Clearing: Distrib. Amount to Coll. Inv./Inst. Plan/Bundling) - calculate the allocated child items amount sum. If the amount is getting allocated is same as amount getting cleared then let SAP do the work. But if the amount is getting partially allocated then there comes the need to manually distribute the amount to correct child items.

6. 20S clearing type

7. Z** clearing variant (Child account line items) [customise variant] . - Need to make amount assignment based on the child's items.

[william_eastman]

Dont run FPMA so much, or for active accounts when they can be handled with AM during invoicing. But if you do run it, then change the parallel object to VKONT.

[AmlanBanerjee]

NK,

You need to create a custom version of the FM FKK_SAMPLE_TFK115 and assign it in the Clearing rules step with clearing rule 8.The items grouped together to a settled unit are transferred in table T_FKKCL_E115.

You can remove the individual items from table T_FKKCL_E115 based on the Rules that you have mentioned.

Based on the filtration, you can set the indicator E_EZREG_E115 to 4 for the items for which you want to do the clearing and set the indicator to 2 for the items which you don't want to be cleared.

In addition to set the indicator E_EZREG_E115, you have to activate the parameter Y_GEN_CLRG_PROPOSAL, then the clearing proposal will be created for the current payable unit.

ciao.

[NikhilKohli23]

Hi Amlan,

Thanks for your reply.

I explore this option but the main problem is that sap is coming with parent items (in T_FKKCL_E115) like CB and open payment documents. We don't have visibility of child items at this point.

CB may have linked with multiple child contracts documents if documents are issued with the same due date.

Example

Items at parent account->

CB (containing invoice documents from C1, C2 and C3) and EF payment of C2(customer paid at child contract)

Our purpose is to clear the EF payment only with C2 invoice not with C1 and C3.

Regards

NK