Upgrade from 3.7 to 5.0

sudokusudoku Member Posts: 50
Hi,
I have one problem while doing upgrade from 3.7 to 5.0.Please help me...

In 3.7 db, table 'Acc. Schedule Line' has one field 'Calculate'.this field
has been removed in 5 db and added two more fields.

Upgrade tool from 3.7 to 5 is not looking into this field 'calculate'.so while
importing new 5.0 objects into the database,I am getting error message saying

"You cannot delete or change the type of the Calculate filed (in the Acc.
Schedule LIne) before the value in the field is reduced..............)

What is my next step??

Thx in advance..

Comments

  • nrapendranrapendra Member Posts: 208
    i think u must create a field with same name and datatype
    in new version too.because it contains some data and its not good to lost it.
    Nrapendra Singh
    (Sr. Tech. Consultant)
    Dataman Computer Systems (P) Ltd.
    web :www.datamannet.com
    mail :nrapendra@datamannet.com
  • sudokusudoku Member Posts: 50
    In 3.7 db field 'calculate' in acc. scedule line table is standard field, it is not the custom field.In 5 db,instead of this field another two fields are created. Actually this type of conversion are handled by upgrade tool from 3.7to5, but it is not working...

    ](*,)
  • Alex_ChowAlex_Chow Member Posts: 5,063
    You have to write a process only report and blank out whatever is in there. Then move the value of that field to the upgraded database.

    Not fun, I know... :(
  • Ashu_bhattAshu_bhatt Member Posts: 28
    The error you are getting its because data in that field is not blank. You handle this in upgradetoolkit 1. Look at the code in the codeunit.

    If i would be you, i would prefer to save data in some table(offcourse with primary keys) for future reference.
  • sudokusudoku Member Posts: 50
    I 2 got the idea of copying the field value into another table with primary key fields and copying back after upgrade.

    but the field calculate in 3.7 db is divided into 2 fields in 5.0 db.
    ex: in 3.7 calculate field option values are:
    Net Change,Begining Balance,Ending Balance,Debit only,credit only.
    now in 5.0 db acc. schedule line table has two new fields
    row type with option values net change,balance at date,begining balance.
    account type with option values net amount,debit amount,credit amout.

    So i confused to which field i have to copy the values of calcualte?

    any idea???????
  • Ashu_bhattAshu_bhatt Member Posts: 28
    I think you need better understanding about the fields.

    The example you gave is a flowfields. So following your example, i would transfer data to G/l Entry table considering filters for Netchange, Debit or credit amount fields so that data will reflect on corresponding fields.

    I might need to upgrade customers frm 3.70 to Navision 5. Do post your re-solutions, i will be followong this link :D
  • Alex_ChowAlex_Chow Member Posts: 5,063
    The Calculate field on the acc. schedule line table is not a flowfield.

    What I would do is to export the values in the dataport, then import those values into 5.0 and populating the Row Type and the Amount Type based on whatever value is in the Calculate field in the old version.
  • sudokusudoku Member Posts: 50
    Hi Alex,

    What you have suggested me is corrcet.Can you please explain me indetail, populating the Row Type and the Amount Type based on whatever value is in the Calculate field in the old version.

    I considered like:

    CASE "3.7 Acc. Sche. Table".Calculate OF
    "3.7 Acc. Sche. Table".Calculate::"Net Change":
    "5 Acc. Sche Line"."Row Type" := "5 Acc. Sche Line"."Row Type"::"Net Change";
    "3.7 Acc. Sche Table".Calculate::"Begining Balance":
    "5 Acc. Sche Line"."Row Type" := "5 Acc. Sche Line"."Row Type"::"Begining Balance";
    "3.7 Acc. Sche Table".Calculate::"Ending Balance":
    "5 Acc. Sche Line"."Row Type" := "5 Acc. Sche Line"."Row Type"::"Balance at Date";
    "3.7 Acc. Schedule Table".Calculate::"Debit Only":
    "5 Acc. Sche Line"."Amont Type" := "5 Acc. Sche Line"."Row Type"::"Debit Amount";
    "3.7 Acc. Sche Table".Calculate::"Credit Only":
    "5 Acc. Sche Line"."Amont Type" := "5 Acc. Sche Line"."Row Type"::"Credit Amount";
    END;
    "5 Acc. Sche Line".modify(true);

    Correct me...Why upgrade toolkit is not handling this situation????
Sign In or Register to comment.