T
03/28/2025, 10:47 AMCeligo AI
03/28/2025, 10:47 AMAI generated answer (using internal Slack threads):To get the Cost of Goods Sold (COGS) amount in a saved search, you can use the 'Expense/COGS' field. This field should be available in the results section when you are setting up your saved search. However, if you are trying to get the COGS for a specific item or a kit, you might need to use a formula to sum up the COGS of the components. You can use the 'COGS line' filter in your search to get the COGS from a transaction or from all transactions including a specific item. If you want to include the GL number and not just the text, you might need to create custom fields on the item record to store this information. You can populate these fields via item import, scripting, or mass update. Once these fields are set up, you can include them in your saved search. Please note that currently, displaying the account number with the account name in an Item Saved Search is not available and is under enhancement request. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
03/28/2025, 10:47 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815599263
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.810024738
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.809218526
Celigo AI
03/28/2025, 10:47 AM