how to extract data of customer payment amount excluding vat to display in report

AI generated answer (using internal Slack threads):

To extract data of customer payment amount excluding VAT to display in a report, you can create a custom field and use a formula to calculate the amount paid excluding VAT. Here's how you can do it: 1. Navigate to the Customization > Lists, Records, & Fields > Record Fields. 2. Click on 'New' to create a new custom field. 3. Set the label as 'Amount Paid Excluding VAT'. 4. Set the type as 'Currency'. 5. In the 'Formula' field, enter the formula to calculate the amount paid excluding VAT. The formula could be something like

{amountpaid} - ({amountpaid} * {taxrate})

. This formula assumes that the

amountpaid

field contains the total amount paid including VAT and

taxrate

is the VAT rate. 6. Save the custom field. Now, you can use this custom field in your reports to display the amount paid excluding VAT. Please note that the formula used in the custom field might need to be adjusted based on your specific requirements and the actual field names in your NetSuite instance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******