on 10-19-2015 12:17 PM
Hi Experts,
Here we have a scenario like below:
For Contract they wanted to give some discount on Basic Rent :
Example :
Conditions:
10-Basic Rent as 100
20-Discount as 5 %
30-Final Price should be calculated like (100-(100*5%)) and display as 95
so that any charges I wanted to charge to customer this condition 30(Final Price) as a base
and also If we wanted to charge this 95 in different payments like below with different dates and system should check the total value should not exceed the condition 30-Final Price.
1.Payment 1- 25%
2.Payment 2-40%
3.Payment 3-35%
Please throw some light on this.
Thanks in Advance.
Regards,
Murali
Hi Mohan,
The first two conditions (10 & 20) should be created as statistical condition, only for information purpose.
Base Condition 30 should be actual rent, which will be derive its value from formula E1 % share of condition.
Condition Condition Type Unit Price Formula Statistical Check box
10 10 Basic Rent 1000 Fixed Amount X
20 20 Discount 5 E1 % share X
30 30 Base Rent 95 E1 % share
Your condition should look like below screen shot.
Regards,
Amar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Amar,
thank you very much for your reply.
As you mentioned discount and Basic rent is statistical conditions and more need to enter the discount and Final Price Percentages manually in the conditions instead of automatic calculation .this % of condition I checked but it does not do auto calculation.
but Discount condition should be posted to finance as part of Discount G/L
I have some other idea to address this
If I maintain :
10-Basic Rent --Statistical-----------
20 Discount --One time condition--
30 Final Price-Actual Rent ----------Always this condition is like (10-20)it means Basic Rent -Discount is the Final Price ,even though there is no discount it considered as "0"
but how to derive this Final Price condition from (10+20)Conditions
Regards,
Murali
Hi Mohan,
This is achievable.
Create a new calculation formula in the path:
RECACUST-->Flexible Real Estate Management--> Conditions and Flows -->Calculation and distribution formulas -->Calculation Formulas
You can see, I have used 1000 Badi Calculation in the field Internal Formula, use internal calculation method 1000 and also you have to implement the badi RECD_CALC_RULE.
Get in touch with your developer to implement above Badi and put your logic there.
Regards,
Amar
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.