My Stuff

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

JohanvL Blue Ribbon

Comments

  • Hi @Jack Daryl Espiel-Oracle , Oh wow.. that sucks. As a workaround, is it possible to have a popup when the Delete button has been pushed, that gives some instructions? Thanks
  • @Mikko De La Fuente-Oracle Thank you for the insights and tips to get it all working! Yes, I'm now able to do 1 call to add addresses and creditcard info in 1 swoop. Thank you!
  • @Mikko De La Fuente-Oracle Thank you for that last bit of info.. I didn't know I could do that; I thought that the external id was something that's already inside of Netsuite. Ok, I did that, and it came back without errors.. HOWEVER.. when I post this: It only did the 2nd address and the creditcard. Why didn't it add the…
  • @Mikko De La Fuente-Oracle I actually did a Saved Search on a customer record.. and I got back the internal id, the ID, but the external id was empty. Am I missing something???
  • @Mikko De La Fuente-Oracle I've tried out the upsertList method.. and I received 2 messages: the plastformCore: status says it's successful.. but then when it goes to the writeResponse, it says it's not successful and gives the following message: Please enter value(s) for: First Name, Last Name, Category, Subsidiary, Lead…
  • @Mikko De La Fuente-Oracle Ok, I think I see what you mean.. I'm going to try that. Now, so far I've done this: create customer rec - (add info to customer rec - get customer rec (to get the id's for addresses and creditcards)) - repeat the previous part that's in parenthesis a few times - submit SO (with those id's) - get…
  • @Mikko De La Fuente-Oracle Yes, I read about upsertList before you answered, however, how would that work for 1 record? After all, I'm not creating 2 customer records, but update/add information inside the record. Example: creditcard: address: and that's just 1 address... and then the upsertlist example from Netsuite: How…
  • No, thank you. We'll try it another way....
  • @Jack Daryl Espiel-Oracle I actually am going to disagree. I got it to work... and it works perfectly. I had to search for information outside of Netsuite and found an answer on stackoverflow that fixed my syntax. So my formula is: CASE WHEN LOWER({item}) LIKE '%(item name)%' THEN {description} ELSE {item} END
  • @Mikko De La Fuente-Oracle the order has been fulfilled at that point, yes... What I would want is: items go back in stock (where they came from) order being refunded. Not sure if that can be done easily through SOAP?
  • @Mikko De La Fuente-Oracle I made sure that I put in everything that I had originally put in when I submitted the SO, and that solved the issue. I believe I had to take a field out though.. but in the end, I can now say that the first issue has been resolved. Thank you. Did you find out anything about the 2nd issue that I…
  • @Mikko De La Fuente-Oracle I believe I tried it WITH the amount, but got another error, however, I was out right after that. I hope to get back to it today. Thanks.
  • ugh.. it would've been so much easier if it would be possible to just cancel ALL items in 1 swoop, specially with the replaceAll="true"... ok. I'll look into that.. in the meantime, when I did the following: <soapenv:Body> <update xsi:type="platformMsgs:UpdateRequest"> <record xsi:type="tranSales:SalesOrder"…
  • So if I have 2 items in the order, I could simply do: <s0:itemList replaceAll="false"> <s0:item> <s0:line>1</s0:line> <s0:isClosed>True</s0:quantity> </s0:item> <s0:item> <s0:line>2</s0:line> <s0:isClosed>True</s0:quantity>  </s0:item> </s0:itemList> So questions regarding the above would be: Is that the correct way of…
  • @Mikko De La Fuente-Oracle , The article gives an example for an opportunity record instead of a transaction record. I assume it works the same, however, when adding the isClosed to the item list, how do I determine what to add it to? The example given (again, opportunity record) uses: <s0:itemList replaceAll="false">…
  • @Mikko De La Fuente-Oracle , The article didn't say anything about an isClosed field. Could you elaborate a bit on that, please? How would I use it? As for the second one.. maybe I need to rephrase what I meant to say. When an SO is placed, I can cancel/close the order in the UI and nothing happens to the credit card…
  • Hi @Mikko De La Fuente-Oracle , Thank you for your response! Yes, I know I can do that through updating the line fields.. but coming back to my initial question: How do I do your answre through a SOAP call? (just raw xml) Order has been entered through SOAP and there is ONLY a Receipt ("cash sale" I believe that's…
  • @Mikko De La Fuente-Oracle , Thank you for your response. It sucks that not all Saved Searches are accessible through SOAP WS... Do you know if they are accessible any other way? (REST?) I am currently using a workaround, but prefer to make curl calls to Netsuite. As for enhancements.. I gave up on those a long time ago.…
  • Ok, just to answer a question I'd asked earlier: issueInventoryNumber is what's needed in the inventory detail part.
  • Hi @Mikko De La Fuente-Oracle , I used a live card instead.. and it went through. So it looks like it's working. Thanks!
  • Hi @Mikko De La Fuente-Oracle , Thank you.. yes, that was very helpful. However, now I'm getting the following error: A saved search with the internal ID 1234 does not exist. However, this saved search DOES exist. Am I missing something?? Thanks,
  • @Mikko De La Fuente-Oracle , that article is about ACH Processing.. nothing about sample cc numbers... -Johan
  • @Mikko De La Fuente-Oracle , Not sure what I'd done wrong before.. I set everything back up again and it's working now, as in that it doesn't throw an error about the issueInventoryNumber or binNumber. The issue I have now is the CC_PROCESSOR_ERROR: Invalid account number. Possible action: Request a different card or other…
  • Hi @Mikko De La Fuente-Oracle , Thank you! Ok.. I've tried BOTH receiptInventoryNumber and issueInventoryNumber... The feature you mentioned IS enabled on the account and 4. I looked into that.. and it's not really helpful..: they mentioned binNumber.. but not in an example. They mentioned both mentioned above (both…
  • Hi @Mikko De La Fuente-Oracle , Thank you.. However, since I want to use this in SOAP, I would not be able to look this up for every SOAP call that I need to make... 1. When I did the call without this, I get the following message: Please enter value(s) for: Serial/Lot Number, Bin Now, I can get the Bin number, but how do…
  • Hi @User_HXWQS , Thank you for the information.. however, I do have a question about your xml: I have inventoryDetail as a sublist and a quantity. I understand the quantity you need to pick from the inventory, but how do you determine where to pick from? (The id of the "serial/lot number"?) Or is this done by the location…
  • @Jack Daryl Espiel-Oracle , I also posted this into Netsuite's regular support, since I wasn't sure if I would get a response from this thread (and then afterwards I forgot where to find this one...) But yes, you are correct. To make a long story short: When you make fields HIDDEN as the default setting and then VISIBLE…
  • Hi @User_HXWQS , Thank you for that information. I've had other things come up, so I'll have to push this off for a few days, but will let you know how it turned out.. Thanks!!
  • @Tafara I do have a question about this, because I'm trying this out and it's not working... So I have a form and custom field X is set up as Hidden. Currently I have it set up so that it triggers on "Before Record Load" (in state1), with condition that field Y has value Q. Parameters has the Field X and Display Type then…