i need to count the number of transaction lines where the amount is the same

AI generated answer (using internal Slack threads):

To count the number of transaction lines where the amount is the same, you can create a saved search in NetSuite. Here are the steps: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the record type you want to search. For example, if you're looking at sales transactions, you might select 'Transaction'. 3. In the Criteria subtab, add the following filters: - Main Line = False (This ensures you're looking at line items, not the transaction as a whole) - Amount (Set this to the specific amount you're interested in) 4. In the Results subtab, add the following fields: - Internal ID (Summary Type: Count). This will count the number of lines that meet your criteria. This will give you a count of all transaction lines where the amount is the same. If you want to see this count per transaction, you can add 'Document Number' (Summary Type: Group) to the Results subtab. Please note that this is a general approach and might need to be adjusted based on your specific requirements and the data available in your NetSuite account. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

how do I make a numeric amount field to text so that I can group it