Migrate from Bizowie ERP to Acumatica

Bizowie customer records map 1:1 to the Acumatica Customer DAC (AR303000 screen). Primary address, contact info, and credit terms transfer directly. Multi-company associations in Bizowie (N:N) collapse to a single primary Customer record in Acumatica — secondary associations can be re-created using Contact records if needed.

Bizowie vendor records map to Acumatica's Vendor DAC (AP303000 screen). Payment terms, tax ID, and remittance address transfer directly. Multi-location vendor addresses map to Acumatica's vendor location model — Bizowie vendor address records become separate VendorLocation entries keyed by the vendor record.

Bizowie item records with inventory tracking map to Acumatica's StockItem DAC (IN202500 screen). Item class, description, UOM, and lot/serial settings transfer directly. Items flagged as non-stock in Bizowie map to Acumatica Non-Stock Items — the ItemType field drives the target DAC. Bizowie units-of-measure conversions map to Acumatica's UOM table with conversion factors preserved.

Open Bizowie sales orders with status 'open' or 'partial' migrate to Acumatica's SOOrder DAC (SO301000 screen). Order type (Regular, Blanket, Transfer) maps to the OrderType field; line items, discounts, and warehouse assignments transfer as SOLine records. Completed or cancelled orders migrate as historical records in the SOShipment and ARTran tables for financial continuity.

Open Bizowie purchase orders migrate to Acumatica's POOrder DAC (PO301000 screen). Vendor, PO type, line items, and expected delivery dates map directly. POLine records carry item, quantity, and cost from Bizowie. Closed POs are recorded as historical receipts in APRegister or POLandedCostDoc as applicable for financial audit trails.

Bizowie invoices map to Acumatica's ARInvoice DAC (AR301000 screen). Customer reference, invoice date, due date, terms, and line amounts transfer directly. Tax amounts map to Acumatica's tax zone model — Bizowie tax codes are mapped value-by-value to Acumatica tax bucket IDs before migration. Prepayments and credit memos are flagged separately in the DocType field.

Bizowie vendor bills migrate to Acumatica's APInvoice DAC (AP301000 screen). Vendor reference, invoice date, terms, and line costs transfer directly. GL account assignments on bill lines map to the appropriate Acumatica expense or inventory account based on the Bizowie account code. Discount terms are preserved in Acumatica's PaymentTerms DAC.

Bizowie GL chart-of-accounts records map to Acumatica's Account DAC (GL202500 screen). Account code, description, account type (Asset, Liability, Equity, Income, Expense), and active/inactive status transfer directly. Bizowie subaccounts require mapping to Acumatica's sub-account dimension — FlitStack generates a subaccount mapping table based on Bizowie subaccount segment values before the GL migration runs.

Historical Bizowie journal entries map to Acumatica GLTran records attached to Batch records in the GL301000 screen. Each line carries account, subaccount, debit/credit amount, and description. Beginning balances are loaded as opening journal entries in the current period rather than back-filling closed periods — this keeps historical trial balance intact while Acumatica's posting logic validates account-type consistency.

Bizowie warehouse records map to Acumatica's Warehouse DAC (WH204000 screen). Warehouse code, name, and address transfer directly. Bizowie bin/location structures map to Acumatica Location records under each Warehouse. If Bizowie bin naming follows a convention (zone-rack-level pattern), FlitStack parses the convention and generates the corresponding Location records in Acumatica.

Bizowie lot numbers on in-stock inventory migrate to Acumatica's LotSerial nbr field on the INTran record. Each item's lot/serial class from Bizowie is mapped to the corresponding Lot/Serial Class in Acumatica. Expiration dates on Bizowie lots transfer as LotExpirationDate in Acumatica. Serial number tracking follows the same path with ItemSerial records created per unit.

Bizowie user records are matched to Acumatica users by email address. If a Bizowie user has no corresponding Acumatica account, they are added to a fallback contact group and flagged. Owner assignments on Bizowie records (sales orders, quotes) transfer as the Acumatica OwnerID field on the corresponding document DAC.

Bizowie custom fields on any entity become Acumatica user-defined fields with a Usr prefix (e.g., UsrShipViaCode on SOOrder). FlitStack generates a field creation plan listing each custom field's data type, pick-list values, and target DAC before migration runs. N:N associations in Bizowie custom objects are flattened into 1:N relationships in Acumatica's DAC model — junction tables are created as custom DACs with proper PK/FK setup.