Tuesday, September 18, 2018

Report to show the Item Usage in Assemblies


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

2. Under Criteria > Standard > Filter: Type=Assembly Build

-  Item Fields: Name=indicate in here the name of the member item

 - Date=set something appropriate

3. Under Results > Columns > Field: Item

    Item fields: Description

  Quantity

   *Sort it by Item then by Date

4. Preview

Note: The Quantity column will show the values on negatives because these are the member items which were used on building the assembly.

 

 

 

 

 

 

No comments:

Post a Comment