i have created custom approval status in invoice but when the approval status filed the pending the status reference is still open i want to change it to be pending based on my custom approval field

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can create a custom approval status for your invoices using custom fields and workflows. Here's a general approach: 1. Create a custom field in the invoice header called "Custom Approval Status". This field can have a drop-down list with values such as "Pending Approval", "Rejected", and "Approved". 2. Configure a workflow that changes the value of this custom field based on your business rules. For example, when an invoice is first created, the workflow can set the "Custom Approval Status" to "Pending Approval". 3. When the invoice is approved or rejected, the workflow can update the "Custom Approval Status" accordingly. Please note that this custom field will not prevent the invoice from having an impact on the general ledger. It is merely an indicator of the approval status of the invoice. Also, it's important to note that once an invoice has been approved, it is not possible to change the approval status back to "Pending Approval" natively in NetSuite. You might be able to script around this limitation, but it would require additional development work. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******