JB
09/18/2025, 10:31 PMCeligo AI
09/18/2025, 10:31 PMAI generated answer (using internal Slack threads):To create a saved search to know if a cash refund or cash sale has been deposited, you can follow these steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select Transaction from the list. 3. In the Criteria subtab, set the following filters: - Type = Cash Sale or Cash Refund - Main Line = True - Status = Deposited 4. In the Results subtab, you can select the columns you want to display in your search results. For example, you might want to include 'Name', 'Status', 'Amount', 'Date', etc. 5. Save the search. This will give you a list of all cash sales and cash refunds that have been deposited. In SuiteScript, you can create a similar search using the following code:
javascript
var cashsaleSearchObj = search.create({
type: "transaction",
filters:
[
["type","anyof","CashSale","CashRfnd"],
"AND",
["mainline","is","T"],
"AND",
["status","anyof","Deposited"]
],
columns:
[
search.createColumn({name: "name"}),
search.createColumn({name: "status"}),
search.createColumn({name: "amount"}),
search.createColumn({name: "date"})
]
});
Please note that the 'status' field value might vary based on your account setup, so you might need to adjust it 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.
******Celigo AI
09/18/2025, 10:31 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840515137
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.827026367
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826416
Celigo AI
09/18/2025, 10:31 PM