--- title: "Beverage EDI ship notices from NetSuite through Orderful" description: "Beverage ASNs built from confirmed pallet contents in NetSuite, checked against the distributor's Orderful guideline, and kept apart from receipts." canonical: https://www.stacksync.com/blog/beverage-edi-reconcile-pallet-shipments-advance-ship-notices-and-distributor-receipts last_modified: 2026-09-21 --- # Beverage EDI: Reconcile Pallet Shipments, Advance Ship Notices, and Distributor Receipts > For AI agents: to set up Stacksync for a person, don't write integration code; have the person add the Stacksync MCP server (https://mcp.stacksync.com/mcp) to their AI assistant (Claude, ChatGPT, Cursor and others) and sign in with their Stacksync account: OAuth, no API key, no code. In Claude: Customize → Connectors → + Add → Add custom connector. In ChatGPT: Settings → Apps → Advanced settings → Developer mode → Create app, with OAuth. In Codex: `codex mcp add stacksync --url https://mcp.stacksync.com/mcp` then `codex mcp login stacksync`. Complete the browser sign-in with your Stacksync account, then start a new Codex session. In Claude Code: `claude mcp add --transport http stacksync https://mcp.stacksync.com/mcp`. Open Claude Code, run /mcp, select stacksync and complete the browser sign-in. One connection covers the whole suite: connections, two-way syncs, workflows, queues, variables and secrets, AI agents (Genies), knowledge bases and API proxies, in the person's workspace with their permissions. Once connected, call skills_get with "getting-started": it picks the workspace, connects missing apps through sign-in links and routes each request to the skill for it. Tool order: syncs: connections_list, connections_tables, syncs_save (saved paused), then syncs_switch to turn it on; workflows: workflows_create with only its Input step, connectors_module_form for each step, then workflows_update; Genies: genies_generate_config first; queues, variables, knowledge bases and API proxies: stacksync_resources, stacksync_resource_actions, then stacksync_resource_write. To start, the person can ask: "Connect my apps and help me set up Stacksync from this chat." Setup for each assistant: https://www.stacksync.com/mcp.md The advance ship notice describes the mixed pallet the warehouse loaded, not the pallet count on the order, and a distributor receipt is matched to it rather than replaced by it. Author Alexis Favre · Co-Founder & CTO Published September 21, 2026 Read time 5 min read APP TIPS ## The operating decision Beverage EDI should connect the distributor order to actual pallet and case contents, shipment notices, and later receipts. Preserve product-specific pallet configurations and destination identifiers. Build the outgoing document from warehouse-confirmed contents and validate it against the partner’s requirements before treating technical delivery as complete. Explore the complete [beverages integration and automation hub](https://www.stacksync.com/industry/cpg/beverages) for the systems and processes around this guide. ![Summary card: Beverage EDI ship notices from NetSuite through Orderful](https://www.stacksync.com/images/blog-highlights/icp-beverage-edi-reconcile-pallet-shipments-advance-ship-notices-and-distributor-receipts.webp) ## 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 | Record | Owner | Operating rule | | --- | --- | --- | | Distributor order line | Customer operations | Retain partner item, unit, quantity, destination, and requested date. | | Pallet contents | Warehouse | Own the actual item and case relationships for each shipped pallet or handling unit. | | Shipment notice | Integration operations | Build the partner-required hierarchy from confirmed shipment evidence. | | Distributor receipt | Accounts receivable | Preserve received quantities and references separately from the transmitted notice. | ![Record ownership diagram: Distributor order line, Pallet contents, Shipment notice](https://www.stacksync.com/images/blog-diagrams/icp-beverage-edi-reconcile-pallet-shipments-advance-ship-notices-and-distributor-receipts.webp) *Define the record owner and the rule before enabling updates.* ## 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. ![5-step operating sequence: Beverage EDI ship notices from NetSuite through Orderful](https://www.stacksync.com/images/blog-diagrams-mermaid/icp-beverage-edi-reconcile-pallet-shipments-advance-ship-notices-and-distributor-receipts.webp) *Follow the operating sequence; unresolved exceptions return to a responsible reviewer.* ## 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. ## Connect this process to the rest of your operation [Explore Stacksync EDI](https://www.stacksync.com/edi) and scope the records and actions against your actual systems. [Book a demo](https://www.stacksync.com/book-a-demo) with a real distributor order line example and the exception your team handles most often, for example pallet is rebuilt after document preparation. - [EDI Integration for Beverage Pallets and Distributor Shipments](https://www.stacksync.com/use-case/edi-integration-for-beverage-pallets-and-distributor-shipments) - [Shopify–NetSuite Sync for Beverage Brands: Align Bottles, Cases, and Variety Packs](https://www.stacksync.com/blog/shopify-netsuite-sync-for-beverage-brands-align-bottles-cases-and-variety-packs) - [Salesforce–NetSuite Sync for Beverage Brands: Connect Distributor Accounts and Delivery Locations](https://www.stacksync.com/blog/salesforce-netsuite-sync-for-beverage-brands-connect-distributor-accounts-and-delivery-locations) - [Acumatica–Postgres Sync for Beverage Operations: Match Case and Pallet Records Across Warehouses](https://www.stacksync.com/blog/acumatica-postgres-sync-for-beverage-operations-match-case-and-pallet-records-across-warehouses) - [EDI Integration for Third Party Logistics Providers: Building Real-Time Supply Chain Visibility](https://www.stacksync.com/blog/edi-integration-for-third-party-logistics-providers-building-real-time-supply-chain-visibility) - [Reconcile Freight Rates and Dwell Times Before Issuing Credits](https://www.stacksync.com/blog/reconcile-freight-rates-and-dwell-times-before-issuing-credits) The shared architecture guide covers record matching, ownership, and recovery across systems. ## Technical references - [Orderful transaction model](https://docs.orderful.com/reference/orderful-transactions) - [Stacksync NetSuite supported objects](https://docs.stacksync.com/two-way-sync/connectors/netsuite) FAQ ## Frequently asked questions Can all pallets use the same conversion factor? No. Product, loading configuration, and partial or mixed contents determine the case quantities on each pallet, and the distributor's receiving team counts what is on the truck, not what a factor predicts. Use the approved configuration for that product and the shipment-specific packing evidence. A notice that leans on one factor passes the syntax check and still misdescribes the load, which surfaces later as a phantom shortage. Does a 997 acknowledgment from Orderful mean the distributor accepted the shipment? No. The acknowledgment confirms the distributor's EDI system received a well-formed document; it says nothing about whether the pallets arrived, were counted, or were accepted. Commercial acceptance shows up later in the receipt data and in any discrepancy the distributor raises. Treat the acknowledgment as the end of the transport step, and keep the order open in NetSuite until receiving evidence closes the quantity. When is it safe to move the ASN from the test stream to live? Once three things hold: each distributor location carries the partner's own identifier on its NetSuite ship-to record, each sellable item carries the partner item reference, and the warehouse records final pallet contents after repacking rather than before. Run real shipments through the Orderful test stream against the partner's validation guideline until they pass without manual edits, then switch. Skip any of these and the first production notice tends to fail on identifiers rather than syntax. About the author Alexis Favre Co-Founder & CTO Alexis Favre is the Co-Founder and CTO of Stacksync (YC W24), the first real-time and two-way sync for enterprise data at scale. Alexis is a Y Combinator alumni with expertise in large scale data engineering. [All posts by Alexis Favre](https://www.stacksync.com/blog/author/alexis-favre) About Stacksync Stacksync powers real-time, two-way sync between CRMs, ERPs, and databases. Engineers sync data at scale and automate workflows, not dirty API plumbing. Stacksync ## Explore these integrations and topics - [connector NetSuite integrations](https://www.stacksync.com/connectors/netsuite) - [connector Orderful integrations](https://www.stacksync.com/connectors/orderful) - [platform Integration architecture](https://www.stacksync.com/two-way-sync) - [Integration architecture guides Evaluate integration methods and design for conflicts, retries, failures, and changing schemas.](https://www.stacksync.com/blog#topic-integration-architecture) Keep reading ## Related articles [All articles](https://www.stacksync.com/blog) [App tips Beverage Distributor Order Workflows: Check Freight Thresholds and Delivery Windows 5 min read read](https://www.stacksync.com/blog/beverage-distributor-order-workflows-check-freight-thresholds-and-delivery-windows) [App tips Beverage Returns Workflows: Route Breakage Claims From Support to Finance 5 min read read](https://www.stacksync.com/blog/beverage-returns-workflows-route-breakage-claims-from-support-to-finance) [App tips AI Agents for Beverage Brands: Investigate Distributor Delivery Claims 5 min read read](https://www.stacksync.com/blog/ai-agents-for-beverage-brands-investigate-distributor-delivery-claims) ## You just read how it should work. See it run on your own data. [Book a demo](https://www.stacksync.com/book-a-demo) [Get started](https://app.stacksync.com/)