SAP REFX - SALES BASED AGREMENTS - HOW TO SETTLE FOR DAYS & MONTHS saparately

[narnei]

Dear Experts,

As a new person to SAP REFX need to know more about SALES BASED AGREMENTS ( CONTRACTS) how to calculate the RENTS

1.for exact days

2.for months.

3. If whole contrat is valid only for 15 days how to settle it.

Even though if we give contract start date is mid of the month 15.11.2013, how to calculate for individual days as well as for months.

Requirement scenario is as below.

Rental conditions start date escalation details are as below.

15.08.2013 to 14.11.2013 - - Minimum rent 1000 -- Sales based rent calculation % is  5% based on sales.

and rent escalation as below.

15.11.2013 to 14.11.2014    -  Minimum rent 2000 -- Sales based rent  calculation % is  8% based on sales.

Even though contract start 15.08.2013. need to settle the rent upto 30.11.2013.

Then it will start from 01.09.2013 to 30.31.10.2013 - month wise.

Again 01.11.2013 to 14.11.2013 -- need to calculate saparate rent.

Your advise with clarity  will be highly appriciated.

[Former Member]

Hi Mr.Rao,

For your first query of Calculation of Sales Based rent for exact days and for limited period there is an option for frequency in Sales Rule where you can set frequency and validity with the option of setting Pro rata active and select your calculation method as 30 days or exact days. Below is the screen shot

of that screen.

For your requirement please use Sales Grading and create 3 conditions with suitable validity with 3 respective Sales Rules and Reporting Rules.

Hope it could help you!

Regards,

Siddharth

[narnei]

Dear Friends,

Thanks for your inputs.

Tried with the above given options, its not working as per the given requirement.

Can any one share me the relavent steps to take it furthur.

Thanks,

Rao

[anispalash]

Hi NS Rao,

I have little experience with sales based rent, but I hope this helps.

For the current year, input the condition type your going to use with valid from 15.08.2013 then valid to 14.11.2013

Then go to posting parameters, then Frequency, create a new Frequency then on the Calc. Method use Exact Days.

Then go back to the Conditions tab then select your condition, then go to Terms tab, on the Frequency field, enter the Frequency Id you have created.

Hope it helps!