Why can't I select my new Statistical Account in C...
# ask-stanley-ai
a
Why can't I select my new Statistical Account in CSV imports for a Vendor Bill's Expense : Account sublist field mapping's default value? The Account field is mappable in the CSV Import setup, but the new Account is not among the many that can be selected for the mapping's default value. I am able to select it when I am manually creating a Vendor Bill. How come I can't select this account for an Expense, in the default value dropdown for the Expense : Account field mapping in the CSV Import setup? THE ACCOUNT FIELD is mappable. The Account field is fine. The new account is not selectable for the default value, though. Why is that? Don't tell me anything about fields being available. The field itself is not the problem, the value to be selected is what's not available. Is it because it's a statistical account? The statistical account is NOT A field! It's a field value option for the Account field. Why is it being filtered out? This is NOT about fields being accessible or available. It's about field VALUES.
c
AI generated answer (using internal Slack threads):
The issue you're experiencing is likely due to the nature of Statistical Accounts in NetSuite. Statistical Accounts are a special type of account used to track non-monetary data. They are not designed to hold financial data and therefore, they are not available for selection in financial transactions, including CSV imports for Vendor Bill's Expense. When you're manually creating a Vendor Bill, you're able to select the Statistical Account because the system allows you to do so in the user interface. However, when you're setting up a CSV import, the system is more strict and only allows you to select accounts that are valid for financial transactions. This is not a limitation of the CSV import feature, but rather a design decision by NetSuite to ensure data integrity. If you need to import data into a Statistical Account, you may need to consider a different approach, such as using a SuiteScript or SuiteTalk API. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.816955566
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.81414783
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.813537717
Please provide your feedback on this answer.