19
Oct/09
0

VA05 Mass Change Sale Orders


There is a requirement where I need to mass change sales order pricing dates. In this scenario, a sales order is entered months in advance, and price is subject to change up to ship date. Prior to shipment, I need to update the pricing date to the ship date.

Is it possible to define a custom pricing type (such as X) that pulls in current system date as a basis for the mass price update?


Sales order Price will be set based on the “Price Date” Specified in the Sales Order Header. Same date will be copied to all Line Items as well.

So If your using validity periods in the condition master record (VK11 transaction), sales order price will determine based on the date appear in the Header & line item.

Since you want to pick the price based on the delivery date, you can do a configuration to pick the sales order pricing based on the “Requested Delivery Date” instead of Sales Order Creation date.

Go to VOV8 transaction
Go in to your sales document type.
There is a field called “Prop.f.pricing date” under “Requested delivery date/pricing date/purchase order date” section.
You can maintain below values there.

BLANK – Proposal based on today’s date
A – Proposal based on requested dlv.date (header)
B – Proposal based on valid-from date (header)
C – Proposal based on contract start (header/item)

As per your requirement maintain “A” there.

Then at the point of sales order creation system will pick the price as at Requested delivery date for the sale order automatically.


Viewed 46783 times by 5714 viewers

Related Posts

Comments (0) Trackbacks (0)

No comments yet.

Leave a comment

No trackbacks yet.

Powered by Yahoo! Answers