Filter the Item sublist on your Sales Orders?

You want to limit the selection in your Items sublist on your Sales Orders. Since the item selection are way too many as seen below:

image.png

Create the Saved Search:

Navigate to Reports > Saved Searches > All Saved Searches > New

image.png

On the New Saved Search page, click on Item

image.png

On the Saved Item Search page, set the fields below:

  • Search Title: <Set your search title here>

Criteria subtab:

  • Type: is Inventory Item
  • Name: has keyword Akko

Note: Feel free to change the criteria of the Saved Search depending on your business purposes.

image.png

Once you’re satisfied with your criteria, the results should now be filtered based on what you set as seen below:

image.png

Customize the Custom Form:

On your Sales Order page, navigate to Customize > Customize Form

image.png

On the Custom Transaction Form page, navigate to Sublist Fields subtab and set the field below:

  • Item Filter: <The Saved Search we created earlier>

image.png

Results:

Once done, the Item sublist should now be filtered as seen below:

image.png

Now you know how to filter the Item sublist on your transaction records! I hope this helped! 😁

Leave a comment

Your email address will not be published. Required fields are marked *