Sage Line 50 Product Valuation

Sage Line 50 Product Valuation

Didn't find your answer?

I am a new user of Sage Line 50 (Financial Controller)so please bear with me.
I am struggling to find how to amend a product value on stock items that have changed in price since they were ordered. The Product Valuation printout (which is used for the stock valuation in the accounts) seems to use the price that was on the order rather than the price on the invoice even if the invoice price is edited during the 'Update' process in POP. Is there any way that the stock value can be changed to reflect the correct purchase price?
The problem arises on a regular basis because the accountant enters all foreign currency purchases in Sterling at a (manually) converted rate on the date of order which, of course, is different to the rate on the date of invoice.
Is there any way to get an accurate stock valuation figure without doing laborious manual calculations?
Jane

Replies (1)

Please login or register to join the discussion.

avatar
By David Carter
06th Feb 2005 23:52

help soon
Jane

Sage seems to calculate an "Average Cost Price" (weighted average, or just average?). It also holds a Last Cost on the Purchase order price in the stock record.

I think you need to export the stock file into Excel and do it there.

I could put together a brief tutorial on Sage's Report Writer to show how to export the stock balances and prices to Excel. It's very simple. Would this help you?

Thanks (0)