mchen_26125 Blue Ribbon

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.