Skip to content

Automate Co-Packer Receipt Exceptions for Snack Brands Before Inventory Reconciliation

When a supplier's revised packing list, the dock count, and the NetSuite receipt disagree, this workflow keeps one case open until the right owner records a decision.

Author
Ignacio Malpartida · GTM Engineer
Published
Read time
5 min read
Automate Co-Packer Receipt Exceptions for Snack Brands Before Inventory Reconciliation
APP TIPS

The operating decision

Route co-packer receipt exceptions to the team that can resolve the underlying fact: supply, receiving, product operations, or finance. The workflow should preserve the supplier notice, physical count, and ERP receipt separately, then advance only after the responsible owner records a decision. Avoid making a mismatch disappear through an unreviewed quantity update.

Explore the complete packaged food and snacks integration and automation hub for the systems and processes around this guide.

Summary card: Co-packer receipt exceptions routed from Gmail to NetSuite

What this looks like in packaged food and snacks

A supplier emails a revised packing list after a truck arrives. Receiving has already recorded a partial acceptance, while product operations discovers the supplier used an old case size. The workflow must collect both document versions, determine the effective conversion, and route any ERP correction to the authorized receiver.

Records, ownership, and update rules

RecordOwnerOperating rule
Receipt exceptionSupply coordinatorRecord supplier, shipment reference, affected item, discrepancy type, and priority.
Document versionSupplier liaisonKeep original and revised notices with their timestamps and stated quantities.
Physical countReceivingOwn the observed quantity and accepted or held disposition.
Resolution decisionResponsible ownerSpecify the approved conversion, correction, or supplier follow-up before the case closes.
Record ownership diagram: Receipt exception, Document version, Physical count
Define the record owner and the rule before enabling updates.

Work through the process

  1. 01
    Detect a meaningful difference
    Compare quantity and unit only after matching the receipt identity. Separate a missing receipt from an actual count discrepancy because those cases have different owners and next actions.
  2. 02
    Request targeted evidence
    Ask for the missing packing list, receiving count, or approved case definition. A generic supplier follow-up creates more messages without establishing which fact blocks reconciliation.
  3. 03
    Route by cause
    Send a pack mismatch to product operations, a physical shortage to receiving and supply, and a posting issue to the ERP owner. Retain a single case so teams do not create conflicting corrections.
  4. 04
    Close after acceptance
    Require the reviewed destination result or documented supplier resolution. A reply saying resolved is insufficient if the ERP still shows the old quantity or the held goods lack a disposition.
  5. 05
    Send the revised packing list twice and watch the case in Postgres
    Forward the scenario's revised packing list to the intake Gmail address and open the exception it creates in Postgres. The case must show one named owner and one stated missing fact, such as the effective case size. Two owners, or a vague reason such as quantity mismatch, means the routing rules are not ready. Then try to close the case without the corrected NetSuite receipt or a documented supplier resolution attached; the workflow should refuse. Finally, send the identical packing list again. The existing case should gain a duplicate-evidence entry and nothing else. A second case, or a repeated correction request to the ERP owner, halts the rollout.
5-step operating sequence: Co-packer receipt exceptions routed from Gmail to NetSuite
Follow the operating sequence; unresolved exceptions return to a responsible reviewer.

Handle the exceptions explicitly

Packing list is resent unchanged

Attach the duplicate evidence without reopening or duplicating the operational correction.

Several receipts share one shipment

Resolve the line and receipt references before applying a quantity decision.

Owner cannot confirm case size

Leave the line blocked and preserve the original units rather than choosing a convenient factor.

What to verify before expanding

  • Each discrepancy has one current owner and a precise missing fact.
  • Closing the case requires accepted resolution evidence.
  • Resending an unchanged packing list attaches evidence to the existing exception without repeating the accepted receipt correction.
  • An unknown case size leaves the affected line blocked with its original units, rather than accepting a default conversion.
Book a demo for packaged food and snacks integration and automation

Connect this process to the rest of your operation

Explore Stacksync workflows and scope the records and actions against your actual systems. Book a demo with a real receipt exception example and the exception your team handles most often, for example packing list is resent unchanged.

The shared architecture guide covers record matching, ownership, and recovery across systems.

Technical references

Book a demo for packaged food and snacks integration and automation

FAQ

Frequently asked questions

How does this differ from the receipt sync article?
Two-way sync keeps the NetSuite receipt and the Postgres comparison view in step; it has no opinion about who should act on a mismatch. This workflow owns the human side: who is asked, what evidence they must supply, and what counts as a verified correction. Run the sync first, because the workflow needs the comparison rows to detect a difference at all.
Do supplier emails need a fixed format for Gmail intake to work?
No fixed template, but two things must be present: the shipment or purchase-order reference somewhere in the subject or body, and the packing list as an attachment rather than a pasted table. Without a reference the workflow cannot match the message to a receipt, so it should hold the message for the supplier liaison instead of guessing. Agree that minimum with each co-packer before intake goes live.
What does the workflow do with the correction once the owner decides?
It packages the correction with its reason, the document versions, and the physical count, then hands it to the authorized receiver, who posts it in NetSuite. After that, the workflow reads the item receipt back and compares the posted quantity with the approved decision before it will close the case. Held goods keep their disposition on the physical-count record; the workflow never releases them on its own.

About the author

Ignacio Malpartida
Ignacio Malpartida
GTM Engineer

Ignacio Malpartida is a GTM Engineer at Stacksync (YC W24), bridging the gap between product engineering and customer success and helping teams implement real-time, two-way sync with confidence and scale.

All posts by Ignacio Malpartida

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.

Coworkers laughing in front of a laptop in a casual office setting

You just read how it should work.
See it run on your own data.