Re: Dimension Set Entry Not Update after Upgrade From NAV 2009 to NAV 2016
the upgrade runs the dimension updates using sql scripts. You should get an error if they fail. Do you have any customizations to the NAV 2015 upgrade programs?
Fixing this after the fact is dangerous - you should run the upgrade again and make sure you each step works before you continue with the next one.
The only shortcut I can think of is to run the dimension update by itself if you have not added any dimensions yet. But then you take the risk of having a bad dimension setup which will cause you continual problems.
Re: Can anyone tell me the difference between Accounting Period Tables 50 and 10560
Table 50 is the "standard" one that comes from the base W1 version of NAV and is used in most of the localised versions but this is not used in the GB version of NAV.
The GB version of NAV uses the "Accounting Period GB" table instead and does not use the "Accounting Period" table
Re: Importing Secondary Dimension in Gen. Journal Line table
Show your code, it'll be easier to identify the problem
Re: Can you make NAV not ask for your password every time you open RTC with NAVUserPassword Authe
You could use Windows authentication by creating the useraccounts on the server which runs de NAV server with the same name and password as used on the workstations. So, if John has an account in the domain Domain (domain\john), you could create a user on the navserver (navserver\john) with the same password. Windows authentication should work then.
A downside: You need to do all userrelated things on the server.
It is not possible to bypass the logonwindow using NAVuserpassword authentication of UserName authentication.
Re: 2 Instance 2 Lisences 1 database
How about putting in some parameters in the servicetier to disconnect (and free!) sessions that haven't been used for some time?
But I wouldn't use it in a production environment. And the license needs to be on the server level. If it is on the database level, the database level license overrides this system.
Re: RDLC report, problem with row numbering
Hope this helps -
Re: Password Protection for Documents (eg. Pdf, Excel, Word) generated by NAV 2016
If you are talking about generating a report in NAV, and allowing the user to print to PDF, then there is no standard feature in NAV that would prompt for a password - since printing a paper copy is an alternative output option.
If security for a particular report is a concern, then you can limit a user's ability to run the report at all. You could also customize that report or a group of reports requiring a second-level password be entered - but again, that would be a customization.
Hope this helps.
Re: Report Original, Duplicate, Triplicate
Your idea (using a Dataitem as Integer) is right, in fact, I have seen that is done by standard code, but I don't understand why shows to you a number, are you showing the copytext var? Have in account, in each step of dataitem Integer, NAV pass to next record on a table Number (on this case from 1 until 3), whereby your IF statement is right, but if you don't clean that var, text is shown in all pages like 'Original'. Is NAV showing the numbers on the layout?
Re: CTRL+SHIFT+ENTER - creates a new document but the cursor is in the lines, not the header
I'm sorry awarn, totally misread your post. Instead you can use Shift + F6. If the General Tab is right above the Lines Tab you only have to press it once.
Re: Getting primary key in code
CURRENTKEY will not give you exact answer if "SETCURRENTKEY" was used before... (somewhere in the code)
Instead, you can use virtual table "Key" and filter to key number 1, or simply do a GET ==> Key.GET(TableNo, 1)
MESSAGE('%1', Key.Key); //
Will show "Document Type,No."
On another note, here is a function that tells you if a field is part of the primary key:
IsPrimaryKey(_TableNo : Integer;_FieldNo : Integer) : Boolean
FOR i := 1 TO RecRef.KEYINDEX(1).FIELDCOUNT DO
IF RecRef.KEYINDEX(1).FIELDINDEX(i).NUMBER = _FieldNo THEN
I hope this will help.