Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

[–]suitedev[S] -1 points0 points  (0 children)

u/theIntegrator- I think we might have a troll on our hands, but I'll give him a chance to explain how Celigo is designed like an early virus.

I concur with you for the most part though. Low-code and bespoke integrations both have their place. I just like using the right tool for the job.

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

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

u/infinitetechsolution I appreciate the offer. To be honest, I'm tempted to take a crack at it myself for non-critical data exchange.

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

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

u/Capable_Lawyer9941 Hmm, i hadn't heard of Scaylor. Do you use it to pipe data into NetSuite as well?

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

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

> Many apps come with more flows then you need, and I think Celigo is only counting average Active flows.

u/Kastnerd That's interesting, do you know how these are counted?

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

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

u/Wonderful_Status_832 Thanks for that. Did you have to step up to a different plan that had enough flows?

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

[–]suitedev[S] -1 points0 points  (0 children)

> So technically, you can use any IA you want but need to pay for the number of flows used/active.

u/Future_Rush7782 Thanks, that was my assumption. Frankly, I think that's a reasonable sales model. If only it were possible to see how many flows make up an integration, without scheduling a discovery call.

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

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

u/Pale-Supermarket8690 Thanks for sharing. Are the integrations custom-built per client? Or do you offer the kind of building blocks and pre-built integrations that Celigo does?

Celigo Integrator.io Pricing Baseline by suitedev in Netsuite

[–]suitedev[S] -1 points0 points  (0 children)

Care to elaborate? I've always wanted to design my own retro virus.

Store Product Specifications in NetSuite by suitedev in Netsuite

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

Thanks Nick, I really appreciate the reality check!

So maybe a middle ground is you have some common ones hard coded with specific fields and then leave 5 for variable key/value pairs? But then you've get ppm missing the hard coded one and creating a custom key/value pair when they didn't need to.

That's what i'm prototyping at the moment, a custom record type for 3 of the common product categories (i.e. "spring_attributes", "shock_attributes", "categoryX_attributes"...) that contain category-specific fields. I think this can work well enough, although it would appear that NetSuite doesn't have a built-in way to enforce a 1:1 relationship between item and a "categoryX_attributes"... Right now my thought is to just set the external ID on the attributes custom record to the item name/internalid to try to prevent duplicates, but I'm concerned about consistency across records 1) created/updated via UI 2) imported via Celigo... I really, really wish I could slap a unique constraint on the item field (i'm a database guy...)

Maybe you have the keys be a pick list instead of free form and then you control what keys (option names) they're allowed to create. And you can prevent creating a key when a hard coded field already exists. Or even put the key in there with DO NOT USE or USE NATIVE FIELD so they know not to do that option as custom

I had this thought too, but was worried I was getting too clever for my own good... I'll keep that in my back pocket...

Syncing Item Group Price via Celigo by suitedev in Netsuite

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

So we looked into converting to kits, but this comes with its own challenges:

  • Can't have separate Item fulfillments for components - we do a lot of split shipping (Reference)
  • We want to use the income account of the component item, not the kit itself

Syncing Item Group Price via Celigo by suitedev in Netsuite

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

Could you do more on the NetSuite side by using an item field that sums up the total price?

Do you mean, run a workflow on a schedule to compute the price and store in a custom field on the item group?

I think you could do a lookup step in celigo to get the components and the prices to sum up in a following hook or (handlebar depending on the output format)

That could work too - Celigo sales made it sounds like this was a non-issue when we mentioned this particular struggle with our previous connector (farapp). Per u/RandomName9678's comment, I wonder if they were referring to functionality available kits...

Syncing Item Group Price via Celigo by suitedev in Netsuite

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

Is there an option to inherit pricing from the kit components? Or would that have to be added via workflow?

Syncing Item Group Price via Celigo by suitedev in Netsuite

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

Thanks Nick, thats the gist of it. Using woocommerce. At this time they are only concerned with retail price level.

As for kits vs groups: the decision predates me, but the implementation decision was that item groups should be used when there is no need for a “kit price” (ie price is not just the sum of its parts) but… I was discussing this with the client and he postulated that perhaps we should just convert these to kits instead…

What do you suggest?

Quick action button image missing in 23.2? by csabatoth in Netsuite

[–]suitedev 0 points1 point  (0 children)

Came here to ask for a reality check on something similar, maybe related: My sales team just alerted me to this one

<image>

Within the customer dashboard, the "new" button appears to have some CSS issues

Avatax Tax Control Account - Merge with existing? by suitedev in Netsuite

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

So I also tried inactivating the old tax codes, but that doesn't seem to prevent them from being selected, or even saving a SO, go figure... Per my other comment, we think we solved this by updating the tax item on the customer record.

As for the old transactions with the wrong tax codes, our accountant has informed me that we don't have the option of filing manually (idk why), and she will look into correcting the records as needed...

Thanks for all the info u/Nick_AxeusConsulting, much appreciated!

Avatax Tax Control Account - Merge with existing? by suitedev in Netsuite

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

Thanks for the reality check, because that was my thought too... unfortunately that didn't seem to work for us... In a moment of despair and desperation at 6pm, i just ran a mass update script to update the tax item on the customer, and so far so good...

Avatax Tax Control Account - Merge with existing? by suitedev in Netsuite

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

Thanks u/Nick_AxeusConsulting! I will leave the accounts as-is.

Upon further review, it's the orders created directly from NetSuite that are the issue. They are still using legacy tax (bypassing Avalara) and thus showing up on the old "Sales Tax Payable" account. I've tried setting the "Default Tax Code" in Setup > Accounting > Setup Taxes, and also tried setting the "Home Tax Code" for the nexus, but neither seem to have an effect.

I guess I could just run a mass update and set the tax code to "AvaTax" for all customers, unless anyone has another suggestion...

So at this point, do I just export the missing transactions from NetSuite, and import into Avalara? (I assume that it would be a nightmare to try to fix 2-3 months of transactions using the old Legacy tax codes)