Hi Danelle,

From the title of your query we see you want to manage the sales cost, is it? Usually the sales cost depends the way you manage the stock valuation, how is it manage on your side? Avarage lot cost?

Hi Martins,

Stock valuation is based on average lot cost and last purchase price.

Hi Again,

It's actually just average lot cost.

Danelle Werkin said:

Does the COGs pull from the last purchase order? If so, how quickly does the price change? Is it once the purchase order has been invoiced?

The price is updated from the reception of goods, and then reevaluated with the invoice, if the price is different.

Danelle Werkin said:

If I have a supplier that tells me they can offer me a raw material at a certain price, but I don't need to buy yet, should I enter the offered price into price list entry or RFQ? And does the supplier with the lowest price transfer to a purchase order?

Does not transfer, you can print to compare, but need to select manually, from Responses to Purchase Order, you can use the action in the purchase order to select the response.

Danelle Werkin said:

I'm constantly getting price quotes and price changes, and I don't know the best way to manage all of this through Sage. Additionally, I buy thousands of raw materials that fluctuate based upon the market so it's hard to remember when I get a better price unless i go to each supplier every time I order something. 

I think that's life... not a SAGE problem... ;)

This is correct. Keep in mind the reevaluation based on the invoice price is done only if the 'Adjust receipt cost' field is ticked on the valuation method.

The supplier offer based on a RFQ should be entered as an answer (GESPPD). When the best answer is identified, you use the function FUNPPD3 to create the price list based from the selected RFQ answer.

Ideally you can request your supplier to keep you updated whenever there is a price change by sending the new price as a file. Then you import this file as a new price.

Or a Trade Promotion Management software might be useful in your case.

Morning Julien,

How do I import a price as a file?

Ok so once we get the raw materials in, the avg cost updates?

thank you. that is helpful.