Migrate from Kentro ERP & 3PL to Acumatica

Kentro products map to Acumatica Inventory Items. We preserve the Kentro SKU as InventoryCD, map the product description to Description, and set the Stock Item checkbox based on whether the product is inventory-bearing in Kentro. UOM (each, case, pallet) maps to a UOM class in Acumatica with cross-reference to Kentro's unit of measure.

Kentro customers migrate to Acumatica Customers with Bill-To and Ship-To locations. Kentro's billing address and shipping address become separate location records under the customer. Customer class in Acumatica is set based on Kentro's customer type (wholesale vs. D2C) to apply the correct tax zone and payment terms.

Kentro suppliers map to Acumatica Vendors. The supplier's address, contact email, and payment terms migrate as Vendor attributes. We preserve the supplier's Kentro ID in a custom field for reconciliation against purchase history. We also assign a Vendor Class based on the supplier’s category to set payment terms and tax zones. Bank account details for ACH can be migrated to Acumatica’s Vendor payment methods with appropriate security handling.

Open Kentro orders become Acumatica Sales Orders with the original order date preserved as OrderNbr. reference. Kentro's order-status values (pending, processing, shipped) map to Acumatica's order status workflow. Each line item maps to Sales Order Detail with InventoryID, quantity, and the Kentro shipping method mapped to ShipVia.

Kentro's fulfillment records are split across Acumatica's Shipment and Inventory Transaction entities. The fulfillment ID becomes the Shipment Nbr.; line-level shipped quantities create Inventory Receipt or Issue transactions to update on-hand. Original carrier and tracking number migrate as Shipment attributes.

Kentro's bin-level on-hand quantity per warehouse becomes an Inventory Item Site record per Site (warehouse). Kentro's FEFO priority number maps to a Lot/Serial Nbr. class if Acumatica uses lot tracking, or is preserved as a custom field for fulfillment sequencing. Qty. Available is recalculated in Acumatica based on allocated and available logic.

Open Kentro purchase orders migrate to Acumatica Purchase Orders with Vendor, line items (InventoryID + quantity), and expected delivery date preserved. Kentro PO status maps to Acumatica's PO status field. Line-level discounts, shipping instructions, and any notes attached to each PO are also transferred as attributes on the Purchase Order detail. If Kentro records the buyer contact, we map that to the Requested By field in Acumatica for traceability.

Kentro's 3PL service records (cross-dock flag, Amazon FBA prep status, white-glove flag) have no native Acumatica equivalent. We preserve these as custom fields on the Shipment (e.g., FulfillmentType__c) and include a migration note for your Acumatica admin to configure fulfillment workflow rules.

Kentro backorder records map to Acumatica's availability check result on the Sales Order. Backordered quantity appears as a line-level note; the original backorder date is preserved as a custom field. Fulfillment rules for backorder release are documented for rebuild in Acumatica's automation.

Kentro's channel label (Shopify, Amazon, TikTok) per order has no native Acumatica equivalent on Sales Order. We create an OrderSource__c custom field and populate it with the Kentro channel name. This enables Acumatica Generic Inquiry filters to segment by channel.

Kent returns migrate as credit memos or adjustment lines in Acumatica. If inventory is returned to a specific bin, we create an Inventory Issue transaction. Return reason codes map to a custom field for reporting. The credit memo links to the Sales Order so AR can be offset. Returned inventory cost posts to the COGS account, and we preserve the timestamp for reporting. Acumatica generates it from the credit memo.

Kentro's product listing variations per channel (e.g., Shopify SKU vs. Amazon ASIN) map to Acumatica's Inventory Cross-Reference table. We preserve the channel-specific identifier in a custom field on each InventoryID cross-reference record. This cross-reference lets Acumatica match marketplace sales to the correct inventory item automatically. It can also store the channel price for reference during order import.