Beverage EDI: Reconcile Pallet Shipments, Advance Ship Notices, and Distributor Receipts

What this looks like in beverages

A distributor orders a full pallet plus loose cases of another flavor. The warehouse builds a mixed pallet for the final shipment. A notice based on the original order’s pallet count would not describe the physical shipment, making receiving and later shortage investigation difficult even if the file passes syntax checks.

Records, ownership, and update rules

Work through the process

1. 01
   Confirm the handling-unit rules

   Review how the partner expects pallets, cartons, item lines, and identifiers represented. A mixed pallet may require a different hierarchy from a full single-item pallet.
2. 02
   Use actual packing evidence

   Collect the final warehouse contents after approved repacking. Keep partial pallets and loose cases explicit rather than converting every handling unit into a standard pallet quantity.
3. 03
   Validate the business totals

   Reconcile shipment notice lines to actual cases and the remaining order balance. Compare destination and item identifiers as well as document syntax.
4. 04
   Track the receiving outcome

   Attach later receipt evidence and keep discrepancies open for operations or finance review. The notice describes what was shipped; it does not establish what the distributor accepted.
5. 05
   Send a mixed-pallet ASN to the Orderful test stream before go-live

   Ship a test order as one full pallet plus a mixed pallet holding two flavors. Generate the notice from the warehouse's confirmed contents in NetSuite and send it to the distributor's test stream in Orderful. The mixed pallet must appear with an item line and case count per flavor under its own handling unit, and the totals must equal the shipped cases and the balance left on the order line. Then repack the mixed pallet after the draft exists and regenerate. Stop the rollout if the mixed pallet arrives as one averaged line, if totals disagree with the shipment or order balance, or if the first draft goes out unchanged.

Handle the exceptions explicitly

Pallet is rebuilt after document preparation

Regenerate or correct the affected notice under the partner’s process before relying on it.

Receipt reports only a pallet total

Request the needed item detail before resolving a line-level shortage.

Loose cases are omitted

Block release until the document describes the complete actual shipment.

What to verify before expanding

• Mixed pallets preserve their item-level case contents.
• Notice totals reconcile to the actual shipment and remaining order quantities.
• Loose cases and partial pallets appear in the shipment contents instead of disappearing behind a whole-pallet total.
• A pallet-only distributor receipt leaves line-level shortages unresolved until the necessary item detail is obtained.

Technical references

• Orderful transaction model
• Stacksync NetSuite supported objects