Sage 300

I'm trying to create a query for a client to find items that haven't been used since a certain date (ICILOC.LASTUSED). They don't want to see items that were created recently and haven't been used yet (LASTUSED=0), but still show items that were created…

How can I get a listing of the inventory Items in a specific location that contains a specific word in the description? For example a want a listing of all item with "Widget" in the Inventory Item Description. HELP???? Our OLD system could have…

Hello all. We believe we have found an issue with the Item Finder Qty on Hand field. When the user applies a filter using an Optional Field, the finder will display the wrong qty on hand. For example, if we filter for "Item Number" starts with 20149…