Hello,
I am wondering what the formula is for the field Avg shipping days. I was hoping to use this in a Gridview to determine how well stock is moving, however the numbers aren't what I am expecting them to be.
For example we have an item NE NSM2 we sold 625 LY, 635 YTD with an average of 59/month over the last 12 months. This is an item that moves quite well. However the AVG shipping days is 337. This is an item that has been on the system for a number of years and it may not have moved as well 8 years ago.
I would like to know how this 337 is calculated.
Thanks
_________________________
Lance Tennier
TDL Canada