'CFR' variable error when importing Nav4.0SP1 objects

m.pacanam.pacana Member Posts: 75
Im trying to import the NA400SP1Objects.fob i got from the partnersource into my Navision 4.0 application, and im having an unknown variable error 'CFR'

do you have any idea on this issue?

thanks

Comments

  • Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
  • m.pacanam.pacana Member Posts: 75
    the error was displayed when i import the fob file. it doesnt state where or on what object does it occurs.. have any idea where and why does this happen?
  • ara3nara3n Member Posts: 9,257
    are you using sp1 executable or 4.0?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • m.pacanam.pacana Member Posts: 75
    I have a navision 4.0 currently installed in my pc and im trying to export the sp1 objects. is this the right thing to do?
  • m.pacanam.pacana Member Posts: 75
    What really comprises the navision sp1? is it an fob file or is there an appropriate executable for this to be upgraded in navision 4.0? :)
  • ara3nara3n Member Posts: 9,257
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • m.pacanam.pacana Member Posts: 75
    thanks a lot.. :lol:
  • ara3nara3n Member Posts: 9,257
    welcome a lot. :mrgreen:
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • m.pacanam.pacana Member Posts: 75
    Hello again,

    I already have a Navision 4.0 SP1 product installer and NA400SP1Objects.fob. I already installed the 4.0 SP1 installer, but when i tried to import the NA400SP1Objects.fob, Same error still occurs. Do i still need to import the fob after I installed the 4.0 SP1 full installation?

    Also, I also noticed that the Navision 4.0 SP1 product installer i have does not create a database.fdb and Sql option database upon fresh installation. So i still need to install a previous version (Nav 4), then uninstall it but leaving the database files, then install 4.0 SP1.

    Am i doing the right thing here? thanks
  • m.pacanam.pacana Member Posts: 75
    ara3n wrote:
    are you using sp1 executable or 4.0?


    Im now using the sp1 executable but the databases are from 4.0, since the sp1 exe installer doesnt create a new instance of databases, both fdb and sql.
  • bbrownbbrown Member Posts: 3,268
    I ran into this today.

    'CFR' is a a field in the 14000 range on tables 36 & 38 (maybe more). The 14000 range is the Mexico localization. It would appear that you are attempting to import FOBs from a US/Canada SP1 into a US/Canada/Mexico PreSP1.
    There are no bugs - only undocumented features.
  • ara3nara3n Member Posts: 9,257
    bbrown
    Yeah I remmember that as well. I think the way I fixed it was just design the form and delete those fields from the Form.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • m.pacanam.pacana Member Posts: 75
    Thanks for the tips. \:D/

    By the way, do i also need to upgrade my current license used in Navision 4.0 to Navision 4.0 SP1?? Will it not work when I use the license in SP1?

    Also, I noticed that the Navision 4.0 SP1 product installer i have does not create a database.fdb and Sql option database upon fresh installation. Is this true for all product executable of Nav 4.0 SP1??

    thanks
  • ara3nara3n Member Posts: 9,257
    Yes you need a new license. The reason is that they've added new tables Standard journal, and Employee portal, and you'll run into problems when you try to create new company.

    My guess on the installation isssue, It's probably disabbled by default. Select manual installation and you can tick what you want to install and what you don't want to install.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.