Bulk change Purchase Order Cost Prices
L
Leisure Lakes Bikes - Admin
Suppliers are upping cost prices a lot just now. Existing Purchase Orders are arriving with incorrect cost prices despite the cost price being correct at the time the purchase order was placed.
The only way to fix this is to manually find then adjust each purchase order.
A Purchase Order wizard that can find POs with specific ILCs would be great.
S
Stefan Moody
Can you please push this out on the next requests update so customers can vote on it again.
We're getting lots of supplier updates through in 2022 where we need to update existing Purchase Order costs.
For example I've got 500 PO lines from Specialized that all have cost price updates and the only way is for me to manually open up each one and adjust each line. I've then got lots of other suppliers lined up this year with similar price increases. 1,000's of PO lines will need updating over the next few months.
L
Leisure Lakes Bikes - Admin
Any update with how we can cope with this problem?
I've got the first of what will, no doubt, be many supplier updates to run through.
All existing POs from this supplier now have incorrect costs on them.
L
Leisure Lakes Bikes - Admin
Lots of cases recently where suppliers are increasing their cost prices regardless of when the purchase order was placed. I'm having to manually find and adjust the cost prices of multiple POs on a regular basis now and it is incredibly time-consuming. Can you please review this request again.
NOTE: these incorrectly priced POs will also overwrite correct Supplier Costs when booked in and give you inaccurate Average Cost Prices so very important to get this job done.
L
Leisure Lakes Bikes - Admin
I've now got another major supplier with a complete cost price update needed. All current Purchase Orders now have incorrect cost prices on them.
750 Purchase Order lines need updating so that costs are accurate when booked in.
At present I've got over 3,000 Purchase Order lines that need to be updated and not a hope of getting on top of them.
HELP!
Rebecca Clarke
Leisure Lakes Bikes - Admin: Hi. I can see why this is causing frustration for you. Whilst not a solution for now, we added the ability to book stock in using CSV with the last release, would adding the cost to this import provide you with a workable solution in the future?
L
Leisure Lakes Bikes - Admin
Rebecca Clarke: Unfortunately not. Can't see how that would work. A Wizard which selects ILCs on all open Purchase Orders (usual Wizard selection options) would do the job. I can then export/cross ref with accurate costs, import and update. Easy!
S
Stefan Moody
Leisure Lakes Bikes - Admin: Hi, with suppliers changing their cost prices with ever increasing regularity we are regularly having to update cost prices on open purchase orders. This problem is unfortunately not going to go away. This week I'm going to have to manually update 100s of purchase order lines so the correct cost price is booked in.
Can you please put this request out again to all your customers as I'm sure that this is a frustration for many of them.
We really need a wizard that will allow us to bulk update open purchase order prices.
S
Stefan Moody
I've got another swath of supplier price updates due 1st May which will affect 100's of open PO lines.
I can easily identify the PO numbers that need updating so a wizard that allows us to import PO numbers then Update Lines to current Supplier Cost Price would be a perfect fix.
I can then run a supplier price update through, identify open POs that need updating and run the whole job through in a few minutes.
Thanks,
Stefan
S
Stefan Moody
This is still an ongoing issue.
Suppliers changing cost prices that affect open purchase orders all the time.
The only sensible way to keep on top of this is to bulk edit open PO cost prices.
Can you push this out to your customers again to see if they are also having similar problems.
Thanks, Stef