On Hand Items History
We need to run a query that show a historical quantity on hand report for several items we provide a client. Been looking at the tables that might have the information but there is not one with history. Seeing that my database is almost 400GB and has been live for 4 years, I assume that data is somewhere to be found.
Any ideas?
Thanks in advance for any help.
Regards,
Francisco Elguera