Zero stock Items -Counting days since inventory became zero

nmunaf

Hi,

I have very elementary knowledge of Navision coding. we are using navision Financials ver 2.6. I have created a report which gives a item wise list of items whose inventory Qty = 0 and list of purchase orders in the system (if any) for that item.

I want to know if its possible to calculate(Count) the Numbers of days since the inventory qty became zero.

ie
No. Name No. of Days since Inventory became zero Qty on PO
1001 Item A 10 360
PO123 240
PO124 120

Alex_Chow

To do a count of the days, all you need to do is:
Integer := Date1 - Date2

I suspect the tables you'll need to use is the purchase line and the item ledger table.