Quantity restriction for Customers in Sales Order

[Former Member]

Hi all,

Please advice on priority basis,

I have one requirement, we want to have quantity restriction for product & specific customer in sales order. system should not allow more than the defined quantity for product to particular customer. We dont have the contract process.

regards

[former_member1249468]

Hi ,

This is not possible in standard sap .Request you to use customization for the same.

This can be done by using the userexit program.mv45afzz and exit userexit_document_save_prepare.For this maintain the condition records in vk11 with customer and material with target quantity.Then use the logic in program saying that while raising the every sales order check the billed quanitity for customer and material and compare the same by vk11 quantity ,if the difference exists then allow ,else give warning message/error message.

Hope it helps.

REgards,

Pasapula.

[Former Member]

Hi,

Your problem is not clear enough to provide solution.

As per my understanding I am having two different way of thinking regarding your problem.

First is that in one sales order your customer should get this much amount of material only not more than that.

The other thing which I understand is that you want that your customer should get overall this much quantity only.

If he order more for that product system should stop his transition.

So I want to know which setting you want to know

Regards

Raj.

[Former Member]

Dear Raj,

Thanks 4 u r reply,

I will explain with example.

for Customer X and Material Y eligible quantity is 100

system should not allow morethan 100 quantity with multiple orders I.e. order 1 - 20 Qty, Order 2 - 50, Order 3 - 30 Qty

when raising the 4 th order system should not allow futther for that customer and material.

Please don't advice for contract because we dont have any contracts.

Pls Advice me

regards

[Former Member]

Hi

Maintain a Z table with Customer, Material, eligible quantity and Quantity procured.

While save sales order use USER EXIT SAVE SALES ORDER, check if the "ordered quantity + Quantity Procured (from Z table)" is greater then eligible quantity, sales order should display error message and will not allow to save the sales order.

try and revert

[Former Member]

Hi,

This can be achieved by the condition type.

Go to V/06 and copy PR00 and made the new condition type.

Now this will be your main condition type which will carry out pricing.

Assign this condition type to your pricing procedure and save it.

Make this condition type mandatory and remove it from PR00.

Now go V/06 and select your newly created condition type and click on detail.

Over there you will find condition update just click on that.

Condition type : C quantity basis.

Do these setting for your condition type.

Now go to VK11 and enter the condition type and store the data first.

Then click on extras u2013 additional data or press F7.

Over there you will find max condition base value.

Enter the total number of value which you want to sell to your customer.

Now every time you create order this value is getting updated for your customer for that material.

So when it reach the limit which you set then this condition type will be deactivated.

And because this will be mandatory condition type so with out this you wont be able to create the sales order.

Itu2019s a little bit confusing language hope so you will understand.

If you have any problem then let us know.

Regards

Raj.