Thanks for the clarification, so I don't do this :h_a_w:!

An easy work around we've been using is just to have an automated email (via saved search) go to the sales rep any time an order is saved that has a shipping method of Pick Up and the tax item is anything other than our home state. Not best case, but it at least reminds sales to change the line item taxes individually or…

We are looking do the same thing. Could scripting be used to set the address as our business address for the case of a pickup? Trying to avoid creating the address each time or having to import, because many customers will be first time customers and won't have the luxury of having our address on their customer record…

Enhancement 59387 is still open, making it almost 5 years old. Anyone have any better work around than journal entries or tricking the system on the COGS account as suggested above?

You might be looking at the summary option on the criteria tab...look at the results tab and you can set the summary type per field. Just pick a field (Such as Inventory Location) and a summary Type (such as Sum or Group). Note that once you set a summary type for one field, the search results are only going to show the…

You should be able to get just the locations you want by setting 'Inventory Location' filter to just the desired locations and the Results of 'Location Available' or 'Location On Hand', etc...

I'd recommend using a saved search instead of a report....there's a lot of documentation on how to create those and schedule them. Ask if you need help with specific pieces of data? 

Can also set it per Role - preferences tab within each role. 

Thanks for the reply JBrox, scripting may be a little beyond our needs/capabilities at this point. We are just now implementing Netsuite, but I think I understand the logic of that type of solution. We'll have to see where this ranks on our wish list moving forward. :)

Outstanding, thank you

OK making some progress w/PHP toolkit. Starting to see how I would've been re-inventing the wheel by creating some of this from scratch. I was able to get at least one of the samples to work in a browser (get_customer), but am having trouble using the saved_search sample as a starting point. This is basically the same as…

Totally stuck here. [PHP] <?php require_once 'PHPToolkit/NetSuiteService.php'; $service = new NetSuiteService(); $search = new TransactionSearchAdvanced(); $search->savedSearchId = "123"; $request = new SearchRequest(); $request->searchRecord = $search; $searchResponse = $service->search($request); if…

Just to close this thread - I am starting to get this to work. Some of the results are being returned as arrays. I've seen this posted on many threads, and really helped turn the corner to see how to get what I needed (along with schema browser): print '<pre>'; print_r($searchResponse); print '</pre>';

Update: Looks like this calls for TransactionSearchAdvanced(). I can successfully get the total record count, going to take some more work to be able to pull the results. [PHP] $records = $searchResponse->searchResult->searchRowList->searchRow; foreach ($records as $record) { echo "Name: " .…

I don't know if this will solve your problem - but you can create a custom field that sources from saved search results. Keys being to not store a value on the custom field and to filter the search by the fulfillment internal id. Netsuite Help is decent for how to set it up.

Well, the saved search would total the weights up and the field just filters that search by the ID if the fulfillment. Search should be just one row when ran stand-alone (using Sum as summary type) and basically it will sum all the fulfillments that match your criteria, which may well be all the fulfillments in the system.…

You can create a saved search that identifies the orders that are 'partially fulfillable'. You could use that search as a criteria in the workflow to take action on those orders. That would be problematic, I think, because the sales orders are going to be potentially changing every time you receive a PO (or another…

We found that the Pick Ticket Printed flag gets reset to 'F' if you partially fulfill the order (using Pick/Pack/Ship). Went ahead and created a script (via a button) to reset the flag - it adds a dummy item to the order, fulfills that item, deletes the fulfillment, then takes the item off the order. It's not terribly fast…

Ok I think I have got it worked out using a Suitelet, User Script and Client Script. Still have to build in proper error handling so the user cannot blow up both orders. That would be a mess. Thanks Olivier for the server-side recommendation, it seems to be much faster than anything I have done with Client or User scripts.…

Well, we have done both of those things. Our sales staff just likes the check item availability screen for general inquiries that are not yet at the order stage. I'd really like to get more item info right into that view.

It is part of the Available to Promise feature. "The Available to Promise feature gives purchasing and sales departments visibility into the projected ship date of goods during the quote and order processes. It enables you to check item availability based on outstanding transfer orders, purchase orders, work orders, and…

Robbie, How can I source in data from a related record into a custom field? It is easy enough to pull in, for example, a phone number field to an SO from the Customer record. However, I am looking to bring in the deposit amount from a deposit that is linked to the SO. In other words, I want to show the amount that has…

I'd imagine you've already checked this but we have had the password expire with Payflow before ... the one you set in the Netsuite UI - Payment Processing Profile. Took us a while to figure out the first time it happened. 

We needed the same thing and had a custom script written that creates a customer deposit on the sales order when that fulfillment is marked Shipped. The credit card is initially put into the order as a payment method, but then the script takes that card, clears it from the payment method, marks the sales order as terms…

Thanks. Just to help me understand, is there a reason why you cannot pull the original credit card selected from the sales order and use that for your backorder processing? Ya I don't see why not, we just haven't developed the script to do that automatically.

Wouldn't the purpose of the approval be such that it does not show in financials until approved? Note that prior to approval it would show the GL impact but with a 'No' in the Posting column. After approval, 'Yes'. If you need to see it it financials but still have some sort of approval process you might think about custom…

Good to hear, I suspected it was something like that just couldn't find it published anywhere. I will turn off a few/re-order to confirm and then start the consolidation. Such an exciting project for the weekend! 

I will test other record types. About 30 client/user event scripts on sales orders, all 1.0. Mostly user event submit stuff, nothing that is pageInit. 

No error in browser console that i can detect, just silent almost as if its not deployed. I guess I could create a problem in the script and see what that does. /** * @NApiVersion 2.0 * @NScriptType ClientScript */ define([], /** * @param {email} email * @param {dialog} dialog */ function() { /** * Function to be executed…

I have tested this on a transaction search and it seems to work as expected. Caveat would be that my version is based around committed inventory/available quantities and not on hand quantities. Waiting to send the email when the quantity on hand changes could be much too late. For that reason, this is based on sales orders…