formula to show the cash sales that multiple return authorization for the same item

AI generated answer (using internal Slack threads):

To show the cash sales that have multiple return authorizations for the same item, you would need to create a saved search in NetSuite. Here's a general idea of how you could set up the search: 1. Go to

Reports > New Search > Transaction

. 2. Set the

Type

to

Cash Sale

. 3. On the

Criteria

tab, add a new filter for

Main Line

and set it to

F

. This will exclude the main line of the transaction and only show the item lines. 4. Add another filter for

Item

, and select the specific item you're interested in. 5. On the

Results

tab, add the columns you want to display. For example, you might want to include

Document Number

,

Date

,

Customer

,

Item

,

Quantity

, and

Amount

. 6. To show only cash sales that have multiple return authorizations, you would need to add a formula field to the

Criteria

tab. This formula would need to count the number of return authorizations for each cash sale, and only include the cash sales where this count is greater than 1. Unfortunately, without knowing the exact structure of your data, I can't provide a specific formula for this. However, it would likely involve using the

COUNT

function and a subquery to the

Transaction

table. Please note that this is a general guide and may need to be adjusted based on your specific requirements and the structure of your data in NetSuite. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******