SAP_Condition Contract Settlement_Fixed amounts and settlement split criteria

[pierpaolo_parma]

Hi all,

in Condition Contract, i've set as slit criteria for payments the combination of:

- Customer (hearder)

- Material (item)

According to this rule, whenever i create a delta accrual posting or a partial/final settlement, the system creates as many documents as the combinations of customer/material retrieved from the calculation base (i.e 7 credit notes, each of them referred to a specific customer with his own materials sold).

If i define a fixed amount condition (RES1) of 1.200€ on a yearly base, my expectation would be that this amount would be split across all the documents (the 7 credit notes above) according to the turnover referred to each customer (to which every single settlement document is referred to) --> so total amount issued would be in any case 1.200€

Differently than my expectation instead, the system reports 1.200€ to each document (credit note); the result is that instead of issuing only 1.200€ overall (equal to my RES1 value), the total amount issues is of 8.400€ (1.200€ * 7 credit notes).

Do you know how could i fix this issue?

Thanks and regards

Pier Paolo

[Anjhi]

Hi,

I have the below proposal as a solution for this.

Add the REBT - Rebate Total volume condition type to the pricing procedure and make necessary mappings to pass the value to this condition type.

Now you have REBT & REBV business volume condition types in the Settlement Pricing procedure. You can calculate the proportionate RES1 value using a custom calculation routine.

Please try and let us know if this works 🙂

Regards,

Anji

[former_member779447]

Hi,

Is your issue resolved? I am facing same issue. Kindly help.

[former_member225662]

HI,

You configured in such a way that settlement documents are split based on customer (Header).

So automatically the number of customers = No of settlement documents.

And you defined rate 1.200€ which is applicable for the entire contract irrespective of settlement documents split.

Example: No split case - Bus Vol = 300; Rate = 1,200 = 360,000

Customer1 Split case - Bus Vol = 100; Rate = 1,200 = 120,000

Customer2 Split case - Bus Vol = 100; Rate = 1,200 = 120,000

Customer3 Split case - Bus Vol = 100; Rate = 1,200 = 120,000

Total = 360,000

When you split the settlement documents per customer then the business volume is also split as per the customer and rate will be same across settlement documents.

If you expect system to automatically split your rate as per above example then the rate will be 400 per settlement document (400*300 = 120,000) which will impact your settlement amount.

Regards

K

[pierpaolo_parma]

Thanks Kishore for your feedback..

I'm not sure to have understood how should i set the system in order to split the overall 1.200€ in a proportional way across the settlement documents based on the customer turnover (to which these documents are referred to) instead of having 1.200€/every document

Can you please advise?

Thanks

[Anjhi]

To calculate proportionate value, use (REBV/REBT)*RES1