cancel
Showing results for 
Search instead for 
Did you mean: 

Block Sales Order if Line Item Value is Zero

vmmjn
Explorer
0 Kudos

Hello,

We have Quantity Based Scale Pricing (e.g. if for a given Line Item in Sales Order if the Line Item Quantity is below 100 ,the Line Item Net value becomes Zero ).

How can we Block Sales Order ,if due to Qty Scales ,Price of any Line Item becomes Zero.

We have one option of using  sale order User exit in the program MV45AFZZ - USEREXIT_PRICING_PREPARE_TKOMK to achieve this requirement.

Is there any other better Option/Standard Option to achieve this .......

Thanks,

Vikas

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

Have you tried with incompletion log for VBAP-NETWR with status 04 before posting here ?  This should work

G. Lakshmipathi

Answers (4)

Answers (4)

former_member184065
Active Contributor

Dear,

Line Item in Sales Order if the Line Item Quantity is below 100 ,the Line Item Net value becomes Zero

I hope ,it is not possible by standard .You can consult ABAPer on this requirement .If you write any code on this requirement then you have to be maintain above 100 quantity to every line item .If not then you may not be save your sales order .I think ,this requirement will effect on your business process if the  quantity ( 100 ) is not available in time .

Tell me one thing ,why you want this kind of requirement and what is the business process.

Kindly ,let me know if you want further help on this.

Thanks,

Naren

former_member182378
Active Contributor
0 Kudos

Narendra,

From my understanding, the requirement is

How can we Block Sales Order ,if due to Qty Scales ,Price of any Line Item becomes Zero.

It might be a possibility that the business user creates a sales order with any qty (e.g. qty below 100).

So it should be possible for the user to create a sales order with any qty. But in case of less than 100 qty, the subsequent documents should not be allowed to be created.

former_member184065
Active Contributor
0 Kudos

Dear,

How can we Block Sales Order ,if due to Qty Scales ,Price of any Line Item becomes Zero.

Actually ,with above statement ,what I understood is ,if the Quantity is Zero or else Price is Zero then he wants that Sales Order under Blocked List.

Note: He has explained his query in two ways .The two ways are differently that's why getting confusion on this by guys differently .Above statement is telling differently and if you see below statement ,it is also telling differently.

Line Item in Sales Order if the Line Item Quantity is below 100 ,the Line Item Net value becomes Zero .

Thanks,

Naren

vmmjn
Explorer
0 Kudos

Hello All,

Thanks to all of you for your Valuable Inputs ..

Quantity 100 is just an Example.....as the Quantity Scales starts with 100 (e.g.)

Material ABC ,Condition record for PR00 :-Quantity 100-200  Price = $ 100

                                                                    Quantity 200-300  Price = $ 80 etc

Order quantity should not be less than 100.

What is happening here if by mistake Order is created for less than Quantity  100 ,PR00 becomes Zero & some times Delivery & billing Created with Zero Value only.(Thru Batch Job).

Tried Incompletion Rule :-for VBAP-NETWR with status 04 (Can not use as there are some orders with Zero Value (Due to 100% Discount condition)

Minimum Order Quantity of Material Master also did not worked.

In an Order ,if Quantity is below Scales (e.g. Below 100 ),PR00 should not become Zero ,it should give some error so that subsequent Documents should not be created with wrong Value.

Thanks Again

former_member182378
Active Contributor
0 Kudos

Vikas,

Tried Incompletion Rule :-for VBAP-NETWR with status 04 (Can not use as there are some orders with Zero Value (Due to 100% Discount condition)

When 100% discount is given, is it not a different item category, in the sales order?

If it is a different item category, then you can assign the incompletion procedure (with VBAP-NETWR) to the standard item categories (and not to the item category where 100% discount is given).

If the item category is the same for standard sale and for 100% discount, then please explain how user is giving 100% discount.

In an Order ,if Quantity is below Scales (e.g. Below 100 ),PR00 should not become Zero ,it should give some error so that subsequent Documents should not be created with wrong Value.

In RVAA01 pricing procedure, PR00 is required (or mandatory). When the value of PR00 is zero, then user can not save that sales order.

The system would give an error.

In your pricing procedure, t-code V/08 is PR00 activated as required? if not do so and then test.

phanikumar_v3
Active Contributor
0 Kudos

""""Minimum Order Quantity of Material Master also did not worked."""

change the message number from warning to error and try.

Phanikumar

former_member182378
Active Contributor
0 Kudos

Vikas,

There are several points in your post -

1. In the sales order, at line item level, if quantity is below 100, then the net price = 0. And you don't want the price to be zero.

Does that mean that you want the order to have more than 100 qty (at line item level)?

2. Incompletion -

G Lakshmipathi has already given the solution, which can be achieved with standard SAP.

Adding few points to his post -

a - Read about status group. Co-relate it with your process (does the process have delivery etc. etc.)

b - When you say - block the sales order. What transaction you want not to be created (delivery or billing or....)

c - The incompletion procedure is assigned to the item category. So if you have multiple item categories, then you need to assign the procedure to multiple item categories.

Former Member
0 Kudos

Vikas,

As Lakshmipathi mentioned rightly, you can include net value field in incompleteness procedure for sales item in OVA2. Assign status 04 so that order is blocked if net value is zero.