Hey @Richard James Uri-Oracle - Sorry I didn't your response. Sometimes I am able to throw and error, and other times it will not throw an error. I will try to get a screen-shot of it next time

khultquist all solid suggestions but no luck

Now I see. This is not possible to use the aggregate function in the criteria or results when doing a summary function over the data. :(

Auggie I used jokell idea and created a custom column. I was able to source the preferred bin from the item record. Here are the steps I took 1. Create custom Column, custcol_preferred_bin 2. Used Free Form Text and source from Item and Preferred Bin. See image. 3. Applied to Quotes and Sales Orders 4. Removed the label so…

So much fun :) I'll give that a try. Thanks. 

Here is image [ATTACH=JSON]{"data-align":"none","data-size":"full","title":"Screen Shot 2017-06-29 at 3.53.49 PM.png","data-attachmentid":424560}[/ATTACH]

I think you might be right. I have made the request to cybersource and I will let you know if that is correct. Thanks!

I haven't tried to decode it, do you know what algorithm it might possibly be? There is also a transaction_id being passed that that is a 16 digit numerical value. So maybe that is it I am working with Mage Delight (Cybersource plugin), Celigo and Cybersource to get this resolved so I should have an answer soon. I will…

Turns out that bin put away sheets were the culprit! We deleted them and are problem was solved. Thanks all!

Gabby did you ever get any figure out these questions?

ironside and mwhite@hgyp.com good suggestions, I have tried both. I was thinking maybe it was some issue with scripting going on in the background that is preventing the search from being sent when it is created. Then again I feel like the search results and the record itself, but I am banging my head here.

Ah I see what you did there, erictgrubaugh . That should work. Thank you much.

@iron

ironside I was wondering if it was not being actually being escaped with quotes myself (it is not nlapiLogExecution, it is just what is being returned in the body of Postman). However the reason I think it is being escaped is that I nlapiResolveURL is returning a syntax error when I pass xmlRequest to it. When I take that…

Well I got it working somehow. Not really sure what the issue was, but at this point I just want to move on with my life lol. Thanks for your help and also thanks for the encouragement in using lodash as well ironside Do you use TypeScript in all/most of your SuiteScripts? I would like to be able to use ES6 (I know…

Really good stuff, I am really grateful for the time you took to write all of this up. I am looking forward to researching the sources you have provided. I also received this answer on SO. Would just like to offer it for other people trying to learn about different design patterns. var itemsToProcess = getItemsToProcess();…

erictgrubaugh This is super helpful. Having something I am working on transformed like this has been eye-opening. The pattern for dealing with search results has been a great help too. As always you are the man. I am going to play around and do some more research myself, but I have some follow-up questions and assumptions…

I know this is pretty old, but worked like a charm for me, ddennison This exactly what I was looking for.

7 years and no support for this yet?

Mine has been down for over a week now. Today is 1/17/2017. I have mailed my account rep and haven't gotten a response yet. 

Any solution to this. Can a credit card be captured with the token and auth code? We have the same setup, Magento with the Celigo connector. We want to charge from NetSuite. When the order comes from Magento via Celigo I am writing a script to create the customer deposit. I want to be able to capture the CC with the…

Did you ever find a solution to this. I am too looking to add just an additional descriptive column to the credit card subtab. Do not want to change anything else about the numbers, just an additional column

al3xicon I see what is it. There were two custom columns. custcol_notes, custcol_printed_notes. custcol_notes was not selected as show/print, I am pretty sure that is why it was throwing error... love coming into a new system. Thanks for listening

al3xicon that's what I would expect. But when I add internal id ${item.custcol_notes} into the script, I get an error. Also when I try to go to the GUI editor I cannot pull in any custom columns using the add field feature. Oh well, will dig into it more. Thanks

It gives me the very helpful "Unexpected Error". It give me that error weather or not I am in source code or the WYSIWYG. The code surrounding is just an HTML table. Pretty sure it is not a syntax error.

al3xicon originally you mentioned adding a custom column type to Advanced PDF. I am looking for this functionality. Are you aware of anyway to add that to Advanced PDF template?

Did you ever figure this out?