I have a large inventory which I need to update the "base price" which is my selling price by pre set percentages of the most recent cost (could be an increase or a decrease) driven by market conditions.

I have been trying to manipulate the "Update Price List" options to achieve this, senior management just want to refresh after purchases.

My setup does not allow me to change from standard cost to most recent cost.

Need your assistance..

Thanks

Hi Edward,

From what I see, the Update Price List function does not allow the Base/Selling price to be updated based on the Most Recent Cost. Not sure why exactly as even though most would not want to do this on an ongoing basis due to the fact that it would mean that their selling price could fluctuate consistently, I would think that there are industries where this would be needed and even for those where they only may want to do it on a periodic basis, it would still be a nice option to have.

A work around might be to:
1. Set up an export template to export the required fields
2. Have an excel template setup that only needs the user to enter the percentage increase or decrease
3. The user "saves as..." (to some other name) the updated template sheet that has all the automatically updated base prices to an import file
4. In Adagio Inventory the user imports the new prices from the file created in 3.

If you wanted to automate a little further, you could have the Update Base Price import template set as an "Auto-import on startup" template and have the specific user preference set to "Process imports". In this case, you might also want to consider setting the "Delete import file on success?" option to help avoid an accidental update that noone would remember accidentally doing

Good luck, Pete

In Jamaica, owing to our monetary policy we have a floating exchange rate and we are now experiencing a decline in the value of our dollar, thus prices are not constant.

I feel like I am gambling with ADAGIO, every time I reach out to my team I need "luck".

I have spent so much time making sure I was not at fault for this situation.

I appreciate the work around suggested but my clients want a solution, as per the menu item Price Update.

Thanks Pete...I await the response from Softrak.

Hi Edward,

Pete has it right as the function currently works - there are no options to change the base cost for markup, using the Update Price List function. Why is it like this? For legacy reasons, and it doesn't have to stay like this for the future, but we don't typically hear too much about this function from users and thus have to assume that either not many people use it, or it works for them as it is.

Pete's suggestion is the best way to approach this, either from the Export template he suggested, or from a GridView view with all the calculations already done (from the existing Markup value stored on each item). GridView supports automatically exporting the view to Excel unattended as part of a scheduled task, so that could assist in making the process more automated.

We hope that using and supporting Adagio doesn't feel like a gamble for you.

I believe that Purchase Orders for Adagio will automatically update the price as you wish on processing the receipt.