-
EDI: Lanham: Fixed Value: Lowercase versus Uppercase
Is there a way to have a Fixed Value be represented as upper and lowercase rather than always defaulting to uppercase?
-
How to create Dynamics NAV Inventory list report with Simplanova Report Wizard
Building Microsoft NAV reports can be a chore :/ . See How to create Dynamics NAV Inventory list report more quickly and easily with Simplanova Report Wizard in blog post
-
Run easily native database server on Docker.
If someone for any reason needs to run native database server he has an option to run it on Docker. Of course, you can still use the traditional forms as usually there are no problems to run it as is from you PC. But if you, for example, need to host multiple instances and do not want to mess you up with services and hosts…
-
Tables CSV Buffer (1234) and XML Buffer (1235), just like Excel Buffer (370) - NAV 2017
Hey guys, I just ran into these 2 tables in NAV 2017, and I thought I'd let you know. It seems that they expanded the functionality of Excel Buffer to both CSV and XML: - Table 1234: CSV Buffer - Table 1235: XML Buffer I still didn't have time to test them thoroughly, but I just wanted to share this piece of info, since I…
-
How to use DIV and MOD
Sorry guys, I keep having to search to get the results. For some reason DIV and MOD usage are not explained anywhere on the online help. So I just want to put this here so I can book mark to it. And yes, I do use mibuso for some of my code repository. x := 5 DIV 2 y := 5 MOD 2 RESULT: x = 2 y = 1
-
Five things to consider when it’s time to upgrade Microsoft Dynamics NAV
Dear NAV users and developers, I would like to share our new blog post with tips and our experience when executing NAV upgrade projects from older than 5th version to 2017. Hope it will be useful to You - Five things to consider when it’s time to upgrade Microsoft Dynamics NAV
-
Dimension as per login
I have few dimension, as per the user login I want to restrict them to see only few dimensions How can this be achieved. Thanks
-
Good day everyone! I went to client site to remove department from his role centre
department from his role centre and after removing the department. I discovered that the client can easy restored the department back. Pls how can i remove the department from the role centre and it can not be restore back by the client.
-
Get a Folder (Not Reg. new DLLs)
When you need to browse for a folder (dialog) you can do this with using standard Windows tools :!: Here an example: Name DataType Subtype LengthShellControl Automation 'Microsoft Shell Controls And Automation'.Shell Folder Automation 'Microsoft Shell Controls And Automation'.Folder3 FolderItems Automation 'Microsoft Shell…
-
How to change previous record?
Hi I want to change previous record in table (to set ending if date in current record is today). I try this code: OnAfterGetRecord() IF "Date From"=TODAY THEN BEGIN Rec.NEXT:=-1; Rec."Date To":=TODAY-1; END;
-
I want to add two flowfields but its not working? Can someone help with other ideas
I am working on something like this: customerPresent( flowfield count of all customers Present) CustomerAbsent (Flowfield count of all customers absent). TotalCustomer := customerPresent + CustomerAbsent; keeps giving error of two record fileds or so.
-
First row on XmlPort
Hi everyone, I have a little problem with C/Side coding on XMLport. What should I do for call to first row from Sales Header and Sales Line this is my code for Manuel order number "Sales Header".SETRANGE("Document Type","Sales Header"."Document Type"::Order); "Sales Header".SETRANGE("Sales Header"."No.",'109003');
-
How to consider posting date in case of closed year?
I want to make a report based on posting date but i found that in case of closed year system marked as "C" before posting date & as a result my report skip the value of Cmarked posting date value. Can anyone help me or give me any idea how can i resolve this issue.
-
Copy a Cronus database to another Cronus database with different collation
Hi guys. I'm trying to copy Cronus Iternational Ltd_ NAV database to one that has the same collation as my SQLServer. What I did: I scripted tha database, tables and views, and I created an empty one. Now, the question: how do I polulate the new database with the data of the old one? Any guess ? I'm a newbie in this kind…
-
Math question
How do I find out the next largest number (rounded to the tens). I need the new number for an internal check. IE: If I have the number 57... I need to know (THISNUMBER - 57) = 3 where THISNUMBER = 60 and conversely If I have the number 88... I need to know (THISNUMBER - 88) = 2 where THISNUMBER would be 90 Been messing…
-
Convert Int to Hex and vice versa with DotNet
You can use DotNet functionality to do the job for you. 1.) Variable Declarations used in the following examples:Name DataType Subtype
LInt32 DotNet System.Int32.'mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' LInt64 DotNet System.Int64.'mscorlib, Version=2.0.0.0, Culture=neutral,…
-
Stop calculating flowfields
Hello guru, I have a table with many flow fields at my customers database NAV2013. The Field Group is set to the: No. and Description. If I open the list page, all the flow fields are calculated. That's correct. If I open the drop down at other page to select my No. from the table - it again calculates all those flow…
-
PDF to TIFF
Hello everyone, Could someone give me an advice how to convert pdf to tiff? free library or dll? I've found some answers on StackOverflow, however they all about not free product and most about Ghostscript. May be there is something else? Thanks a lot for your time
-
Automation Data Type and usage in Dynamics NAV
Hello guys, nowadays we have so many integration with other third party applications. Sometimes you might use your own classes to get some work done. Here are some important article regarding Automation Data type and its usage in Dynamics NAV. Let’e begin with basics, What is Automation data type ? Of course, it is complex…
-
Microsoft Dynamics NAV JOB QUEUE 2009R2 Version
Hello Guys, This is another article that I am sharing with you for your knowledge . Job queues in Microsoft Dynamics NAV allow users to schedule and run specific reports and codeunits. You can set up jobs to run one time or recurring. For instance , user wants to run customer statement report weekly and email to the…
-
BETTER ERROR HANDLING USING IF CONDITION IN DYNAMICS NAV
Hello guys, I would like to share some important tips with you and sometime you might known these tips also you love C/AL coding and you would hate this area, which is error handling. So Let’s have a look of better error handling in Dynamics NAV So may be you love if we have Try Catch statement to capture the errors. But…
-
OData - modify primary key
Hello, we have a webservice published for a page, and we want to change a value of the primary key for a certain record. Is it possible, that this is not possible? : ) I can change any other field with an OData patch command, but he seems to ignore all the fields that are included in primary keys. I understand that this…
-
Windows Login table
Hi We are upgrading from Nav 2009 to Nav 2016. One of my issues is that the Windows Login table does not seem to exist anymore in Nav 2016. I was using this to get the creation date of a user. Is there any other way in 2016 to get the creation date of a user? Thanks Stephanie
-
Update Header page from Lines page using interoperability
Mark Brummel already wrote an example of this issue on his blog using an automation variable : http://dynamicsuser.net/blogs/mark_brummel/archive/2009/12/16/tip-25-update-header-page-from-the-line-page.aspx In the example below the SendWait function of System.Windows.Forms.SendKeys DoNet variabele is used. Create a…
-
Passing a custom filter to report?
Hello everyone :) I have a field FilterValue on my RequestPage where I enter multiple values for filter and it currently looks like this: Value1 | Value 2 | Value3 etc. Then I add that field to my Dataset Designer and pass it's value in group filter in Object designer where I placed Field1 = FilterValue But when I enter…
-
Report Security
Good Morning Please i want to know how to protect a report in Dynamics NAV For example how to hide a report source code if possible or how to protect an object against modification Thanks
-
Add namespace prefix to every node when exporting XML?
Hi everyone. I want to have, instead of this: <PodaciPoreskeDeklaracije xmlns='http://pid.purs.gov.rs'> <PodaciOPrijavi> <VrstaPrijave>1</VrstaPrijave> <ObracunskiPeriod>2016-10</ObracunskiPeriod> <DatumDospelostiObaveze>2016-01-05</DatumDospelostiObaveze> . . . THIS <ns1:PodaciPoreskeDeklaracije…
-
C# app which works with Codeunit Web service
Hi, I have C# app which have to use function from Codeunit which have to modify some fields. Here is a code from app.. Here is function from Codeunit.. I test app, and it works when, return some value in label or textbox, but when should to modify fields in nav doesnt work. Help :)
-
Pre printed reports alignment is going out in Navision 2016
Hi Everyone, I am facing a preprinted issue, they are having 2 warehouses, each warehouse is having 20 (approx.) dot matrix printers, recently they upgraded from Navision 4.0 to 2016. In Navision 4.0 :- we are printing 50000 report from 20 different printers in 2 ways 1. save as PDF & print working fine. 2. Direct print is…
-
Copy and paste record in one table
Hi, I want to create function or report which copy and paste record, but in same table. Example: I have Table1 with key KEY001(auto-increment), and i want to copy rows KEY001,KEY002... and past in the end of the Table.