Help needed Urgently- Rebate based on collected amount

[Former Member]

Dear all,

I come across scenario while discussiion with client that they require rebate with collection. Details of the requirement are given below:

1. SAP rebates run on billed values & set the accrual in rebate agreement on the rate what we have specified in the rebate agreement. Requirement is that, If i have billed on 1000$ & my accrual value is 100$ with the rate of 10%. If i collected 800$ instead of 1000$, then i need to pay the accrual on the basis of 800$ not on the basis of 1000$. It means i have to adjust accrual amount on the basis of 800$. Conclusion is that i have to pay not 100$ accrual instead less then 100$ on the basis of 800$ which i collected.

2. In month 1 have billed on 5000$, my accrual amount is 500$ with rate of 10%. In the 2nd month i have to bill 1000$ and i have given an discount of 500$, it means my billed value is 500$ and my accrual amount is 50$@10%. In month 3 again i billed 500$ and my accrual amount is 50$@10%.

Requirement is that, when i am going to pay the accrual to client, i should pay correct accrual for which he is entitled for. Means i should pay 100$ accrual not 600$ because i have already given an discount of 500$. Discount which i have given already of 500$ should need to be offest with the first month accrual of 500$. So remaning accrual is 100$.

Great if somebody can help me out for the solutioning of the above requirements.

[Former Member]

Dear All,

If any body can help me out to know the function module or BAPI that can update the data from FI side to sd side.

I want to update the standard info structure s060 --for Rebates based on the data from FI side.

Regards

Anand Bakshi

[Former Member]

Try this and confirm

Activate new Rebate pricing procedure by activating S136 in OMO1. By doing this Alternative cal type and Alternate Base type will get opened in pricing procedure for rebate condition type

Use Routine 49 in ALternative calculation type in pricing procedure against rebate condition type

Check the calculation and revert

Senthils

[Former Member]

Hi Senthil,

Thanks for your suggesstion. For your information, i have activated new rebate procedure. Routine 49 is for Condition down payment, totally different functionality. It has nothing to do with requirement which i posted on the SDN.

I need to calculate the rebate on collection not at the time of billing & need to pay the accrual as a discount in the next invoice. I don't want to do the partial or full settlement through credit memo request & credit memo but want to do the settlement by giving discount in the invoice for whatever i have collected as accrual

Thanks

Anand

[ivano_raimondi]

Hello,

requirement 2 cannot be fulfilled.

Rebate functionalitydoes not take into account discount. They are completely separated.

Requirement 1 is not clear to me.

If i have billed on 1000$ & my accrual value is 100$ with the rate of 10% > OK so far.

If i collected 800$ instead of 1000$, then i need to pay the accrual on the basis of 800$ not on the basis of 1000$.

What do you mean ?

What is the collected value ?

FYI

The value proposed by the system in the partial payment is ruled by customizing of rebate agreement type in transaction VB(2.

The field 'Payment procedure' is the relevant.

Best regards,

Ivano.

[Former Member]

Thanks Ivano,

Somebody has started the conversation.

Let me put my questions again.

This requirement is nothing to do with Payment procedure in the agreement type.

1. In any month if i billed 1000$, so my account receivable would be 1000$. My rebate for that month is 100$ at the rate of 10%. During customer receipt if i collected against my invoice 900$ instead of 1000$, my accrual needs to be corrected 90$ instead of 100$.

I know this can not be fullfilled by standard SAP, by any thoughts on this welcomed.

2. I know Rebate can be settled partially or full settlement by payment method( by cheque, bank transfer, or by credit memo) we have configure in rebate agreement type. But here requirement is totally different.

Here, i need to pay the Rebate as a Discount instead of by cheque or by credit memo. While doing the partial or full settlement system will take into account collected accrual up to that day & apply as a discount to the final bill.

Scenario is like that sometimes customer asked to give us the discount on bill for whatever they accrued so far.

This is again cannot solved by standard SAP, but any thought by any body welcome. We have already thought that we need to enhance the solution.

Solution needed urgently.

[ivano_raimondi]

Hello,

could you please clarify this sentence: "During customer receipt if i collected against my invoice 900$ instead of 1000$" ?

Waht does it mean cellect 900$ against the invoice instead of 1000$ ?

About the requirement to pay rebate by discount instead of by credit memo, sorry, but I don't know any workaround to get this functionality.

Best regards,

Ivano.

[Former Member]

Hi Ivano,

Thanks for your valuable efforts & timing.

We have billed the customer for 1000$, means we have created the invoice of 1000!$. While receving the payment against this invoice i only get 900$. But i already calculated the rebate on 1000$ at the rate of 10%. Now i have to adjust my accrual value of 100$ by 90$ , as i have received only 900$.

Thanks for your patientce