Discounts on Payments made by Customer through policies

[Former Member]

Dear Experts,

A requirement has come up whereby the business has to perform the following activity through SAP :

At the start of a period lets say start of the year, business creates policies on specific materials to provide discounts on payments made by the respective customers every month. For example business creates the following policy:

Customer ABC	January	February	March	April	May	June	July	August	Sales Period
Discount on Material ABC	8% of any payment	7% of any payment	6% of payment	5% of any payment	4% of any payment	3% of any payment	2% of any payment	1% of any payment	No Discount
Example of Payment Amount made by customer	50,000	40,000	35,000	30,000	25,000	40,000	30,000	20,000	-
Accumulated Payment with discount	54,000	42,800	37,100	31,500	26,000	41,200	30,600	20,200	-
Accumulated Amount (policy Balance)	54,000	596,800	633,900	665,400	691,400	732,600	763,200	783,400	783,400

In the month of January, business will give 8% discount on amount 50,000 that was paid by customer. In the month of February 7% discount will be paid on 40,000 payment amount, in the month of march 6% discount on payment amount 35,000 will be provided, and so on for further months.

Any sale made to customer in the months January to August will not have any discount privileges, it will only be cash sale and will not be added into the customers policy balance.

In the month of September which is the sales period, customer will order certain amount of ABC material, now by the end of September the customer will have an accumulated payment of 783,400.

Lets say the customer's first sales order is made in September and an Invoice of amount 40,000 is raised against the customers account. System should deduct this payment from the first policy month i.e. January 54,000 - 40,000 = 14,000, after deduction the customer will have only 14,000 amount left in the first month. For the second sale suppose invoice value comes up as 50,000 then system should first deduct 14,000 from January month and use the remaining 36,000 from the month February. So on and so forth.

The requirement is a bit tricky and I cant seem to find any standard way to implement it in system, I want your guidance in this matter if the requirement can be mapped through a standard solution already available in SAP. If there is no standard solution available then I would like to ask how should I custom develop it.

Feel free to ask me if the requirement is not clear.

Regards,
Ali

[moazzam_ali]

Hi

There is no standard solution to this kind of requirement. Only ABAP program can help in this. Did you discuss this with your ABAPER? If you tell this logic to ABAPER I hope he will be able to develop a program that you can execute on monthly basis or quarterly for crediting discount in customer ledger directly or through SD credit notes.

Thank$