Empty report - User specific error

COSY
COSY Member Posts: 8
in NAV Three Tier
I have a user who in one company can preview report "General Journal - Test" and se the lines from General Journal.

When the user go to another company in same database and preview report "General Journal - Test" the report is empty even though there are lines in the General Journal.

Solution?

Answers

  • bilalrai
    bilalrai Member Posts: 50
    edited 2017-07-05
    May be some filter is activated in the ReportPreview type page. Please check this.
  • COSY
    COSY Member Posts: 8
    I have tried to clear filters (ctrl+shift+A) before preview of report - with no result.
  • bilalrai
    bilalrai Member Posts: 50
    I have tested on my local machine. The report showing all the general journal lines that are yet to be posted with warnings if any are like (out of balance).
  • bilalrai
    bilalrai Member Posts: 50
    One more thing. Does the user have enough rights ? Check this.
  • bilalrai
    bilalrai Member Posts: 50
    You can check this by going to the table Permission Set by User. Check the permissions by selecting both companies one by one.
  • COSY
    COSY Member Posts: 8
    I know - the problem is that when the user is in one company the report runs fine and show the lines in the general journal. If the user change to another company and run the report it doesn't show the lines in the general journal.
  • bilalrai
    bilalrai Member Posts: 50
    Assign the Role of SUPER to your user for both companies.
  • COSY
    COSY Member Posts: 8
    The user has Super user rights in all companies.
  • bilalrai
    bilalrai Member Posts: 50
    edited 2017-07-05
    Then no idea bro. Non-Technical guess is "Restart SQL SERVER instance and restart NAV service and then try again". :D
  • COSY
    COSY Member Posts: 8
    Instance and service has been started during maintenance etc. without solving the problem :-(
    Thanks for the effort.

Categories