Difference between revisions of "Migrate from Sage Line 50 to Adempiere"
m (Typo correction i nto >> in to) |
(→Not Mapped) |
||
Line 272: | Line 272: | ||
* PAYMENT_MTH12 -> NOT REQUIRED | * PAYMENT_MTH12 -> NOT REQUIRED | ||
* PAYMENT_CF -> NOT REQUIRED | * PAYMENT_CF -> NOT REQUIRED | ||
− | |||
===Inventory=== | ===Inventory=== |
Revision as of 06:33, 12 January 2008
Contents
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