Migrate from JTL-Wawi to Acumatica

JTL items map directly to Acumatica StockItem (for physical goods held in inventory) or NonStockItem (for dropship or service items). We preserve the JTL item internal ID as RefNbr for traceability. Items flagged as 'Stücklist' (bill of materials) in JTL require Acumatica's BOM module to be enabled and configured by your Acumatica admin before migration runs.

JTL stores item attributes as a JSON column (Eigenschaften) per article containing key-value pairs like {color: red, size: XL, material: cotton}. We parse this JSON and create one Acumatica CSAttributeGroup entry per JTL attribute group, then link each parsed attribute to the corresponding InventoryItem row. Attributes with pick-list values in JTL become CSAttributeDefinition entries with predefined options in Acumatica.

JTL customer records contain both person-level and company-level data in a single record. We split this into Acumatica's BusinessAccount (company information, TaxRegistration IDs) as the parent and Contact (first name, last name, email, phone) as the child. JTL's delivery addresses become additional BQLocation records on the BusinessAccount with the IsDefaultBilling and IsDefaultShipping flags set per JTL address type.

JTL's Firmen table (company-level records used when JTL customer is a business entity) maps directly to Acumatica BusinessAccount with the AccountType = 'Customer' or 'Vendor' set based on JTL's firm type flag. Tax registration numbers from JTL's Steuernummer field migrate to the TaxRegistration collection on BusinessAccount.

JTL sales orders (Auftrag) migrate as Acumatica SOOrder records with the status mapped based on JTL's order status: 'Offen' (open) → SOOrderStatus.Open, 'Bezahlt' (paid) → SOOrderStatus.Completed, 'Storniert' → SOOrderStatus.Cancelled. Order lines map to SOLine with InventoryID resolved from the JTL article reference. JTL's internal order number is stored as an extended field (UsrJTLOrderNbr__) for reconciliation.

JTL delivery notes (Lieferschein) created from shipped orders map to Acumatica SOShipment records. The shipment links to the corresponding SOOrder via the OrderNbr field. Carrier and tracking information from JTL's Versanddienstleister field migrates to SOShipment.ShipVia and SOShipment.TrackingNumber respectively. Multiple Lieferschein for a single Auftrag in JTL create multiple SOShipment records in Acumatica.

JTL invoices (Ausgangsrechnung) migrate to Acumatica ARInvoice. Tax amounts from JTL's MwSt (VAT) breakdown are preserved in ARTran tax fields. JTL's payment status (Zahlstatus) maps to ARInvoice.Status: unpaid → ARInvoiceStatus.Open, paid → ARInvoiceStatus.Closed. Where JTL tracks partial payments, we create multiple ARPayment records linked to the ARInvoice.

JTL purchase orders (Bestellung) migrate to Acumatica POOrder. Supplier resolution happens by matching JTL's Lieferant reference against the BusinessAccount.VendorClass and VendorLocation setup. POOrder status follows the same mapping logic as sales orders. Expected delivery dates from JTL's Lieferdatum migrate to POOrder.PromisedDate on POLine.

JTL goods receipts (Wareneingang) linked to a purchase order migrate as Acumatica POReceipt to update inventory quantities. If a JTL Wareneingang also triggers an invoice, both POReceipt and APInvoice are created with the APInvoice linked to the POReceipt via the ReceiptNbr field. Standalone Wareneingang records without a PO order are imported as POReceipt only.

JTL inventory quantities per warehouse are mapped to Acumatica's INSiteStatus (total on-hand per site) and INLocationStatus (bin-level breakdown if JTL uses Lagerplätze). If JTL has a single warehouse and Acumatica has multiple sites defined, we prompt for a site-mapping rule — by default all stock lands in the Acumatica default site (WHOLESALE or the site designated as default).

JTL address records (Anschrift) with type flags (Rechnungsadresse, Lieferadresse) migrate to Acumatica Address records attached to BQLocation. Full street, city, postal code, and country are mapped field-by-field. JTL's Zustelladresse (special delivery instructions) is appended to the Address.AddressLine2 field in Acumatica for visibility.

JTL item images are stored as URLs or local file paths referencing the JTL database's Bilder table. We re-download and re-upload these as Acumatica UploadFile records, then attach them to the corresponding InventoryItem via NoteDoc. Image ordering (primary image, gallery order) from JTL is preserved as NoteDoc NoteID order in Acumatica.