NetSuite Inventory and Work Orders from Excel
Create and edit NetSuite inventory adjustments, transfers, fulfillments, receipts, work orders and assembly builds from Excel, in bulk.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Record Edit opens a menu with Budget, Journal Entry, Intercompany Journal Entry and Bulk Records, and the Bulk Records submenu lists the saved templates by record type. Callout: Record Edit › Bulk Records › Opportunities. Opportunities is clicked. Callout: A Bulk Records sheet for Opportunities. An Opportunities sheet is inserted, with body field columns (Date Created, Opportunity #, Company, status, Probability), item line columns (Line ID, Item, Quantity, Rate, Price Level) and a Status column. Start is set to 6/1/2026. Callout: Set the date range to download. End is set to 7/31/2026, filtering on Date Created. Download Opportunities is pointed at. Callout: Download pulls the records in. The banner reads Download in progress, then Download complete, 7 records. Callout: Every matching record, ready to edit. The sheet holds 7 opportunities, OPP68 to OPP74, with their 10 item lines. The quantity of Welding Regulator Gauge on OPP70 changes from 5 to 3. Callout: Edit them like any Excel data. The quantity of 25 HP Rotary Vacuum Pump on OPP73 changes from 2 to 1, and SAF200 on OPP68 from 20 to 15. Add/Edit Opportunities is pointed at. Callout: Add/Edit uploads the changes. The banner counts processing 0 of 3 to 3 of 3, then reads Upload complete, 3 updated. Callout: Each row reports what happened. The Status column reads Updated Opportunity OPP70 on both of its lines, Updated Opportunity OPP73 and Updated Opportunity OPP68, where NetSuite set the SAF200 rate to 460; the other rows read Skipped (no changes). Pointing at Updated Opportunity OPP68 shows its link to the record in NetSuite. Callout: Each row links to its record.
Inventory and manufacturing in bulk, from Excel
Counts, adjustments, transfers and production runs generate a lot of transactions, and the numbers behind them usually come from a spreadsheet or a warehouse export. Bulk Records turns that sheet into NetSuite transactions, lines included, and keeps the bill of materials and routing records editable the same way. Only the records you changed are sent, and anything NetSuite rejects is noted on the cell that caused it.
Post inventory adjustments and transfers
Upload adjustments, inventory transfers and bin transfers with a line per item. When you change a line’s quantity and its inventory detail is a single status row, that row is updated to the new quantity.
Fulfill and receive in bulk
Name the source in Created From and Bulk Records creates item fulfillments from sales orders, transfer orders or vendor returns, and item receipts from purchase orders, transfer orders or return authorizations, matching each row to a source line.
Run production from a sheet
Create work orders, then issue components, record completions and assembly builds from those orders, and close them when they are done.
Maintain BOMs and routings
Bills of materials, BOM revisions, manufacturing routings, cost templates and operation tasks are record types of their own, so they can be listed and updated from a sheet too.
Inventory and manufacturing: every supported record type
22 record types that Bulk Records supports. Records with a line sublist are tagged with it.
Transactions: Inventory
- Assembly Build
- Assembly Unbuild
- Bin TransferLines: Inventory
- Fulfillment RequestLines: Items
- Inbound ShipmentLines: Items
- Intercompany Transfer OrderLines: Items
- Inventory AdjustmentLines: Inventory
- Inventory Cost Revaluation
- Inventory Count
- Inventory TransferLines: Inventory
- Item FulfillmentLines: Items
- Item ReceiptLines: Items
- Transfer OrderLines: Items
- Work OrderLines: Items
- Work Order Close
- Work Order Completion
- Work Order Issue
Manufacturing
- BOM
- BOM Revision
- Manufacturing Cost Template
- Manufacturing Operation Task
- Manufacturing Routing
Instead of a CSV import
Post inventory and production transactions with their lines without exporting, editing and re-importing a CSV. Once a record is uploaded, its row links straight to that record in NetSuite, so checking it takes one click.
Bulk Records: a simpler alternative to CSV importsInventory and manufacturing in Bulk Records: FAQ
- QCan I import inventory adjustments into NetSuite from Excel?
- Yes. Add each adjustment with a line per item and upload. Bulk Records creates the adjustments in NetSuite and flags any value NetSuite rejects on its cell.
- QCan I receive purchase orders or transfer orders in bulk?
- Yes. Name the order in Created From on a new item receipt row, and the receipt is created from it with each row matched to an order line. A row that can’t be matched is held back with the reason on its cell.
- QHow is inventory detail handled?
- When you change a line’s quantity and its inventory detail is a single status row, Bulk Records updates that row to the new quantity. Templates can also include Inventory Assignment columns for the lot numbers, serial numbers and inventory statuses you manage yourself.
- QCan I fulfill sales orders in bulk?
- Yes. Name the sales order in Created From on a new item fulfillment row, and the fulfillment is created from it with each row matched to an order line.
- QWhich manufacturing records are supported?
- Work orders, work order issues, completions and closes, assembly builds and unbuilds, bills of materials, BOM revisions, manufacturing routings, cost templates and operation tasks.
Try Bulk Records with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.
More Bulk Records
- Customers, vendors and CRM
- Items and merchandising
- Sales and billing
- Purchasing
- Financial transactions
- Lists and setup
- Bulk Records overview
- How to bulk export NetSuite records to Excel
- Bulk Records use cases, step by step
- Bulk Record Templates in the docs
- Inventory Detail in the docs
- Create Records From Another Transaction in the docs