how to find all invoices that not contain cogs acc...
# ask-stanley-ai
y
how to find all invoices that not contain cogs account because there is system error and this invoices did not affect the stock
c
AI generated answer (using internal Slack threads):
To find all invoices that do not contain a COGS account due to a system error and did not affect the stock, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to
Reports > New Search > Transaction
. 2. In the
Criteria
tab, set the following filters: -
Type
is
Invoice
-
Account (Account type)
is not
Cost of Goods Sold (COGS)
-
Quantity
is
0
3. In the
Results
tab, select the fields you want to display in the search results. For example,
Document Number
,
Customer
,
Date
,
Amount
, etc. 4. Click
Save & Run
to execute the search. This will return all invoices that do not have a COGS account and did not affect the stock. Please note that this method assumes that the system error resulted in the
Quantity
field being set to
0
for these invoices. If the system error had a different effect, you may need to adjust the search criteria accordingly. ****** 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.805966198
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.782705
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.782169104
Please provide your feedback on this answer.