on 11-03-2010 1:12 PM
Hi Experts,
Need your help in below scenario
Company wants if a customer buys 100 tons of cement in a month, 2 tons of cement is given to him free
Kindly suggest how to map this scenario in SAP
I have thought of free goods but donu2019t know how to update the quantity
For example if a customer buys 100 tons of cement in 10 days
10 tons of cement each day on 10th day he should get 2 tons of cement free automatically.
It means if he places the order for 10 tons of cement on 10th day he should get 12 tons of cement
As customer has completed the target of 100 tons of cement and we are giving 2 tons of cement free
Thanks in Advance for your help
Krushnakumar Rathi
Dear Krushnakumar Rathi
I dont think your requirement can achieve with std free goods determination concept. because free goods determination only works with single sales order, but not with multiple orders.
If you maintain the scales OR from qtty to 100 Ton - 2 Ton is free, system will read entered order qtty is reaches the From qtty or not. But it wont read, already created sales orders.
To address your requirement,
Go for the report, eg: FOC report.
report requirement:
Report should display the sales order history wrt: Sold to party, Material, Total ordered qtty & Net value (if required) along with FOC qtty
This is execution report.
There should be maintainedance table to record the Free goods Master record similar to VBN1, where you can store the free goods related data.
Once you execute this report, Based on achieved order qtty, system should calculate eligible Free goods qtty & Create FOC order ( seperate order type) from the report directly.
you can schedule this report as batch job. So that system automatically creates FOC orders for the eligible customers.
Hope it helps,
Regards,
Reazuddin MD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You mentioned that you need to provide 2 tons of free cement once customer buys 100 tons. This can spread across multiple orders within a month.
Now, if you need to give the 2 tons of cement in physical form (in the form of cement bags), then free good determination will be required to add new line item in the sales order when cumulative total qty exceeds 100 tons within a month.
If your business is ok in giving the benefit in amount terms (not physical cement bags), then pricing free good condition will be sufficient to address the issue. The pricing condition type can be made active once the cumulative order qty reaches 100 tons. The pricing condition type will offer additional discount worth cost of 2 tons of cement.
regards,
Vaibhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vaibhav,
You are right the business wants to give the 2 tons of cement in physical form (in the form of cement bags),
My issue is how to cumulate the quantity which should be with in Vaidity period of free good condtion record is there any routing for this or any config setting
Thanks
Krushnakumar Rathi
Hello Krushnakumar
Set up the Free Goods discount condition with condition update in config (v/06).
Then set up the max. quantity as 100 T in the condition record .
See this link:
http://help.sap.com/saphelp_dimp50/helpdata/EN/93/7433d5546011d1a7020000e829fd11/frameset.htm
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
this comes under exclusive free goods:
Exclusive: System configures free goods in exclusive option like free goods quantity is going to be excluded in
order quantity. Ex: For 10 items 2 item is free. Then system configures free goods as 10 + 2.
calculation type which you have to consider for your requriment is:
2 = Unit of reference: When customer orders for 100 cases of material u201CXu201D, then the customer receives an
additional 2 cases as a free of goods. That means business can say that buy 10 get 2 free by granting 200 free
for every full of 10 cases. The customer places order for 100, then system automatically grants only 20 cases
as free goods.
regards,
balajia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Balaji,
You mean to say I need to build a pricing rutine in alter native caculation type
As SAP only consirder the free goods only for one order if it onder quantity is more than free good condition record
Here I have to consider all the order placed by the customer with in amonth
Thanks
Krushnakumar Rathi
hi,
create a schedule agreement to the same. say 100 bags of cement for 10 days = 10 bags per day and at the last day
basing on the quantity it has to pickup 10+ 20 bags as free.
In exclusive free goods access sequence there is a requriment field in which you can assign your own routine for your requriment.
logic:
create a Z table with maintaince view and the fields there inside maintaince view is:
1. line items, order quantity, order date, last day of the sales order creation for eg.
and make it to compare to the order quantity or according to no of line items split. here you need to consider some parameters & give logic to the system that when is the last date of your delivery. for that you need to take last line item or order quantity ends into consideration in that routine.
when ever the scheduling agreement is getting triggered from there only system understands that this is the last day and it will trigger the free goods as expected
then only the exclusive goods that is 10+20 bags has to trigger automatically.
please check teh same in teh system and confirm the fourm
regards,
balajia.
User | Count |
---|---|
69 | |
14 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.