PalletAuditsExporting shipments from NetSuite for a pallet audit
A saved search on item fulfillments (shipments) and item receipts, exported to CSV, with the pallet count.
Build a saved search
Reports > Saved Searches > All Saved Searches > New > Transaction. Filter the type to Item Fulfillment for shipments (status Shipped, not Picked or Packed) and to Item Receipt for receipts, and set the date range to the month.
Add result columns for ship date (the actual one, not the requested one), customer or ship-to name and number, BOL or order/load number, and the number of pallets.
Export
From the results, use Export – CSV or Export – Microsoft Excel. It needs the Export Lists and Perform Search permissions.
Pallet count
NetSuite records packages on a fulfillment; there's no standard pallet field, so many companies add a custom field.
Sources
NetSuite Help: exporting search results
Find your missing pallets
PalletAudits matches every shipment to a declared transfer and lists what to declare, dispute and recount. Your first audit is free.
Run a free audit See a sampleMore guides
Exporting shipments and receipts from your WMS for a pallet audit
Exporting shipments from SAP EWM for a pallet audit
Exporting outbound deliveries from SAP ECC or S/4HANA (VL06O)
Exporting shipments from Oracle WMS Cloud for a pallet audit
Exporting shipment orders from Infor WMS for a pallet audit
Exporting loads and shipments from Dynamics 365 Supply Chain Management
General information, not advice about any specific contract. Your agreement with the pallet company sets the actual fees and deadlines.