Sage 100

I feel like I am missing something obvious. Customer on 2018 Std using Standard Valuation uses the master sales order and copy sales order functions, and can recalculate price using the 'recalculate price' button; but that does not update *cost*. So if they are copying a sales order from last year, but there has been a cost/price increase, the only option seems to be deleting and re-adding the line. I realize I can likely script this, but before I go that route, has anyone else run into this?

Michelle, Do you really need to update the cost on the lines? My understanding is that the cost will be updated at the point of Invoice Register and get the accurate standard cost at that time.

They would like to for accurate forcasting. I can also just update the report they are running to pull from the CI_item table, rather than the SO detail table. but when they are looking at the cost field in SO Entry, it causes confusion.

Customize the panel to show Standard Cost...?

@KevinMoyes That is what I ended up doing, then any reports they have that have cost on them, I am just pulling from CI_Item. Seems to have them happy for now.