3952835 Newbie

and one thing I've found helpful is finding a champion in each department. This times a billion. Our execs don't really have a solid grasp on the potential for NS, so I usually find myself targeting a younger person in a department (with some clout) to engage in projects that I know will be significantly beneficial. I wish…

Inventory Valuation - Customize - Add additional Quantity on Hand columns for each additional month. On each column, set the Alternate Date Range to be relative to today's date, then pick custom, then the last day of each month per column. Does that get you what you were looking for?

Thanks Jenny - the problem was that I was doing an employee search. This info is actually a customer based search. Durrrrr.

One last bump - has anyone been able to work this one out? I hit a dead end.

In order to display sales for a specific previous week, I use this formula. decode(concat(to_char({trandate},'IW'), to_char({trandate},'IY')), concat(to_char({today},'IW')-4, to_char({today},'IY')), {netamount}, 0) This uses week numbers, in order to avoid having to determine the start of the week etc (thus avoiding issues…

OK - I'm officially going cross eyed, but I believe I'm on the right track. I changed over to case statements because I'm more familiar with those (might be a problem here, not sure), and I'm also grouping by month. The code below returns invalid expression, but once I figure out where the problem is I think this would…

I'm having a problem with this and hoping someone can help clarify - I don't see how it can roll through years? Below is an adaptation of the original post in this thread... decode(concat(to_char({shipdate},'IW'), to_char({shipdate},'IY')), concat(to_char({today},'IW')+12, to_char({today},'IY')), {quantity}, 0) If the ship…

Click on the help link in the top right of your NS screen, search for "SQL Expressions". It's the first result.

We typically ship everything same day, so this isn't a big problem for us, but if a shipment is being worked on across multiple days, the warehouse just changes the date of the item fulfillment. For us - this was done mainly to ensure our inventory was being decremented at the right time for accounting reasons, especially…

I think it probably ties into a setting you have in "Setup - Accounting - Accounting Preferences" on the General Tab in the Accounts Receivable section. Not sure why that would pop up from the item fulfillment though.

Happening to us as well, but intermittently. Logged a support case to it.

"What you are experiencing right now is related to an on-going issue right now particularly Defect 229584 - Calculate Shipping Cost using UPS Shipping Item > pop-up message "Could not calculate cost for the selected Realtime rate. The UPS Online Realtime Rates System is temporarily unavailable. Please resubmit your rate…

We have a few integrations and may have been a little cavalier with granting permission in retrospect....but this is useful info Each login can have 1 concurrent user interface login and 1 web service login. So you don't need to give a license to an integration for just the integration's sake. You probably need one during…

That will be challenging, since he's technically my boss.

No. Our controller has indicated it must be a discount. I have a support case logged with NetSuite, but that hasn't been helpful yet.

I was able to resolve this. It was more a function of my own unfamiliarity with workflows, but I have it configured in a way that's working now. The sales hold is a custom checkbox I added to our sales orders. The issue was that I was trying to apply a condition to the state when it didn't need any as the workflow would…

No. This seems like a more robust way to achieve what I'm looking to do - thank you.

Bump - are there any resources on how to use saved searches in workflows?

Is there any special way the search should be configured? I had a search created to be used in this manner, but couldn't get it to work. My search looked at: SO created with date in last 7 days Sum of quantity committed < 4 units Do the results need to be formatted in any special way? The field would be on the header level…

Thanks Evan. Is there any way to accomplish what I'm looking to do without a script? (categorize pick tickets by adding a category designation based on an automatic calculation of quantity committed - or if there's a different way, I'm all ears.)