Item - OnPreDataItem() itemledger.RESET; SETFILTER(Inventory,'>0'); date1:=CALCDATE(refdate,TODAY); itemledger.SETRANGE("Posting Date",date1,TODAY); Item - OnAfterGetRecord() IF itemledger."Entry Type" = itemledger."Entry Type"::Sale THEN CurrReport.SKIP ;
Comments
Technical Consultant, MS Dynamics NAV
first one is for linking and
2nd one to filter all Item Ledger Entries of type : Sale
if there is any sale entry type the report skips the iteration for the item
This is what you wanted...?? Isn't it..??
Technical Consultant, MS Dynamics NAV
Try this, as in the previous one ItemLedger Record will not get reset for the iterations of Item DataItem
Technical Consultant, MS Dynamics NAV
Inventory - Sales Statistics for example, you can run this with Include Items Not Sold ticked, and add a filter for Inventory > 0
www.NextEqualZero.com
A technical eye on Dynamics NAV