Hi,

We do our stock take just before Christmas every year using the stock take options in products and services, we then do a product valuation based on the stock take for our end of year.

The problem we have is that doing the stock take on sage resets the last purchase prices of all of our products back to the standard (undiscounted) cost prices which results in our product valuation being far higher than expected. We then have to manually go through each and every product, figure out how much the discounted amount should be and enter that in which is an incredibly tedious task that takes a very long time.

So the first part of my question is:- Is there any way to set the stock take option in sage to use the last discounted cost prices for product adjustments in rather than using the standard cost price?

I'm assuming the answer to the above is no, in which case does anyone have any suggestions of how we can automatically adjust all of our products back to the discounted cost prices without having to manually adjust them all?

Any help would be greatly appreciated.