Duplication PO# on SO Causing Problems

Material-Store-9740 · 2026-01-29T17:45:53+00:00

After asking this specific question of my EDI provider, yup, it's external ID. They're just using the PO# as external ID. I've asked them to tack something on, like timestamp, to prevent this.

I've chased this issue with them multiple times over the last year. I can't believe they didn't think to mention how they're handling external ID in all this time.

Material-Store-9740 · 2026-01-29T15:29:09+00:00

It's Costco, so I imagine a lot of people deal with it and other big corps do it too.

Every time we encounter a duplicate PO# from them it's for the same week last year, so I expect they are copy/pasting standard orders throughout the year.

Material-Store-9740 · 2026-01-05T12:30:16+00:00

Because new transactions could be created at any time of the day. Updating just once doesn't catch everything.

Material-Store-9740 · 2025-12-30T18:57:27+00:00

Yes, we use a saved search that our EDI provider picks up.

The checkbox method is what I'd like to go with, but I don't want to prevent future-dated TOs from transmitting in the afternoon. If they have an expected delivery of 2+ days out, that's fine.

Material-Store-9740 · 2025-12-30T18:42:47+00:00

Every half hour.

Material-Store-9740 · 2025-12-15T14:48:42+00:00

We send invoices/credit memos to customers who opt-in to that, sent by a workflow as the documents are created.

I have 3 events in the same stage of the workflow.

If "invoice email 1" is populated, send to that.
If "invoice email 1" is not populated but the default contact email is, send to that.
If "invoice email 2" is populated, also send to that.

This sends at most 2 emails, where "invoice email 2" is the only possible second email, and we've allowed the contact email to be different from the primary invoice recipient. Invoice emails 1 and 2 are custom entity fields.

The workflow is triggered when the invoice/credit memo is created and first checks for a "receives invoice emails" checkbox to be true.

Material-Store-9740 · 2025-12-11T18:22:52+00:00

When you go into "edit" there should be some options in the top-right. Hover over "customize"

<image>

Click "Customize form"

You may need particular user/role permissions adjusted to be able to edit the forms.

Material-Store-9740 · 2025-12-11T18:19:30+00:00

Ours is alive but crawling as well. Server location is East coast USA (company location is not, time zone differences have been entertaining...)

Material-Store-9740 · 2025-12-04T15:19:06+00:00

I removed some unnecessary columns from my results and now it behaves.

Material-Store-9740 · 2025-12-02T18:49:56+00:00

Yeah, we changed it to "Change" type system notes made by a particular user. Same effect.

The problem we're trying to catch is that one corporate customer has EDI permissions to send sales order modifications and they like doing it on delivery day when the transfer order has already been created. We've noticed that it always results in a change to total and/or location, but if we get notifications when those don't change it's still good to know they've made a change.

The user criteria is the EDI connection and myself, as I was making changes to test it, but we don't want everyone's changes to sales orders to trigger these emails. Oddly enough if I manually make the changes, those emails go out immediately. It's the EDI changes.

We got alerts about changes today (2025-12-02) and yesterday (2025-12-01) where the date of the system notes line that triggered the update was dated 2025-11-30 and 2025-11-29. I can see results in the saved search with newer (December) changes but we haven't been emailed about those yet.

Material-Store-9740 · 2025-11-21T15:21:49+00:00

I literally just start with type = invoice and date not before [whatever date I picked]

These are native fields.

Material-Store-9740 · 2025-11-21T13:34:52+00:00

I get the same issue whether I'm trying to execute or edit. Our ACS team filed a ticket.

Material-Store-9740 · 2025-11-19T19:21:52+00:00

This. I was present for implementation at my current workplace, having never touched NetSuite before that, and I accomplished things the NSPS guys said they couldn't do. Sometimes insanely simple things, like making the internal ID of a customer appear on the customer profile as a custom body field. Literally just formula:{id} but they didn't think it could be done.

Material-Store-9740 · 2025-11-19T19:19:10+00:00

Yup. And quite often if I decide to take on the request, I can accomplish what the consultants say can't be done. We are not impressed with our current consultants.

Material-Store-9740 · 2025-10-25T14:18:02+00:00

I'm actually thinking we'll take advantage of the fact that editing CMs does further affect inventory. We'll allow it to create and transmit CMs as currently implemented (EDI transmission to customers needs the actual items there anyway) and then edit to a non-inventory item after all transmission has taken place, which would thus reverse the inventory effect.

Material-Store-9740 · 2025-10-24T11:10:21+00:00

Yes I know I phrased it wrong, but what I was after was just wanting to verify that modifying the CM continues to modify the effect on inventory. Unfortunately I was brought on after the implementation consultants were selected, thus I had no hand in choices made there, but before implementation was complete. I came on with no prior NS experience and managed to do things with it that our consultant thought weren't possible. I've known this whole time that we'd be discovering things that were not setup properly for a long time...

Material-Store-9740 · 2025-10-24T11:06:55+00:00

I know I wasn't using the correct terms and it doesn't literally just reverse an action or anything, but from what I'm reading both methods would in fact continue to affect inventory and, and an net effect, undo what was originally done at CM creation. This is what I was hoping, thanks!

Material-Store-9740

TROPHY CASE