how do I report Due To/Due From Subsidiary on Advanced Intercompany Journals?

AI generated answer (using internal Slack threads):

To report Due To/Due From Subsidiary on Advanced Intercompany Journals, you can create a custom field to capture this information and then use it in your reports. Unfortunately, the Due To/From Subsidiary field is not directly exposed in NetSuite's search, reporting, or Analytics Workbooks. Here's a step-by-step guide on how you can achieve this: 1. Create a custom field that will hold the Due To/From Subsidiary information. This can be done by navigating to Customization > Lists, Records, & Fields > Transaction Body Fields > New. 2. Configure the custom field to your needs, ensuring it is set to store text and is available on Journal Entry records. 3. Create a User Event script that triggers on beforeSubmit of the Journal Entry record. This script should copy the value from the Due To/From Subsidiary field into your custom field. 4. Deploy the script to your Journal Entry records. 5. Now, when you create an Advanced Intercompany Journal, the Due To/From Subsidiary information will be copied into your custom field and can be used in your reports. Please note that this solution requires some knowledge of SuiteScript and NetSuite customization. If you're not comfortable with scripting, you might need to seek help from someone who is. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******