Sunday, June 16, 2019

Search for all Inventory-Affecting Transactions Without Assigned Bin Numbers Whose Item Record has ‘Use Bins’ = T

Search for all Inventory-Affecting Transactions WithoutAssigned Bin Numbers Whose Item Record has 'Use Bins' = T

1. Navigate to Lists > Search >Saved Searches > New > Transaction
2. Under the Criteria tab > Standard subtab, add the following:

Filter

Description

Formula

Posting

is true

 

Account Type

is Other Current Asset

 

Transaction Bin Number

is empty

 

Quantity

is not empty

 

Item : Use Bins

is true

 

3. Under the Results tab > Columns sub tab,add the following: 

  • Type 
  • Number
  • Date 
  • Item
  • Quantity

4.  Giveit a name and save.

 

No comments:

Post a Comment