Hello! I'm trying to make a search to pin on our buyer's dashboards that shows them the most recent Item Receipts so that they can spot-check them as well as know what has most recently come in. I have it pretty much done, but I'd like to highlight the line items based on whether or not the total amount received is equal to the quantity ordered. I thought that this would be easy -- create a transaction saved search, set type to Item Receipt, and then use "Created From : Quantity" and "Created From : Quantity Shipped/Received" columns to use for highlighting, but these fields are always blank. I imagine it's because they're not tieing to the Line Items, but instead the Main Line fields. This is how my current Transaction saved search is set up:
Criteria:
- Main Line: false
- Shipping Line: false
- Tax Line: false
- COGS Line: false
- Item : Type: Inventory Item
- Type: Item Receipt
- Department: -Mine-
Results:
- Date (Summary Type: Maximum)
- Vendor : Name (Summary Type: Maximum)
- Type Based Document Number (Summary Type: Group)
- Created From : Type Based Document Number (Summary Type: Maximum)
- Item : Name (Summary Type: Count)
- Item : Display Name (Summary Type: None)
- Quantity (Summary Type: Sum)
Other:
The result of this is a list of Item Receipts that you can click on to see their Items. This is pretty useful in and of itself, but I want to have highlighting for over/short, which is information that I believe can only come from the "Created From" join. Is there some way to get this information into my search so that I can make the most of this? Thanks!