This is rather concerning to me. Last night I created a custom item field and then I began a csv import to upload to that field. There are about 25,000 records that need to be updated and each record will have around 60 characters. As of now, the import is at 50% - that is after 18 hours!! This has to be a performance…

I can't see where this is possible. Saved Searches only show 1 category. We needed this functionality also. The data is there, i just don't know how to get it.

Anyone know how to get a saved search result that shows all the categories that the item is assigned to?

Hey - I fiddled till it worked. thanks again for your help

Thank you very much!

Thanks Mike - I am a workflow guy and I can confirm that I can not set the value for this field in a workflow. I may have to find a script guy to do this for me or it may be time to take that Netsuite Suitescript class.

That is exactly what I did. I now have people asking me to delete records in the database because they think they are duplicates. I am going to go through and mark 'inactive' all of the client records that were created. Be nice is you could add a contact to a sales order. Not sure if there are other requests for this…

The only way the customer would see those fields is if you have it showing on the printing tab of the form. Just make sure those fields are not selected on the printing tab.

We use the PO rate on Sales Orders but I would also like to use it on Opportunities and Estimates but it doesn't seem that it is available. Am I missing it somewhere?

Thanks for the reply. There is one scenario that can occur where there could be a duplicate. We use numbers for our items. Let's say you have an item called 1234. If someone isn't careful, they could name a child item of a matrix item 1234. Netsuite would consider the name to be (parent name):1234 but i have seen it show…

Wow - that's a lot of fiddling. I switched the Custom Item Field to "store value" and it did remove the data. However, when I edited the item and saved it, the field did not populate with the internal id. Bummer. The reason I want the internal ID is because we will use that number to create a item fulfillment via web…

Thats exactly what i thought I could do, but I can't find "internal id" in the source from list. Is it called something else?

Too bad there is not a way to use the getattribute tag in a custom field inside netsuite. Maybe there is another function that behaves similarly. In case someone else is reading this: I'm trying to reference the image url of the parent onto a matrix child record. I can hardcore this into a custom field but I really need it…

Thanks for working so hard on this - i really appreciate it! I created the custom field on the item record and you were right - it sources the internal id perfectly. I created a custom transaction column field and set Source List to item but in the Source From list, the new custom field is not present. Which is really…

Thanks for responding. I do have show internal id's selected. I'm not sure what you mean by a formula field. Could you give me an example? Thanks!

has anyone been able to confirm that this is a problem or not?

Yeah - it works for the administrators but not any other roles

We needed the exact same thing - we ultimately had to have a developer create a website that can push and pull the date in and out of NS via webservices. It works pretty well, but it is a little slow. DLE would be 100 times better and there are a number of other ways DLE would benefit us for transactions. I remember…

Do you close the RA after you issue the refund? Thanks

I think the preference is found under Setup > Setup Accounting - Order/Shipping Tab. The field is called "Refund in Advance of Return". I believe this allows us to refund before we receive. I am still a little nervous - not quite sure if there are some unintended consequences with closing the RA after we have refunded. Any…

Thanks for the info. The only things strange to me is that when I view the Return Authorization, we do have the option to Refund or Receive. If I choose Refund, I still have the ability to Receive. So, I am thinking, if I first Refund the customer and afterwards Close the RA, would that achieve the results I am looking…

We receive a credit, however, many times it is a full month later. I could see where the vendor bill credit might work but it would only work if the items are taken out of inventory when the credit is created, not applied. I will have to check. Thank you for the response!

Thanks for your help Melissa. I am going to do a little more checking, but I do think it will work.

MiselaS, Can you help on this, you do not receive the RA but close it, and you still need to do an inventory adjustment? I wouldn't think that you would have to if you closed the RA and it was never received.

Here's the problem. I was creating this huge matrix item - 400 child items with 4 options. For some reason Netsuite pooped out on the last 120 child items. I didn't realize it so i uploaded a csv file to update all the new items. Well...since the last 120 items were not created intially as a matrix item, the csv file…

This does still work - and its very useful. Also, ERP Guru has come out with a Mass Delete bundle that they give away on their site as a gift. This is a script that deletes any record type in mass based on a saved search. Our accountant accidentally import 11,000 budgets - oops. I am hoping to use this to delete all of…

I cant seem to get this to work. Did you use firefox or IE when you did it. i tried it in both firefox and IE 7

Does anyone know what the Item Receipt would look like when there is a discount line item applied to the purchase order. I want to be sure that the item rate will reflect the discounted amount on the item receipt. Thanks

I like this idea but I am concerned about the fact that there is no audit trail for email alerts. We could potentially have customers that claim that they did not receive the email - and maybe they didn't - we wouldn't know. Email alerts that were working for weeks and then suddenly failing has happened to me multiple…

Thanks for the reply - the only options I see under system notes are: date field formula (date,numberic,text) New Value Old Value Set by Type I didn't see anything for user - except there is the user note field but that does not get populated if you create the lead