Adjust Inventory - Current Price

Altec
Experienced Cover User
32 Posts
Experienced Cover User
Australia
Experienced Cover User

32Posts

1Kudos

2Solutions

Solved: Go to Solution

Adjust Inventory - Current Price

I have to increase the price of approx. 90% of my inventory "current price" soon and am investigating the best method to do this.

 

I have found the shortcut calculation method "percentage markup" but it only give me the option to increase the "last cost" price or the "average cost" price; not the 'Current Price"

 

I expect I could export, modify and import all prices.  Is there a better way to increase the Current Price by 7%?

3 REPLIES 3
Altec
Experienced Cover User
32 Posts
Experienced Cover User
Australia
Experienced Cover User

32Posts

1Kudos

2Solutions

Re: Adjust Inventory - Current Price

To add to this post:

I need to update the "Base Selling Price" only.

After further investigation I expect the best way to do this is to export data (via copy to clipboard and copy to excel) from the Items list, which correctly displays the "sell price".  Then use excel to calculate 7% and round to the nearest 5c; then manually enter the new price into the "Set Item Prices > Current Price" field.  Run the report again and use excel again to compare them to make sure I haven't made any mistakes.

If you have any better suggestions, I am truly open to them.....there are 774 active items (although there is a small percentage that do not need to be updated); and I have to get this done so that all invoices that go out the next day are at the new price (and still work a 12 hour day to get my regular work done!)  wish me luck!

Steven_M
MYOB Moderator
40,148 Posts
MYOB Moderator
New Zealand
MYOB Moderator

40,148Posts

5,447Kudos

5,932Solutions

Accepted Solution Solved

Re: Adjust Inventory - Current Price

Hi @Altec 

 

I would recommend taking a look at Help Article: Bulk update item prices. This outlines a process in which you can export the information out of AccountRight, update it in Excel or another application, and then importing it back in to update that information.

Kind regards,
Steven

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Altec
Experienced Cover User
32 Posts
Experienced Cover User
Australia
Experienced Cover User

32Posts

1Kudos

2Solutions

Re: Adjust Inventory - Current Price

Thank you, yes I did test that option yesterday and it works; albiet would have been quicker to be able to use the percentage markup option. 

It's a pity the shortcut calculation method "percentage markup" doesn't have an option to update the base selling price.  I don't understand how it can be useful the way it is designed, but it must have some purpose I guess.

Thank you for you assistance.

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post