Settlement management - incorrect cancellation of accruals

[Arany5]

I have Settlement Management set up with settings very close to standard and I have the following issue. 

There are 3 settlement dates: 1 - Delta accrual, 2 - Delta accrual, 3 - Partial settlement (and this goes on as accruals are posted every month and partial settlement every quarter). 
1  posts the accrual OK, 252 USD - correct - both RES1 and RED1 condition populated, but only RES1 active
2 cancels 1, then post, 630 USD - correct - - both RES1 and RED1 condition populated, but only RES1 active. REA2 is there as cancellation with -252 (correct)
3 (partial settlement) cancels both 1 and 2 with REA2 -882 which should only be -630, then posts full quarter amount (correctly). Here, accrual 1 should not be cancelled again, only accrual 2. 
How can this be fixed? 

[Anjhi · Accepted solution]

Hi @Arany5,

Delta accruals does not reverse/cancels the accruals. It posts only Delta accrual amount. 

In Step1: Delta accruals posted 252 USD. You can check the accrual entry in the WCOCOF table.

In Step 2: Delta accruals calculated total accrual amount as 882. Since the system already has 252 USD posted in previous delta accruals, it deducts this amount from 882 and posted only 630USD as additional accrual. Now the total accrual amount in the system is 630+252 = 882. If you check the accounting document of Delta accrual, you must see the posting for 630 USD only. You can check this entry in WCOCOF table.

In Step 3: Which is a partial settlement, may reverses existing open accruals. In your case it is 883 USD which was reversed. If you check WCOCOF table, the entries will be marked with value 4 - Reversed in the AccrualsReversalstatus field.

REA2 field brings in the open accruals amount from the WCOCOF table.

Hope this clarification helps.

Regards,

Anjhi

[Arany5 · Accepted solution]

Thanks for all the feedback, none of it contained the solution, but it helped me to find the issue.

[Arany5 · Accepted solution]

The issue was in IMG activity: Define and Configure Condition Type Groups for Accruals. Some entries here were in the wrong column and this caused the problem.

[GauthierVictor]

Hi @Arany5, 

Please take some time to review the settings in CCM. The Standard Configuration Guide can be found in KBA 2535889:
https://me.sap.com/notes/2535889/E

In particular, focus on the following:

• Define and Configure Condition Type Groups for Accruals
• Specify General Settings
• Pricing Procedure: Ensure the procedure has the subtotal correctly assigned for accurate rebate and settlement calculations.

Based on the information provided, these are the only recommendations I can offer at this time, as I don’t currently have access to your system for a more detailed analysis.

Let me know if you have any questions or need further clarification during the review.

Best regards,
Gauthier Victor

[Anjhi]

.