Display quantities sold in past 30 days for each item

johnsogj

I'm creating a report based on the item table.

For each item , I'd like the report to display the quantity sold in the past 30 days.

Can anyone help me with this?

Thanks,
Molly

kine

OnPreDataItem
  Item.SETFILTER("Date Filter",'%1..%2',CALCDATE('<-30D>',TODAY),TODAY);

OnAfterGetRecord
  Item.CALCFIELDS("Sales (Qty.)");

If you will do that for all items and you will print the "Sales (Qty.)" field, you will have what you need... (I hope)

kriki

[Topic moved from Upcoming version NAV 6.0 (formerly NAV 5.1) forum to Navision forum]

johnsogj

Thank you Kamil! it worked exactly as I had hoped.