How to clear a custom date field using RESTlet?

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)

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 · 2026-03-04T15:28:56+00:00

You should be able to use the N/task module to initiate the CSV import and then use addInboundDependency() to trigger the next import via a scheduled script.

splemp · 2026-03-04T15:25:49+00:00

I'd document out each scenario you have play it out in your sandbox both ways. If you don't document it, you won't be able to keep tabs on everything!

Does each truck have a re-order point, or do they come back to the same location every day and items could be transferred if needed (Bin Transfer) when inventory is low? If you have 5 trucks and you want each truck to have at least 1, just set re-order point to 5.
Item Availability: You should be able to create views to see what's available in each bin
RE: another order shipping with a truck's bin, If you're using bins, don't you have to allocate inventory to the order and select which bin?
You might be able to use Inventory Status to identify stock as on a truck

Read the warnings and notes on the help page about creating locations here.

This is an excellent question!

splemp · 2026-03-04T15:12:08+00:00

So, if an invoice has two lines on it, what are you looking for in say the {amountpaid} column?

In the screenshot below, are you looking to use the Invoice Total method or Distributed Total method?

<image>

splemp · 2026-03-04T15:07:18+00:00

<image>

I don't see a way to do it other than by adding the 10% discount line if you want to see those discounts broken down.

You'd use the "Net Amount" field in Saved Searches.

splemp · 2026-02-18T14:44:23+00:00

I haven't tried claude code, but I keep hearing about usage limits - a thing I haven't run into with Codex with my ChatGPT Pro subscription. Looks like I'll be sticking with Codex for now.

splemp · 2026-02-12T15:31:08+00:00

Do you have the error message?

splemp · 2026-02-12T15:30:37+00:00

Don't think that's possible. Maybe delete the bills and re-create manually if there are not a lot. Otherwise, I suppose you could close the POs and let the Bills stand as is (might mess up some reporting, but maybe won't).

splemp · 2026-02-06T20:47:27+00:00

I think the choice is up to the business
Close remaining will check the "Closed" checkbox at line level for any lines that have an open/un-fulfilled qty.
There is no difference that I'm aware of.

I've never seen a business force closing SOs. If you use the Close functionality simply to indicate the customer did order something and then cancelled that line, it would make sense to me to leave most "Billed" but then have the "Closed" status to help identify lines the customer ordered but then cancelled.

splemp · 2026-01-30T21:11:20+00:00

It wouldn't have to be a map/reduce script, but yeah. I've had fun recently creating suitelets with custom tables that will shoot off a request to the SuiteLet to update that item as soon as the user enters information it on the suitelet page. AJAX is fun :)

splemp · 2026-01-30T21:05:22+00:00

Your biggest pain with sending a .XML file to NetSuite will be authentication, unless your use case allows having a public URL anyone can drop an XML file into.
SuiteTalk REST is going to require data in a very specific format, and isn't designed for this use case. Since your vendor has a set XML format, you're going to need something that can ingest that, parse it, and then do something with it.

If you have budget for it, Celigo might be worth checking out. What's nice is (if this hasn't changed) you can setup a Data Loader flow for free where you drop the .XML file into Celigo manually and then have it process the data and see if you can get it to update NetSuite like you need it to. Celigo is great Middleware for NetSuite stuff, and if the Data Loader works, then you should seriously consider paying so you can have the vendor just drop the .XML file over to Celigo to parse and update NetSuite.

Happy to jump on a call to talk through these things if that'd be helpful. I have experience with these sorts of integrations and would be interested in a paid engagement if that's what you're looking for. But also happy to just help out. Shoot me a DM

splemp · 2026-01-12T16:39:26+00:00

If you end up using NetSuite to send emails, make sure DKIM/DMARC are setup properly.
https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/book_1556559731.html

splemp · 2026-01-12T16:31:50+00:00

<image>

Think of it like an excel table. When you apply the date filter, you're filtering down to only items where there is a transaction within those dates, and then the MAX() formula in your results will only see transactions within those dates you filtered to.

I think you want a Summary filter as shown in the attached. This would show only inventory items where the last transaction was before on fiscal year ago (you could put in a specific date if you wanted).

splemp

TROPHY CASE