NAV - Matrix - P491 Items by Location, P9231 Modify Items by Location Matrix - Add location filter

• P491 Items by location main page
• Create LocationFilter Global text
• Add LocationFilter to page as a field
• On Validate, set filter and run setcolumns
• Find this code, and insert this line

MATRIX_CaptionRange - OnControlAddIn(Index : Integer;Data : Text)

SetColumns(SetWanted : 'Initial,Previous,Same,Next')

MatrixRecord.SETRANGE("Use As In-Transit",ShowInTransit);

MatrixRecord.SETFILTER("Code",LocationFilter);//INSERT THIS LINE

CLEAR(MATRIX_CaptionSet);

• P9231 
• Add filter to item table to hide items with 0 qty