My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Comments
-
Thanks Patrick, Think I have been looking at all of this so long my eyes do see half of what they should
-
Thanks @Patrick Fresnosa-Oracle I got some great one-on-one from the PS team yesterday as well. I built the Margin calculation into the dataset as well. How do I format a Workbox Calculation to present as a % (Margin/Income)*100 doesn't pass muster as it doesn't like *100
-
Hi @Patrick Fresnosa-Oracle Yes - I could calculate the margin in the dataset when I get some help with the SQL. Will see if one of our developers can spare a little time
-
So, calculate the Gross Margin in the dataset? Possibly a challenge for my SQL but I will have a try
-
Hi I have made progress, but here is the next challenge. I want to add two columns - Income - Cost of Sales to be labelled margin, and the other to be Margin/income as %. Simply totalling the row gives me the correct answer but no labelling option. Calculated measures don't work. Do I need to build this into the dataset?…
-
Quick Question - is that a subsidiary setting or purely company - I have one client with a mix of calendars
-
@Patrick Fresnosa-Oracle thanks - two workbooks is fine. My emerging challenge is fiscal years - Australia uses July/June which makes using dates difficult. How do I factor 'Last Fiscal Year', Last Fiscal Year to Date, This Fiscal Year into work books? Should I be doing it in the dataset? Other issue is the reversing of…
-
Hi can I also add reversing signs - Income to show positive and COGS/Expenses negative
-
Thanks for responding It was in the SuiteAnalytics reporting section. Support has advised such functionality is not available. Ross