Page 1 of 1

Cost fields in Sage 50 Accounts and Manufacturing

Posted: 25 Feb 2020, 13:48
by JohnH
We run both Sage 50 Accounts and Sage 50 Manufacturing. I'm not in Accounts and product costing is not my direct responsibility, I am operationally focused. I have some issues around getting unexpected prices on purchase orders which means I'm also questioning the validity of reports we generate around spend and margin. I'd like to better understand how cost is handled by the software.
The cost fields are slightly different in both Accounts and Manufacturing -
Manufacturing has: Last Cost Price ( Standard ) and Standard cost
Accounts has: Last Cost Price ( Standard ) and Last Cost Price ( Discounted)
What are the definitions for each Cost?
What drives each of the costs?
Are any of the costs linked across Accounts and Manufacturing?
Is there any logic in play, ie if one cost field is blank use another one to populate a purchase order?
Many thanks

Re: Cost fields in Sage 50 Accounts and Manufacturing

Posted: 25 Feb 2020, 14:29
by brucedenney
I can tell you that in Sage50, the last cost price is set, whenever goods come into stock at the cost price on those goods, typically this is the price on the last purchase order that was delivered into stock.

As I recall from my past experience with Manufacturing, the purchase orders are generated in Sage 50, so I imagine that the cost price from Manufacturing is put on the Purchase order in Sage 50 and that then updates the last price in Sage50.

The cost of goods is recorded against each batch entering stock, it is not the last cost price, the stock is used on a LIFO basis so the cost price of materials being used in manufacturing will be dependant on the cost of the particular batch that is being used. You can see this by looking at the activity on the product in Sage50, goods going out to manufacturing will have the transaction type of MO and they will have a cost price