Migrate from BusinessCloud to Acumatica

BusinessCloud customer records map directly to Acumatica Customers (AR module). Each Customer retains its BusinessCloud ID in a custom ReferenceNbr field for delta-run de-duplication. Payment terms, credit limit, and tax zone map to corresponding Acumatica attributes. Customers marked inactive in BusinessCloud land as Hold status in Acumatica.

BusinessCloud vendor records map to Acumatica Vendors (AP module). Remit-to addresses map to Acumatica's VendorLocation entity. Tax ID (EIN/VAT) maps to Acumatica's Tax Registration ID. Vendor status (active/inactive) maps to Acumatica's Hold flag. We also map payment methods to Acumatica Payment Method IDs, ensuring consistent cash application across documents.

BusinessCloud items that represent services or one-time products map to Acumatica Non-Stock Items. Items with inventory tracking requirements map to Acumatica Stock Items. The item type decision is driven by a BusinessCloud item attribute flag — we surface this in the migration plan so your admin confirms the classification before load.

BusinessCloud AR invoice headers map to Acumatica AR Invoice documents. The invoice date, due date, terms, and reference number map directly. The BusinessCloud customer ID resolves to the Acumatica customer lookup. Document status (Open/Closed/Void) maps to Acumatica's Hold and Open/Released status flags.

BusinessCloud invoice lines map to Acumatica AR Invoice Details. Line description, quantity, unit price, and tax category map directly. The line's inventory or non-stock item ID resolves to the corresponding Acumatica item. Branch ID assignment uses BusinessCloud's entity/branch field to route the line to the correct Acumatica branch.

BusinessCloud AP invoice headers map to Acumatica AP Invoice documents. Vendor lookup resolves by matching the BusinessCloud vendor tax ID or name to Acumatica Vendors. Invoice date, due date, and terms map directly. Prepayments and credit memos carry their original document types into corresponding Acumatica document kinds.

BusinessCloud cash receipts map to Acumatica Payments applied to AR invoices. The payment method (cash, check, ACH) maps to Acumatica's Payment Method. Applied-to invoice references are preserved as application records linking the payment to the underlying AR document. ensuring accurate cash application.

BusinessCloud vendor payments map to Acumatica AP Payments. The payment method resolves to an Acumatica Payment Method. Unapplied amounts land as AP Payment with Hold status for manual resolution before release. We also map the payment date to the DocDate field and preserve the original vendor reference in a custom note field for auditability.

BusinessCloud accounts map to Acumatica Account records. If BusinessCloud uses a two-segment account code (e.g., 5000-010), the first segment becomes the Acumatica Account and the second becomes a Subaccount. If BusinessCloud uses a flat account list, all records land under a default Subaccount (000) with a migration plan for segmentation review.

BusinessCloud users and document owners resolve by email match against Acumatica Users. Unmatched owners are flagged in the pre-migration audit — your team either creates the Acumatica user account or assigns records to a fallback owner. No record lands without an owner assignment.

BusinessCloud custom fields map to Acumatica user-defined fields using the appropriate DacAttribute extension. The field type (text, number, date, pick-list) drives the Acumatica field definition. Pick-list values require explicit value-by-value mapping to Acumatica segments or attributes. Fields with no Acumatica equivalent land as custom fields on the relevant DAC with a naming convention prefix (BC_) for traceability.

BusinessCloud file attachments on records re-upload to Acumatica's file storage and attach to the corresponding document or entity. File size limits follow Acumatica's attachment constraints. Inline images in notes are downloaded and rehosted as Acumatica-attached files. ensuring full data integrity throughout the migration.