item history - inquiry

[swabunn]

Any body knows table for item history - inquiry because I want to pull historical sales and cost information from there to make report in crystal

-Thanks

-Swabunn

 

[martink1]

item tables start with IV..., Iv00101 and iv00102 are the tables I use the most, the tables starting with 300 are supposed to be history tables so iv30101 or iv30301 probly contain historical info. Go the the inquiry item history window, on the menul bar click tools-resource descriptions- windows. you will be able to see what tables are used

 

[barbola]

Your sales tables would be SOP30300 (header) and SOP30310 for the line items and would include item costs and quantities. You may need to join to IV00101 if you want to include Item Class.