Your answer seems to be incorrect. I tested it, and it deleted both records, the Lead and the Contact. Remember that these are created when someone adds a Contact without a Company. Netsuite automatically creates a Lead record that is exactly the same as the Contact. It's confusing and problematic. I'm just trying to…

I'm sorry. it's there. I don't know why I didn't see it before...

Thanks. I'll use internal ID. (by customer ID I mean just the "ID" field in the Customer table.)

ok. sounds like it makes sense to do the leads only first then contacts only. thanks for all the help. I may have another question, but I think that's it for now.

Thanks. Just out of curiosity, why do I have to use an external ID instead of internal ID or the customer ID I already have?

@Michelle Jabanes-Oracle Thanks so much for your extra time on this. I think I'm following what you are saying. If you know, why is External ID functional while Internal ID creates duplicates? But to follow your instructions, I will need help with the question below. I asked that above. I'm not sure if you saw it. I see…

Ok. Thank you for verifying. Please enter a bug report for me, if you can, that netsuite incorrectly duplicates leads when uploading related contacts in this way. If you wouldn't mind, I have 2 related questions. First is how to get a download of the various 'people' lists, like Lead/Prospect/Customer/Contact. I think…

@Michelle Jabanes-Oracle The Company ID was mapped to the Lead record. I see that and agree. But I am importing to Relationships with Leads and Contacts Together. You can see in my screenshot that the available fields are organized as lead, lead-address, etc. There is no option for an uncategorized Company Name as in your…

Thanks for clarifying. That makes sense with Lead then Prospect then Customer. How does that relate to Contacts? I did successfully upload as below. However, even though I had current Lead IDs in the Customer ID column (along with the correct Company Name), and I chose "Add or Update" for the import, I got all new…

Thanks. 2 questions: Can this be done with a Lead? I just tried it and it said the 'customer' wasn't found. It returned in the csv import results the proper ID, but still said it couldn't be associated. Also, how do I tell the difference between a Customer and a Lead? It's very confusing having lead, prospect, customer,…

Note, I did fix my problem by simplifying the logic. I only have one exception case, so this works. However, this does not answer the question because I may need if/elseif/else logic in the future, and this is cleaner code that works due to the simple situation I need to handle. Please address the question above. But I did…

We've been updating the class field manually and it hasn't created an issue. Reminder that I am talking about the line-item class field not the transaction body class field. Maybe I am misunderstanding. If we update the INV line class field from blank to something, then what happens? For example, would you expect that to…

Thank you for bringing this up. I don't understand though. If the Class field is blank, which they all are now, and that is wrong, we want to update the Class field manually. That would create an issue? Also, we would only want to change it if it's blank, and we would only want to change it once to the correct Class (as…

The answer is I didn't have the Class field visible on the Sales Order Form, so it didn't populate. Now that it's visible, it will populate automatically. I left it off because I didn't want people to change it to something wrong. I didn't realize it would be left blank.

Updated question and screenshots. Functionally the same, but hopefully more clear: This invoice has a Item (standard) and a Class (standard) filed in the line item. When we enter an Item, we want the Class to fill out automatically based on the information in the Item record. * with hierarchy. What's the easiest way to do…

Netsuite. Netsuite Suite Answer. Community. Ideas... Massively confusing. I finally found it at least.

where can I access this article? I gave a screenshot that shows if I Search with the 356104 number, nothing comes up. What search term did you use to find it? Enhancement # -356104 Customization > Forms > Transaction Forms > Customize a Deposit form > Under Screen Fields > Please have the ability to customize and add…

I'm talking about the article that addresses my issue. Enhancement # -356104 Customization > Forms > Transaction Forms > Customize a Deposit form > Under Screen Fields > Please have the ability to customize and add column fields under the Other Deposits and Cash Back tabs

custhelp.com? it sounds like oracle has so little commitment to bug fixes they've banished the list to a whole different domain. Also the listed reference above from Angelica yielded no results. Is there some other way to search?

you have given 5-digit number but no hyperlink. how do I find it? it's not on community.oracle.com - where do I put in those numbers?

ok, so it's another unfixed bug in the system. please provide a hyperlink to the suiteideas page instead of a number since it's hidden in a totally different website. I can barely keep track of all the different websites oracle maintains for unfixed bugs and issues. I have a link, but it looks like the site is shut down.…

We'd like that FROM field to show up on Other Deposits and Cash Back. (or some other customer name field). How can we customize those alternate sublists on the DEP transaction?

Thank you for thinking of me, but please don't ping everyone to say you can't help or that you will help. Just wait until you can. Otherwise it wastes my time with an email notification that isn't an answer. I got two emails to to say I didn't get an answer.

that's it. thanks!

I think I'm ok with the DEP transaction. I'm asking about the PYMT transaction now. Below is essentially what I'd like to do (not to move Customer, but to make another Customer or custom-type Customer field in the PYMT line item... or to have the Customer field from INV2019 show up by by the Date in the Applied To field…

Yes, I need it for reporting. I used a bad example. Yes the 'From' line has customer info. That should work. But PYMT doesn't. But my main question was how to edit that section, on DEP or PYMT. Do you know that? I don't see anything in the customer forms...

Thanks. I don't know why I didn't see that. Is this correct as well? It doesn't look like I can leave them blank. Sourcing & Filtering: Source List = Customer (Line), Source From = Customer.

please stop pinging me without an answer. this is so irritating. why do you do it?

done. thanks

I did find the inactive list. thanks. I removed the role associated with the account, just in case. I have no roles on that login now. Can I feel safe there's no way to access our account? Is there any escalation or netsuite follow-up to police these attempted logins?