Friday, September 14, 2018

Filter out negative quantity for items on a transaction search

Customer is trying to create a transaction search and would like to pull out negative quantities. On the Criteria tab > Quantity= Not less than 0 but still transaction search is showing negative quantities.

* The negative quantities are coming from the Cost of Sales account.

1. Navigate to Lists > Search > Saved Searches > New > Transaction

2. Criteria tab > Memo = does not contain Cost of Sales

3. Preview search

Note: This is not applicable to other types of transaction. For instance, in an Assembly Build, there will still be negative quantity for this will represent the decrease in the quantity of the Components. Other transaction types on which this article is not applicable are Inventory Transfer, Bin Transfer, Inventory Adjustment and other transactions which are not hitting Cost of Sales account. 

 

No comments:

Post a Comment