Packlistly

Epicor Prophet 21 (P21) export documents & multi-carton packing lists

Turn reviewed Epicor Prophet 21 wholesale distribution sales order or pick-ticket CSV/Excel exports into a Commercial Invoice, crate-and-pallet Packing List, Carton Labels, SLI, SOLAS VGM and USMCA/CUSMA Annex 5-A document set.

Export item-level Prophet 21 Order Entry or Pick Ticket rows, then reconcile mixed-origin cartons and pallets

In Epicor Prophet 21 (P21), North American industrial wholesale distributors—across fasteners, fluid power and hydraulics, electrical and automation supplies, HVAC/plumbing, and safety/MRO lines—manage multi-warehouse inventory, unit-of-measure conversions, and high-SKU pick tickets. Export item-level rows from Prophet 21 Order Entry, Pick Ticket / Pack Verification, or an Info Manager / SQL / Crystal report to Excel (.xlsx) or CSV—retaining columns such as Item ID, Extended Description, Shipped Qty or Ordered Qty, Unit of Measure and Unit Price rather than an Accounts Receivable header-only invoice summary. Keep one shipment per upload with its P21 order or pick-ticket reference and 3-letter ISO currency, and review Epicor Prophet 21’s wholesale distribution documentation alongside your company’s user role permissions.

  1. Map P21 item IDs, plain-language commercial descriptions (expanding abbreviated catalog codes), shipped quantities and unit prices once in Packlistly, and confirm seller, consignee, buyer tax/BN15/RFC/NIT/EORI ID, currency, and Incoterms® 2020 rule with named place.
  2. Wholesale distributors frequently ship U.S.-made and imported MRO SKUs on the same pallet: pair each line with its verified 6-to-10-digit HS/Schedule B code and actual manufacturing Country of Origin (LineItem.origin, distinct from your U.S. ship-from warehouse). Allocate units across master cartons, wirebound crates, and ISPM-15 skids with measured net/gross weights in lb or kg and outer dimensions in in or cm.
  3. Review cross-document quantities, net-vs.-gross weights, >$2,500 shared Schedule B SLI groups, SOLAS VGM math, and 9-element USMCA/CUSMA completeness before generating up to 10 synchronized export PDFs from the saved shipment.

Worked example: hydraulic directional valves and stainless fitting kits across nine packages

Prophet 21 pick-ticket lineUnits × pricePackagesNet kgPackage gross kg
24V directional hydraulic control valve manifold (HCV-310)15 × $380 = $5,7005 heavy-duty cartons × 3 units105125
316 stainless JIC hydraulic fitting & O-ring assortment (JFK-48)80 × $22 = $1,7604 master cartons × 20 kits4452
Total$7,4609 packages149177

Fictional shipping-dock inputs: shrink-wrapping all nine cartons onto two separately weighed 20 kg heat-treated ISPM-15 pallets yields 217 kg total cargo gross mass, kept distinct from the 177 kg package-only gross weight so cross-border LTL, ocean HBL, and SOLAS VGM figures match dock-scale weights.

This is a manual CSV/Excel upload workflow, not a live native Epicor Prophet 21 API, DynaChange, or EDI connector; it requires no P21 server customization and never writes back to Prophet 21. Upload is included on Free ($0/month, 5 shipments/month, 1 user), Starter ($29/month, 50, 3), Expert ($59/month, 300, 10), Pro ($129/month, 1,000, 20) and Enterprise ($599/month, 3,000, 50)—see Plans & pricing. Teams with developer resources can also post structured orders via the REST Order API on Starter and higher plans.

All 7 free export checkers · Try a sample spreadsheet · Review sample PDFs · Check Commercial Invoice fields · Check packed quantities · Check SLI fields · Check draft B/L · Check VGM arithmetic · Check letter of credit fields · U.S.-to-Colombia DIAN & CTPA guide

Packlistly does not transmit ANSI X12 or EDIFACT EDI messages, does not file AES/EEI in ACE or destination customs entries, does not certify physical container weighing, does not screen restricted parties, and does not determine HS/Schedule B codes, ECCN/ITAR/EAR export licenses, or legal USMCA/CUSMA or CTPA origin qualification. Epicor and Prophet 21 are trademarks of Epicor Software Corporation; this workflow is unaffiliated with Epicor Software Corporation.

Try a sample ERP order

The fictional CSV shows two products split across four cartons. The invoiced quantity appears once per SKU.

Test it in the packing list checker

Review origin and filing separately

USMCA certification applies only when goods qualify. The certifier determines origin eligibility; Packlistly does not legally certify tariff-shift or regional value content qualification. Packlistly does not file AES/EEI in ACE; an authorized filer handles any required AES/EEI filing.

Start Free — 5 shipments/month, no cardTry the free USMCA checker

Compare plans · See export document templates

Frequently asked questions

Is Packlistly a live native Epicor Prophet 21 (P21) API, DynaChange, or SQL connector?

No. Packlistly uses a manual CSV/Excel upload workflow included on Free ($0/month, 5 shipments, 1 user) through Enterprise ($599/month, 3,000 shipments, 50 users), requiring no Prophet 21 DynaChange rule, middleware add-on, or database write-back. Teams with developer resources can also post structured orders via the REST Order API on Starter ($29/month) and higher plans.

Which Epicor Prophet 21 columns should our Order Entry or Pick Ticket export include?

Export item-level rows for a single wholesale shipment—such as Item ID, Extended Description, Shipped Qty or Ordered Qty, Pricing/Selling Unit of Measure, and Unit Price—along with the P21 order or pick-ticket number and 3-letter ISO currency rather than an Accounts Receivable invoice-header summary.

How do industrial wholesale distributors handle multi-origin MRO, fastener, fluid-power, and HVAC cartons?

Wholesale distributors often ship dozens of mixed-origin SKUs on the same export pallet. After uploading P21 order lines into Packlistly, your warehouse team assigns each line its verified manufacturing Country of Origin (LineItem.origin) and 6-to-10-digit HS/Schedule B code, distributes units across cartons, crates, and ISPM-15 pallets, and checks net/gross lb or kg weights.

Does Packlistly transmit EDI 856/810, file AES/EEI in ACE, or determine USMCA origin?

No. Packlistly generates up to 10 synchronized export PDFs and checks cross-document quantities, weights, >$2,500 shared Schedule B SLI totals, VGM math, and 9-element USMCA/CUSMA field presence. It does not transmit ANSI X12/EDIFACT EDI messages, does not file AES/EEI in ACE, does not screen restricted parties, and does not determine HS/Schedule B codes, ECCN/ITAR/EAR export licenses, or legal USMCA origin qualification.