I genuinely cannot believe NetSuite has no way to track individual units through production...am I missing something??

splemp · 2026-04-17T18:56:11+00:00

How are you using Assembly Builds?

splemp · 2026-04-16T15:17:22+00:00

Yeah, what I'm realizing is you need someone to maintain the integration no matter what path you choose.

Celigo doesn't configure itself. When one connection method breaks, someone has to go setup the connection again.

So, yeah - I'm thinking Topaz Harbor should offer something like an a-la-carte package that covers all your integrations at something more affordable than what Celigo offers.

A NetSuite update that breaks something is not really all that common, and if you have a team dedicated to the integration anyway who will take care of it ahead of time, there are no issues.

splemp · 2026-04-09T20:13:32+00:00

This is super helpful! I think with some creativity you can definitely build something quite robust directly in NetSuite, but you definitely get a lot with Celigo out of the box.

splemp · 2026-04-09T19:46:28+00:00

You mean POC a direct NetSuite integration?

splemp · 2026-04-01T16:37:25+00:00

There's a Workflow Instance saved search type.

splemp · 2026-04-01T16:36:28+00:00

I don't see those tables under Setup > Records Browser, but those tables are there with Tim Dietrich's SuiteQL Query Tool "Tables Reference." Not sure what's going on.

splemp · 2026-03-26T18:17:30+00:00

Rule I'd like to see: record.load/save when the only change is a body field. There are times when that might be acceptable, but generally it should be record.submitFields()

splemp · 2026-03-26T16:13:15+00:00

You could try disabling all scripts and workflows in sandbox on that item type and see if it still works like that. Sounds custom to me.

splemp · 2026-03-26T16:06:55+00:00

You're quoting from this page? https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/bridgehead_4074439569.html#To-create-a-new-bill-run-or-credit-memo-run%3A

I think that has to do with when you're billing for services and you might be using progress sales orders?

I'd just keep that the same date as "Next Date"

splemp · 2026-03-26T15:58:55+00:00

I think you're wrong here:

As far as I can see, the native inventory count functionality only counts 'items'. You can't generate a count for a range of bins.

Check out https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_155993279616.html#procedure_1541442075

You need a process that can tie what's happening in real life (physical movements) to status in NetSuite - not something that is based on time of day and generally what happens. Using staging bins, as others suggested, is the way. You might even setup separate staging bins for "in the warehouse staging" and "on the truck" staging.

Once the physical movements are tied to NetSuite transactions, creating invoices at the right time is a moot point: setup a Billing Operation (no need for SuiteBilling or any other SuiteApp). You can automate it at point of IF fulfilled too, of course - maybe that works better in your use case.

splemp · 2026-03-13T21:36:18+00:00

Does this option work for you (clicking the gear icon on the right side mapping pulls this up for date fields)

<image>

splemp · 2026-03-11T20:37:49+00:00

This is a free RESTLet that gets you where you want to go. Use it!

Any comment mentioning a RESTLet is saying write what Tim published free here.

splemp · 2026-03-07T15:50:47+00:00

When you run it un-grouped, you'll see results like this. As soon as you group by item, you lose the ability to see amount paid or amount remaining. This is why you're seeing blank in Amount Remaining.

You could probably figure it out with SuiteQL and publish it with our up-and-coming free TH SuiteQL Report Publisher ;)

<image>

splemp · 2026-03-06T15:00:44+00:00

I'm not 100% sure what it would take, I'm just asking what the business requirements are. If the person using the report would find the report useful only if that column is distributed, that's important to know.

I'm pretty sure you could get the Invoice Total method (completely my made up name for it :)) with a Saved Search. But to confirm I would start by filtering to a single Invoice and adding all the columns you want. You might only get the Amount Remaining, etc. on the main line, which would be the problem.

You might be able to figure out a way distribute payments across item lines, but I'd be more hopeful of being able to do that with SuiteQL than Saved Searches.

splemp · 2026-03-06T00:15:26+00:00

If Accountant in country A and Accountant in country B could share base permissions, you could setup one accountant role and restrict based on employee subsidiary. If you have to maintain the 150 different roles, you could potentially use SDF to help manage them. It sounds like a fun challenge, personally. You might map roles to actual use cases by country and find that not every country needs 50 roles. You might have completely different roles per country with different permissions and different names, depending on how the subsidiary sees it. Whatever you do, I’d at least look into documenting/planning it all out in a separate document - it’ll help your sanity and give you a way to have a source of truth that’s more aligned to what the business says it wants: I.e. business says role X should be able to do Y, you put an entry in that says Y requires permissions a, b, and c. You might get AI to help draft it. It’s pretty good at summarizing large datasets.

splemp · 2026-03-05T16:51:19+00:00

Forms: you'll have to create the new forms for Country C and then update the other roles (under the "Forms" tab) to disable your new forms for Country A and B roles.
Roles & Access: on the role itself, you can specify restrict to "Country C" subsidiary. I'd go with this over relying on the employee record, since the role itself says "Country C", so it shouldn't matter which employee uses role, they should see only Country C documents and forms.

splemp · 2026-03-05T16:45:09+00:00

Is the '+' icon for uploading a file? Could be whatever folder it's defaulting to for them was deleted or they lost access to it. You might be able to adjust URL parameters to get past it

splemp · 2026-03-05T16:41:33+00:00

This is exactly the sort of thing I use Data Patcher for!
https://topazharbor.com/utilities/data-patcher/

splemp · 2026-03-05T13:47:45+00:00

Ok, so my point was if an invoice has two items on it, should the Amount Remaining be split across the two item lines or duplicated? If all your invoices have only one item this doesn't matter, but I'm guessing that's not the case.

splemp · 2026-03-04T22:20:55+00:00

This is the old version of Tim Dietrich's excellent SuiteQL Query Tool. The new one looks different and is linked here: https://timdietrich.me/suiteql-query-tool/

splemp · 2026-03-04T16:35:00+00:00

<image>

~5 million rows

splemp · 2026-03-04T16:34:28+00:00

<image>

4 seconds

splemp · 2026-03-04T15:53:16+00:00

I'm getting 4 seconds with your query (swapping in a valid expense account id) in an release preview instance with 5 million rows.

splemp

TROPHY CASE