My Stuff
Share Your SuiteWorld Experience & Earn a Special Badge!
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
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