Last Cost Price Automatic Updating

SUGGESTED

When receiving deliveries, Sage automatically updates the product last cost price to that contained within the PO.  Is it possible to turn this feature off?

  • 0
    SUGGESTED

    Hi Chris,

    Thanks for using Sage City, and apologies for the delay in reply.

    Unfortunately the Last Cost Price field is updated by the purchases orders, this is automatic and cannot be turned off at present. The Last Cost Price can be updated by several actions, this is from the Knowledge Base:

    This is the latest cost price for the product, which is taken from the last entry that's been made using either the Opening Balance, Adjustments In, Purchase Order Processing or the Global Changes options. No discount is taken into account.

    You can request a change in the way the sofware fucntions by posting on the ideas board, which is reviewed regulalrly by our software developers: https://www.sagecity.com/gb/sage-50-accounts-and-sage-50cloud-accounts-uk/i/sage-50-accounts-and-sage-50cloud-accounts-ideas

    Kind regards,

    Andy

    Sage UKI

  • 0 in reply to Andy Rickeard

    Is this irrespective if the item is a "Stock Item" or "Non-Stock". As we dont have stock switched on so to speak all non stock.

  • 0 in reply to Gazmoz

    Also does using supplier price lists make a difference or does the last cost price still get overwritten?

  • 0

    Not a great answer I'm afraid Gareth.  Let me give you a scenario...

    We raise many purchase orders that have up to 20 lines in the order.  Historically, Sage have clearly recognised this and developed the 'Duplicate' feature in order to both save time and assure accuracy for a repeat order.  The problem with this is that when duplicating the order, it does not update the product prices to the current price against the products - it uses the price the price from the order being duplicated.

    Then, as you know, when delivering the order Sage updates the product Last Cost Price to the old price.  The only way I have found around this is to duplicate the order and then reselect every line item - clip the product dropdown, select the same item and then OK.  So what's the advantage of 'Duplicate'?

    I, like many others (including Gazmoz who I see has also posted the same problem as a separate thread), keep our product prices up to date by updating the product itself, not by Sage updating it for us.  This is because Sage is flawed in this way in that, having multiple persons using the system, we cannot possibly ensure the prices are accurate when Sage updates them itself it the various different ways you have identified.

  • 0 in reply to Chris Parkin

    Hi Chris, thanks for the reply.

    I just think Sage in a lot of ways is unfit for purpose operationally and a lot of my probs seem to be basic things.

    I get your point in your post but bit of a different issue.

    Yeah when duplicating or memorizing it wont pull through current cost price or sales price (for both Purchase orders, sales orders, invoices etc) in customer price list prices. But all you need to do instead of reselecting the line is take the last letter out of supplier ac ref then enter and it refreshes whole order bringing through all current prices for PO same on sales side for quotes, SO;s invs etc.

    But as you know PO prob is if cost prices change in between PO being raised and marked complete will overide last cost price with pop item unit price at time po raised.

  • 0
    SUGGESTED

    Hi Both,

    Duplicate is just a direct copy of the order you wish you be duplicated, as Gazmoz mentioned, re-selecting the supplier will recalculate the prices for you.

    In answer to if you use Stock, non stock or price lists all will update the last cost price on the product record. The reason for this is that Sage 50 uses FIFO (First in, First Out). 

    This means every product transaction's cost price and sales price needs to be recorded in the activity, this allows for calculations on reports when it comes to average cost and sales price.

    I think we could probably introduce a tick box to avoid updating the last cost price on the details tab of the product record, so it's probably worth logging that as an idea using the link below:

    Sage 50 Accounts and Sage 50cloud Accounts Ideas - Sage 50 Accounts and Sage 50cloud Accounts UK - Sage City Community

    Kind Regards,

    Ian - Sage 50 Dev Team

  • 0 in reply to Gazmoz

    Thanks for the tip Gazmoz, that works a treat.  Hadn't considered trying that.

  • 0 in reply to Ian C

    Gazmoz, I have posted the idea as Ian advised.  Please up-vote it. Thanks