Migrate from Sage Line 50 to Adempiere

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Overview

What is Sage Line 50?

Line 50 by Sage([1]) is a financial software. This page helps with migrating from Line 50 to ADempiere.

Outline of the Migration

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

Customers

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

  • 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

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

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

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


PURCHASE_LEDGER->I_BPARTNER

  • ACCOUNT_REF -> VALUE
  • NAME -> NAME

PURCHASE_LEDGER->C_BPARTNER

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

  • 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

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


STOCK->I_PRODUCT

STOCK_CODE -> VALUE DESCRIPTION -> NAME UNIT_OF_SALE -> C_UOM_ID - need to map these SUPPLIER_PART_NUMBER -> VENDORPRODUCTNO WEB_DESCRIPTION -> DESCRIPTION

STOCK->M_PRODUCT