My Stuff
Comments
-
I want to know about this too. I got the same email.
-
The answer is NO. you cannot control how each user shares their calendar. not even an administrator can do it. You will have to email all 80+ users, and tell them to share their calendar with their new/current manager.
-
zzz, still not able to control. netsuite calendar is a joke.
-
seems like a common issue without a good solution
-
yep that happened to me before
-
okay, now i definitely don't want to be using netsuite's auto-calculate safety stock level
-
I don't like your idea of having multiple unit type when they share the same base unit of measure. I would just set up. LB 1 unit (base) 5 LB Bag 5 units 10LB Bag 10 units 20LB Case 20 units i don't understand why you would create multiple unit type of the same units.
-
unit of measure on netsuite is really confusing. whenever there isn't a unit of measure, i always assume it's base unit. ive tried the report builder. when i change quantity to "sales uom", it still shows me the base unit. doesn't work for me.
-
Criteria Account = Sales Revenue Posting = True There is a function column next to summary type. Category Sum of Amount Sum of Amount (Function: % of Total) to sum specific date range Sum of Formula(Numeric) CASE WHEN to_char({trandate},'YYYY') = '2015' THEN {amount} ELSE 0 END) this will cover year 2015 Sum of…
-
are you talking about percentage of total or percentage increase between two periods.
-
look under your item inventory and see where your income gets posted. there are probably others way of doing this, but this is what i use. screenshot below. for % Chg. use max summary. SUM(2016 sales) / NULLIF( SUM(2015 sales), 0) - 1
-
you have LY vs YTD or do you want to compare LYTD vs YTD. LY + YTD / LY?? (This is what you have) this will also give an error if LY = 0. * to prevent an error use LY + YTD / nullif(LY,0) (LY + YTD) / nullif(LY,0) ?? or YTD / nullif(LY,0) - 1 ?? or YTD / nullif(LYTD,0) - 1 ?? I usually use this to compare YTD vs LYTD…
-
amount - transaction total is for main line. what is category? if this field is a body field, then you are okay. you just need main line = yes.
-
SUM(CASE WHEN to_char({trandate},'YYYY')=to_char(add_months({tod ay},-12),'YYYY') AND to_char({trandate},'MMDD')<=to_char(add_months({to day},-12),'MMDD') THEN {amount} ELSE null END) that's what i use. if anyone else has a better and shorter formula, please share with me :)
-
I use YTD Sales SUM(CASE WHEN to_char({trandate},'YYYY')=to_char({today},'YYYY') THEN {amount} ELSE null END) LYTD Sales SUM(CASE WHEN to_char({trandate},'YYYY')=to_char(add_months({tod ay},-12),'YYYY') AND to_char({trandate},'MMDD')<=to_char(add_months({to day},-12),'MMDD') THEN {amount} ELSE null END)
-
I wonder if decode is a faster execution or the same as using case when
-
I think this might work. to_char(LAST_DAY( ADD_MONTHS({today},-1)),'MM/YYYY')
-
btw, using 'set when ordered by' works. thanks netsuite community
-
using max doesn't give a max amount on KPI scorecoard. it just does a count.
-
When I do summary type Min or Max, on the KPI it will do a count. It will not give the results.
-
aww, thanks for the help. it still didn't work. the total amount still shows everything.
-
i dont know. what do you mean set when ordered by? is that a sql formula?
-
quick search 77030, or 7703 or 770 is there something else like "is but if not near" 77030
-
i like how my search looks |2013YTD_____________|2012YTD_____________| |________________1000|_________________2000| it's annoying that it's not aligned.
-
same problem. searchresults.csv i would create a script to rename the file, but my saved search has a lot of formulas. it's not just a simple pulling of a field. it would be too much headache to do
-
not possible to group by without using summary type
-
im also trying to do a search for budget by period/month doesn't seem like you can...
-
no one answers because no ones knows. it's a mystery to me too
-
i cannot customize this part. those columns are still there even when i disable and check preferred form.
-
for example, i go into new opportunities, communications, notes. it still shows the columns i hide on the form.