User_569R9 Red Ribbon

That is brilliant- happy to help Hope you can now create the workbooks you need

Hello I have tired several time to get my username changed - I do not want to be 'User_569R9' - my name is Berndt Anyway - firstly it seems you did log a ticket with NetSuite to be given access to the Account Analysis area. Navigate to Enable Features Scroll down. Do you see Custom Data Configuration→Netsuite Account…

Feedback on using the Account Analysis area I used the Account Analysis area to create a report finding detail for information in Revenue accounts I was able to run a report without having to know up-front what transaction type it was It gave me the data and worked a bit like creating a report from the 'Transaction' table…

Hello Sorry to hear that - not sure how and where you raised the case. The method I used that worked was through NetSuite Are you an authorized NetSuite Support contact? if not, you will have to be set-up or find out who is Assign yourself the role of NetSuite Support Centre Log out and log back in Navigate to…

Hello Good news, after logging a ticket, the Account Analysis subject area was activated I can see ‘ NetSuite Account Analysis in the ‘Enable Features’ area After enabling it, I could then see ‘Custom Data Configuration’ in the Data Configuration area Click on Create – top right corner Select Columns. DO NOT tick the…

Hello Veronica Thanx for your reply - unfortunately your link is not accessible - it simply shows 'Unauthorized'

Hello user10090865 Any news on how to activate Account Analysis subject area yet? I have blown away all that was there. then activated Purchases and Payables activated Sales Enabled Procure to Pay enabled Order to Cash Ran Reset & Reload The Account Analysis has not appeared John, what step is missing?

Hello Yes, I agree Feedback I can give I activated Sales, Order to cash and Procure to Pay in the Data Configuraiton→NetSuite Warehouse sections I enabled 'Order to Cash and Procure to Pay Functional areas in the Enable Features section Pipeline status is active and has been running for a while I did a full reset and…

Hello I am experiencing the same. issue, also on 24.R2.P2 As per documentation, one should enable the 'Sales' functional area. I have enabled both functional areas available to me, there is no 'Sales' available, only 'Order to cash' and 'Procure to pay' I can see it has been activated in the activity tab. How does one even…

Thanx

Hello Pamela Please point me to where I can see the time and timezone this takes place

Thanx Slobodan

Thanx Elychelle - will keep this in mind Sound like the recommended approach is Use NSAW subject areas as is (create data sets, data flows as necessary) Use data augmentation, CAM, Semantic model extension for missing columns/data Last resort is use custom SQL via the Netsuite2 connection to create a data-set

Thanx Slobodan I have tried this out and it worked - I was able to create a data set using SQL juts as you showed here This is going to open up doors!! Thanx so much for your help

Thanx John- I am going to give this a go Slobodan - you refer to a NetSuite2.com connection. Is that the NetSuite Analytics connection? that one sets up under Data→Connections? This allows one to connect to NetSuite Analytics, but I do not see any option to issue SQL directly at NetSuite… Please can you send more info on…

Hello Elychelle Thanx for your reply. Please can you elaborate on what 'OAC NS2' is In the meantime I have found quite a few helpful things Project is called Job in NetSuite - there is a Job dimension in several subject areas e.g. Sales Orders and Item fulfilment 2. In several subject areas that do impact projects the Job…

Hello Slobodan It would be brilliant to understand how you would approach this using a custom SQL query do you run the query from the ADW tables? Is it one or more than 1 query Does this query then create a fact table How does one bring in the dimension tables e.g. Account, Department?

Thanx- that sounds interesting- I have not done that yet. Any tips?

Sure Standard subject areas are not ideal - containing columns and even folders that are either misleading or not clear enough e.g. Job is actually project - nobody knows it as job and will not look for job- if one can rename it to Project, it will massively increase useability Same if one can simply order columns…

Further to this - the main objective is to be able to create reports/visualisations for Projects in NSAW. By default NSAW does not have much around this . Projects could have several transaction types e.g. Invoice, Vendor Bill and Journal Customer Invoice subject area contains a 'Job' dimension that has probably 70% of…

OK - after testing a few things the issue turned out to be the username As we support several NetSuite customer we create an admin username e.g. "netsuitelogin+ABC@ourcompany.com " this way we can then have one email account but several users across many companies. Data Augmentation does NOT like ' +' - I created another…

Hello john Thanx for your patience on this. Is your suggestion only available the first time or should it be available on edit as well? When one clicks on the level, the pencil icon appears in the furthest right columns. One can select a different Primary Key or Display Attribute. At no point does the Ragged tick box…

I have been testing this out as I could think users would love the ability to drill down on account hierarchies e.g. P&L→Gross Profit→Revenue→Parent Account→Account I have managed to create part of it (green highlight) . I still need to get go-ahead from the client to create a custom fields on the account record in…

Thanx for all your help John, feels like I am making progress. NSAW could be great - it just needs a bit more activity and clarifying

Thanx

Thanx John I have made good progress and was able add Customer category . Added screen dumps for the benefit of others I added Category and Company- one can now drill from Category to Company in reports The lowest level is Customer ID, which is there by default It is not really meaningful, but I could not find another way…

Awesome- thanx John

Hello No sure what to respond to this? OK - thanx all good

Thank you so much Sydney I had a go at what you suggested and can share that it is working 100% Thought I would share this with the community- it could help someone Link in Data Action on NSAW is https://844601.app.netsuite.com/app/accounting/transactions/${keyValuesForColumn:"NetSuite - Customer Invoice"."Transaction…

Thanx So much - this worked 100% Please add this to documentation somewhere - that after accessing as Admin, one needs to resets the OAX_USER's password and then access as OAX_USER when one wants to see synonyms and values in tables