how to create an inventory activity detail report ...
# ask-stanley-ai
n
how to create an inventory activity detail report for special order items only
c
AI generated answer (using internal Slack threads):
To create an inventory activity detail report for special order items only, you can follow these steps: 1. Navigate to Reports > Inventory/Items > Inventory Activity Detail. 2. Click on the "Customize" button to modify the report according to your needs. 3. In the "Filters" tab, set the following filters: - Posting is True - Tax Line is False - Shipping Line is False - Item Type is Inventory - Account is Inventory - Order Status is "Pending Approval" (or the status you use for special orders) 4. In the "Columns" tab, select the columns you want to display in your report. For example, you might want to include Item, Quantity, and Transaction Date. 5. Click on the "Save" button to save your customized report. Please note that the Inventory Activity Detail report shows all the transactions that affect your inventory. If you want to see the transactions that will equal to the inventory valuation report as of a specific date, you might need to use a saved search instead. To create a saved search: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select "Transaction" as the record type. 3. In the "Criteria" tab, set the following criteria: - Type is Sales Order - Status is "Pending Approval" (or the status you use for special orders) - Main Line is False 4. In the "Results" tab, select the columns you want to display in your search. You might need to use the "Group" summary type to group the results by item. 5. Click on the "Save & Run" button to save and run your search. Remember, you can always modify these steps according to your specific needs. ****** 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.815958
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8138237
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.81248945
Please provide your feedback on this answer.