My Stuff
Comments
-
Any plan on the new release for 2009. The CASE statement sure would be handy right now.
-
From clause subquery does not work (anymore). SELECT TX.TRANSACTION_ID FROM (SELECT * FROM TRANSACTIONS) TX results in: Error: Subquery in FROM clause is not supported in Pushdown Query mode (State:IM002, Native Code: 0) BTW, subquery doesn't work in select list either, they do work in where clause
-
Is the OpenRDA ODBC Driver for UNIX an option for us or is there something that precludes connection with something other than NetSuite provided driver? Given we'd have to shell out the $'s, but is it possible?
-
Unary operator not allowed in select list This now causes syntax error: SELECT -TXL.NET_AMOUNT FROM TRANSACTION_LINES TXL Error: Syntax error in SQL statement. syntax error line 1 at or after token <TXL>. (State:37000, Native Code: 0) Workaround? 0-TXL.NET_AMOUNT
-
who is bob and how did he become my uncle? :)
-
OK, that covers orders, any idea for customers? These come in thru NS checkout and Google Checkout.
-
as a work around, you could just delete it in the after submit. you know the type & ID
-
try same in after submit. I have some code that does this (last I checked). I belive the event for this is 'paybills'. The before event doen't get invoked (last i checked). Also, if your updating the payment record then you need to set the tranid to "To Be Printed" or it doesn't show link in the print checks list that is…
-
add return true
-
Thanks Yang, I'll add request. My case is that I want to do something like the "Pay Bills" form. To set this up I now have have the user press a button so I can add the check boxes to the table/list.
-
So I see webstore as a standard field referenced in this thread but I don't see it documented anywhere. Is this a reliable way to determine if a sales order originated in the NS webstore? I'd like to run a server side script keying off this. Creating new thread for this question
-
nope, just the one.
-
I'm not expert either but I think will achieve with you want. Put the table inside a block like <div> that reserves the space then set row height on table rows explicitly. <html> <body> <div style="height:200px;width:300px;border:1px solid green;vertical-align:top"> <table style="border:1px solid black"> <tr…
-
I'm seeing similar issues, nlapiSetLineItemValue works for list, text & the like but I'd like to set the value for a custom field that references a project and this does not apear to work. I'd rather not open up each line and edit/commit. Any guidance? Is sourcing an issue? function copyProjectToLines(type) { var rptCliPrj…
-
I think the doc on this is incomplete (2009.2). It appears the the addEditColumn column arg needs to reference a column that MUST have a url like in the example above. This method does not appear to generate the url on it own (which would be nice 'cause I want to process a list of mixed transaction types and include link…
-
If you are going to do this in a batch mode and you think you are going to be processing some large # of records the use WS. If you are confident that # of records < 1000 and operation will falls within governance then scheduled script can work. You'll need to filter customers with search criteria based on a "need to…
-
SuiteScript is not suited to do large batch processing. There are also governance issues around how much you can do in one call. You can certainly add a UserEvent based script to do this on customer record create going forward but for existing customers use Web Services to add the task. That being said, you could put a…
-
see message https://usergroup.netsuite.com/users/showthread.php?t=7012 it worked for me server side, mail was sent
-
Yes that does it, thanks: invoice.setFieldValue('email','the@address.com'); invoice.setFieldValue('tobeemailed','T');
-
field name is 'tobeemailed' , I have success setting it server side.
-
Yang: What's the latest on this release that fixes this issue? We have a project on an account going live that needs it. We wasted lots of time trying to troubleshoot this, not knowing about the existing issue. Would appreciate an update - thanks - sohail@suitesotware.com
-
Any idea when Assembly creation or modification will be supported in web services integration? We have a NS integration with Arena PLM and this is currently a major challenge. I believe this is Enhancement request: 117891 TIA - sohail@suitesoftware.com
-
I am having issues with sales tax calculations and rounding. I have 1 item with price of $95.00. Tax Group rate is 8.5% on line. If I use discount on order of 100% or $95.00 the Sales Order total come to -0.01. What's up? I understand I could make "non taxable" and other manual work arounds but this happens in Web Services…
-
We have a file-based hosted integration with Magento, i.e., we consume magento-generated XML files and insert Sales Orders, Cash Sales & Payments into NS. We are seasoned integrators for NS, using a range of APIs to support our NS clients. For us, upgrading our hosted integration from using Magento files to the Magento API…
-
Yes, I have. Performance if I recall is linear, 2 logins will process twice as much. I've used 5 in a multi threaded threaded app to do a large data migration, each thread used its own axis client connection and maintained a separate session with NS.
-
I have found the issue and successful work around (for me). There is bit of change of behavior a bug. NS used to allow customers of company type to be added as sub customers to customers of type individual. At least with the WS add operation you could. This does not work anymore and you get the "Unexpected Error". I still…
-
Yup, me too Looking at the logs I see things start to go wrong at 02/19/2010 10:51:12 pm Pacific. ALL Customer adds are failing with Unexpected error like so: [Code=UNEXPECTED_ERROR] An unexpected error occurred. Error ID: g5xbyptm1v9ms917mn86l This appears to not be affecting all accounts since I have know some not seeing…
-
sounds like a permission issue with the saved search, is the web service user the same as the search owner, (just make the search public)
-
No NS does not permit this. A seat can only have 1 WS request active in NS and a time unless its special concurrent seat.
-
Not sure about approval but to just retrieve POs do this: TransactionSearchBasic tsb = new TransactionSearchBasic(); tsb.setType(new SearchEnumMultiSelectField( new String[] {TransactionType.__purchaseOrder}, SearchEnumMultiSelectFieldOperator.anyOf));