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..
0
Comments
in new version too.because it contains some data and its not good to lost it.
(Sr. Tech. Consultant)
Dataman Computer Systems (P) Ltd.
web :www.datamannet.com
mail :nrapendra@datamannet.com
](*,)
Not fun, I know...
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
If i would be you, i would prefer to save data in some table(offcourse with primary keys) for future reference.
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???????
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
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.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
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????