Stock Value Calculation?

[fibonacci-d]

I know Actinic has various facilities etc. Accounts wise, it would save doing a huge recount of stock for a client of mine if Actinic gives an up-to-date value of stock based upon the stock entered against all products.
For example - Football Boots RRP £50 = 5 in stock (Trade price £30 +VAT) = Value of stock £150 +VAT
Can you view at anytime the current value of stock?
Chris

[leehack]

You could run your own query on the database to produce this, i don't see this ever being part of standard actinic due to minimal people wanting it. An export of products plus their stock level, looking up prices in a database via the product reference should do it.

[NormanRouxel]

Look at the Product table in ActinicCatalog.mdb. Fields of interest are

Status (N is not deleted)
Product Reference
Short Description
Price (in pennies)
nStockOnHand
nProductType (0 is normal product)

If you use Components, permutations, etc then life gets more complicated.

[Jan]

You can only store the sales price in Actinic, you can add a cost price using our profit and pricing tool and print a sales value report for all or selected products. You can find more details and a free trial here

Regards,

[fibonacci-d]

all help gratefully received - didn't think there was anything immediately within Actinic that could do this but not to worry, running a query with Lee & Norman's suggestions is a definate possibility as is Jan's...
Cheers,
Chris