ben.vanderbeek

See this thread, may be applicable although it was re:Preferred Stock Level not Re-Order Point https://usergroup.netsuite.com/users/showthread.php?t=31487&highlight=preferred+stock+level

in Auto Calculate Reorder Point Issue Comment by ben.vanderbeek Jan 21, 2013 5:05PM

Have you tried using the SQL SUM() formula to do what you're describing? I believe if there's such an aggregate function in the formula, NetSuite may ignore the function in the Summary Type column. I've successfully performed calculations using different summary functions inside formulas.

in Calculation between two columns having formulas Comment by ben.vanderbeek May 16, 2018 11:03AM

For 2010: # of Business Days This Month: decode(to_number(to_char({today},'MM')),1,20,2,20,3,23,4,22,5,20,6,22,7,22,8,22,9,21,10,21,11,20,12,21) Business Day of the Month (today): TO_CHAR({today},'dd') * decode(to_number(to_char({today},'MM')),1,20,2,20,3,23,4,22,5,20,6,22,7,22,8,22,9,21,10,21,11,20,12,21) /…

in Date formula for last business day Comment by ben.vanderbeek May 12, 2010 8:07PM

how about "# of business days in a month" or "# business days MTD" ? thanks! :)

in Date formula for last business day Comment by ben.vanderbeek Jan 5, 2010 7:40PM

That approach (beforeload, select/commit lines) is what I would have recommended. Hopefully that works for you.

in Populating Items on Form Comment by ben.vanderbeek May 15, 2018 3:58PM

timw, did you ever resolve this? I'm considering SCA but need marketing features to work. Thanks.

in Promotional URLs don't work on SuiteCommerce Advanced Comment by ben.vanderbeek Oct 8, 2014 3:31PM

Thanks Frederic. Odd, I got SSS_RECORD_TYPE_MISMATCH with the same code. But yeah I figured it wasn't possible.

in Can you load a ship item in SuiteScript? nlapiLoadRecord('shipitem',...) Comment by ben.vanderbeek Nov 18, 2011 2:52PM

I'm experiencing the same problem - can't figure out how to do a true PUT with nlapiRequestURL.

in nlapiRequestURL and HTTP PUT Comment by ben.vanderbeek Apr 12, 2015 7:26PM

If the invoice is not generated from the Sales Order, but created as a standalone transaction, the Sales Order status wouldn't change Associating the invoice afterward also wouldn't change the SO status. SO approval is separate from (and understandingly, you'd expect it to be prior to) invoicing. It sounds like the process…

in Sales Orders showing as Open even though they have been paid Comment by ben.vanderbeek May 15, 2018 4:05PM

I have the same question.

in Why is <NLSTATE> not a drop down list in Online Customer Form Comment by ben.vanderbeek Aug 10, 2012 8:03PM

Have you tried SuiteScript? I've seen what you're describing achieved by having a user event script concatenate the relevant line item field values into a single text area body field, which then has its changes tracked in System Notes.

in Tracking Line Item Changes in System Notes Comment by ben.vanderbeek May 16, 2018 11:08AM

OK Thanks. What's your guess as to when this might be fixed? How often are updated to the PHP Toolkit released?

in PHP_Toolkit not parsing saved search xml response correctly Comment by ben.vanderbeek Dec 2, 2011 12:38PM

Thanks Lorne. Could you help me come up w/ a workaround? [LIST] [*] Call a separate search to get item descriptions [*] Parse the raw XML myself [*] ...? [/LIST] I've gotten it to work with itemId (item "Name") and locationQuantityAvailable. Is that because they come before "Other Prices" alphabetically? I just need some…

in PHP_Toolkit not parsing saved search xml response correctly Comment by ben.vanderbeek Nov 25, 2011 12:09AM

Wow. Yes that worked perfectly. Thanks Lorne! :)

in Get list of Price Levels via web services Comment by ben.vanderbeek Nov 23, 2011 12:37PM

In my case it was because I had turned on Multi-Location inventory, and the location assigned to the item that I was testing with was missing its address. Instead of giving a warning about the location's address, it gave an error as if the buyer's address was incorrect.

in UPS Real Time rates not working Comment by ben.vanderbeek Mar 24, 2008 12:30PM

I'm having a similar problem. Seems to work if a customer registers themselves, but not if I create the customer from w/in NetSuite. James did you ever find a solution?

in UPS Real Time rates not working Comment by ben.vanderbeek Mar 21, 2008 7:29PM

NetSuite support says you can modify the preferred Sales Order Transaction Form to show the Location column field and hide the Location body field, and then the Fulfill Sales Orders screen could filter by the preferred location of the item instead of the location set on the order. From NetSuite support: You were asking…

in Fulfillment workflow for SO's with both inventory & drop ship items Comment by ben.vanderbeek Jan 21, 2009 5:18PM

I'm having the same issue. I'm going to attempt to use locations to filter out drop ship orders. Does anyone know how to make the location on a SO automatically get set to the location of the item (assuming there's one item) when the SO is created by web services or via the NetSuite web store? There's an enhancement…

in Fulfillment workflow for SO's with both inventory & drop ship items Comment by ben.vanderbeek Jan 21, 2009 4:20PM

I haven't. Have you looked into whether this Javascript library is usable within SuiteScript? https://github.com/openpgpjs/openpgpjs

in PGP Encryption Comment by ben.vanderbeek May 15, 2018 11:32AM

Confirmed w/ NetSuite Support that one cannot disable System Notes in SuiteScript: Based on the Help Guide, you cannot disable the System Notes via SuiteScript as it is not included on the Scriptable Records found on SuiteScript Records Browser. You will only have an option to disable or enable the System Notes for Custom…

in Deleting System Notes Comment by ben.vanderbeek May 12, 2010 8:03PM

We do use NetSuite for our applicant tracking, we have a whole internal app for it built on the SuiteCloud platform. We have not yet rolled out the online application form, but we do intend to do it in the future. By the way, we are also rolling out internally a platform-based performance management application built on…

in HR recruiting process Comment by ben.vanderbeek Jan 9, 2012 2:09PM

Haha Krish0nan! Good observation. For us it's more about tracking applicant status and follow up interactions, making it searchable by keyword, etc. Right now using a Google Doc Spreadsheet and realized it would make more sense to get it inside NetSuite rather than having separate systems. Thanks for your insight.

in HR recruiting process Comment by ben.vanderbeek Jan 6, 2012 12:38PM

Sorry to revive an old thread but just wanted to see if anyone had anything to add to this discussion. Everything described makes sense. We'll have fewer applicants so won't need to do the web form / scripting probably (wouldn't hurt). I just want to make sure I'm not reinventing anything, for example, the wheel.

in HR recruiting process Comment by ben.vanderbeek Jan 5, 2012 8:40PM

Jeremy I know it was a year ago but I do have PHP code that retrieves a saved search and writes a CSV file. If you're interested I could post samples.

in Auto generating a CSV file of products from Netsuite Comment by ben.vanderbeek Jan 9, 2012 2:13PM

Logs and system notes do consume physical disk space, but NetSuite does not count the space occupied by logs and system notes as part of the "data usage" that is referenced by our service pricing. As Rob points out, customization can become a very large source of data usage when the cross references to custom elements…

in Storage Space Usage Comment by ben.vanderbeek Sep 12, 2013 2:28PM

Just an attempt at an explanation - maybe in view mode, the record is not considered to have been loaded from a script perspective, since it's only being displayed. Not a great explanation, but that's my first guess.

in CurrentRecord field value in View Mode Comment by ben.vanderbeek May 16, 2018 11:20AM

Sorry for the late reply, you've probably already figured this out. Are you saying that you'd want only the Sales Order quantities to be included in the demand calculation, and not the Estimate? If the SO isn't linked to the Estimate, I'm not sure how NetSuite would know to only include one of them. Demand Source =…

in Forecast consumption Comment by ben.vanderbeek May 11, 2018 1:08PM

Sorry for the late reply. 1. Are all the items you want to include set to Replenishment Method = Time Phased? See Inventory Management User Guide page 88. https://system.netsuite.com/app/help/helpcenter.nl?fid=InventoryManagement.pdf 2. Have you tried the projection method Seasonal Average? See Inventory Management User…

in Demand Planning Inquiery Comment by ben.vanderbeek May 11, 2018 1:15PM

I can't find "Specific costing" in the help documentation. Did you mean Standard? I see FIFO, LIFO, Average, Standard, Group Average.

in Average costing vs. specific costing Comment by ben.vanderbeek May 14, 2018 3:14PM

I had an Open Work Orders saved transaction search where I embedded javascript in a custom saved search formula text column '<script>...</script>', which made an nlapiRequestURL client-side call, retrieved an XML version of the work order (append &xml=T to the Work Order URL), parsed it to find the value in the header…

in Identifying Buildable WOs when Inventory is received and components come off backorder Comment by ben.vanderbeek May 14, 2018 3:01PM

ben.vanderbeek Newbie

Comments