Skip to main content

Hi All 

In the Inventory Part in Stock I need to filter out for all users the parts that we have set with the description = DO NOT Use and also containing no stock, like this: 

 



The first part is set up like this in the page designer

 



How can I set up the 2nd part, the available quantity >0 ? 

Thanks,
Asela 

Hi ​@Asela Munasinghe,

It is not possible to add a filter for AvailableQty > 0 through Page Designer, and I am sceptical about your first condition as well, whether that would work.

Two ways come to mind to handle this condition. 

  1. Create a Saved Search for a business user with the desired conditions, and set it with the screen startup mode using the search setting. Later, import same search setting into the other user's personal profile. 

Ensure all users’ personal profiles have Startupmode entry for the Inventory Part In Stock screen. 

  1. Second option is worth enough to try, delete the standard navigation option for Inventory Part In Stock screen for the Global Context, and create a new navigation option with desired filter conditions.

 

Regards

Abdul Rehman

Hi ​@Asela Munasinghe 

How often are you running the Cleanup of Inventory database task?  Natively, this will remove records that show 0 on hand from this page.  The original transaction will still exists, but the record will be removed from this page.

Regarding the ‘do not use’, are these inventory parts connected to sales parts?  If you don’t want the users to sell these parts, what about inactivating the connected Sales Part instead?

If that doesn’t work either, how about creating a new field for ‘Part Status’ on the Inventory Part in Stock page.  Once that fields exists, you can create conditional formatting to highlight the row a certain color if Part Status = X.

 

Reply


Terms & ConditionsCookie settings