プロフィール

Avatar
ロック解除可能なバッジを表示 ロック解除可能なバッジを表示

Matrim Bronze Medal

コメント

  • Never tried printing those, but seems like they can be accessed by "quantitypicked" and "quantitypacked". Found out by looking at a sales order and adding "&xml=T" to the URL in the browser. That's a useful trick for finding undocumented field ids.
  • I had the same requirement and made a Custom Record Type to hold the necessary information: Then added scripts to source this information on-the-fly to a Transaction Line Field for printing estimates, sales orders, invoices, packing slips and shipping labels. Didn't know something similar is available in the Supply Chain…
  • "Print Picking Ticket" is available for Sales Orders by default as a standard NetSuite function, you can add or remove it from the form by going to Customize -> Actions -> Standard Actions -> Print Picking Ticket -> Show In your case "Display as" has been selected as "Menu" which puts it as mouse-over option on the…
  • Probably doesn't work because Item Groups are missing from the switch, try adding: case 'Group': recordType = 'itemgroup'; break; Either way you can avoid the error by placing a try around everything after the switch block: // load item and get image file from Item Display Thumbnailtry { ...} catch(e) {}
  • The best approach I can think of for this sort of custom approval mechanism is to use a custom record type that holds all the necessary information, then convert the custom record to a standard bank deposit upon approval. I don't think you can do that by a Workflow, though, probably needs a Suitelet for the approval /…
  • Okay, I finally found the solution myself. I am using a Formula (Text) column with below code: REGEXP_REPLACE({custbody_internalmemo}, '[[:cntrl:]]{2}', '<br>') Where {custbody_internalmemo} is the text area custom field on the transactions being searched. []+ and similar whitespace match expressions did not work. It…
  • I don't think that's possible without scripting. "Location Available" (id: locationquantityavailable) cannot be chosen as a source (from the item record) for custom column fields, maybe because it wouldn't know which location's value to source. Even if it were possible using a formula field, the value would then only be…
  • Have you added any sorting in your Advanced PDF/HTML template? Look if there's a ?sort_by added to the #list tag. If not, normally the items should appear in the same order as they are entered to the transaction, not ordered by on hand quantity. I did some customization for the order of our picking tickets using a custom…
  • Have you looked at SuiteAnwers #33496? If I understand correctly, this answers your question. If not, maybe can you explain/show in more detail what you are trying to do? Are you doing some kind of nested search or lookup for each of the 3000+ search results? Then it will indeed time out or exceed the limit of API…
  • Okay, hope that worked for you. By the way, I think the reason why the approach in #22385 might time out is because for a pricing search you get a lot of search results with the same internal ID (that of the customer!). So depending on how you've constructed the search it might be repeating the search again and again, each…
  • Thank you for the reply pcutler, but I think that process is more complicated than necessary. Maybe I haven't communicated the problem well enough: I'm not trying to capture data from some 3rd party Suitelet, I'm the author of the Suitelet that's creating the data and just looking for another way to output it (i.e. as an…
  • Yeah, I also prefer the behaviour of reports, i.e. you change all the filters you want, then click the Refresh button. Can you do that by showing the search results in a sublist on an nlobjform? I've only done this with nlobjlist (POST method) so far. That way you always need to reload the Suitelet's page to get back to…
  • With that workaround you lose the functionality of adding/changing filters on the results screen (on the fly), though, right? For changing filters you'd need to have a form (GET method) where the user can make some choices, then load the search results / list after they click a button. And if you want to change filters you…
  • For a start, try replacing everything from row <#if record.item?has_content> and below with the following: [code] <#assign shipping=0 handling=0> <#if record.item?has_content> <table class="itemtable" style="width: 100%; margin-top: 10px;"> <#list record.item as item> <!-- start items --> <#if item_index==0> <thead> <tr>…
  • If you post the code of your invoice template I can tell you where to insert the parts I've mentioned. I won't be able to write the <#if> statement for checking for shipping and handling items, though, unless you provide more details about what kind of item records you use for these and how to recognize them (e.g. by item…
  • Yeah, as I've said at the moment it won't be able to identify your shipping charge lines. I don't know how shipping items are implemented on your account, e.g. we use Other Charge item records for it that all have the parent item "Shipping". I guess I can figure it out for your account if you do the following: [LIST]…
  • That's certainly possible, for instance by using 2 variables declared by e.g. <#assign shipping=0 handling=0> before the <#list> block in your code. Then put an <#if> statement in your <#list> of items to check if the current line item is a shipping or handling item, if so don't print the item but instead add its amount to…
  • I can confirm that this markup worked also for our saved search templates in 2017.2 and 2018.1, I don't think there has been any change to this since it was introduced. JCaudle that error seems to happen only on Chrome and is not specifically related to NetSuite. You can find many troubleshooting guides on google.