I need a saved search to identify Item Receipts fr...
# ask-stanley-ai
m
I need a saved search to identify Item Receipts from a return, that are marked restock but have no COGS impact
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems that you can create a saved search to identify Item Receipts from a return that are marked restock but have no COGS impact. Here are the steps: 1. Go to
Reports > New Search
2. Select
Transaction
as the record type 3. On the
Criteria
tab, add the following filters: -
Type
is
Item Receipt
-
Main Line
is
True
(to exclude line items) -
Created From
is not empty (this indicates it's created from a return) -
Restock
is
True
(this indicates the item is marked for restock) -
COGS Amount
is
0
(this indicates there's no COGS impact) 4. On the
Results
tab, add the columns you want to display, such as
Document Number
,
Item
,
Quantity
,
COGS Amount
, etc. Please note that this search will only return Item Receipts that are created from a return, marked for restock, and have no COGS impact. If an Item Receipt is not created from a return, or it's not marked for restock, or it has a COGS impact, it will not be included in the search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.821936
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819782913
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818409085
Please provide your feedback on this answer.