PalletAuditsExporting loads and shipments from Dynamics 365 Supply Chain Management
Using All loads and All shipments in Dynamics 365 SCM and Export to Excel to pull a month for a pallet audit.
Where the data is
Warehouse management > Loads > All loads covers inbound and outbound loads (use Show closed to include shipped loads). Warehouse management > Shipments > All shipments lists shipments. Bills of lading are on the load.
Exporting
Open in Microsoft Office > Export to Excel exports the grid with your current filter. The default limit has been 50,000 rows; one month at a time stays well under it.
Pallet count
License plates identify a pallet, tote or container. Count pallet license plates only.
Sources
Microsoft Learn: loads; Microsoft Learn: Export to Excel
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 shipments from NetSuite for a pallet audit
General information, not advice about any specific contract. Your agreement with the pallet company sets the actual fees and deadlines.