on 01-23-2009 1:54 AM
Hi All,
Buisness requires to calculate Rebate like for example -
100 bags - rebate is $1/per bag.
Now if customer buys 120 bags in certain period of time, he should get rebate on 20 bags x 1 usd = $ 20/- .
In Regular rebate customer gets rebate on 120 bags x 1/- per bag = $120/-
IS there way to configure this scenario in standard SAP that customer get $20/- rebate only not $120/ rebate?
Thanks,
Manish
Hi,
I have taken an example to explain your scenario.Hope this will help you.
The rebate to the customer is based on certain volume of product within specified time. The process says, firstly create the material or customer rebate in VBO1.Say if we take a material rebate having agreement type BO02,the scale is based on quantity. In conditions under T code VBO1 put the scale quantity for eg 10 units, amount (total rebate/piece) 25 GBP for 1 unit and the accrual amount for eg 100 GBP which you think can be paid as the partial payment before the full settlement. Remember you canu2019t put the partial payment more than the accrual defined. Make a standard order OR, process it till the billing. Now go to VBOF (update billing document for rebates) and run/execute the report, the report updates the sales volume with the relevant billing documents as of now of the customer. After that go to VBO2 and click on summation/sales volume and see that the total sales volume being generated. Also you can see the verification level and the drop list which will show you the relevant billing documentsNow if you again change the accruals again or do the partial payment let say 100 GBP through VBO2 a credit memo request is generated which can be processed to credit note by removing the billing block through VA02 and than going to VF01 and generating the credit note. Now change the status to B for doing full settlement in VBO2 and than click the final settlement tab. The credit memo request will be generated automatically with item category B1N.Change the billing block status in VA02 and than take the reference of this request and create a credit memo through billing. We will see the account u201Csales bonusesu201D in the accounting document of final settlement credit note.
Rebate accruals allow your accounting department to keep track of how much your company owes customers with whom you have rebate agreements.Within FI, the rebate accrual is posted to two accounts ERU and ERB: a sales deduction account and an accrual account. The accrual account is cleared when the rebate agreement is settled with a credit memo.All the relevant order types say of manual accruals or partial payment and are shown in the control data of related agreement type.Also see the accounting document of every credit note being generated. Posting accruals manually in the overview screen can be useful in different situations such as:
u2022 Lump sum payments to be done to customer for eg for front of the store display
u2022 Accruals correction for eg if we need to do some changes in the accruals amount under the condition record than we canu2019t do it,we can just do the relevant correction in the overview screen and can post the remaining accrual amount whether in positive and if negative to reverse the accrual.
Thanks
Rishi Balani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI Rishi,
Thanks for your reply but you have not still hit the object Why accruals are not showing in billing? What I am missing? I know rebate processs very well but some time we do not know ourselves what we are missing. I also ran VBOF transaction well, put material as refe in accruals too.
My Q is why accrulas are not showing in billing? What settings I should once again check? Please advise.
Rajiv Trivedi
(SD Certified)
Hi Rajiv,
I was actually giving the resolution to Manish because i suppose he put up the question but any ways i believe you should see the account determination for rebates.Rebate condition type must have an account key assigned to them in the pricing procedure used by the sales doc types for orders.One account key is assigned for revenues(ERU) and the oppsote key is assigned for accruals(ERB).These account keys are assigned individual G/L accounts in account detrmination under G/L account keys as the relevant table.
I hope this will help you.
Thanks and Regards
Rishi Balani
Rishi,
Account keys are already assigned in a/c determination as ERB Rebate sales deduction & ERU Rebate accruals.,
My question was -
Buisness requires to calculate Rebate like for example -
100 bags - rebate is $1/per bag.
Now if customer buys 120 bags in certain period of time, he should get rebate on 20 bags x 1 usd = $ 20/- .
In Regular rebate customer gets rebate on 120 bags x 1/- per bag = $120/-
IS there way to configure this scenario in standard SAP that customer get $20/- rebate only not $120/ rebate?
Thanks,
Manish
Hi manish
Maintain scale rebate and in that you give the scale as 120bags =1$ per bag and maintain the next scale as 121bags = 2$ per bag
So if the customer buys 120bags he will be getting the rebate and if he crosses that quantity then he will be getting more than that .
NOTE : But if the customer buys only 100bags then he is not eligible to get rebate .
Regards
Srinath
Srinath,
Your suggestion is to explain about the rebate scale but here question is , if order is for 120 bags,
business wants to give rebate on only 20 bags not on 120 bags.
Even If you maintain scale of 1 to 100 bags - No rebate & 100 - 200 bags - $2/- bag rebate doesn't matter.
System will give rebate on 120 bags x 2/- = $240 whereas business wants to give 20 bags x2/- = $40 Rebate.
I think this is only possible by user exit, that is the only way.
Thanks,
Manish
Hi Manish
If you maintain scales also then it wont be calculating rebate for the balance qty
Say for example 120pcs - 3% rebate ; From 150- 5% Rebate
But if the customer purchases 120pcs then he wont be getting for those 20pcs. But if the customer orders continuously 3 times the sames order then it will become 150*3=450pcs.So within that time the rebate value will get accumulated for those 450pcs . and the system calculates for 5% rebate of that 450pcs value.
But if the customer orders only 130pcs then the customer wont get rebate for those 10pcs initially . As he will be eligible for 3% rebate only. For those 10pcs he is not .
So only solution is , assign a sub-routine in the pricing procedure for the rebate condition type telling that if the qty exceeds the scale then that value should be taken into consideration while settling.the rebate for the customer (KUNNR)
Regards
Srinath
Hi Manish
If you assign a sub-routine to the rebate condition type then it is possible . Your requirement can be fulfilled .Take help of the ABAP'er and then maintain a new subroutine and then assign in the Alt Calc type feild then it is possible
NOTE : Just for your information asking for numbers, email-id's etc are against rules and regulations in the forum .
Regards
Srinath
Hi,
I created BO02 rebate with activations at customer, billing, Sales Org. Created order, delivery,PGI, Billing. Then also released billing to accounting successfully. While creating Rebate accruals are maintained well which I double checked.Billing type is relevant for rebate.
When I see VBo3>Condition>Payment data NO ACCRUALS are seen or available. I shall appreciate if you identify What am I missing here?
Thanks
Rajiv Trivedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rajiv,
You have to check few steps before we check in agreement type -
1. Please check whether rebate condition type exists in condition tab of billing document.
2.If yes, check whether PAYER is activated or not. ( NOT SOLD TO ).
3. then check Sales volume & verification level.
4. If still not, check condition records, what is Accrual amount & compare UOM .
thanks,
Manish
Hi Manish,
Thanks for your suggestions. I have already activated Payer, Sales Organization & Customer in billing tab. BO02 condition record exist for valid period for customer, material. Requirements 24 exist with ERB/ERU a/c keys in pricing. I could not see rebate in billing document. I have completed order,deliver,billing & document flow states complete till billing. Invoice is open i.e. if payment is made it will be complete. But I think still rebate should be seen in billing which is not the case.
Sales volume is not seen at verification level neither accruals. Accruals rate & UOM is only one. Earlier I had done this successfully but now not moving ahead. Any suggestion?
Thanks
Rajiv
(SD Certifed)
HI,
Why cant u go for discount in this scenario u and maintain scales ur problem will be solved.
Or If u want to go with rebates only create a new routine alterntaive calculation type as the above said logic and assign this routine to the rebates conditon type in the pricing procedure.
Regards,
kishore.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Kishore,
We cannot do discounts here since these are retroactive, we need to do Rebates only.
Your 2nd suggestion is vaild here but we have these kind of rebates for some customers &
other customers will get rebates as regular rebates i.e. on the complete qty.
How do we do those rebates, any suggestions.
Thanks,
Manish
User | Count |
---|---|
86 | |
10 | |
9 | |
8 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.