Option to stop Purchase Orders overwriting Supplier Costs when booked in
planned
L
Leisure Lakes Bikes - Admin
Did you know: When you book a Purchase Order in to stock the Supplier Costs are overwritten to the Purchase Order Cost price.
This causes us all sorts of problems.
We put a lot of effort into keeping the Supplier Costs accurate. We can't use SIM for this as SIM cost prices are not accurate for us so we run them manually so that when a Purchase Order is raised it has the correct cost price on it.
Pre-orders, staff purchases, special deals, bulk purchases etc all have lower prices on the Purchase Order. When they are booked in to stock the Average Cost prices are updated correctly and accurately and work very well.
The actual Supplier Cost price is then also updated meaning that any further Purchase Order raised will have an incorrect and too low price on it.
What is needed is an option when booking in Purchase Orders to update average costs (as the system currently does very well) but to please leave the supplier cost price alone.
The default option should be set in Configuration for the company with a tick option to change this on every Purchase Order (if you need to).
S
Sally
Please could you give a timescale for when this change will be made, we are having the same issue with Supplier Cost prices.
W
Will (MR)
Please can we get an update on this, been nearly 2 years
S
Stefan Moody
Another example of why this is a major issue.
Trek are updating all their bike prices on 08/10/22.
All our open PO cost prices will be honoured at the current, lower cost prices.
I'll run the new prices through tonight.
From tomorrow, all our open POs, when booked in, will overwrite my nice, new, accurate cost prices.
I've now got to somehow monitor all Trek Bike POs booked in, identify which ones were booked in with old cost prices and manually adjust them to be correct. The next day another store will book the same bike in, or order another one at the incorrect cost price and the vicious circle continues...
Oh, yes, we've also just gone through a whole load of pre-orders, all with lower cost prices to standard that have now been mostly booked in, completely messing up 1,000s of supplier cost prices.
I just can't manage this and keep on top of it.
So frustrating.
Suzy Weightman
Merged in a post:
Ability to turn off cost price changes from PO's
A
Alice
When changing a cost price on a purchase order or goods in it updates the item listing - very annoying if something is on offer or is one off free stock as you have to change the cost price back. Could there be an option to turn this off?
D
Dan Donnan
planned
Hi everyone,
I've added this suggestion to the development backlog to be implemented in a future release.
At the moment I cannot provide a timeframe for when this will get looked at, but those who have voted for this will be notified when the work begins.
Thanks,
Dan
S
Stefan Moody
Dan Donnan: Hi Dan, any progress yet with this. In 2022 we are getting more and more price changes from our suppliers which we can just about keep up with but having POs overwriting high value items is increasingly a problem that's just not going away...
Thanks
Stefan
S
Stefan Moody
PLEASE, any idea when this will be implemented?
We're now into loads of Autumn/Winter pre-orders that will be arriving over the next months.
This means that, once again, our re-order supplier cost prices will be wildly out as soon as these pre-orders are booked in.
This thread is now two years old but I've been raising this issue since 2018.
Thanks,
Stefan
W
Will (MR)
Stefan Moody: my take on this, although lots of interest, is not planned.. :( i wonder how many users these need before they become essential!
S
Stefan Moody
Will (MR): Yes, it does seem that accurate cost prices is not a high priority with Citrus Lime...
S
Stefan Moody
Dan Donnan: Any idea when this will be sorted.
Another season of pre-orders being booked in and yet another load of incorrect supplier cost prices I have almost no chance of tracking and keeping accurate for re-orders. So frustrating.
S
Stefan Moody
I do hope that a fix will be included in the POS 2 release.
Can you confirm this please?
We really do need this resolved, ideally combined with some form of bulk PO cost price wizard.
Supplier cost prices are changing all the time and maintaining accurate cost prices on Citrus Lime is becoming increasingly time-consuming/impossible.
With tough competition in the marketplaces it is vital(fundamental, surely) that we maintain accurate margins.
Accuracy to within 0.5% or lower is needed so we can be proactive and competitive with price-matching.
Thanks,
Stefan
W
Will (MR)
Stefan Moody: so frustrated with this, we now EMPLOY someone to check every PO, just to ensure if it's a promo pricing it is comitted and then any other PO's with this item have to be manually adjusted.
raised in 2020, still an issue in 2023, c'mon CL, sort it!