Last Cost Price Automatic Updating

Question

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?

Ian C · Answer

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

Andy Rickeard · Answer

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

Sage 50 Accounts

Last Cost Price Automatic Updating

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING