-
How do I export my NAV objects to txt files?
Hello, I understand there is a pretty standard way that people do this - I have not done it before. Can someone point me to the appropriate resources? What are the considerations? Do I need to be careful of anything? Corruption of data? Should I not do this on production DB, during off hours only, etc?? Any guidance to a…
-
How to check how many users are allowed in my Licence
Dear all, How can i check how many users are allowed in my Navision license
-
Change the report behind the print button - warehouse shipment
I've created a custom report for the warehouse shipments and now I wan't to change the default report behind the "Warehouse shipment" print button (page 7335) to that report. Where can I find or do this?
-
Enable / Disable
Hi I have Button on Main Form. I want when Form gets loaded it should be disabled. If User enters Amount in any row in SubForm then it should get Enabled. Thanks
-
add fields from different table to a form
i want to add balance field to the " form sales order" from "customer table".But for sales order form "sales header table" is the source table .any guidance is much appreciated
-
Filter Data
Hi I have Main Form & Sub Form . Main Form Source Table is Location & Sub Form is Sale Line Table. I have below code to filter record according to User Id Location . It should display only 1 record according to User Location . User should not be able to select any other Location. User should not be able to select Previous…
-
How to grant Read only access (to all data ) in Navision
Hi, Our company rely on Navision Consultant from another company for Navision support. Therefore, they need to access our system to help out in troubleshooting from time to time. However, is there any way we can restrict their access to read only? (e.g. can read all data from all the modules, but cannot perform transaction…
-
Clear Field Values
Hi I have sub form in Main form . Sub Form has fields Location , Date , receipt Amount , receipt Date . If user presses Esc on form then it should clear Receipt Date , Receipt Amount with blank values in all records. Thanks
-
get batch name of journal
How can I get a specific batch name in NAV2016? I'm trying to get the document number for a specific section but i just can get the journal name.. and i cant figure how to do this
-
Loop
Hi I want to loop from start date to end date. How I can add 1 Day to start date till it is equal to end date Thanks
-
Position Cursor on a particular column
Hi How to position Cursor on a particular column in subform Thanks
-
First & Last Record's Value
Hi In a subform there can be no of lines. There is one Date field . I want to get First & Last Record's Date Value Thanks
-
User Blocking in Navision
Dear All, Good Day! Can we block a user to access Navision if he/she enters his user ID and Passwword wrong multiple times. Is their a way to do this customization. Thanks in advance
-
I edited layout with vs studio 2008, but it didn't apply on report layout(nav2009)
In Nav2009, I edited layout using vs studio 2008 and saved and compiled. and then... window -> run -> dynamicsnav:////runreport?report=reportid but my editing was not apply on the report layout. (Report didn't not changed.) Even In RTC, Report didn't not changed. I don't know the what is problem or I'm missing something
-
CurrForm.Update
Hi On Push Trigger i have done some processing and have written the below line CurrForm.UPDATE(TRUE); It will Update all Controls . Is it possible that only a particular Control should be Updated say SubForm. Thanks
-
NEXT function with FIND('+')
I’m looking at a bit of code put in a codeunit by my predecessor and I’m a little confused. Here’s what the code that has me a bit perplexed: IF Rate.Tbl FIND(‘+’) THEN REPEAT Logic which assigns values to some variables UNTIL RateTbl.NEXT=0; I understand that FIND(‘+’) finds the last record in a set and that the variables…
-
Serious issues with Order Promising
Hello, It seems I'm completely stuck with the Order Promising issues at a client. The root of the problem is the following: Say if you have a part, Check-Avail. Period Calc. of one year, a sales order due half a year into the future for 100 pieces (not reserved) for the part, 100 pieces in stock for the part and four weeks…
-
get different dimension value
Hi everyone, I'm trying to set a dimension value for each two records but i'm only assigning the last value for all and I can't figure why. In dimension value table I want the "VEND" for Dimension Code and use that records in my "Dimension code" of the first image. So for now I have the dimension code RG, but my idea was…
-
Setting up Change Log to track Modification of objects
Hi.. I'm currently looking into the Change Log functionality to track the insertion, modification and deletion of Navision objects (Table 2000000001). Although I have defined to track insert, modify and delete for all fields of Table 2000000001, I noticed change log entries are created only for deletion of Navision…
-
Temporary Table
Hi How to Update Data in SubForm from Temporary table Thanks
-
NAV 2009 R2 old Builds
Hello, where can i download old Builds for NAV 2009 R2 Sweden? Thanks
-
How to encrypted NAV 2009 backup file.
Hi, Good Day! One of my client want to encrypt database backup file for NAV 2009. How can we do that any suggestion. Thanks in Advance
-
Record DataType in Form
Hi When we create variable of Record DataType say CustLine with Sub Type say Customer in Forms . How it works. if in Insert Record in Record variable Custline say CustLine.Insert it will automatically save Data in Main Table. Thanks
-
Filter Record
Hi I have written below code to filter record according to user Location . Problem is when i click next button it displays one more record which i don't want. It should display only 1 record. https://imgur.com/a/1eh46gp IF UserSetup.GET(USERID) THEN BEGIN UserSetup.TESTFIELD("Location"); IF (UserMgt.GetUserInfo2(USERID) <>…
-
How to set password protected PDF file in NAV 2009?
Hi FRiends, [Version: 2009 SP1 Classic Client] I need to convert Customer Statement (and Sales Invoice) report to PDF and send to customer's e-mail ID which is mentioned in Customer card. I can able to convert into PDF and attach send as an e-mail successfully. I am facing couple of issues: 1. How to set password to the…
-
payment slip journal/feuilles bordereau paiement
Hi everyone, does anyone has a tutorial or a how to process payment slip in navision?
-
Nav2009 Classic form update
Well, am somewhat a novice in nav2009 and have a problem I do not understand why it is so. On a form - properties - SourceTableView: Where(CustomerType=FILTER(5) It show correctly all the type 5 customers - but when deleting a line in this speciale table it afterwards shows all customers regardless the type. Can't figure…
-
Numbering in a code field in calssic and sql
Hi everyne, In navision classic (local database), if you put a number in the code field, it looks like this: 1, 2, 3, 4, 5, 6 , 7 , 8, 9, 10, 11,...... In navision classic (sql database), if you put a number in the code field, it looks like this: 1, 11, 2, 3, 4, 5, 6 , 7 , 8, 9, 10, ...... why is that?
-
Calculate Balance
Hi I have below some of the fields in Database Location , Date , Amount , Paid Amount , Balance . In Balance field i want its value should get updated by like this Amount - Paid Amount = Balance. Can we do it at Table level Thanks
-
Excel issue while data is exported from Navision
Dear All, Good Day! When some of my user are sending data from Navision to excel using standard feature of Navision they are getting bellow error "Replaced Part: /xl/worksheets/sheet2.xml part with XML error. The name in the end tag of the element must match the element type in the start tag. Line 1, column 950378". When I…