Custom Stock Level Report (v1.6)

[mgbolts]

Hi,

I need to calculate the stock balance on a particular date, ie. roll back the stock balance from 'today' and determine the balance on a past date.  My error for not doing or keeping a backup on that date! 

I dont need anything flash, a simple flat file is all I need. ie. I dont need PS to be working effective on this historical date.  Just need the stock balance data...  

I plan to run a simple sql script to perform the calculation. In this regard, my query  relates to the database schema for PS1.6 to make sure I determine it correctly.

It looks like I can achieve this through the ps_stock and the ps_stock_mvt tables.  I am guessing that if I start with the balance from the ps_stock>physical_quantity field and then adjust it for all of the movt records in my date rate using the ps_stock_mvt>physical_quantity field.

Any advice in this regard would be appreciated.

Thanks Mark