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.
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?