thread632-1047972 - Sold Qty in item Quantities tableIV00102

[swabunn]

The tables IV00102 has quantities sold column but when we closed inventory module qty sold column reset to "0" and began updating current years sales quantities. Now I am making crystal report needs quantities sold for previous year i.e 2005. In which table historical quantities has been moved to . we are maintaining history and I can see historical qty sold records in cards - inventory - history. from which tables this data is coming, please help

-swabunn

 

[jazgeek]

that field is reset when year end is complete.

only way you'll be able to tell previous year sales is by checking historical sales and summing by year.

the table would be SOP30300 with a link to SOP30200 for date. Filter by Document type for invoice, don't forget to check voidstatus too.

you could make a view to group by year


-----------
and they wonder why they call it Great Pains!

jaz