Someone delete a transaction?

Yes, but more than likely we have deleted a lot more than just one transaction

That works, but might have unintended consequences elsewhere if you have transacting numbering configured

Hmmm you're talking about with aut-generated numbers, right? But those are for Document Number and not necessarily the Transaction Number, right?

i've run into this issue before, where the transaction number does not match the document number, netsuite basically said they're not guaranteed to be in sync. And there was another field for me to use instead... let me dig around and see if i can't find the results from that ticket. my issue was with item fulfillment records though

Ah that's so friggin silly... Well, if you were able to resolve the Item Fulfillments, I think I should be able to resolve Invoices, since at least those are able to be updated via CSV

oh, looking back, it appears i had a mis-match between tranid & transactionnumber, where one was named,

Item Fulfillment #IF-12345678

, but the other was

IF-12345677

YES

where here was the first part:

Based on our engineers, the encountered behavior is as expected since the transaction number and document number are independent numbers. Upon creating a transaction, the transaction number is assigned based on the numbering setup and right after the transactionnumber generation, the same happens with the document number and independent document number sequence.

If there are two transactions created at the same time, there is a possibility that the second transaction gets earlier to the process of assigning the document number.

The suggested workaround is to incorporate some delay into the script to prevent the occurrence of having two transaction generated at the same time but we still cannot guarantee that the numbers will be the same.

LOL what kinda solution is that

this was a good one too: 🙄

Case: 3114376: Defect 503951 : Item Fulfillment the tranid shows one value, and the transactionnumber an incorrect value

Status Change:

Status changed from Open - Under Investigation to Closed - As Designed

Ooooo I bet it's an enhancement request that will never get looked at

I think in the end, we ended up using the 'Transaction Number' field, now this was in a saved search

One thing I mentioned here is disabling the preference for Global Search Includes Transaction Numbers

mine is unchecked also, i'm trying to find the search that this was on, because it was an interesting field

Ah I gotcha my man. Really, this issue was specifically for the Global Search. That being said, I super appreciate you looking through your notes! 🔥🔥🔥

i think you're issue is similar in a sense, when netsuite generated different transaction numbers, and document numbers (for the same transaction record), they both showed up in the global search as well

Yeah, it's definitely similar. But I guess, I just don't really understand how we can start using the transaction number, if that makes any sense - when the Document Number is what is shown in the UI. To get the Transaction Number and start using it would be kind of a pain, don't you think? You would have to go to the XML every time, and even then, since there is no setting to disable the Doc Nums from the Global Search, you would still run into an issue where you're pulling two different transactions with the same number.

no i get you, you run a global search for invoice 123456 and get back 2, then you're like great, which one is the real one

Maybe you could turn on "allow override" and script an update process

Yeah I was thinking about that - not sure if it's worth it, since we easily have over one million invoices

Sounds like a bad idea.

Think we're gonna just go with this preference for now... I'm really thinking that might be the solution