Historical Item Sales - Previous Years

[Chris Kelleher]

Besides itemwhse.qty-sold-ytd, are there any historical item sales
tables/fields which store previous multi-year sales? I am interested in
qty sold and gross $ sales per item.

TIA,
Tim

 

[Chris Kelleher]

I don't know what version of Symix you are on. But the Syteline versions
have a table called sale-sum. This table stores the past 65 months of
inventory sales along with net price. Hope this helps.

Mike Dahlem
OSG TAP & DIE, INC

 

[Chris Kelleher]

That was a surprize to me Eric!

I immediately went to Sales and asked if they knew about these reports?
I showed them Item by Volume and was surprised to hear:
"These reports show what was Shipped and not what was Sold - that is why
we do not use them".

Well to answer the original question:
Every year I dump

<BLOCKQUOTE><font size="1" face="Arial, Verdana">code:</font><HR><pre>
" assign
invval.inv-date = t-per-end

invval.item = item.item
invval.unit-cost = item.unit-cost
invval.cur-u-cost = item.cur-u-cost
invval.qty-used-ytd = item.qty-used-ytd
invval.qty-mfg-ytd = item.qty-mfg-ytd

invval.qty-on-hand = itemwhse.qty-on-hand
invval.qty-sold-ytd = itemwhse.qty-sold-ytd
invval.sales-ytd = itemwhse.sales-ytd
invval.qty-pur-ytd = itemwhse.qty-pur-ytd.
"
[/code]

before resetting YTD on them - we already have 5 years of historical
data instantly available on any Item screen.

Jake Kacher