Just came across this today, wanted to pull a child items parent internal id to our DB but its not being included in the response. Surely what appears on the saved search should be what comes across in the xml response? Whats the point in offering it as a feature otherwise? EDIT: Going to raise this a defect if anyone else…

Any update on this? I didnt really want to create my own list, would rather pull it straight from the schema.

Thanks for the replies on this, I was basically looking for something like this which im thinking could be done with custom fields and some scripting. 1. Item goes out of stock, date custom field is marked with the days date. 2. Item comes back in to stock, 2nd date custom field is marked with the days date. 3. Report / SS…

Nice idea Evan, does make sense to go down this route, as you say i would be able to see when items went out of stock, not just that they did at some point in time. What logic could i use to get this working, for instance, what data would be checked to say that the item was in stock but is now out of stock and vice versa?…

Thanks for your recommendations, i ended up writing a C# program which downloads all the info i needed and sends out the email, wont obviously include the footer that NetSuite generates for unsubscribing etc but it gets the job done.

Anyone have any idea on how to do this? Basically the email needs an intro, then followed by each item ordered on that cash sale which is hyperlinked to the url of the product and then a footer.

Could we also add in to this thread, we need the options to set criteria based on "Date of last order" and "Date of last sale". We could use this to mass update all customers whos "Last order date" is more than 3 months ago, etc.

Thanks Evan, dont know why i didnt even think of that. Works fine now.

Is this even possible in NetSuite then? How am i meant to extract my customers billing address to send them catalogues?

Coming back to this, i just tried creating a saved search to use for a mailshot but i couldnt see any search fields relating to the billing address. Has this been removed?!

Im not sure if this is a related problem but recently reports im running are timing out for no reason. Im not sure if im running more complex reports but im getting alot more errors appearing than normal. For instance, i just tried running "Customer" search. Criteria - Transaction : Date Billed = Within 01/01/2009 to…

Im actually trying to do this right at the moment. We have the advanced inventory module and this doesnt exist as standard. Im finding that i can create 2 seperate reports but not both in one. For some reason, NetSuite has not included backordered as a field under the Sold reports. It has : Quantity available; Quantity On…

Hi Evan, thanks for your help, that report seems to work fine :D

Actually Evan, it doesnt fully work, the report is taking into account item adjustments and item receipts for purchase orders etc. It needs to be based only on sales orders, but i cant include this in the criteria otherwise it looks through them and strips out everything and i cant do it based on a summary either :( any…

Hi Evan, i tried pasting that query into the forumla field but it wont let me add the row to the summary. Do i have to paste it exactly as you put it down?

Thanks Evan, is clear to me now :) tried it out and seems to work perfectly. Thanks again.

anyone, please? :)

Something like this: var items = ""; for ( var i = 1; i <= nlapiGetLineItemCount('item'); i++ ) { if (nlapiGetLineItemValue('item', 'newquantity', i) < '0') { items += "\n" + nlapiGetLineItemText('item', 'item', i); } } if(items != '') { alert("The following items will result in a negative stock level.\nPlease amend them…

Agreed, using a client script to run through each line to determine the new quantity, then fire an alert if it goes below 0.

Hi John, we too have around 3000 skus, with around 1000 locations. The bins seemed to work fine at first, however a few months in we noticed that stock levels were going a bit funny. At a closer look, we noticed that it was possible to not only change stock levels on the bins, but also on the "On hand" level as well (In…

Just a suggestion but you might be better off not using bins. We used to use it and it screwed all our stock levels up.

We had a meeting with MetaPack a few days ago and the solution seems very good. The integration with NetSuite is as follows. The MetaPack system will download all orders that are pending fulfilment. From there you can print order labels from one system. For instance, we ship via UK Mail and Royal Mail. We currently use two…

Bump - Has anyone got this fixed yet? Its starting to cause us issues. Over time stock that has been received and orders that were previously binned as there was not stock are not appearing in the pick ticket bulk list. Our customers are phoning us askingwhere their goods are and we cant give them a decent answer.

Did we get any further with this, we are having alot of problems with this issue. We have examples whereby we print the picking ticket but the customer phones back and wants it shipped at a later date. At the moment we have to keep a manual copy of the picking ticket so that its not forgotten. Another point to add on this…

Does anyone know of a way to run a script that will either input or amend a value on the system notes? I really want to get this problem fixed with the picking tickets. If we are able to input a record which is "Picking Ticket Printed = False" or able to edit the same record and change it from True to False we could get…

Nope, however, there is a strange thing in the system. I have seen instances in the system notes where the status has changed form T to F, but i dont have a clue how it was done.

Oh my god, what the hell ! Just logged in for first time since update, i absolutely hate this new design! Everything is so confusing to read and why is everything so BIG! Im having to scroll down twice as much now, before almost everything fit on one screen. NetSuite, another fantastic job, rather than fixing existing…

We have ZERO users using a touch screen system and never will have, order entry etc is far easier with a good old mouse and keyboard. Talking about saved searches, the filters should have been left at the bottom, some of the drop down filters almost disappear into the rest of the screen because there are no borders around…

Is it me, or did i see a post from a NS employee last week telling us this would be released on April 30th? Its now May the 1st and nothing has appeared in the enable features section....

Where is the beta help document for this? Thanks.