Thanks for checking into my script, Olivier. Looking back at the nlapiLookupField, I am going through the custom saved search field by field: The desired outcome for the formation of 'vendorBillTranId' is "tranid / location-name / customer-name" . 1st try: 'number','location','customer' "customer' and location gave me the…

Thanks for the inputs. Since items on the POs are approved from the SOs and most are non -fulfillable, we bill against the POs. The script will be scheduled to run on daily basis. My first test of the script failed with the Error: USER_ERROR Please enter value(s) for: Ref. No. Stack Trace:…

Additional question: What is involved with the NetSuite system when adding a second sales order form with different fulfillment process?

Re-polished the scheduled script and executed for a test run, the script deployment status: complete 100%. But the bills did not get transformed. What is missing? :( function processChasePOs(type) { var context = nlapiGetContext(); context.setPercentComplete(0.00); // set the percent complete parameter to 0.00 //only…

The same with our account. [Beta] Search Results for the scheduled saved searches still come to my Inbox, even when I am not in the list of recipients.

There are times "disapproval" means "reject" or just not closing the lines, and a resend of reject notification is to be performed, till these line items are approved (Is Approve: checked) again. Well if disapproval means Closing the line, and approval means not closing them, then the out of the box Item Receipt screen…

Thanks Brett. the requirements have gotten more complicated but I will integrate this idea... Hi Lynale, The first thing I'd tend to do would be to include the customer's email in the saved search results. Then for processing I'd tend to do something like this: var searchResult =…

Update: I utilized the Custom Task form and the Employee's mobile access actually allows employee to "Complete" (with a finger swipe) the task, the automation of PO receipt follows this trigger. Thanks.

Update: I utilized the Custom Task form and the Employee's mobile access actually allows employee to "Complete" (with a finger swipe) the task, the automation of PO receipt follows this trigger. Hi Anne, You are able to set a custom purchase order form as preferred on the employee center role. In order to do this, edit the…

Yes I do have that. Make sure 'totalOrdered' is initialized as a numerical value. Like : var totalOrdered = 0;

using your sample script, I expanded mine to calculate the TotalQty on hte order. The incrementing of qty seems to concat, rather the sum. My Total Qty = 501,212,200,200,484 (concat of 7 Item lines: 50+12+12+200+200+48+4). Any suggestion to get the correct Total of Qty from all Item lines? var numberOfItems =…

Thanks Brett, I revised and simplified the code to where I just need 1 summary and 3 group columns, and used addColumn method, fixed the parameter values which are to be captured from the fields. Then the entity Filter was the challenging one, as anything I tried would not work(customer/internalid/entity/entityid). With NS…

Thanks! It's been (hidden) there! Yes, in the help for nlobjSearchFilter, the entire list appears.

That's said and fixed. The bigger problem is my SS is not loading. The debugger keeps bugging me on a custom field. An nlobjSearchFilter contains invalid search criteria: custitem_fas_cat. An nlobjSearchFilter contains an invalid operator, or is not in proper syntax: custcol_fas_cat. An nlobjSearchFilter contains invalid…

[LEFT]Yes, I tried that, and continued debugging ...till I had "UNEXPECTED ERROR" and then to the latest, it says "No records to show." on the page, whereas there is data results on the SS . What do I do wrong in my script? :h_a_w::h_a_w:[/LEFT] [LEFT].. // fields data as filters var filters = new Array(); filters[0] = new…

You would have 2 custom fields. one is the Item multi-selection field on your inventory record. One is the item option field. You will do a CVS update on the multi-selection field of your inventory records. And then source the transaction item option field to the Item MS field.

Question: Does your script ever run/work for posting transactions , e.g. Cash Sales?

I have the same situation having occurred twice just within this month. But my script stopped completely, not paused. It's the only script we have scheduled to run every weekday. On first occurrence it stopped after 2.77s; on the 2nd it stopped after 10.86s. System error received: Script: Batch Billing PO Type: Scheduled…

That's the only way, I thought. Will implement that. Thanks for the ideas.

This looks like what I need. How do I apply that to my Formula(numeric) : {Today}-{custbody_reminder_date} >24 Where {custbody_reminder_date} is of the time/date field type. OK... got it: If anyone is interested, I found this here: http://www.psoug.org/reference/date_func.html

Should I have the custom field 's display type as "Normal" instead of "Disabled"?

That was exactly what I had, not enclosing it in CONCAT() function. The two pipe characters are the concatenation operator, so you don't need to put it inside the concat() function too

CONCAT({customfiel1},'/',{number},'/',{shipto}) gives me the Invalid expression or incorrect char type message. using the pipes || as in: {customfiel1}||'/'||{number}||'/'||{shipto} returns "/null/" values. What causes this? It turns out you have to do a max summary type. count will try to do a total on a non-numeric…

Yes, unfortunately the "subsidiary" feature is just there, but does not do much work. I figured the Subsidiaries in OneWorld is not fully-developed, so had to implement around "Location" instead. You want to make sure the set up of inventory and users/employees is flexible to locations across subsidiaries. If your…

Sure. Thanks Olivier. <span style="font-size:'1'">function beforeLoad(type, form, request)</span> <span style="font-size:'1'">{</span> <span style="font-size:'1'">var currentContext = nlapiGetContext();</span> <span style="font-size:'1'">var currentUserID = currentContext.getUser();</span> <span style="font-size:'1'">var…

Yes, that's it! The second parameter! I took out the spaces and it now works in all browsers. Thanks to y'all and NS support. Yes, Olivier is correct, it is related to your window.open(). window.open(URL,name,specs,replace) IE is looking at 'name' not as the 'name' of the window, but the target window attribute. that is...…

I guess the CONCAT formula works with two strings only, I still got this error message. Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit. Search: Transaction Search Formula:…

Thanks for all the inputs. I have the Search Mass Update scheduled to run @ 4am Central Time (2am Pacific Time). It was behaving well so far until this morning the update did not run until 5:30am (3:30am Pacific). What was going on with my account server? Not all of my PO's were updated in time before another scheduled…

Yes you can.. but the problem is you cannot task your employees.. which is what we are experiencing. or setup events properly for that matter. It is still the same issue in current version 2013 Release 1; a partner cannot task employee. Still a "Pending" enhancement, per NetSuite support. So the alternative was to create a…

I found the solution. In the (advanced) partner's role, we would want to check "Do not restrict employee... " box.