Maintain Sales Order Price (PR00) in billing

[Former Member]

Hi, we have a scenario that Billing is done weeks / months AFTER sales order is created. Meanwhile material price is changed.

So Billing is picking new price where-as some customers insist upon old price (one agreed at the time of Sales order creation). how can we handle the situation?

- one solution is to offer them Credit Memo, but that will be very tedious process if we have heaps of customer that insist upon old pricing

- or control the copy controls (Sales Order => Billing, VTFA.... Price Type field). But then every customer will get old pricing. Where-as we want only some customer get the privilege to have still got the original price (decided at the time of Sales Order creation)

Any tips will be highly appreciable.

thx in advance!!

/V

[former_member186385 · Accepted solution]

Hi,

At this moment,  i can think of three solutions

1.  We had the same requirement and solution we have provided was, Posting the stock to sales order stock Using 412 E which will block the price of material on the posting date

When you are Billing, instead of picking the price from condition record system will fetch the price from sales order , ( pricing date from sales order)

either you can manually post or Use some job for automatic posting.

2. Using Billing user exit, try to pick the Pricing date similar to sales order without changing it in Billing document, this can be restricted based on the customer group for which you want the old price

3. As suggested by other members, you can go with new item category determination and make modifications in the copy control

you can leverage any of the solution based on your convenient

regards,

santosh

[former_member182378 · Accepted solution]

santosh,

Thank you for your post!

Could you please elaborate point 1?

Point 2 - If the "earlier" condition record is deleted and the new condition record is created. Then with the pricing date in the sales order, the system shall not find any valid condition records.

added - would your suggestion take care of manually entered prices (in sales order, flowing  into the billing documnet)

Kindly comment.

Message was edited by: T W - added in blue color

[former_member186385 · Accepted solution]

Hi T.W,

Posting the sales order using 412 E will block Stock against the sales order and also it will block the cost and Price on particular posting date

when you are creating Delivery from this order which was posted to 412E, your COGS will not vary even if VPRS changed in material master

and in the billing document you can see both VPRS and PR00 ( as per standard) copied from sales order for whatever the copy control settings

this scenario is generally applicable for Orders which were not delivered on same month when order created

For second Point, Manually condition records will not work with the above change of user exit

hope it is clear,

[former_member182378 · Accepted solution]

santosh,

Thank you for your post!

[Former Member · Accepted solution]

Hi, Santosh,

"Posting the sales order using 412 E", use MB1B (412+E) or create new schedule line category with movement type 412?

Post stock from normal stock to sales order stock will block the cost on posting day but how it block price of PR00 in the billing?

Thanks with best regards

Jian

[Former Member]

Hi, Jain,

Solution 1: add new ztable to record all special customers, then create new copy routine base on this ztable to modify price date in copy control.

Solution 2: If you do not want to any development:

I suppose you use condition type PR00, pricing procedure ZXXX01, which will not update price in billin.

2.1. change condition type PR00 pricing date field into "E"  through V/06 ,reference PR00 create new condition type PR04, Pricing date please choose "C". (for condition record, you only need maintain or change PR00)

2.2 create new pricing procedure ZXXX02 copy ZXXX01, replace PR00 by PR04, others keep unchanged

2.3 create new cusomer pricing procedure  category  Y: not updated, Z: Updated,

2.4 pricing procedure determination with cusomer pricing procedure Y, get ZXXX01; with Z, get ZXXX02.

2.5 pricing type in copy control please use "C"

Now, if customer do not update pricing in billing, please use "Y" in customer master data, and "Z" for the customer who want to update pricing in billing.

Any problem please let me know.

Jian

[Former Member]

Hi vibhor,

Update your condition type in field  manual entries = 'C' and save.

In your pricing procedure for condition type PR00 tick check box as 'Manual'.

Hope this might be helpful to you.

[former_member204407]

Hi,

If its already billed or going to be billed then go with old price.then list down price variation those Billing documents (some of customers you want to settle as per price change) use Retro-Billing concept and settle those Billing documents.

Regards,

Krishna.

[former_member184065]

Dear,

First of all ,please let me know ,how you are creating Billing before creation of Sales Order .

Now,after creation of sales order ,what steps you perform in sap.

Thanks,

Naren

[former_member182378]

Vibhor,

If the client feels that there are lot of CMIRs to be maintained / created and they would not want to take that way.

Then you can go for some enhancement / coding.

In a userexit you can have a table with Customer numbers, Item category.

Also maintain this item category (as manual) in VOV4.

When one of these customers is given in the sales order, then the item category populated in the sales order would be different from when sales order is created for "other customers".

[shashi_thakur]

Hi Vibhor,

You can look at using either the perform 'userexit_pricing_rule' or 'userexit_pricing_copy' in RV61AFZA to set the KNPRS (pricing type) value during Order Creation or during pricing copy based on your custom logic. The custom logic can be set to look at a customer attribute to decide whether to set the knprs or not. This way you can extend the solution to other customers as well as and when needed or an alternative would be a custom table if you want a valid from and valid to field to be attached on who gets new price and who gets re-determined prices.

Regards,

Shashi

[former_member182378]

Vibhor,

I feel that a separate item category is the way forward. In VTFL / VTFA, at item category level, you can set the pricing type = D.

In customer master info record, you can give a Usage.

This usage can be used in Item category determination VOV4, to populate the item category automatically.

Thus the item categories would be different for customers billed at the rates in the sales order and for the customers billed with the revised rates.

[venu_ch8]

Dear

yes we can control another pricing procedure at billing level

Generally We maintain pricing procedure determination in OVLK C.P.P+D.P.P+S.AREA

Same like this Create separate pricing procedure and maintain all relevant condition types ,,just go to VOFA here assign new pricing procedure

AND go to OVLK here in another row as well as you maintain C.P.P+D.P.P+SALES AREA

Now test at sales order level you will get one pricing procedure and at billing another pricing procedure

Side comment :  Some times price will be changed after creation sales order  ( ex delivery level ex gold)so if the new price automatically will come to billing level just go to VOV8 Activate propsel f pricing date  check box

PLZ LET ME KNOW

Dear mentors plz correct me if i am wrong ,, thanks a lot

Regards

venu

[former_member182378]

venu,

Please check the transaction code for Pricing procedure determination.

Paraphrase the requirement (given by the OP)

- Is it about having a different pricing procedure at billing document level?

- Or is it about the rates (values, material price etc.) given in the sales order, Tab conditions; should be identical to or unidentical to that in the billing document?

(using the same pricing procedure)

[moazzam_ali]

Hi Venu

Can you explain how different pricing procedure will help the OP to keep the price same as in sale order after price increasing? If lets say they are using PR00 condition for sales price and you are determining new pricing procedure then how system will copy PR00 same as it was in sale order?

I am not getting your point. Could you please explain it.

Thank$