AX 2012 Change all open purchase order prices for a vendor

(0) Share

Report

Posted on by Tim Schofield

Hi - we have a scenario where when vendor prices are changed, they immediately apply to all open purchase orders. We'll import the new vendor prices as purchase price trade agreements, but we're looking for a simple way to re-price all existing open purchase orders. Someone's suggested filtering for open purchase orders for the vendor and changing the vendor on the purchase order, and then changing it back to the original vendor. That certainly refreshes the purchase prices, but it seems a drastic thing to do, and is pretty time-consuming if there are a lot of open PO's. Is there a more elegant solution?

Thanks

Tim

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

As per my understanding this requirement is not a part of standard dynamics AX.

You need to have a customization

I suggest you should create a batch job process to update the purchase order price

logic could be

select all the purchase orders as per filter parameter

find out the new price setup for the purchase order vendor

update the Purchase order line price and calculate the purchase line amount

Please verify and update us if you need any kind support for this customization

Was this reply helpful? Yes No
Suggested answer

Daxer Persson 3,005 on at

Like (0)

Report

There is no function enabling an update of purchase order lines based on a price change.

However I would not change vendor and then change vendor back again. Somehow this sounds wrong to me (e.g. if quantities on PO have been received).

Manually reentering the Quantity on each PO-line should make an update (yes, possibly a lot of work - or a job doing so).

You also need to confirm the order again.

Was this reply helpful? Yes No
Weaveriski 23,620 Moderator on at

Like (0)

Report

When required we have developed this in slightly different ways, but ultimately on the posting of the journal it auto-updates the purchase order and sets a flag on the header and line so you can view these (although they never get resent).

Was this reply helpful? Yes No