I could, but this is the tip of the Iceberg, now im being told that along side this defect the time part of the datetime stamp is not recognized, only the date. I think someone needs to have a good look through this feature and get it a once over.

Looking at it quickly everything seems to be sound. In NetSuite, you can use the Web service usage log which contains the actual SOAP requests that C# will generate and also the responses from NetSuite. It might be worth having a look through the responses to make sure that the right info is being exported and that there…

Hi Leonard, what sort of SOAP requests are you making to get this info?

I just ran a simple console program and the results matched that in the UI. Here is what i wrote: using System; using System.Net; using CustomerBalance.com.netsuite.webservices; namespace CustomerBalance { class Program { static void Main(string[] args) { NetSuiteService service = new NetSuiteService();…

I think the problem is that the datetime that is returned is coming back without a time component, but the filter respects the time part. Both that and the > 1000 problem are scheduled to be fixed in the next efix. A note on the > 1000 problem - it's not a good idea to return much more than 1000 rows at a time as it…

Think it might be related to the outage they had a couple of days ago, our requests have doubled, even tripled in some places because of it.

Hi Paul, thanks for replying. Basically its an external programme that im designing to control our warehouse inventory, including bulk locations etc. I want to hold a database outside of NetSuite which contains all our product info including stock levels which isnt a problem, i have a program which downloads all this on a…

Hi jschneller, not that im lazy :) but do you have any examples to get me started on this, i understand basics in C# but im not trained up enough to go this in depth yet. Would appreciate any help you can hand me.

It wouldnt be a web app, its a windows form app. So basically i would need a class that would hold all the web service requests in it, this would potentially be used to create the cookies etc and login originally and then follow on request could share this session as it were. Ok, ill have a poke around and see how i get…

Ok, so how would i go about looping through all my items creating new RecordRefs for each one to request from NetSuite? We have around 3500 items in our database that i need to check stock on.

Hi Wiktor, thanks for your reply. I did come across this but i noticed that you have to supply the internal id of the items you want to lookup, seems kind of backwards to me. If you perform a basic item search i get 50 results in 4 seconds. If i use the item availability search im making 1 request per second so 50 lookups…

Hi Scott, thats the exception error i get in my program. I cant actually access the SOAP response through the WS usage log as it throws a not found error. Im getting these errors randomly every week or so. I had one this morning as well. All im doing when i get this is an inventory item search, nothing special.

We had this issue for a long time, request that would normally take 12 seconds took 350 seconds instead. We filled a defect for it. I was contacted by support today to see if it was still an issue, i ran our requests and they are back to normal. Check it out, see if yours has improved.

I think NetSuite has been having some issues with their web services recently. We use a system that downloads all the item information to use with our warehouse system. Towards the end of December it started timing out and has done since then. I filled a case yesterday and its being looked into, S2. I have tried today and…

Whitecloud, i believe NetSuite is having issues with their reports and web services. Alot of requests that normally take 50 secs for me now take 350 secs. Might need to submit a case. chris

I wouldnt say that, 3/4 of my first c# project was written using examples i found through Google. Just depends what you are looking for i suppose. Also we had a software programme written for us a few years back in java and i didnt like the feel of it. That said, it all comes down to how comfortable you feel with what…

Started from scratch im afraid, basically started with copy and paste from different references :) From there i managed to understand what was going on and was able to write some code myself. Am still only a beginner, but have a couple of programs that download item data from NetSuite for example which then create all my…

Hi Martyn, i currently use C#, the added bonus being that you can use their express edition for commercial use if you dont want to pay out for visual studio. I used the express edition for a long time, you can also use SQL express edition if you want to store data as well. Im not sure if Sun has a free version. All i can…

It happened on 11th November around midday, this was found to be a defect in NetSuite which has been fixed.

Dont worry, figured out you can, just hadnt converted into bytes correctly. I had alook around and managed to get it working but using the following: File uploadFile = new File(); FileStream fs = new FileStream("c:\images\"+findImage.Name, FileMode.Open, FileAccess.Read); BinaryReader br = new BinaryReader(fs); byte[] data…

Not sure if this helps, but we used to use the 2008.2 and had problems when it came to item web store categories, which was Category1. When we changed up to 2009.2 its changed to just Category and we can reference alot better now. Might be worth upgrading your code :(

Ignore me, i hadnt put bodyFieldsOnly = false :)

Defect was filed, just caused alot of issues, is working ok so far today, fingers crossed!

Ok, back to this, does anyone know how to read the pricing using C#? Ive got it in the SOAP response but am struggling to loop through the pricing matrix to get what i need.

Well, i have finished this off now, i got rid of the get request and found a way to get the info out of the search request. If you want any help with something like this, drop me an email, chris@blitzsport.com

Confirmation please? I think i have this code working now but wanted some confirmation for a workflow i have put in place. 1. Login 2. Search using SO number 3. From results, grab the internal id and perform a get request 4. Use info from get request 5. Logout Is this correct, or should i be able to use information from…

Hi Abhi, thanks for your reply but im almost done with the C# programme, i might as well finish it. I went into the help section of Netsuite and found a sample basic search for C# and it has the following for the response section: // Process response if ( response.status.isSuccess ) { // Process the records returned in the…

I could probably do this, but the amount of transactions we have a day warrants an individual programme. We do roughly 350-400 consignments per day so someone would be forever running the report to get the information out. If we programme it, i can schedule it and get it to import the data automatically. The current…

Hi Nick, im home now so ill post up my code tommorrow, quite a bit of it, but almost got it running perfect now. It basically works like this. I send search criteria via web services using C#. When NetSuite responds, im able to loop through each sales order (in this case) and get the information out from it. The only stuff…

Ive had a small breakthrough, in terms of getting information from a sales order if i supply the internalID and use the get function. What im missing is reading the list of internalIDs from a search function which i cant then use with the get function.