ben.vanderbeek Newbie

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

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.

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) /…

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

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

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

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

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

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…

I have the same question.

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.

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

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…

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

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.

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?

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…

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…

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

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…

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…

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.

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.

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.

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…

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.

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 =…

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…

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

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…