Migrate from Sage Line 50 to Adempiere

From ADempiere ERP Wiki
(Redirected from Sage Line 50)
Jump to navigationJump to search

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

STOCK->M_PRODUCT[edit]