Page 1 of 1

Cost price update

Posted: 30 Jun 2022, 08:50
by sageNoob
After posting invoice of any supplier. The quantity of product updated automatically but for cost price of that product I have to do manually in product and services field. Is there any way I can setup for Cost Price update also automatically?

Re: Cost price update

Posted: 30 Jun 2022, 10:47
by brucedenney
Posting a Supplier invoice has no impact on stock.

The cost of items going into stock is set on the Purchase Order and is the price at the time goods are received.

If you are not using Purchase orders, then you will be adjusting stock in, when you do that there is a cost price field you can enter the cost price in.

If you set a cost price on the product record, that price will be used as the default when you reorder the product on a purchase order unless there is a price list in place for the supplier.

Re: Cost price update

Posted: 01 Jul 2022, 16:09
by sageNoob
Can you please share documents with screenshot, so I can do testing from my side.

Re: Cost price update

Posted: 04 Jul 2022, 09:50
by brucedenney
Of what?

Re: Cost price update

Posted: 04 Jul 2022, 10:55
by sageNoob
Full process from making purchase order to post supplier invoice in sage.

Re: Cost price update

Posted: 04 Jul 2022, 13:02
by brucedenney
If you get stuck on any part I could do more screen shots.

There are 3 steps

1/ Make a PO and put it on order
This will prompt you with the current cost price form the product record (unless you have a supplier price list) as the default price for the item but you can override this.
Screenshot 2022-07-04 135158.jpg
I will overrode the price from 1.60 to 1.50

so the product record still says 1.60
Screenshot 2022-07-04 135340.jpg

2/ Receive delivery of the goods into stock (or amend if receiving part of the delivery
Screenshot 2022-07-04 134723.jpg

These will go into stock at the price on the PO 1.50
Screenshot 2022-07-04 135527.jpg
And update the last cost price on the product record.
Screenshot 2022-07-04 135628.jpg

3/ Update the ledgers from PO this is the invoice entry.
This puts the invoice on the supplier ledger.
Screenshot 2022-07-04 135729.jpg
Screenshot 2022-07-04 135818.jpg
Press update if everything is correct, or edit if you need to change something, any change made to the unit price will not alter the price the item went into stock at as that happened when the good were delivered and can not be changed now. (Except by manually adjusting stock out and then in again)
Screenshot 2022-07-04 140058.jpg
Hit the save button and/or change any of the values needed.