Hi @IvanChow Try using PeriodRolling(Sales, -365, 0) if your date grain is daily. If you have monthly, try AGO(Sales, "Date", 1) with a YTD filter. Note. Ago functions work right only with fields from date hierarchy.

Hi @Judith Culanding-Oracle Thank you for your response. To view security panel related activities, Could you please confirm if there’s a specific feature that needs to be enabled to view data in the Security Audit History? For some reason, there’s no data appearing in Security Audit History subject area in one of our…

Hi User_IJB6M To Share reports with other business users, you need to move the reports to the Shared Folder and you need to assign permissions to the shared folders that you create. Here's the help link Create catalog folder Share catalog folder Thanks!

Hi @Adrianne A. I noticed that the Opportunity Transaction Type Code is still showing as "Opprtnty" instead of "opprtnty" (with a lowercase "o"). As mentioned earlier, the transaction type is case-sensitive. You can raise an Oracle support case directly from your NetSuite instance by navigating to: Support > Account Center.

@Adrianne A. and Alex Joves -Oracle The issue seems to be related to the value of transaction type. On the NetSuite link, the transaction type for Opportunity is shortened. Please update your column values for the transaction type to display "opprtnty" instead of "Opportunity" (note the spelling). This should resolve the…

@Adrianne A. Could you also share a screenshot of the data actions ?

@Adrianne A! The one prerequisite would be you have to be logged on to NetSuite for the navigation to work. Please ensure to logon to netsuite before you click on the navigation from OAC

@Adrianne A. This could happen when you are not able to resolve the column. Just reselect the column at both places and pick the relevant columns. For eg. First column will be the opportunity transaction type and next will be opportunity internal identifier and validate the syntax

Hi, Something like this worked for me. Please keep in mind the transaction type is case sensitive in the netsuite link https://4546180.app.netsuite.com/app/accounting/transactions/${valuesForColumn:"NetSuite - Opportunity"."Transaction Attributes"."Opportunity Transaction Type Code"}.nl?id=${valuesForColumn:"NetSuite -…

Hi Berndt, Thanks for sharing the detailed screenshots. It seems I've followed all the steps correctly, but the Account Analysis didnt get listed under subject areas until i redeployed. Now i see the Account analysis subject area. Thank you for all your help!

Hi, Thank you for the input. Good news is Account analysis subject area is made available under enable features and the steps until deployment is complete. However i dont see the subject area when i click on create report. What step am missing here ?

Thanks Gaurav. Can admins still log in to NSAW if SSO fails. Any documentations on setups ?

Regarding your first question, Custom Fields in NetSuite that have "Store Value" unchecked generally cannot be mapped directly to NSAW because they do not store data at the record level. These fields are typically formula-based or dynamically calculated and don't hold static values that can be exported or mapped to an…

Thank you very much for the detailed steps.

This is great news! Could you guide on how you raised a case ? for somereason when we raise a case, the case gets automatically closed with no updates.

User_569R9 I have raised a support case from my end for the same, will keep this thread updated upon answers. Hoping to get a resolution soon.

Thank you, Yes, Sales functional area is activted and i am on 24.R2.P2 I will try and log a ticket. Thank you!

Thank you, but i dont see it availale

Hi, Thanks for the above. I am referring to the Whats new table under the same link ( Link: https://analyticspmce-analyticspm.cec.ocp.oraclecloud.com/site/OADemos/whats-new.html The link Demo instances tab, takes me to a login page and am interested in the July 2024 updates