Building transaction line custom fields on NetSuite ERP to be transferred to NetSuite Analytics Warehouse, but it's not showing on NSAW.

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Based on the conversations, it seems that the issue of the custom transaction line field not showing in NetSuite Analytics Warehouse (NSAW) could be due to a few reasons. Firstly, it's important to note that NSAW is typically used for migrating detailed transactional data, but it might not be the best tool for handling custom fields. One of the users suggested using custom records for data migration instead of actual transaction records, as it requires less work and has fewer failure points. However, if you still want to use NSAW, you need to ensure that all related data (item/product data, customer data, vendor data, etc.) matches the corresponding NetSuite records. Also, you need to create accounting periods for all historical transactions to land in, and these periods should be reconciled and closed. As for the custom transaction line field not appearing in the Revenue Recognition JE, it could be due to the Rev Rec JE being detailed. It's suggested to check if the field is showing in the JE form and if there's any value in the field that is not pulled through. If you've checked all these points and the issue persists, it might be a more complex problem that requires a deeper look into your NetSuite setup.