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

I believe it's a rolling average. The new transaction (days to ship/total shipments) is rolled into the current stat. Perhaps some strange invoice date has thrown off this calculation.

Hello Lance,

We went a looked at the code, and are not convinced that the calculation is correct (or meaningful). The calculation is supposed to be:

and then increment the shipment count.

However, that's not what it's doing which explains why you are having trouble getting to the number displayed on the screen.

We will correct the code for Inventory 9.3A (or change it to something else if anyone cares to suggest a better calculation).

Thanks Andrew