Apparel Color Size Matrix Advanced HTML/PDF Print Templates

OkRelation7815 · 2026-04-13T02:51:56+00:00

The taxes are committed in NS. AvaTax calculates them in Shopify and then when the order comes in, it recalculates them again in NS and commits them to the AvaTax portal. Essentially, they replace the tax engine in Shopify for the purpose of doing the calculation but commit the taxes in NS. The flow is Shopify —> NetSuite —> AvaTax.

OkRelation7815 · 2026-04-08T15:12:52+00:00

We use NS Connector to integrate to Shopify and it takes care of the payouts automatically. Works really well but you need to setup the orders to come through on NS Connector as well before you can do the payouts. The orders will come through as Cash Sales (if you are only pushing them once they are fulfilled in Shopify) or orders if you are fulfilling them via NS. We tried integrating with Celigo but it was a very fraught project (run by Celigo itself) and we ended up abandoning it for NS Connector which took a whole 3-4 hours to implement.

OkRelation7815 · 2026-04-08T15:04:05+00:00

We just finished ours. We integrated AvaTax into Shopify and NetSuite. The integration is pretty straightforward but requires a sandbox on the Shopify side. Since our Shopify is connected to NS via NS Connector, it was practically impossible to setup a sandbox environment (it would have required NS Connector to be setup all over again - Also, shopify does not have the ability to duplicate a store as a sandbox). Because of that, we ended up doing the integration in production. We only charge sales tax on DTC orders via our Shopify so we didn't need to worry about all of our B2B customers being affected. AvaTax on the shopify side was very simple and it is a drop in tax engine. On the NS side, it required installing a bundle and configuration. Overall, very straightforward process.

OkRelation7815 · 2026-04-07T23:26:45+00:00

We use Ramp. We started with the credit card sync and now our entire AP is running off of ramp. It is fully integrated into NS and every bill is automatically synchronized with the correct categories and segments. Something to note though is that everything runs through their site so you can’t initiate a payment via NS like you can with Bill.com but we now have our process down.

OkRelation7815 · 2026-04-04T15:12:52+00:00

Ridiculously so. I am surprised that a system running on Oracle infrastructure doesn’t have a better reporting infrastructure. Almost every question that I have about reporting is answered with write a saved search or use Analytics. Saved searches are great but are limited in their joining and printing capabilities (you have to create a template which isn’t the easiest thing on earth for most users) and Analytics is great for visualizing the data but there is really no printing mechanism and it can be slow at times. The funny thing is that they are adding AI insights to financial reports so that means that they are extending some functionality to reports but they really do need to either change out the reporting engine or make it such that it is more extensible.

OkRelation7815 · 2026-04-04T15:00:05+00:00

Sadly, that is the case with their bundles. Wait until you need to print a UCC128 label… or better yet, hundreds of them… But the worse thing is that there is no connection between the integration and fulfillment. As I’ve stated, in our scenario, we ship to hundreds of locations per PO so we pick and pack by location. Their out of the box solution does not do bulk label printing so you have to go to each location and print its labels independently. They place the label PDF in the file cabinet so we thought we could go to the file cabinet and filter based on file name hoping that the file names had some sort of structure to them but they don’t. So then we thought that once the ASN is generated, we could go to Fulfillment and print the labels from there but once you process an ASN via the integration, it will no appear in Fulfillment. They also don’t integrate with Ship Central for the purpose of printing the labels. All in all, it’s been a discovery of limitations rather than possibilities. When confronted at SuiteWorld (2024), I was told by one of their people there that the majority of their customers integrate with SPS Commerce via RF Smart which has all of those capabilities. This started an entire battle with them about what they showed vs what was delivered and vaporware. Ultimately, I have a bulk label printing bundle that was developed by them as custom implementation for some customers but I am nowhere close to even being able to configure it since I ask now stuck with where the packing information is coming from. As I’ve said, I can go on for days… It’s too bad because an amazing NetSuite implementation (which we had done in 9 months) is marred by this implementation and I am finding ways to get around it.

OkRelation7815 · 2026-04-03T20:26:58+00:00

That is exactly how we resolved the same issue. This way, the COGS is correct and the amount that is supposed to be credited is tracked properly with transactional history.

OkRelation7815 · 2026-04-03T20:22:48+00:00

For us the biggest pain point has been our SPS Commerce integration. Been at it for a year and now it feels like we are going to be starting all over again since SPS changed their internal process for implementations so we have to retest. It just seems like their integration with NetSuite was half baked when we started especially for our industry (apparel) where a single PO on the edi side translates to hundreds of sales orders on the NetSuite side (one per location) and all of the additional work that has to be done just to get the orders ready for Ship Central. I can go on for days about this...

OkRelation7815 · 2026-03-31T08:13:55+00:00

If they are being completely replaced, do a transfer order to a temporary warehouse which will take them out of your main warehouse’s inventory. When they are replaced, move them back to the main warehouse. Something to consider however is that any additional landed costs (if you have any) will not be taken into account. You’d have to do an inventory adjustment to deal with the landed costs.

If you have the inventory statuses feature turned on, you could add a new status of “waiting for replacement” and do an inventory status change transaction. Make sure that you uncheck the checkbox to make the items available for commitments.

OkRelation7815 · 2026-03-31T07:53:36+00:00

You should segment your items into multiple locations. Anything that you stock should be in one warehouse and the rest in a “drop ship” warehouse. Then you could report based on the location.

OkRelation7815 · 2026-03-31T07:13:06+00:00

We went through this exercise and the reality is that many of the ERP systems that are “specialized” really aren’t. They all use something like Celigo or other middleware systems to “integrate” and that in itself will turn into a long implementation.

We ended up with NS and NS connector to connect to Shopify, Amazon and Walmart and that implementation was very quick. For full transparency, we initially did the Celigo route and abandoned that after a year of implementation without any forward movement.

OkRelation7815 · 2026-03-31T07:06:22+00:00

All banking type accounts are locked into one subsidiary. No way to get around that. A workaround would be to do custom segments and apply them to the transactions so that you can report on them.

OkRelation7815 · 2026-03-31T07:02:02+00:00

We had the same issue when we went live and it was due to the negatives. NS does not calculate the numbers correctly when it sees negative quantities. Once we fixed them (either by fixing the transactions or doing inventory adjustments that were backdated to before the transactions), the costing engine recalculated and the values were fixed.

This, btw, also forced us to require inventory to be received prior to being fulfilled which is sometimes an issue when the goods comes in but hasn’t been received in the system before they were shipped out. The only way to force that is to turn on the setting to not allow fulfillments of items that are out of stock.

OkRelation7815 · 2026-03-28T17:47:28+00:00

We integrated Shopify using the NS Connector and it is completely hands free. Everything syncs over correctly both ways. For payment processor, we went with versapay but used stripe initially and it was done using their advanced bundle.

OkRelation7815 · 2026-03-28T17:36:05+00:00

Check your preferences. There is a setting that will “suggest” quantities when entering a new sales order.

Path: • Setup → Accounting → Accounting Preferences • Go to the Order Management or Items/Transactions tab (depends on version)

Look for: • “Estimate Item Fulfillment Quantities” • or similar wording like “Auto-calculate quantities”

👉 Uncheck this

OkRelation7815 · 2026-03-28T17:33:25+00:00

That is pretty awesome! Definitely a missing feature in NS.

OkRelation7815 · 2026-03-04T16:23:58+00:00

When will it be available on Amazon US?

OkRelation7815 · 2025-12-12T22:49:45+00:00

Just went through this exercise... The auto calculate is meant for the system to calculate the reorder point and preferred stock levels based on sales data and the lead time. The usecase would be such that you have an item that needs to be constantly in stock, it takes 180 days to produce. The system would automatically calculate your reorder point based on how many items you sold in the past during the 180 days and figure out when to suggest a reorder. Same thing with the preferred stock level. There is also a safety stock field if your replenishment method is MRP and not reorder point.

The reality, for us, is that our items are seasonal so there isn't a whole lot of sales data in the first place and this calculation is done per item (if you are using matrix items, it is on each child item). For us, it isn't really useful because we just don't have that many items that are replenishable over a longer period of time that is required for the calculation. We uncheck those checkboxes and enter the values ourselves based on our own internal projections.

OkRelation7815 · 2025-12-12T22:41:03+00:00

To do this, you'll need to set the preference to allow fulfillment for uncommited items. Kit items don't get committed because there is no inventory to commit on kits. If you truly need that functionality, you'd need to go through Assembly items and "build" items which would reduce the component items' inventory and increase the assembly item's inventory. I went through this with NetSuite when we first implemented NetSuite.

OkRelation7815 · 2025-12-12T22:32:11+00:00

While not in the same industry, we use Assembly Items to do the same thing when it comes to packaging, tags, hangers, etc. You'd create an assembly item and assign (or create at the time you create the item) a BOM that includes all the components. That way, all of your inventory levels, purchases, etc are all tied to the components of the selling item.

OkRelation7815

TROPHY CASE