Inventory - Option to automatically update purchase price when buy new product
Ability to have an option to automatically update purchase price on the item when users buy the same new items.
Purpose: To save time from having to manually update each item price when there’s a different price on the same new items.
Thanks for your comments and emphasis on the bills side of things for the idea here. I've made sure this is shared with our team in this space.
Bills is an area we're continuing to develop with building on beautiful and I'll be sure to let you know here if there's any consideration made to change behaviour of this through the bills add and edit flow.
-
Helen Lindsay commented
Such a surprise and very disappointing that this is not standard in Xero, it's in MYOB!! You can access the products and services directly through the bill when inputting AND it automatically updates the purchase price so you are aware of the last price that was paid. This is critical so that if there is a discrepancy it can be monitored, and the sale price can also be amended to cover the purchase cost increase. If I knew this before I changed to Xero I would have thought twice before changing over!!
-
Miranda Hopping commented
It's not just the purchase (cost) pricing, but the sale price that needs to be able to be updated when entering stock/bills. This will save considerable time,and I would consider it a critical function.
In MYOB you had the option to be able to update both cost and retail prices right there in the one screen as you entered a bill.
This really needs to be a standard feature in any accounting package no matter how basic. -
Peter Kerly commented
also a feature to increase all products and services by an amount (% or £) each year or whenever it becomes necessary.
Dont want to keep importig/exporting data.
This was a feature on qb desktop. -
Hanlie van Gend commented
With the constant rising of prices, this feature is becoming critical!
-
Candace Hunter commented
This is one of our biggest frustrations with Xero. We previously had MYOB that automatically recorded our last purchase cost. Now we are losing time and potentially profits having to remember to update the hundreds of items that we purchase. This should be a standard feature and I'm a little surprised that it isn't.
-
Kelly Franssen commented
In MYOB when you entered a supplier invoice it automatically updated the product cost. This is beneficial when there are supplier increases (especially the little sneaky ones they don't tell you about) or when you negotiate a better discount and they (believe it or not) reduce the price a little.
-
Luisa Magao commented
We have prices that constantly fluctuate and it is very time consuming to have to constantly update the price item by item. Very frustrating. I agree with Riaan would have expected it to be a standard - or at least have the option to turn this on or off as needed.
-
Riaan Badenhorst commented
This is something I expected to be standard. If the system update the "on hand", why not the cost price?
-
John Bryan commented
Hi Kelly
That still requires us to remember that an item has changed at the point where we sell it. What we need to be able to do is easily record that the cost has changed at the point when we BUY it.
-
Katie Manns commented
Hi Kelly, it is more critical to be able to edit the inventory items from the Bills so that when we enter a Bill from our supplier if the cost of the inventory item has increased (as has been happening due to inflation) then we can quickly and easily update the sales price in the inventory so that we can maintain the correct margin on our products. Can you please extend the edit function from invoicing into bills as well.
-
Edward Henry FIPA FFA commented
It's not the ability to edit from new invoicing, but rather when the items are purchased ie from a bill, that it is important to update the cost.
-
Libby Owen commented
We really need the ability to edit inventory straight from bills. I'm double handling things and it leads to mistakes and inaccuracies when I'm invoicing. Please consider making this change!
-
Amanda Hubley commented
It would be better if the products were able to be edited from Quote documents. Since we almost always start with a Quote. This is in response to being able to edit items from invoice lines.
-
Emma Rosenblatt (Accounts) commented
Hi @Kelly, I still don't think this solves our issue. Firstly, you have only addressed items we invoice but not items we are billed for. If we are uploading bills into the system and they include items that we track, then there is no way for us to update the pricing of each item like you are suggesting we do in the "new invoicing"...This option of automatically updating prices when creating invoices and bills are both important, but I do feel like most of us are referring to bills.
Another issue with inventory is when I assign items to a project from a bill why does it not take it out of stock or show anywhere in the inventory section that items are allocated to a project? I feel like assigning items to projects is only half doing the job. Yes, an expense "a dollar value" is charged to the project by doing this action, but nothing about it affects the stock count. From what I understand the only time we can affect the stock count is once the item has been invoiced, but, if materials are being used to make an item then technically they are no longer in stock or for better words they have been allocated to a job. Or the items were delivered before the bill was entered into Xero and the purchased items are already being used...If I wait until invoicing an item before stock is affected then this is not an accurate or true representation of stock count...Also my company will never invoice each individual item because that would create a 100+ line item invoice. A product bundle system would work much better where many items make 1 product.
-
Emma Rosenblatt (Accounts) commented
Not having this feature takes away the autonomy of Xero. Our stock controller is very frustrated that prices do not update automatically when billed for a different amount, prices for us are almost always changing, nothing stays the same price for very long.
-
Katie Manns commented
This would be amazing, especially paired with the ability to set a standard markup or margin so that when you entered a bill that saw the cost price on an item had increased then it automatically updates the sales price in inventory according to the standard margin or makeup set.
-
Udo Systems Accounts commented
I need different price points for bulk buys! manually entering and remembering these is painful and time consuming.
the only thing MYOB has over Xero.
Min Max system would also be great to help with stock control.
Thank you!
-
Kellie Galati commented
Yes this is critical. I can buy things one week and a few weeks later and continually changing price. If I have 10's of items on the bill and have to update after that is extremely tedious. If we could have the ability to update on the purchase order and our the bill/ invoice and this is updated in products and services. That would save so much time
-
Leonie Williamson commented
Yes, please add this feature as the current climate is seeing the prices changing constantly. I have also found that in the change over from MYOB the prices did not come across and I thought that when I entered cost price when entering a bill that it would update. But unfortunately not so I am having to do it manually. Very frustrating.
-
Kellie Galati commented
I totally agree, I have to highlight my invoices to keep aside for when I have finished, then go into products and services and update each line individually. Would be so much easier if when changing price on purchase order or bill/invoice for a line item, it updates for those products in inventory.