Error in FINSQL not in the FIN?????

kish2007kish2007 Member Posts: 64
Dear All,

I installed SQL 2008 and NAV4.0. I am testing DB with our customer license. In FIN with our customer license the purchase order report( R- 405) is working correctly. But in FINSQL when i run the report iam getting error like " you do not have permission to read the Responsibility Center Table" . Iam using same license in FIN and FINSQL. iam running the report with SUPER user in FIN and FINSQL. i gave all permissions to the user.


Do you have any ideas.


Thanks & Regards,
kishore....

Comments

  • krikikriki Member, Moderator Posts: 9,110
    Which version of 4.0?

    You should have at least 4.0SP3 with latest hotfixes for SQL.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kish2007kish2007 Member Posts: 64
    Hi Kriki,

    It is NAV4.0 SP3 with HF6.


    Regards,
    kishore.
  • jannestigjannestig Member Posts: 1,000
    If you are using your customer license most likely there is a table entry which contains the responsability centre.

    Check the setup.

    Are you using the cronus database ? they are two seperate DB's

    If your customer license doesn't have the responsability centre on it you will get this error.
  • garakgarak Member Posts: 3,263
    which security model do you use?
    Do you make it right, it works too!
  • kish2007kish2007 Member Posts: 64
    Thanks for your replies.

    Now i got the solution. The Responsibility Table having data. when i run with our customer license it is getting error.

    So i deleted the data.

    Regards,
    kishore.
Sign In or Register to comment.