I found it quite strange that NAV have this feature. There is no restriction or validation on Unit Price. Scenario is very simple. - The item in Sales Order has been partially shipped and invoiced, or some other item has not been shipped, therefore the Sales order document is still visible - NOT in history yet. - User re-open the Sales Order - Amend unit price at any line you wish My question is: What is the rational for allowing this ? Will it not cause confusion on the sales invoice or total sales amount ? Thanks.
Hi Cynthia,
Welcome to the Dynamics User Group!
The sales price is stamped on the shipment and will give the original price if the shipment is invoiced using get shipments. The ability to amend the price is to allow for price variability. If you want to control this then you can use (if V5.0 or greater) the sales order approval functionallity.
Thanks for the quick response. Price variability…are you saying that the reason is so we could sell at different price to the same customer at different timing in the same SO ? Which dumb customers would want to pay that SO ? I am sorry for being rude, but I still don’t see a valid reason. Would you mind to elaborate with a simple story?
Not sure I understand your complaint completely.
Do you want the price to be Non-Editable?
Sometimes We enter the same items 2x the first line might be a certain qty at full price where the second line will be a zero price line because of some free promotion. Buy 10 get 2 free - an example of having two prices for the same item.
Also, the price might not be different for the same customer on the same sales order, but it could be for a different customer then how would you make that change if the price field was non-editable. Do you Release your Orders?
Hi Cynthia,
Two examples - commodity based goods e.g. oil, chemicals and goods where the price is dependent on the quality/strength of the good which is tested on shipment e.g. chemicals, food
Or maybe, the goods you sell are in FCY, which of course it will have a different exchange rate everyday.
Regards,
-TR-
OK… Kinda get the idea of allowing price difference for a sales line - edit price for FOC item, .
Back to main problem: “change unit price at anytime”.
This sales line 10000, item A, quantity 2, has been shipped and invoiced. But somehow user re-open the SO - which still has other outstanding lines, and modify the unit price ONLY in line 10000. Never increase item quantity.
What’s the idea / purpose of allowing this ?
Item A, qty. 2 . then how many of item A shipped? how many of item A invoiced? what is the outstanding qty. of item A when a user change the unit price?
if no more outstanding qty. for item A, the unit price change has no affect.
OK I understand now. Changes on unit price will not have any impact on sales invoice.
Whatever shown in sales invoice is correct because that’s what the sales order is at that point of time.
Time to educate users!!