JohnCirocco · Sr. NetSuite Administrator · Silver Trophy

Steve, In a word, no. That just determines which pick slips are presented for picking. If you select Fully Committed it will only allow you to print pick slips where everything is in inventory. Also, when there is a PO for a drop ship, it is already omitted from a pick list. the real issue is when someone fulfills the…

No damage when we enabled it. Just remember the limitations of it being beta.

Sounds like a perfect example of the beta pivot reporting function

One example: In my case I created a custom transaction body field "custbody_search_ship_to" as Free-Form Text and checked the box for Global Search. Under the tab "Validation and Defaulting" I set the Default Value field to {shipaddress}.

Yes, unfortunately you need store value and also unfortunately my cheap and easy technique does not work for fields that change. We rarely if ever change the ship to the customer entered on that particular order so it works for us.

Only thing I can think of is when you save the transaction field, use save and apply to forms and not just save. Sorry.

We had similar issue and was told no by support but there is a work around. Create a custom field that is based upon the field you want. My customer service group wanted to be able to search any part of the ship to address to find orders.

Evan, that's awesome, thanks! I just reported a bug as it returns back every deleted since we went live but I was (incorrectly) under the impression that it was not visible.

Try this: ceil(({cost}*{custitem_margin_multiplier})/5)*5 source: google: "oracle sql round up nearest 5" Thank you SO much!

Try using the Item Join for Class Case when {item.class} = 'Product Line X' then {amount} End

Something easy for all of you today... I have a CASE statement to select items in a list. I cannot get the following to work at all. Case when {memberitem.isphantom} = 'No' then 1 else 0 end I have tried ''N', Is True and every variation of upper and lower case. Anyone have a thought?

Something New (for me)... I have a formula to auto calculate a selling price based on a Custom Field for Margin which works exactly as originally needed: {cost}*{custitem_margin_multiplier} Now the Customer wants the result to be rounded up to the next $5 increment. Super easy in excel but I am at a loss in a formula…

I am hoping all you experts can help me with what "should" be a simple workflow formula to set a field value. We are integrating with Accellos and need to pass the Customer Shipping account based upon the Shipping Method on a Sales Order. They can have any/all of accounts for UPS, FedEx or an LTL carrier. All the Ship…

Transaction Search Criteria: Formula (Numeric) {today}-{trandate} is greater than 45 Amount Remaining is Above Zero = True Type = Invoice Main Line = True

would type need to be in brackets? False error?

I assume you are referring to the Item Pricing tab under Financial on the customer record? If yes, then you can clear the list by adding a single item to each customer using CSV. When you get to the import options page, click advanced options. Check the box labeled Overwrite Sublists. We have a dummy item that we use on…

We did ours in 2 steps. First we used a CSV to import the new Bin as preferred. The CSV had the NetSuite Item Name/Number, Old Bin (now no longer preferred) and the New Bin. Once the Bins were added, we then fed the same CSV into a script which (using Web Services) performed the Bin Transfer. If I remember correctly (from…

We use FarApp for eBay, Amazon and XCart (similar to Magento). We have had great success with his services.

Marty, We have been with FarApp 3 years this September. No issues with his service at all. When we were supposed to go live September 1, 2010 we realized that the e-commerce functions of NetSuite were not going to cut it. We approached FarApp (who we had already signed on to do Amazon) to see if he would be able to connect…

I believe it assumes that the .jpg must be in the images folder (just like when importing items) so you just specify the image name with extension

We have just over 20,000 items and process the entire batch twice an hour without problems. Our search contains the criteria: Last Modified is within 12 hours ago and 1 seconds from now and when an item is added to a cash sale and approved, the last change on an item is updated. This way you only get items that have…

I agree but also disagree... The Celigo tool currently DOES do Checks and Credit Memo's. We just started using it but we needed experience with NetSuite first before the tool became meaningful for us. It is extremely difficult to automate something you do not yet know. That being said a third party helper will get you…

If you migrate the data before live you have much less issues. I actually wish we would have not rushed our implementation and done it. Once Live you have to deal with Inventory, GL, Cash issues that are not worth it. Even if you are doing before live: To get purchasing history not only would you need to have the PO's in…

Yes, you stumbled onto one of the "bugs" in the implementation of Bins in NetSuite. In your instance it should work. Make sure that you do not do any transactions that can affect inventory for any items once you start the process until it is completed. We had an issue in our original implementation back last September…

David Ballantine and pixelplumber Our developer also saw the Define function as the cause and once we set the scripts to testing we are temporarily OK but the functionality of the script is lost.

farrago Did you ever resolve? I just started noticing fulfillments where the tracking is blank on the fulfillments but we know we posted tracking. Problem is I was at Suiteworld so am trying to track down of this started on the 30th when you posted.

Our users are just starting to experience this issue. Submitted a case to be added to 533824 but no response as of yet. For some reason I thought they resolved this last week?

They just enabled a fix this morning. If users are still having the issue, they suggested the following: Support Case #: 3372961. Hi John, Thank you for your time earlier. Below is a summary of our discussion. We rolled out a fix this morning and this might have an effect to users where the email/text editor is impacted. A…

I received notice that they released another fix last night I am testing and so far it all looks good. We are on .NA2. and I enabled the script that was using the define function.

JoeMasek Yes they are aware. I have not gotten an update yet as to the status after we notified them we still had the issue (prior to disabling our scripts)