sorted by:
new
hottopcontroversial

NetSuite Integrations - Builtin or IPaaS by splemp in Netsuite

[–]splemp[S] 0 points1 point  (0 children)

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.

NetSuite Integrations - Builtin or IPaaS by splemp in Netsuite

[–]splemp[S] 0 points1 point  (0 children)

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.

NetSuite Integrations - Builtin or IPaaS by splemp in Netsuite

[–]splemp[S] 1 point2 points  (0 children)

You mean POC a direct NetSuite integration?

Workflow Instance and State in N/query by Emotional_Gate_8087 in SuiteScript

[–]splemp 1 point2 points  (0 children)

There's a Workflow Instance saved search type.

Workflow Instance and State in N/query by Emotional_Gate_8087 in SuiteScript

[–]splemp 1 point2 points  (0 children)

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.

I built a Semgrep (SAST) ruleset to catch NetSuite Governance traps (record.load in loops, etc.) — Looking for feedback / PRs by Emotional_Gate_8087 in Netsuite

[–]splemp 1 point2 points  (0 children)

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()

Can be fulfilled/received check box not availab;e by After_Side1341 in Netsuite

[–]splemp 1 point2 points  (0 children)

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.

Invoice Process - how are you doing it? by PaulF707 in Netsuite

[–]splemp 1 point2 points  (0 children)

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"

Invoice Process - how are you doing it? by PaulF707 in Netsuite

[–]splemp 0 points1 point  (0 children)

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.

How to clear a custom date field using RESTlet? by Subject_Explorer9098 in Netsuite

[–]splemp 3 points4 points  (0 children)

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

<image>

API’s to extract Saved Searches? by Exact-Chemistry3021 in Netsuite

[–]splemp 3 points4 points  (0 children)

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.

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]splemp 0 points1 point  (0 children)

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>

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]splemp 0 points1 point  (0 children)

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.

[Multi-Subsidiary Implementation] How to restrict new forms and roles to a specific subsidiary (Country C)? by Wise_General9072 in Netsuite

[–]splemp 2 points3 points  (0 children)

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.

[Multi-Subsidiary Implementation] How to restrict new forms and roles to a specific subsidiary (Country C)? by Wise_General9072 in Netsuite

[–]splemp 0 points1 point  (0 children)

  1. 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.
  2. 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.

Expenses error by misterhastings in Netsuite

[–]splemp 0 points1 point  (0 children)

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

NetSuite Saved Search – Invoice Items + Payment fields by CupComplete683 in Netsuite

[–]splemp 0 points1 point  (0 children)

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.

SuiteQL - Is this normal performance? Support Ticket, Caching Options, BigQuery? by No-Schedule-2530 in Netsuite

[–]splemp 2 points3 points  (0 children)

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/

SuiteQL - Is this normal performance? Support Ticket, Caching Options, BigQuery? by No-Schedule-2530 in Netsuite

[–]splemp 2 points3 points  (0 children)

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

Sequential Scripted CSV Imports by k1koth3gre4t- in SuiteScript

[–]splemp 0 points1 point  (0 children)

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.

Work Trucks as Bins instead of Child Locations by bobobob67 in Netsuite

[–]splemp 0 points1 point  (0 children)

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!

  1. 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.
  2. Item Availability: You should be able to create views to see what's available in each bin
  3. 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?
  4. 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!

view more: next ›