@Jackie Yang 1&2 are where you issue lies (imho).
Your issue is -
Everything (chips, pallet top/ bottom, and gps tracker) is setup as inventory items. So when a customer orders a pallet (720 units), you need to consume the “consumables” (pallet bottom and lid, and gps tracker) for each pallet, but you aren’t invoicing the customer for the consumables (which is common). And you don’t have a full Pallet set up as an inventory item (which is common too)
There’s one of several options you can do to simplify things for urself -
Option 1.
If you can convert the consumables to non inventory items, then you can create a “Kit Inventory Item” say Item KIT720GPS (which does not require assembly) which consists of following bill of materials -
Chips - 720 (inventory)
Top - 1 (non inventory)
Bottom -1 (non inventory)
GPS Tracker - 1 (non inventory)
Basically you are creating a “Kit” for 1 pallet which includes everything that goes with the pallet.
Customer order comes in - 1 Pallet. (I would get the customer (or your EDI translator) to switch to Unit of measure of Pallet, and link it to item KIT720GPS in NetSuite.
Then your 3 PL gets the order (for same Kit item), they build and fulfill the order.
Warehouse should be able to send you a confirmation through Celigo that will “assembly and fulfill” the order in NetSuite directly. This way your supply chain team doesn’t need to manually do anything.