Stock management

[Xavier Vidal]

Hi

I would request a feature, which is very interesting (and critical for us): stock management.

I'm not talking about "how many products of XYZ type we have", but something like a warehouse log.

Let me give you an example, let's call this table: StockLog

When you are buying products:

Day: 2/1/2009
WarehouseId: 2
ProductId: 5
Quantity: 10
Pack: 567 (product's group)
Cost: 15.40€
ExpirationDate (if it suits): 2/1/2010

When you are selling products:

Day: 5/1/2009
ProductId:5
WarehouseId: 2
Pack: 567
Quantity: 1
Cost (sale): 19.30€

This log is very useful to know:
- quantity of stock (for "pack", for "product"...)
- expiration of stock (useful for doing some marketing actions)
- profit reports based on buy/sale with respective cost/price (very very accurate)

It could be possible to have this in PS in a near future?