Migrate from Sage Line 50 to Adempiere
Overview[edit]
What is Sage Line 50?[edit]
Line 50 by Sage([1]) is a financial software. This page helps with migrating from Line 50 to ADempiere.
Outline of the Migration[edit]
The data migration process involves connecting the ODBC-JDBC bridge to the system ODBC data source created when Sage Line 50 installs (e.g. SageLine50v10). You can connect to this data source (no username or password) as read only and then export the records from Sage Line 50 in to Adempiere.
Not all data can be easily migrated for Sage Line 50. This page explores how you can get the majority of data from Sage Line 50 in to Adempiere. You will need to review your Adempiere data after you have imported it or modify the mappings for your implementation. e.g. to group suppliers according to your business partner groups
The following mappings (based on Sage Line 50 v 10 UK Version) will assist you in this process.
Mapping[edit]
Customers[edit]
1. Load data in to the I_BPARTNER table
2. Load data in to the C_BPARTNER table
3. Load Data in to the C_BPARTNER_LOCATION table
SALES_LEDGER->I_BPARTNER[edit]
- ACCOUNT_REF->VALUE
- NAME->NAME
- ADDRESS_1->ADDRESS1
- ADDRESS_2->ADDRESS2
- ADDRESS_3->CITY
- ADDRESS_4->REGIONNAME
- ADDRESS_5->POSTAL
- CONTACT_NAME->CONTACTNAME
- TELEPHONE->PHONE
- TELEPHONE_2->PHONE2
- FAX->FAX
- E_MAIL->EMAIL
SALES_LEDGER->C_BPARTNER[edit]
ISCUSTOMER='Y' - make sure the business partner is marked as a customer
- WEB_ADDRESS->URL
- FIRST_INV_DATE->FIRSTSALE
- VAT_REG_NUMBER->TAXID
- CREDIT_LIMIT->SO_CREDITLIMIT
- CREDIT_REF->DUNS
- BALANCE->TOTALOPENBALANCE - caution with this - this may be calculated if you imort invoices ...
To Be Mapped[edit]
C_BPARTNER_LOCATION
- C_ADDRESS_1->
- C_ADDRESS_2->
- C_ADDRESS_3->
- C_ADDRESS_4->
- C_ADDRESS_5->
- DEL_ADDRESS_1->
- DEL_ADDRESS_2->
- DEL_ADDRESS_3->
- DEL_ADDRESS_4->
- DEL_ADDRESS_5->
To be analysed
- TRADE_CONTACT->
- DEL_NAME->
- DEL_CONTRACT_NAME->
- DEL_TELEPHONE->
- DEL_FAX->
- ANALYSIS_1->
- ANALYSIS_2->
- ANALYSIS_3->
- DEPT_NUMBER->
- DEPT_NAME->
- STATUS_NUMBER->
- STATUS_TEXT->
- DEF_TAX_CODE->
- DEF_NOM_CODE->
- CURRENCY->
- COUNTRY_CODE->
- DISCOUNT_TYPE->
- DISCOUNT_RATE->
- PRICING_REF->
- SETTLEMENT_DISC_RATE->
- SETTLEMENT_DUE_DAYS->
- PAYMENT_DUE_DAYS->
- ACCOUNT_ON_HOLD->
- TERMS->
- RESTRICT_MAIL->
- TERMS_AGREED->
- DATE_ACCOUNT_OPENED->
- DATE_NEXT_CREDIT->
- DATE_LAST_CREDIT->
- CAN_CHARGE->
- BUREAU_CODE->
- DATE_CREDIT_APPLIED->
- DATE_CREDIT_RECEIVED->
- OVERRIDE_TAX_CODE->
- LAST_PAYMENT_DATE->
- LAST_INV_DATE->
- TURNOVER_MTD->
- TURNOVER_YTD->
- PRIOR_YEAR->
Not Mapped[edit]
These fields are calculated in Adempiere from the invoices you import
- INVOICE_BF -> NOT REQUIRED
- INVOICE_MTH1 -> NOT REQUIRED
- INVOICE_MTH2 -> NOT REQUIRED
- INVOICE_MTH3 -> NOT REQUIRED
- INVOICE_MTH4 -> NOT REQUIRED
- INVOICE_MTH5 -> NOT REQUIRED
- INVOICE_MTH6 -> NOT REQUIRED
- INVOICE_MTH7 -> NOT REQUIRED
- INVOICE_MTH8 -> NOT REQUIRED
- INVOICE_MTH9 -> NOT REQUIRED
- INVOICE_MTH10 -> NOT REQUIRED
- INVOICE_MTH11 -> NOT REQUIRED
- INVOICE_MTH12 -> NOT REQUIRED
- INVOICE_CF -> NOT REQUIRED
- CREDIT_BF -> NOT REQUIRED
- CREDIT_MTH1 -> NOT REQUIRED
- CREDIT_MTH2 -> NOT REQUIRED
- CREDIT_MTH3 -> NOT REQUIRED
- CREDIT_MTH4 -> NOT REQUIRED
- CREDIT_MTH5 -> NOT REQUIRED
- CREDIT_MTH6 -> NOT REQUIRED
- CREDIT_MTH7 -> NOT REQUIRED
- CREDIT_MTH8 -> NOT REQUIRED
- CREDIT_MTH9 -> NOT REQUIRED
- CREDIT_MTH10 -> NOT REQUIRED
- CREDIT_MTH11 -> NOT REQUIRED
- CREDIT_MTH12 -> NOT REQUIRED
- CREDIT_CF -> NOT REQUIRED
- PAYMENT_BF -> NOT REQUIRED
- PAYMENT_MTH1 -> NOT REQUIRED
- PAYMENT_MTH2 -> NOT REQUIRED
- PAYMENT_MTH3 -> NOT REQUIRED
- PAYMENT_MTH4 -> NOT REQUIRED
- PAYMENT_MTH5 -> NOT REQUIRED
- PAYMENT_MTH6 -> NOT REQUIRED
- PAYMENT_MTH7 -> NOT REQUIRED
- PAYMENT_MTH8 -> NOT REQUIRED
- PAYMENT_MTH9 -> NOT REQUIRED
- PAYMENT_MTH10 -> NOT REQUIRED
- PAYMENT_MTH11 -> NOT REQUIRED
- PAYMENT_MTH12 -> NOT REQUIRED
- PAYMENT_cf -> NOT REQUIRED
Suppliers[edit]
PURCHASE_LEDGER->I_BPARTNER[edit]
- ACCOUNT_REF -> VALUE
- NAME -> NAME
PURCHASE_LEDGER->C_BPARTNER[edit]
ISVENDOR = 'Y' - flag this as a vendor / supplier
- WEB_ADDRESS -> URL
- VAT_REG_NUMBER -> TAXID
- CREDIT_LIMIT -> SO_CREDITLIMIT
- CREDIT_REF -> DUNS
To Be Mapped[edit]
- ADDRESS_1
- ADDRESS_2
- ADDRESS_3
- ADDRESS_4
- ADDRESS_5
- C_ADDRESS_1
- C_ADDRESS_2
- C_ADDRESS_3
- C_ADDRESS_4
- C_ADDRESS_5
- CONTACT_NAME
- TELEPHONE
- TELEPHONE_2
- FAX
- E_MAIL
- TRADE_CONTACT
- DEL_NAME
- DEL_ADDRESS_1
- DEL_ADDRESS_2
- DEL_ADDRESS_3
- DEL_ADDRESS_4
- DEL_ADDRESS_5
- DEL_CONTACT_NAME
- DEL_TELEPHONE
- DEL_FAX ANALYSIS_1
- ANALYSIS_2
- ANALYSIS_3
- DEPT_NUMBER
- DEPT_NAME
- STATUS_NUMBER
- STATUS_TEXT
- DEF_TAX_CODE
- DEF_NOM_CODE
- CURRENCY
- COUNTRY_CODE
- DISCOUNT_RATE
- SETTLEMENT_DISC_RATE
- SETTLEMENT_DUE_DAYS
- PAYMENT_DUE_DAYS
- ACCOUNT_ON_HOLD
- TERMS
- RESTRICT_MAIL
- TERMS_AGREED
- DATE_ACCOUNT_OPENED
- DATE_NEXT_CREDIT
- DATE_LAST_CREDIT
- USE_BACS
- USE_BSOC
- BACS_REF
- DATE_CREDIT_APPLIED
- DATE_CREDIT_RECEIVED
- OVERRIDE_TAX_CODE
- LAST_PAYMENT_DATE
- FIRST_INV_DATE
- LAST_INV_DATE
- BALANCE TURNOVER_MTD
- TURNOVER_YTD
- PRIOR_YEAR
- BANK_NAME
- BANK_ADDRESS_1
- BANK_ADDRESS_2
- BANK_ADDRESS_3
- BANK_ADDRESS_4
- BANK_ADDRESS_5
- BANK_SORT_CODE
- BANK_ACCOUNT_NAME
- BANK_ACCOUNT_NUMBER
Not Mapped[edit]
These are calculated after import of purchase invoices in Adempiere
- INVOICE_BF -> NOT REQUIRED
- INVOICE_MTH1 -> NOT REQUIRED
- INVOICE_MTH2 -> NOT REQUIRED
- INVOICE_MTH3 -> NOT REQUIRED
- INVOICE_MTH4 -> NOT REQUIRED
- INVOICE_MTH5 -> NOT REQUIRED
- INVOICE_MTH6 -> NOT REQUIRED
- INVOICE_MTH7 -> NOT REQUIRED
- INVOICE_MTH8 -> NOT REQUIRED
- INVOICE_MTH9 -> NOT REQUIRED
- INVOICE_MTH10 -> NOT REQUIRED
- INVOICE_MTH11 -> NOT REQUIRED
- INVOICE_MTH12 -> NOT REQUIRED
- INVOICE_CF -> NOT REQUIRED
- CREDIT_BF -> NOT REQUIRED
- CREDIT_MTH1 -> NOT REQUIRED
- CREDIT_MTH2 -> NOT REQUIRED
- CREDIT_MTH3 -> NOT REQUIRED
- CREDIT_MTH4 -> NOT REQUIRED
- CREDIT_MTH5 -> NOT REQUIRED
- CREDIT_MTH6 -> NOT REQUIRED
- CREDIT_MTH7 -> NOT REQUIRED
- CREDIT_MTH8 -> NOT REQUIRED
- CREDIT_MTH9 -> NOT REQUIRED
- CREDIT_MTH10 -> NOT REQUIRED
- CREDIT_MTH11 -> NOT REQUIRED
- CREDIT_MTH12 -> NOT REQUIRED
- CREDIT_CF -> NOT REQUIRED
- PAYMENT_BF -> NOT REQUIRED
- PAYMENT_MTH1 -> NOT REQUIRED
- PAYMENT_MTH2 -> NOT REQUIRED
- PAYMENT_MTH3 -> NOT REQUIRED
- PAYMENT_MTH4 -> NOT REQUIRED
- PAYMENT_MTH5 -> NOT REQUIRED
- PAYMENT_MTH6 -> NOT REQUIRED
- PAYMENT_MTH7 -> NOT REQUIRED
- PAYMENT_MTH8 -> NOT REQUIRED
- PAYMENT_MTH9 -> NOT REQUIRED
- PAYMENT_MTH10 -> NOT REQUIRED
- PAYMENT_MTH11 -> NOT REQUIRED
- PAYMENT_MTH12 -> NOT REQUIRED
- PAYMENT_CF -> NOT REQUIRED
Inventory[edit]
STOCK->I_PRODUCT[edit]
STOCK_CODE -> VALUE DESCRIPTION -> NAME UNIT_OF_SALE -> C_UOM_ID - need to map these SUPPLIER_PART_NUMBER -> VENDORPRODUCTNO WEB_DESCRIPTION -> DESCRIPTION
