-
SETFILTER returning unwanted results
Hello, I am receiving unwanted results when filtering on the 'Gen. Journal Batch' table (232) in Nav 2013 The code will produce a list of all of the journal batches being used by the user but I can't figure out how to filter it correctly. Currently I have the code below which should return 2 rows, 1 row for 'DEFAULT' and…
-
NAV 2015: Can a General Journal be scheduled to post?
Is it possible, in NAV 2015, to set up a schedule to post a recurring general journal (e.g. have the job execute the recurring journal posting on the 2nd day of each month)? I have been researching this question for some time but I am not finding anything specific to this topic. Thoughts? V/R, Paul
-
Ledger Report for all companies
Hi Everybody!!!!!!! I have a requirement of creating a report which will show all the ledger entries of a Customer/Vendor throughout all companies in the database if the Customer/Vendor is present in other companies as well. I know the "CHANGECOMPANY" function to use in this case. But can not understand that how I can run…
-
User disabled
Hi all. Something strange happen for a Windows Nav user. Sometimes, without any reason, the user it's been authomatically disabled.
-
Strange issue ASNI - ASCII
Hello everyone. I have such a problem. I have file with name 'münd.pdf' and in the NAV 2009 it stores like 'mu¨nd.pdf'. So, the 'ü' actually replaces with 2 signs 'u¨'. Even if I replace this 2 sings with one 'ü' (252) - the FileSystem returns false on FileExists. With others files I receive - everything looks fine. I…
-
question about reading a txt document in report
Hello Guys!! Imma newbie, so if you could help me I'd be very grateful. So here is the thing.. Im designing a report, which has to import a text file into a report. OK, I'm done with the importing, but I cannot read the file, well obviously Im doing somthing wrong.. Could you help me please :)
-
In NAV 2016, how can I get the XMLport to save a file without any interaction from the user?
Hello! I have an XMLport that exports a report to a CSV file. No issues there. When the XMLport runs, I would like the file to be saved to the export folder without the Export File Dialog box opening and asking: “Do you want to open or save this file?” See Image1. There is a checkbox that I can uncheck “Always ask before…
-
GDT Where Used Tool - free of charge -
Analyze your NAV objects NAV 5, NAV2009, NAV2013 All objects, functions and fields will be listed. See connection by "where used" http://www.g-d-t.de/download.htm
-
Stored Procedure from MsSQL to Temporary table to Nav
Good day. I have this kind of problem. is it possible for a stored procedure to have a value in the temporary table(SourceTableTemporary Property of a Page in Navision) which can later on be pulled out and made to appear in a page(NAVISION)? Thanks in advance :)
-
Printing Blank Lines
Hi..Though I have seen this topic no of times but could not get clear...Can anybody mention the steps to print blank lines in the body of NAV 2013 R2 reports? Any link also will be helpful...Sorry for asking repeated question.
-
Nav from Spectra Property Management Database
I need to import all data from Spectra in my Database. Does anyone have any information about what field for what? Thanks
-
Why is Codeunit not populating table?
I created a test codeunit and set it up to run from a job queue. It ran fine with no errors, but did not populate the table. I added a message to make sure the date was formatted correctly, and it is. I ran the codeunit without the job queue and it ran with no errors. Here is the code I used: Documentation() OnRun() WITH…
-
new project but will not used default database of Nav
hello. im a newbie in Development side in Nav. I have a question, is it possible that I can use the database of my old application? any ideas ? thanks in advance..
-
Image in Report 10401
Hello everyone. I have troubles with image in current report. I've tried in new blank report - my code works perfect, but with Report 10401 it keeps be blank. The code is on PreReport ClientFileNAme := 'D:\_WORK_\SAve.bmp'; ServerFileName := FileManagement.UploadFileSilent(ClientFileNAme);…
-
Line No. does not Auto-increment
I'm a newbie developer here :) I have this custom table that I created and it has a Line No. Column as my primary key and also for identifier purposes. I have this custom code that I created its very simple, yet I have this kind of problem encountered. hope you guys can help me with this one. (See attached Images) by the…
-
how to display the list of items in the SO line based on dimension selected in header
I have created global dimension 1 code which have dimension values that represents the products that are sold by the company.All the items have been already assigned with their corresponding default dimension value code which represents their product group.Now when a sales order is created,firstly the product code is…
-
Adding a tick box
I need to have an extra box like the "two sided" one in the picture. How do you do this? Thanks
-
How to import LOT No's into order lines?
I am to code an import of Lot No into order lines in NAV 2016. I can see that the application (when entering Lot no's manually) uses the page 6510 Item Tracking Lines. This contains quite complex code that results in a line in table 337 Reservation Entry (made when leaving the page). I could begin to analyze the inner…
-
Request Page Problem.
I'm still new in Navision, how can I restrict a variable in request page that if the variable is empty the report will not load. instead it will show a message that the "Vendor No." is required. (see attached photo)
-
Installation of NAV 2016
Hi All, I wanted to know if I can install Microsoft Dynamics Nav 2016(Version: 9.00.45778) on a PC where Microsoft Dynamics Nav 2013 R2 (version: 7.10.35473) is already installed(Operating System Used: Windows Server 2012)? I got an error message while running any "Form","Pages", and “Report" from Nav 2013 R2 Development…
-
migrating Data from Nav 2015 to Nav 2016
goodmorning, im still learning Navision, Can anyone give some links or guidelines how to transfer data from Nav 2015 to Nav 2016.. Thanks in Advance. hope you can help me.. Godbless
-
Coverting Decimal/Integer to hh.mm.ss
Hi. I'm a newbie in Navision, Can someone help or guide me how to convert Decimal or Integer to hh.mm.ss. Thanks in Advance. Best Regards :)
-
NAV 2016 Upgrade
Hi Experts! I am upgrading NAV2013 Indian Loc. to NAV2016 IN. After Sync all tables i am moving to Upgrade Data from Tools->Data Upgrade ->Start. But i got error thatMicrosoft Dynamics NAV Development EnvironmentNo Upgrade methods have been found. Please create an upgrade codeunit with at least one Upgrade method in order…
-
2009 debugger
Hello. Good day, I'm new in nav development. I need help and can someone give me some tutorial or give an idea how to use debugger in nav 2009 R2. i've been using breakpoints but it won't work. thanks in andavnce
-
Query Problem
I've Just create a QUERY and that Query I set some FILTERS (See Attached Image). The FILTERS are correct, supposedly my codes (see attached image) are returning 3 lines of data and sum up the value. but my condition is not working even I'm using READ and FINDSET. please help solve my problem. I'm a newbie
-
Error While executing upgrade codeunit-ID-104025
Hi Experts, While trying to upgrade the database from NAV2013R2 to NAV 2015, facing some problem with execution of upgrade code unit.(Codeunit-104025) Microsoft Dynamics NAV De volgende SQL-fout werd niet verwacht. Cannot insert the value NULL into column 'Ledger Entry Amount', table 'Test Company$Detailed Cust_ Ledg_…
-
Import data using dataport
Hi I am new at NAV and i have trouble to import data using dataport to NAV I have data in csv file formated like this. Name Address City Phone Mike Adress1 City1 00000 Luke Adress2 City2 111111 Paul Adress3 citiy 44444 1. I am using code like this Contact.INIT; Contact."No.":=NoSeriesManagement.GetNextNo ('Contact', TODAY,…
-
SETFILTER misbehaving
vWHTEntry is a QUERY, and everytime I filter it with code it doesn't hit my REPEAT UNTIL (see attach image) even though it's right. but when I go to the Properties vWHTEntry object set the table filter it works find.I dont know why when filter it with code it doesn't work. please help me and give me some ideas. im a newbie…
-
Try this easy and smooth way to transform Classic Reports to RDLC
Shortly, I am referring to '1ClickFactory Code Transformation Classic Reports to RDLC service'. Find out how this service could easier your upgrades here
-
training for navision development
Can anyone give me a link or where can I find online training for navision development ? :) thanks in advance, hope you can help me with this one..