Stockout time for Items

Becka

Hello there
Our client requires Report, that shows stockout time for Item. ](*,)
Any ideas??
Thanks a lot

rdebath

Guessing what you mean by "Stockout time" is "When will I run out of stock"

Sounds like you need to count how many of an item have been using in the last month divide that into your current stock. That number is how many months of stock you have left.

That's just a linear "curve fitting", there's lots of other methods you can use but if the client hasn't specified keep it simple.

AFAIK there's no standard Navision report to do anything like it.

Becka

Stockout time = time during Item was out of stock

rdebath

Err, that's not something that'll just drop out of a sumindex, but it's still pretty easy.

Use a temp table to collect the posting dates that exist on the ILEs for that item within the report's date range.
For each of those work out the stock level, when it's negative add it into your sum.

Becka

what do you mean by "ILE"?

superjet

add new flowfield Item."Inventory to date "that is the same as Item."Inventory" but with Posting Date=FIELD(UPPERLIMIT(Date Filter))

run report from some [start date] to [end date] in REPEAT..UNTIL cycle for each Item
Calculate this new field "Inventory to date" applying Date Filter with each date from [start date] to [end date] period

and check IF "Inventory to date" < 1 (or some other minimum) THEN
Days := Days + 1;


something like this..

kitik

Becka wrote:

what do you mean by "ILE"?

ILE = Item Ledger Entry

superjet wrote:

add new flowfield Item."Inventory to date "that is the same as Item."Inventory" but with Posting Date=FIELD(UPPERLIMIT(Date Filter))

You could also use the existing field "Net Change" and always write the filter like this one: ..EndDate

Salut!

Becka

Thanks a lot, I solved this problem with your help guys..
Thanks again 8)