-
NetSuite Admin Tip | SuiteAnalytics Workbook to Identify Active Employees with Inactive Supervisor
In many organizations, the Supervisor field on the Employee record represents the reporting structure used for approvals, escalations, notifications, task ownership, and operational reporting. Over time, these reporting relationships can become outdated due to promotions, reorganizations, or employee terminations. One…
-
Add Time stamp to Standard Reports
Is there any way to add timestamp to the report's name or in its extract for Standard reports (Trials balance, income statement, etc…).
-
Analytics DataSets Link
I am not able to link the System Note's Record Id with the Track Time Internal Id field. Is that even possible?
-
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…
-
[Standard Costing] Can't find "Cost Accounting Status" Field in Analytic Workbook
Hi Gurus, I am trying to pull the "Cost Accounting Status" field in a Workbook type with "Item Location Configuration", but could not find this field. I noticed this field seems like only available in Saved Search under "Item" Search, is my understanding correct? Which means NetSuite Analytic Workbook at the moment cannot…
-
Celebrating a Major Milestone: Successful Migration to NS2 DB
Hi NetSuite Community, We are thrilled to announce that we have successfully completed a significant milestone in our migration journey from the NetSuite DB to NS2 DB! 🎉 This achievement marks a major step forward in modernizing our data infrastructure and optimizing our ERP and reporting capabilities. While there are…
-
Item Invoiced but not fulfilled
Hi, I would like to write a saved search or Analytic dataset (preferred) that would show items that are invoiced but not yet fulfilled. The issue is that I also need to remove those items against which invoices have been raised but a credit note has aleady been issued, nullyfying the invoices. And another puzzle are…
-
Does Suite Analytics dataset have the equivalent field as "Amortization: Destination Account"?
In the saved search, there is a field called "Amortization Schedule: Destination Account". I can't find it in the suite analytics dataset. I need to the field to get the expense account for those vendor bill line with prepaid account. Please advise. Thanks,
-
Does Suite Analytics dataset have "1099 eligible" or equivalent field?
In the saved search, there is a field called "Vendor: 1099 eligible". I can't find it in the suite analytics dataset. Please advise. Thanks,