My Stuff
Uncover the power of data with the Analytics Hub —your ultimate guide to mastering NetSuite Saved Searches and Reports. Simplify the complex and unlock your organization's true potential. Dive into the Analytics Hub now and soar to new heights!
Hello Community! Josh Maxwell, a User Experience Researcher for NetSuite Foundation has fun a question for you. Imagine for a moment that NetSuite had an assistant like Alexa or Siri. What would you ask of your NetSuite assistant? Use this survey link to share your top questions to the assistant.
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Here are some examples to get your creative juices flowing.
"Did I pay vendor John Doe last month?"
"Take me to my largest sales order for this month."
"What invoices haven't been paid yet?"
Comments
-
when you look at assembly detail - it put first line into inventory for the item in question and all the other lines are the item used… Basically i want my formular to return TCT12IC08 on all lines…
-
No. It is an acquisition. Our new owners have legally changed our fiscal year end to be Dec 31st. All our subsidiaries did have a year end of Sept 30th We were acquired on May 15th 24. So our year end is now May 15th 24 and we need a "Stub" year end from May 16th 24 to Dec 31st 2024. My reading says we have to move all…
-
accounting period for various transactions Company acquired on may 16th 24 So need a calendar year being may 16th to dec 31st 24 Former year end was sept 30th So ready to move transactions so we can modify. But it would seem fix reveals on payment postings can’t be modified by script or mass updates. So asking if that is…
-
sp. are!!
-
you ate brilliant. There should be a suite answers on this. It is a classic example of what users would want to do!!
-
Aqesome dialogue and most appreciated. It would good to see an enhancement for markup on customer billing. I really suspect it is another module. Just trying to work what that is . Fun continues..
-
Will have to look in to We never charge time. We have a vendor bill in sub b that we tag belonging to sub a. I want to bill it to sub a which I can use the billable tag..but how do I do a markup on billable expenses?? Is this a new module like suite billing or something. I just don't see this . I thought you said an…
-
Yes it is but Sub B marks up the cost to charge to Sub A and does milestone billing. I just want the markup to eliminate and the actual cost detail to go over to Sub A books so they know what was bought on their behalf.
-
Let me think… Sub A issues po to Sub b Sub B issues sales order to Sub A Sub B issues PO to external vendors - these costs are in direct relation to the sales order issued to sister company - we need to track these costs to know profit margin… This is all services driven. Ideally we want the actual costs charged to the sub…
-
So what are the workarounds??? What do others do with this system limitation??
-
Also what about inventory reports - want users to have access but NOT be able to see any costing information - is this also an enhancement?
-
Man never ending enhancement list! Thanks for the answer
-
This formular works for customer deposits… max({amount})-abs(sum((CASE WHEN {applyingtransaction.trandate} BETWEEN to_date('01/01/2016', 'MM/DD/YYYY') AND to_date('12/31/2023', 'MM/DD/YYYY') THEN {applyingtransaction.amount} ELSE 0 END))) Then i thought i need to consider applied to info so tried this as i am dealing with…
-
exactly - thanks.
-
To be clear Is just in the header of the sales order. I just want more custom body fields that contains the dollar value of all items on the sales order - based on unit cost on the inventory record, and NOT average cost. I can not use GM analysis as CMSS, Shephard solution is providing other costs associated with the sales…
-
Why is everything an enhancement!!! So sad.
-
Sorry - just looked at this. Yes exactly that. i have a sales order - and i want to know gross margin at the header section of the sales order. That is why i need a sum of the line item costs. I want the gross margin to be based on purchase price of the items listed in the sales order and not on average cost.
-
i have a bunch of open vendor bills and credits that are cancelled out by journals - i do not want to use the user interface to match them all as it will take too long. Therefore i am planning to do it via script. Currently my plan is a NIL bill payment and that seems to be working.
-
Any thoughts on this??? Gentle followup!
-
Also what about being able to set the cleared flag via a script and datecleared??? Is that possible - any known workarounds?
-
Most tragic and appreciate your time in looking into this. It is weird that given both are financial reports - that they have inconsistent outputs. All reports under financials should be done the same method! Thanks
-
thanks for your detailed response. The challenge i have is if we run revenue by item - it agrees to the consolidated income statement irrespective of the months I put in the filter. and the subsidiary context. However when i run cash sales by item - it moves around within the months So for this report - no changes But for…
-
Do you have foreign currency involved in your demo account? It is a standard report. Accounting periods and not dates - not that it should matter.
-
Revenue by Customer Revenue by customer is working but sales by item is not consistent within the months itself..
-
Sorry i was away... and yes still need further assistance We are NOT cash based. It is the idea that when running a detailed sales report - the report called - Sales by Item Summary - so this is NOT a balance sheet or income statement report - but on a consolidated basis - the exchange rate used is dependant on the start…
-
Well done - I just stumbled on to this as well! Most appreciated.
-
If i run the report for the periods Jan 23 to Feb 23 and show monthly numbers, and then run the say report from Jan 23 to March 23, and show monthly numbers. The total number for sales i have for Jan 23 changes between reports. It is a cash sales report. It seems to be using a different exchange rate.
-
and in case anyone else is looking - it cant be done on a workflow. Has to be a scripted solution!
-
yes i am referring to this functionality.
-
It is insane and really sad!