cancel
Showing results for 
Search instead for 
Did you mean: 

Free goods determination (Quantity Update)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

reazuddin_md
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi KK Rathi,

I suggest to issue credit note fot the 02 Ton or 40 bags of Cement instead of issuing free of cost cement as incentive.

As you have to consider Excise and sales tax impact and how it will be accounted ?

Regards

Rajesh Kumar Bhansali

Former Member
0 Kudos

Hi Rajesh,

This is not an Indian senario.

This senario is from UAE

Thanks

Krushnakumar Rathi

0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Balaji,

If possible please explain your solution in some more details

Krushnakumar Rathi

Former Member
0 Kudos

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.