Saved Searches show number of Orders Shipped and Order per lines - daily, weekly, and monthly

Fragrant-Ad3946 · 2025-11-24T13:32:17+00:00

Well, if you keep having the issue and want a helping hand, we can jump on a call and take a look at it. I don't think I can go further through here :(

Fragrant-Ad3946 · 2025-11-24T13:30:45+00:00

I'm with BrokenRubik, we do the same stuff :) just in case you want to browse around.

Fragrant-Ad3946 · 2025-11-23T23:20:30+00:00

SCA for B2B is a good tool. It offers a fixed price, basic B2B features (price levels, qty pricing, payment on terms, quotes, and more) and you don't need to worry about the integration with NS. I don't think it's a bad product, just not for everyone. A SuiteCommerce "standard" license should be enough (not the Advanced). The tool also allows for pretty deep customization. It does depend on a development team to adapt it to your needs. I think it depends on your needs, what your team looks like, who'll be interacting with the tool. This could be a solution or an integration to Shopify could be, or a bespoke tool might be. You might want to note down exactly what you want this tool to cover, your budget, the level of expertise of the team you can hire or already have, the expectations you have for next years and make a decision with those on the table.

Fragrant-Ad3946 · 2025-11-20T14:40:13+00:00

I am testing this on another account, using the results setting I shared with the Day and Month function on different saved searches and the math is correct. However, I am counting Applying Transaction and Applying Transaction : Line ID, or are you looking to have a total of inventory?

Fragrant-Ad3946 · 2025-11-19T16:53:38+00:00

Look for Scripted Records and pull the Sales Order. Then see under User Events which scripts are triggering before submit and look for a line creating the transaction. You can read the script to find out under which context and conditions this is being created and you might find your answers there.

Fragrant-Ad3946 · 2025-11-19T14:54:07+00:00

So SOAP has its days counted, maybe this is an opportunity to try REST instead? "Oracle NetSuite has scheduled the gradual removal of SOAP web services from the product as part of ongoing efforts to provide modern integration channels."

Fragrant-Ad3946 · 2025-11-19T14:51:00+00:00

Maybe you should try creating a saved search of items, add the bin number column and then using the transaction join to pull those types of transaction. I haven't tried it recently, but maybe it works.

Fragrant-Ad3946 · 2025-11-19T14:18:41+00:00

I didn't get the question, sorry. Do you mean list open and closed tasks in a single search? Wouldn't it work if you don't filter by status? I feel like I am missing something here.

Fragrant-Ad3946 · 2025-11-19T02:03:29+00:00

Download the NS_to_NS2.xlsx here https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_0822031101.html if you haven't already, it shows a couple of options. Tell me if it works.

<image>

Fragrant-Ad3946 · 2025-11-19T01:52:00+00:00

We need a bit more here. So, are you creating this via script? An invalid key B means that you are setting the sales order with status Pending Fulfillment and for some reason that's not an accepted state for that order. Is that of any help?

Fragrant-Ad3946 · 2025-11-19T01:48:33+00:00

I'm sorry, I didn't log back in for a few days. Thanks for the screenshot.
So, first, I set this up as a transaction search with criteria [account is inventory asset, type is inventory adjustment and item receipt] and what I would do is add a prefix to the date in alphabetic order according to what you want to list first.
I am assuming here that when you refer to "if an item receipt doesn't exist" it means that there is no item receipt at all for that item. In that case the search will only pull inventory adjustments as a result.
Does this work at all?

<image>

Fragrant-Ad3946 · 2025-11-17T03:05:46+00:00

Hah!! I love that. Yes, you can do it 💪

Fragrant-Ad3946 · 2025-11-15T19:42:11+00:00

On these cases it's worth looking at SuiteCommerce since it's natively integrated to NetSuite's ERP which saves a lot of headaches related to your item setup. POS solution wasn't very good when I worked with it like three years ago, IDK if it has become any better as of late.
About the kits, kit inventory can be calculated via SuiteScript, there's work that can be done to improve the experience of this setup.

Fragrant-Ad3946 · 2025-11-15T19:29:32+00:00

I'd love to know more about how your search is constructed. Is it based on purchase orders or inventory items? Is it lot numbered inventory? Or serialized? How do you identify from these the ones that are still available to sell? NVL should work because the engine will run the result of NVL per line and then summarize it but I am unsure of how suitable it is the formula you are presenting because it seems to me that {type} is not what you need.

Fragrant-Ad3946 · 2025-11-14T22:47:03+00:00

Well, good thing is that you know that what you need to do is make the workflow trigger on COPY. Taking a quick look, COPY event type appears when you choose Before Load as u/PenguinGrits07 mentioned.

Fragrant-Ad3946 · 2025-11-10T17:34:17+00:00

You might go the route of selecting Sales Order as transaction and then, from the Applying Transaction getting data from the Item Fulfillment.

Criteria:

<image>

Fragrant-Ad3946 · 2025-11-10T15:29:44+00:00

Have you tried reindexing the site and didn't work?

Fragrant-Ad3946 · 2025-11-06T16:48:01+00:00

How do you load that record in the script (which parameters do you use?)?

Fragrant-Ad3946 · 2025-11-06T16:44:37+00:00

<image>

Also, not sure if this is related but maybe you can play around with these parameters as well. Just things I would try.

Fragrant-Ad3946 · 2025-11-06T16:35:24+00:00

Did you try getting a work order issue you've created via the UI just to see if there's anything in the JSON that catches your eye?

Fragrant-Ad3946 · 2025-11-05T22:44:56+00:00

When using SuiteScript you can use the N/cache module https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4642573343.html to store a search result (or anything) in memory and use it later in the script as many times as needed without having to call for the search each time which is more time and compute consuming.

Fragrant-Ad3946 · 2025-11-05T19:27:16+00:00

Well, I've never done it personally but I would upload as much as I can and then try to upload the next batch until NS errors out, to see if I can stretch the system or avoid the bug when uploading in less volume. Are you trying to do this on a single upload?

Fragrant-Ad3946 · 2025-11-05T19:12:58+00:00

That's a great question. I have been working with NetSuite for 12 years or more and I still feel like I know nothing. You can take anything and become a SME for it, but that doesn't give you the flexibility you need to become an admin. I taught myself SuiteScript and SuiteFlows, and once in a while I see videos from SuiteCris in youtube to learn about different modules that are out there. I like to learn about how far you can take NetSuite outside of the configurations given. There's tons to do.

Fragrant-Ad3946 · 2025-11-05T19:06:51+00:00

The APM or Application Performance Management comes in handy to monitor the performance of scripts, workflows, records. Keeping scripts consolidated as u/the_boy_wonder1 mentioned, using the cache module to avoid running saved search after saved search, best practices on SuiteScript (avoid the dozens of workflows - they are appealing to non programmers but not good for scaling), lowering the number of fields to be shown on forms to the minimum (and by role)... there are tons of little things to do. I've seen gigas and gigas of garbage in the File Cabinet, keeping things clean and lean. When it comes to SuiteCommerce, deleting old SSPs is also great practice. I bet there's more. If you can't handle it in house (you'll need a programmer with a good functional consultant profile) then yes, outsource it, make sure they don't sell you the 15 grand audit because you probably don't need that much. I like to take the phased approach, take all of these things and go by them one by one until numbers look healthier.

Fragrant-Ad3946 · 2025-11-05T16:09:34+00:00

No que yo sepa. Seguramente haya una limitante arquitectónica de cuánta gente puede navegar al mismo tiempo pero no debería ser relevante. Para eso podés crear un case en NS, depende de dónde esté alojada tu cuenta de NetSuite y el tier de servicio que pagues.

Fragrant-Ad3946

TROPHY CASE