-
Formula for excluding non-summary inactive COA
We usually use datasets instead of saved searches for COA export as several fields like ‘Eliminate Intercompany transactions’ and ‘Reconcile bank statements’ options are not available in Saved Searches. While preparing the dataset, we cannot directly put the criteria as exclude inactive as the inactive accounts include…
-
How to limit access to dataset shared by system in Analytics
Gurus, We noticed that some datasets with System as the owner is shared across different roles. Below is the screenshot from Warehouse Manager role as example: How can I ensure the system default datasets are only shared to the appropriate roles? Thanks,
-
Help Finding Vendor Prepayment Object in SuiteAnalytics (netsuite2.com)
Hi, In SuiteAnalytics on NetSuite.com, the Vendor Prepayment object used to be available under the Transaction table, and I was able to report on it without any issues. However, after switching to netsuite2.com, I’m no longer able to locate this object or any associated fields in the new data source. I've searched through…
-
NSC | Run Intercompany Elimination: The account XX is an inactive account. Please correct the...
SCENARIO: User is tasked with running intercompany eliminations in their OneWorld instance. During the process, they encounter an error message stating, "The account (xx) is an inactive account. Please correct the import file and resubmit." User wants to to identify and update the inactive accounts in their import file to…
-
NSAW|Custom Datasets not available to users other than creator
Has anyone else struggled with this issue? I have created custom datasets in NSAW to integrate custom record tables into the data warehouse. However, other users don't see these datasets. They only see the out-of-the-box ones.
-
NSC | Elimination > Error: Transaction and foreign currency account use different currencies.
SCENARIO: User is responsible for executing an intercompany elimination process in their NetSuite instance. During this process, they encounter an error message stating, "Transaction and foreign currency account use different currencies." User needs to check the currency and transactions in question so that they can change…
-
NSC | How to Create a Dataset for Elimination Accounts with Associated Currencies?
SCENARIO: User is tasked with creating a dataset for elimination accounts that includes the currencies associated with them in their NetSuite instance. When a currency is added to an account record, certain restrictions are placed on its use, and it may not be available for elimination journals or subsidiaries. By creating…
-
NSC | How to Create a Dataset for Inactive Elimination Accounts
SCENARIO: User is tasked with creating a dataset for inactive elimination accounts in their NetSuite instance. The challenge is that these accounts do not have a unique identifier specifically for elimination accounts, making it difficult to distinguish them from other accounts. User tried to create an Account Saved Search…
-
How to show transaction Class header in a Workbook?
I'm trying to get a dataset of all transactions by class. We are selecting class by transaction body but the analytics datasets only seem to make class available on the transactions lines. In order to link it to another table, I'd like to have a list of transactions(Headers) by class. If I could group the transaction lines…
-
NetSuite Production Suite Analytics Changes for Audit Trail for Controls
Our auditors are asking us for Audit Trail reporting (to see any changes made to WB's and DS's) on a monthly basis. I have reviewed the documentation and created the resulting WB's and DS's. The result on the DS side only shows changes to the audience. (tested by adding columns, removing columns, adding and removing…