Migrate from Aptean Compiere ERP to Acumatica

Compiere BP with Type=Customer maps directly to Acumatica Customer. Name, email, phone, address fields copy across. BP.CreditLimit maps to Customer.CreditLimit. If the BP has both customer and vendor flags, we create both a Customer and a Vendor record and link them by the original BP_ID stored in Source_System_ID__c.

Compiere BP with Type=Vendor maps to Acumatica Vendor. Same field set as Customer — name, address, payment terms, tax ID. Vendors do not carry the same credit-limit semantics; Acumatica Vendor.CreditLimit represents accounts payable hold rather than sales credit exposure. This distinction ensures that vendor credit limits are applied only to purchase transactions, not to sales orders.

Compiere Product maps 1:1 to Acumatica Stock Item. Name, Description, UOM, Unit Cost, Sales Price, Product Category all migrate directly. Products marked as 'Service' in Compiere map to Acumatica Non-Stock Items. The Compiere Value per Price List rule becomes Acumatica's Price Matrix entries.

Compiere Warehouse stores up to 5 dimension levels per Locator (Aisle.Bin.Rack.Level.Bay). Acumatica's Location field holds a single string. We concatenate Compiere's dimension values using a dot separator and write the result to Acumatica's Location field. Your Acumatica admin pre-configures Location codes in the Warehouses screen before migration.

Compiere C_Order with DocStatus=CO (Completed) or CL (Closed) migrates to Acumatica Sales Order. Order number, order date, customer reference, branch, line items with quantity and unit price all map directly. Open orders migrate as Sales Orders in Open status so they can be fulfilled in Acumatica.

Compiere M_PO with DocStatus=CO or CL migrates to Acumatica Purchase Order. Vendor reference, order date, line items, receipt warehouse all map 1:1. Open purchase orders migrate in Open status so goods receipts can still post in Acumatica. The order number and original PO date are preserved in Acumatica for audit trail continuity.

Compiere C_Invoice (invoiced, not cash-positions) with IsSOTrx=Y migrates to Acumatica AR Invoice. Invoice number, date, due date, customer, amount, description, and line items all map. Original Compiere document number is preserved in a custom field for audit traceability. All payments and credit memos linked to the invoice are also migrated as separate AR adjustments.

Compiere C_Invoice with IsSOTrx=N migrates to Acumatica AP Invoice. Same field mapping as AR Invoice but against the Vendor entity. Vendor invoice number and invoice date copy across. Prepayments (Compiere Allocations) are not migrated as AP Invoices — they require Acumatica-side configuration.

Compiere Fact_Acct lines map to Acumatica Journal Transactions against the pre-created Chart of Accounts. Original posting date, account, debit, credit, and description all migrate. Trial balance data is included; full historical detail lines migrate unless the scope excludes pre-2020 data. Account numbers must exist in Acumatica before this step runs.

Compiere AD_User records map to Acumatica Employees for internal users and to Customer Contacts for external-facing contacts. Email address is the match key. Users with Compiere roles that have no Acumatica equivalent are flagged for your admin to reassign in the Acumatica Users screen post-migration.

Compiere M_PriceList entries with EffectiveDate and BreakQty rules map to Acumatica Price Matrix detail lines. Value-based price lists migrate as fixed prices; discount-based lists require Acumatica-side Price Manager configuration. The active Compiere price list at migration date becomes the default for new documents.

Compiere C_PaymentTerm records (Net 30, 2/10 Net 30, etc.) map to Acumatica Terms. The Due type (days vs. fixed date) and discount day/percent values migrate directly. If Compiere uses custom payment terms, we create matching Terms records in Acumatica before documents land.

Compiere C_Tax records (rate, name, tax type) map to Acumatica Tax codes. Tax zone assignment requires your Acumatica admin to configure Tax Zones linking the tax code to customer tax categories. We migrate the tax code name and rate; tax zone binding is a post-migration configuration step.

Compiere ADempiere custom columns added via Data Dictionary with Entity Type=User map to Acumatica User-Defined Fields. Field data type translates: VARCHAR to String, NUMERIC to Decimal, DATE to Date, BOOLEAN to Boolean. The UDF must be created in Acumatica's Customization > Forms screen before migration; we surface a pre-migration UDF creation worksheet listing every custom field.