We’re using SuiteBilling in NetSuite. The issue is that we have multiple billing accounts for the same customer across different subsidiaries. The default billing account is set for one sub, but we need to import invoices via CSV using another billing account (not the preferred one). When we try, we get an “invalid entity reference” error. The only workaround is manually switching the default billing account each time before importing, which is too time-consuming.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're encountering an issue with the entity reference when trying to import invoices for a non-primary subsidiary via CSV in NetSuite. This could be due to the fact that the system is not recognizing the correct billing account for the respective subsidiary. One possible solution could be to explicitly specify the subsidiary in your CSV file. When you perform a CSV upload, you can include a column in the file that specifies which subsidiary the invoice is for. NetSuite should then automatically apply the appropriate billing account based on the subsidiary information provided in the upload file. Another potential issue could be with the customer reference you're using in your CSV file. Make sure you're using the correct reference (internal id, external id, or name) for the customer. If you're using the name, ensure it matches exactly with the name in NetSuite, including any special characters or spaces. If you're still encountering the "Invalid entity reference" error, you might want to try selecting a customer from the list in NetSuite (not using id or external id but default value) and see if that resolves the issue. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******