I believe I am encountering the same issue as well. Were you able to uncover the issue or is there a defect or enhancement number for this? thanks in advance for the info. I'll submit a case as well and update this string if I get the information first.

I actually found a fix for this on SuiteAnswers last year. It's article 31964 if you'd rather just save the link. But here's the fix. Assuming you have your personal preferences to max out values in a list, you should be able to update 1000 searches fairly quickly using this approach Follow the steps below using Google…

Sorry to revive an old thread, but I just killed most of my afternoon trying to track down the impact of a report permissions issue that I just discovered was due to last night's secret update. This is only the most recent of several major issues in our implementation that miraculously started to occur on Friday mornings,…

Quick check on an old thread - is it still the case per Evan's comment on 12-19-2011, 11:09 AM that date and time in email templates coming from a join to custom date or time of day fields on another record will display as text (ie YYYY-MM-DD HH:MM:SS) in the merged emails? And is the fix still to have a custom field that…

Hi all - hopefully someone either knows how to do this or can tell me definitively that it can't be done and why. I need to build a saved search on time entries that provides, in a single grouped results column, either a summed result for the duration of grouped time entries OR a static value of 80. When I attempt to add…

Just to follow up on this, I've just realised that this is actually a defect that I'd seen before (171746) The week ALWAYS starts on which ever day is 1st Jan - so this year it's always a Sunday! It's an S3 defect, so not expecting it fixed anytime soon. Mark - Just to make sure I'm reading this right, does that mean that…

Hi Delten. I've been seeing this today as well (I am also in Canada). Sandbox in particular seems to be running very slow - 30-45 seconds just to load the homepage. Anyone else?

Best approach here from my experience is to create specific folders, restrict them by employee groups based on criteria (see this SuiteAnswers article for options - https://netsuite.custhelp.com/app/answers/detail/a_id/8926/kw/file%20cabinet%20folder%20restriction) and then train users to only upload their sensitive…

Alternatively, you can set the Constraint Type on the task to 'Fixed Start' rather than 'As Soon As Possible' and then set the Start Date with the expected date of achieving the Milestone. Since the task will have no hours, End Date will equal Start Date.

So it seems the only option here that allows me to keep all of my other requirements (Consolidate Projects on Sales Orders, Billing Schedule by line, using Revenue Commitments) is to split my sales orders so that my T&M Project is on its own transaction that doesn't generate a revenue commitment. Anyone ever seen anything…

Okay update following review with NS support. If your requirements include projects set at the line level of the Sales Order (Consolidate Projects setting), AND line-level billing schedules, then you will have a 'Bill Sales Order' page that includes orders that do not need to be billed. This apparently cannot be avoided -…

Hi Jamie. I can verify that this is how the calculation natively works. The only time excluded is time on Projects marked as 'Exempt'. The assumption made here is that if your time is against a project marked as either utilized or productive, you were working. The only difference is whether that time was billable to a…

For the benefit of anyone else who runs into this, the solution is to ensure that Project Consolidation is turned on, which allows multiple projects to be linked to the Sales Order at the line level. By setting up multiple projects with the billing item on each project set to the appropriate item to align with the desired…

Has anyone ever found a way to limit the list of Projects available for linkage to transactions so that you can't select a Project that is ALREADY linked to a Sales Order? It seems odd to me that Projects that are already being billed on one SO can be added to another one...anyone ever seen this?

As far as I know this is still not possible. The approach I've recommended for clients in the past is to not actually use the individual employee's labor cost, but rather a blended rate by role. Typically it's not a problem for folks to know that a Jr resource is roughly $50/hr and a Sr resource is roughly $75/hr. It's…

I can see it in the selectable fields in a Set Field Value action on Customers....is the field exposed on your preferred form?

Hi Amanda. I built something similar for another client - I believe what you're missing is a condition on your WF state that Custom Form != Ops Sales Order (ie - WF action is not needed because it's already on the right form) Without this, you're stuck in a logical loop that never ends. Page loads -> WF changes Custom Form…

I may be misunderstanding but I suspect the issue is that you are attempting to access a sublist (Project Task Assignment) with a workflow, which is not supported. If you need to auto-assign project tasks you would need to look into a scripted solution as Workflow will only allow you to set values on the actual record, not…

Thanks Daniel, so just to be 100% clear, once an account has been officially moved to 2014.1, both production and any linked sandbox accounts will be able to use SuiteFlow on TimeSheet and the Time Entry subrecord? Can you give any guidance on when release documentation will be updated to include the specific actions that…

Thanks Daniel, this is really helpful. One last question if you're able to indulge me. Can I assume that SuiteFlow-based routing of Time approval will behave similarly to Expense reports in accounts where the preference for Expense Approval Routing is activated? ie a 'Next Approver' field is available and can be set via…

Hi Daniel. Can you please clarify your response re: Time Entry records and Suiteflow? From my review of the beta, TimeSheet is exposed but the sub record Time Entry is not, either as a unique record type for Suiteflow or as a join via a WF on TimeSheet. Am I missing something? Pls advise. Thanks!

Sorry, spoke too soon. It's not working...I'm assuming that I am adding this formula, verbatim, to the formula field within the Parameter Value of my Set Field Value action so I end up with an action parameter of: Date PO # Expected={today}+decode(to_number(to_char({today},'D')),1,2,2,2,3,2,4,2,5,4,6,4,7,3) Is that correct…

Thanks Evan! worked perfectly. P

Just to close this off for anybody who runs into this same issue, the problem was that I was using a SQL formula in a client side trigger on the workflow. SQL apparently only works on Server side triggers and you need to write formulae in Javascript for Client side. By changing the action to a server side trigger (before…

Hi Evan. While I'm sure that would work, I was surprised that there was not a way to access a list of Project records in the field mapping on a 'Create Record' action for Project Tasks, considering that it's a mandatory field for the Project Task record. I agree that most of the time you would only be using WF on a Project…

Has a defect or enhancement ever been logged for this issue? I was attempting to create Project records via workflow but not from the Project record (long story) and was unable to complete it as I had no link to the Project Name. Anyone have any additional information on this? Thanks!