In a situation were you have over 30,000 products like supermarket
How do can you do Sale Price computation based on last purchase price..?
Looking at the costing methods available, they are not helping..
Average cost price affects the sale price desired when there is a significant margin between two prices.( Eg. previous purchase was $10 and new purchase price $30 the avaerage gives me a loss.)
And Real pricing changes the cost and gives desired sale price but in batches of purchase but I need to change the sale price of all products, stock on hand and incoming stock to a marked based on the new purchase price.
While using Periodic/Manual Stock Valuation.
@Niyas
Thank you very much.
I believe this is exactly what I wanted.. But unfortunately this module is not working with manual inventory valuation, it gives an error.
And with automatic inventory valuation it can only do one purchase order and updates the cost but the next one it fails to update the price. But this can do the trick if it worked.
Thanks
@chris
Excellent, that's even better. will look into it. Thanks alot.