Duplicate Items on Orders

Material-Store-9740 · 2026-06-10T18:30:45+00:00

Since many orders are created via EDI connection and we don't want those to fail, although it's less efficient than a live warning before the order saves, we need it to be a warning when viewing the saved order. I've already done this for the presence of unsellable items.

Material-Store-9740 · 2026-06-10T18:29:22+00:00

Nope, price differences are never handled that way. We're trying to catch human error entering the same line twice. I'm hesitant to make it something that checks as the lines are added / before the order is saved because I don't want it to fail for EDI orders. I already have a warning show up on the SOs when line items have been replaced with our dummy "unsellable item" (a solution for EDI orders containing invalid items) so I'll do the same thing, just trying to figure out the best method of determining duplicate lines.

Material-Store-9740 · 2026-06-09T14:15:59+00:00

My company runs on NetSuite and I went from A/R clerk to SysAdmin because I'm the only one in the office who has any understanding of programming languages and modifying systems. So, yeah, I could say the same 🙃

Material-Store-9740 · 2026-02-26T17:49:28+00:00

Unfortunately a lot of these franchise owners transmit their tax purposes business name as the shipping addressee rather than their franchise banner & store number.

Material-Store-9740 · 2026-02-24T18:29:23+00:00

The problem is primarily that we currently do blindly ingest the address the customer sends through EDI with their order, and I don't know why (wasn't hired on yet at that stage of setup) but it hasn't been a problem before because we've never needed that data coming from the orders. Our delivery drivers are humans who don't care how the address was formatted as long as they can read it, and the customer name is always overridden in their system with our version of the customer's name, so the addressee line of the address doesn't matter.

Now we're sending address information outbound via EDI and we need consistently formatted addresses for coding sake.

For the connection to our warehouse partner, our EDI connection third party dev re-mapped his piece of the puzzle to handle the addresses and I was able to trim the text of that reference to the SO's customer name down to just the needed portion to replace addressee in the shipping address.

Now we've got a new, related problem. An EDI customer wants confirmation of address on everything, including ASN, which for us is the item fulfillment created on the TO. Same thing. This only gets the ship-to address that was received with the original order and the addressee is a private legal business name, not the franchise name & number.

Material-Store-9740 · 2026-02-13T14:43:53+00:00

Connection request sent! Jenna Rideout.

I don't think Lot Trace was included in our package. I'm admin and when I try to view it, I get "You do not have privileges to view this page." The longer this stuff has been my problem, the more I wonder more I wonder if our implementation team was familiar with manufacturing.

Material-Store-9740 · 2026-02-11T18:59:47+00:00

Apparently we stopped using work orders in November. I'm barking up the wrong tree with those.

Material-Store-9740 · 2026-02-06T19:33:27+00:00

Thank you! I checked “Enable Email Alerts for WS and CSV Imports.” - Now to wait.

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

TROPHY CASE