I'm hoping to:
CSR's will often change Sales order header information e.g., Requested ship date, after all lines have been added and a Sales Confirmation has been provided to the customer. The SO confirmation is one method we use to confirm products/quantities/pricing with the customer.Periodically, we create new Sales Trade Agreements where the effective dates do not overlap i.e., we end the original agreement prior to the start date of the new one.
If a Sales order header value e.g., Requested ship date, is changed after new TA prices come into effect, the unit price on those lines are overwritten with the new TA price without warning or the ability to retain the original value*. Since a confirmation was provided to the customer with the original TA price, we need to manually change each unit price back to reflect what was confirmed with the customer.
*Note: We are aware of the Trade Agreement evaluation parameter in AR parameters > Prices, however, this only allows you to prevent changes on unit prices that were derived from an 'external' source such as a Quote or if the unit price was manually entered/changed.
We can appreciate that for some businesses this would be desired behaviour, however, our business uses the Sales order confirmation as an informal on-the-fly price agreement and therefore we do not want the prices to recalculate or at least automatically update when a header value is changed. I can appreciate that with some field changes e.g., Price group, you would expect the values to update or at least prompt for update which is where any potential solution gets complicated.Curious if anyone else has encountered this, found a way to work around it, or has any other insights. Any and all feedback appreciated :)#FinanceandOperations#AX2012#Sales
Thank you for the quick and detailed reply Andrew 😊 I am familiar with those settings and currently we have them all set to 'prompt'.
I've done some testing with 'Always' and the main reason we aren't using that is because when there is a line with a manually entered unit price you still receive the pop-up (presumably because it recognizes a manual price) but because the update setting can not be checked by the user (presumably it's system set because of the 'always' setting), the price and discount section is not editable and it defaults to the last selection, which may or may not be applicable this time (screenshot). At least in 2012, it's the user checking the update box that makes the price and discount fields editable*. As expected, if it is set to 'update all', any manually set prices are overwritten.
*There are some fields which don't even do this (bug?), and even once checked, the user is still unable to edit the price/discount selection. E.g., Requested ship date makes it editable but Delivery terms does not.
In the scenario where the unit price was derived from a TA and that TA has been subsequently ended and a new one is effective, upon making a header change, it is overwriting the price with the new TA with no pop-up, as expected.
I set Requested ship date to 'never' and while it did correctly retain the original TA price – it also doesn't update the lines with the header change I made (requested ship date). (Disappointing, but as expected).
Systematically, I understand, but it doesn't support our business which requires the line data to be updated and for the original price to be retained if the SO change being made doesn't impact the price. E.g., if you changed 'Price group' you would want it to evaluate and update but if you changed 'Requested ship date' (at least in our business) the evaluation should result in no change. Perhaps this is too specific to our business, but it seems to me that other companies would function in a similar way, no?
Thank you again for your response and suggestions – this is my first post, and I'm looking forward to getting involved in the UG community 😊
If you've found this thread useful, dive deeper into User Group community content by role