Ben_1984

Looks like adding the Line ID and setting to to null is working for us too! Thanks @Elychelle Gulen-Oracle (again, apologies for not reading your initial reply close enough).

in Not sure why I'm getting the CSV import error, "This record contains duplicated key or keys" Comment by Ben_1984 Aug 22, 2024 2:47PM

Hi @Nicole Mendoza-Oracle, yup! Appreciate the reply and the assistance. I will be interested to see if other members pop in with any insights based on their experience, but you've given me some good references to continue troubleshooting on my end.

in How to handle two scripts trying to update the same item record in Xedit? Comment by Ben_1984 Aug 21, 2024 6:59PM

Thanks @Nicole Mendoza-Oracle, really appreciate the reply. The errors I'm getting will sometimes reference one script and the other times reference the other script, so probably no workflow in this case (but, I didn't even think about conflicts between workflows and scripts, so it's good to be aware of that as a…

in How to handle two scripts trying to update the same item record in Xedit? Comment by Ben_1984 Aug 19, 2024 7:09PM

Hello @Elychelle Gulen-Oracle my apologies! I read your initial response too quickly and didn't register that you were saying to include the line ID but set it to null. "In the Field Mapping of CSV Import, add Line ID (Purchase Order Items : Line ID) and click the pencil icon along it then select Null." I've updated my…

in Not sure why I'm getting the CSV import error, "This record contains duplicated key or keys" Comment by Ben_1984 Aug 9, 2024 3:41PM

Hello @Elychelle Gulen-Oracle I appreciate the help troubleshooting this issue. I realize your suggesting to test with just a few lines, but I'd like to clarify how this would end up working for the full files: What I'm understanding is that I would take every line number on my existing PO and put it in my CSV with…

in Not sure why I'm getting the CSV import error, "This record contains duplicated key or keys" Comment by Ben_1984 Aug 7, 2024 3:13PM

Hi @Elychelle Gulen-Oracle I appreciate the follow up! All of the transaction records I'm updating have multiple lines being updated (usually a couple hundred lines each, on average). EDIT FOR CLARITY — I'm not updating the individual lines for any of the transactions, I'm overwriting the full sublist for all the…

in Not sure why I'm getting the CSV import error, "This record contains duplicated key or keys" Comment by Ben_1984 Aug 5, 2024 3:54PM

@Elychelle Gulen-Oracle appreciate the reply! Not sure if this addresses the issue for a couple reasons: 1] I am using the "overwrite sublist" option, so I would assume it shouldn't matter (just for the sake of troubleshooting, I just checked the failed transaction and each item is only listed once). I should have…

in Not sure why I'm getting the CSV import error, "This record contains duplicated key or keys" Comment by Ben_1984 Aug 3, 2024 1:39PM

Looks like this is just a consequence of how things are designed. Got the following replies: —— "NetSuite has carefully reviewed the information on the issue and we have concluded that the behaviour is working as expected. We are reviewing SuiteAnswers to ensure that this is documented." —— Good day. We received an update…

in In CSV transaction imports has anyone had trouble updating and adding transactions at the same time? Comment by Ben_1984 Jul 25, 2024 2:52PM

FYI, got this update from support, "please be informed that the case is being reviewed for possible defect filing."

in In CSV transaction imports has anyone had trouble updating and adding transactions at the same time? Comment by Ben_1984 Jun 5, 2024 5:21PM

@Patrick Fresnosa-Oracle thanks for the follow up. I've created a Support Case. The way the documentation reads, I would expect to be able to add and update multiple transactions at the same time, https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N345294.html. Appreciate the independent confirmation and…

in In CSV transaction imports has anyone had trouble updating and adding transactions at the same time? Comment by Ben_1984 May 29, 2024 6:42PM

Hi @Patrick Fresnosa-Oracle Yup, two separate imports works (just adds an extra step for our weekly operations). When creating only the new transactions via import, I'm selecting "add" for the data handling (I haven't tried "add or update" with a CSV that only has new transactions in it, not sure if the issue would arise…

in In CSV transaction imports has anyone had trouble updating and adding transactions at the same time? Comment by Ben_1984 May 25, 2024 1:30AM

Thanks John and Patrick, I appreciate the attention to this question, and it's useful to see independent confirmation of the issue. That's an interesting idea respecting the external IDs, but, unfortunately, for us the purchase orders being updated do not have external IDs. Full context: Each week we are using NetSuite's…

in In CSV transaction imports has anyone had trouble updating and adding transactions at the same time? Comment by Ben_1984 May 24, 2024 2:28PM

Ben_1984 Red Ribbon

Comments