Sage 100 export documents
Reconcile Sage 100 sales and shipping records with a Commercial Invoice, multi-carton Packing List and Carton Labels.
Match Sales Order Entry, lot and serial records, and Shipping Data Entry
U.S. and Canadian mid-market distributors and manufacturers using Sage 100 (formerly MAS 90 / MAS 200) can prepare a team-approved .xlsx or .csv extract. Match Shipping Data Entry to the actual dispatch. Use the available Business Insights Explorer (BIE) export, a configured Visual Integrator (VI) export job or an approved Crystal Reports or Excel extract. Save the relevant values for the shipment before mapping.
| Source record | Fields to map | Review before handoff |
|---|---|---|
| Sales Order Entry or invoice | Order and line references, item code, selling unit, invoice quantity, unit price and currency | Use the invoice and order lines that correspond to the dispatched release, especially on partial shipments. |
| Shipping Data Entry and lot or serial allocation | Shipment reference, shipped quantities, warehouse and lot or serial IDs where applicable | Match actual shipped quantities and lot or serial allocations to the order. Record any selling-to-shipping unit conversion. |
| Warehouse pack-out | Package IDs, item allocation, marks, dimensions and measured net and gross weights | Compare packed units and package counts with the invoice and draft transport document. |
See related file workflows for Sage 300, Sage X3 and Sage Intacct, Sage Accounting and Microsoft Dynamics GP.
After mapping the file, run the deterministic cross-document consistency checks and prepare up to 10 matched export documents, including the Commercial Invoice, Packing List and Carton Labels. Review the Shipper’s Letter of Instruction (SLI), USMCA fields and SOLAS VGM where applicable. For L/C shipments, compare dates, amounts and shipment terms against the credit and its amendments before presentation.
Review packed quantities, net and gross weights and required fields before preparing up to 10 matched export PDFs from the saved shipment, including Commercial Invoice (CI), Packing List (PL), SLI, SOLAS VGM and USMCA where applicable. Verify lot records against your ERP before handoff.
CSV/Excel mapping is included on Free ($0/month, 5 shipments and 1 user) through Enterprise ($599/month, 3,000 shipments and 50 users). Send mapped orders through the REST Order API on Starter ($29/month) and higher plans. The workflow uses approved exports and makes no changes to your ERP.
All 7 free export checkers · Commercial Invoice · Packing List · SLI · Draft B/L · SOLAS VGM · Letter of Credit · Sample PDFs · Try a sample order
Review mandatory-filing rules and the applicable 15 CFR § 30.37(a) value threshold with the responsible filer.
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
Which Sage 100 records should I use for a confirmed shipment?
Use Sales Order Entry for order references, selling units and commercial terms. Match Shipping Data Entry and applicable lot or serial records to the dispatched quantities and the physical pack-out.
How should I export Sage 100 shipping data?
Use an approved Business Insights Explorer view, configured Visual Integrator export job or reporting extract. Save the relevant values in CSV or Excel and check that order, shipping and pack-out lines refer to the same release.
Does Packlistly have a native Sage 100 or MAS 90 connector?
Packlistly does not connect by live API or EDI to Sage 100. Use approved CSV or Excel extracts. On Starter or higher, developers can send mapped orders through the Packlistly REST Order API.
Who handles export filings, origin and bank presentation?
Packlistly prepares up to 10 export documents and runs deterministic cross-document consistency checks. It does not file AES/EEI in ACE or submit destination filings. It does not provide legal tariff/origin determinations, certify FTA tariff-shift eligibility or make ECCN or license determinations. Packlistly does not issue UCP 600 or ISBP banking compliance opinions.