Job Queue Report Date Format

jordi79
jordi79 Member Posts: 280
in NAV Three Tier
We have a NAV server servicing different users across users from different countries. Each country is a separate NAV tenant.

The problem is that if we run a report with Job Queue, the resulting report always uses the regional setting of the NAV server to display date format and decimal formats. I have tried changing:
1) NAV Server, "Service Language"
2) And "User Personalization"."Local ID"

But none of these setting affect the date/decimal formatting for reports created via Job Queue.

Answers

  • jordi79
    jordi79 Member Posts: 280
    I found out that in the "Scheduled tasks" table there is a field called "user format id". I am sure this can affect the regional settings that is used to run a report. The question is, I do not know how this is populated from.

Categories