Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Cost price update
Cost price update
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?
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Cost price update
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.
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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Cost price update
Can you please share documents with screenshot, so I can do testing from my side.
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Cost price update
Of what?
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Re: Cost price update
Full process from making purchase order to post supplier invoice in sage.
- brucedenney
- Site Admin
- Posts: 4629
- Joined: 28 Feb 2006, 09:56
- Sage Version: v28 UK/Europe/Africa
Re: Cost price update
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.
I will overrode the price from 1.60 to 1.50
so the product record still says 1.60
2/ Receive delivery of the goods into stock (or amend if receiving part of the delivery
These will go into stock at the price on the PO 1.50
And update the last cost price on the product record.
3/ Update the ledgers from PO this is the invoice entry.
This puts the invoice on the supplier ledger. 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)
Hit the save button and/or change any of the values needed.
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.
I will overrode the price from 1.60 to 1.50
so the product record still says 1.60
2/ Receive delivery of the goods into stock (or amend if receiving part of the delivery
These will go into stock at the price on the PO 1.50
And update the last cost price on the product record.
3/ Update the ledgers from PO this is the invoice entry.
This puts the invoice on the supplier ledger. 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)
Hit the save button and/or change any of the values needed.
Login to access the files attached to this post.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 13 guests