-
Move unlicensed objects
Ever wanted to change or look at objects your don't have a design license for? Just move them in a licensed area: -In the object designer mark the object so it gets a blue backround (shift+space) -press ctrl+c -press ctrl+v -confirm the two error messages -without leaving the line, change the ID to one you have access to…
-
Searching for field usage
If I don't have access to the Developers Toolkit is there a way to search where any given field is used in Navision Objects.
-
How to know which decimal sign Navision uses
How can you know which decimal sign Navision uses? GetDecimalSign() : Text[1]// GetDecimalSign// Returns the decimal sign currently in use by Navision// PARAMETERS:// RETURN-VALUE : Decimal Sign currently in use (',' or '.')EXIT(COPYSTR(FORMAT(1.5),2,1));
-
Insert Fields into Dataport
In a Dataport, on the Field Designer, open the field menu. Select the fields you want to add to your dataport from the field menu then click somewhere into the field designer window and the selected fields will be added. Marcus Fabian m.fabian@thenet.ch +41 79 439 78 72
-
Read EventLog
Hello I'm running an executable from navision that write messages in event log. I would like to use a standard automation to query theh eventlog for the message. Can someone point me to the right direction? The com has to be standard so that I don't have to register it on every box. Thank you.
-
Skip Empty XML-Tags
on demand here is the code to skip empty xml-tags after using a xml-port: DeleteEmptyXMLNodes(VAR XMLNode : Automation "'Microsoft XML,v3.0'.IXMLDOMNode") IF XMLNode.nodeTypeString = 'element' THEN BEGIN IF (XMLNode.hasChildNodes = FALSE) THEN BEGIN IF (XMLNode.xml = '<' + XMLNode.nodeName + '/>') THEN XMLNode :=…
-
Convert back Navision SQL database option version.
Hi all, There is a situation where by opening Navision client with higher version will popup a confirmation message whether you want to convert databatase. Once if you accidentally click "YES" then you can't use original Navision Client to open your Database anymore. :cry: Now, I found the easiest way how to convert it…
-
Which NAV Conference should I attend
So just to sum up all the different conferences: 1. Convergence This is the 'customer' dynamics confrence. Partners can bring their customers and let them interact with Dynamics product team members and peers. If you are an end user and you see Dynamics as the product that changes your business compared to your…
-
How to move data in blob fields between tables
If you have data in a blob field that you'd like to move into a blob field in another table, use something like this: sourceBuffer.CALCFIELDS(TextData) ; sourceBuffer.TextData.CREATEINSTREAM(linsStream) ; linsStream.READTEXT(ltxtData) ; destinationBuffer.TextData.CREATEOUTSTREAM(loutStream) ; loutStream.WRITETEXT( ltxtData…
-
Navision Predefined Bitmaps
In the Navision help, the bitmap property stated that there are 44 predefined bitmap images. Does anyone have the pictures of those images handy? :mrgreen:
-
Easily create Forms from Reports and vice versa
Got a request from the user to create a report based on a form and/or create a form based on a report? You can do this easily by simply copy and pasting all the controls on a form (caption box, text box, etc) and paste it on a new report. This works the other way around. You can create a new form and just copy and paste…
-
"Protect" form/report/dataport
Haven't seen this posted anywhere, so... I've seen a few posts wondering if there is a way to "protect" the code from others. Well, what I'll post here is not a solution, but might be at least a bit usefull sometimes. Oh, and also, this trick isn't much of a trick, it's simply Navision bug abuse :) , which will probably go…
-
Request Form indented dataitem set filter
Kia Ora You have a report with 2 dataitems and you want to set a filter on the second dataitem on the Request Form when its call from another form. Customer >Cust. Ledger Entry Use CustLedEntryRec.SETRANGE("Posting Date", myDate);REPORT.RUNMODAL(RptNo,UseReqForm,FALSE,CustLedEntryRec); This will show the request form with…
-
Indent C/AL code in 5.0
I was just working in 5.0 (I have one customer live on 5.0 runtime :mrgreen: ) and noticed myself still indenting C/AL code line by line when I remembered that you can select a bunch of code in 5.0 and indent with TAB and unindent with SHIFT-TAB. So, for everyone else who forgot or did not knew anymore. :shock:
-
NAV SQL Tuning - Covering Indexes
SQL and NAV is hot these days. More and more knowledge becomes available and more companies and freelancers start helping customers tuning their databases. Most of the problems exist in "older" databases. Especialy early version 3 databases have difficulties performing. Fortunalely version 5 of NAV is very much pre-tuned…
-
Form Communication Mechanism Questions
I'm not putting this into the tricks and tips forum (If a moderator deems it to be useful or new, please move it) because: A) I don't know if it is a known mechanism or not. B) It's an implementation of an idea, it would need a bit of work to make it more generic. C) It's an idea that need developing. However, over time I…
-
NAV 4.0 client connecting to a 5.0 server
This seems to work :? Don't know if it is a wise thing to do but... 8-[ (Hope this has not been posted yet :oops: )
-
Save Reports To Excel
Run a report, click save as html, and change the file extension to .xls. You will be able to open and manipulate the cells in Excel! One thing you will find is that cells that should be discrete are occasionally merged. Be sure to select all of the cells and un-tick the merge cells format property. Total excel control --…
-
SQL Stored Procedure to Delete Zero Value Sift Fields
The following SQL SP will delete the rows in SIFT tables which have zero values. It builds the SQL Statements dynamically, so if a table is modified it will automtically pick these changes up. Then re-indexing can be scheduled in SQL alos & the NavisionOptimisation tasks are not required. GO /****** Object: StoredProcedure…
-
Function to calculate differens between two dates
I need help to calculate number of days between two dates and just only ordinary working day should take cares. Say I have "Posting Date" and "Requested Receipt Date". I want to know how many days it's between them and no holiday involve. I know u can use (DiffReq := "Posting Date" - "Requested Receipt Date") but it don't…
-
Terminal Services and main menu problem
Here is the setup: Windows 2003 Server Terminal Server w/ Citrix Navision 3.7b SQL Client Windows intg/Auth 1 user with chronic main menu problem The user has an issue where she logs in and the main menu is in the top left corner of the app window. there is no way to minimize / maximize mouse click etc.. to move the window…
-
FILTERGROUP Example
FILTERGROUPS are used in 2 ways: 1) when you want to put multiple filters on the SAME field 2) when you want to hide a filter from the users, so they cannot change/delete it -Example for 1: I want Customers whose names start with ABC and have XYZ somewhere in their namesSETFILTER("Customer…
-
Character that comes last in sorting texts-strings
The character that comes last in order in general is not 'Z' or 'z' or '9' but some 'exotic' character. This trick is interesting in case you want to convert aSETFILTER("Some Field",'%1','abc*'); in aSETRANGE("Some Field",'abc','abc' + PADSTR('',5,MaxSortingChar())); and probably gaining performance. And this is the code…
-
InLineEditing: first press F2 to edit a field in a tablebox
Sometimes, when you create a tabular form, you want the fields to "look" like non-editable (e.g. to enable "find as you type"), but when pressing F2, you want to be able to edit the field. You can do this with the property "InLineEditing" on tableblox-level! (You're still able to disable editing in certain columns, off…
-
Catching Errors In Navision -- Useful even for the Experts
We all know (and if you don't search the forum) that the only way to catch errors in Navision is the If codeunitA.RUN then structure. We also know that you can programatically call codeunits with the this structure Codeunit.run( Codeunit's Object Number ) However, its less known that when using the latter structure…
-
Search for Fields in Table Designer GLobal Variable, Func.
Hello If you design a table, you cannot search for fields. Here is a trick to search for Field Names. Design the Table. Hit table to move the curser to the Field Name. Hold Shift and hit the down arrow keys. You'll notice that field becomes uneditable. Then hit the First letter of the Field you are looking for. e.g. Design…
-
File>Database>Information
In Navision 3.01, native database version, if you go to File>Database>Information and click the Tables button there’s a column labeled Optimization. I was wondering what the numbers mean, is a low number better than a high number, what’s the range, etc. Title changed from "Tables Question" to "File>Database>Information"…
-
How to make a word wrap in a caption
I think the Topic says all. I've heard it is possible to make a word wrap in a caption, e.g. of a button. I would be glad if someone could say me how. Kind regards, Christian
-
Shorter way to write "x := x + 1;" and others
I suppose most of you will know this, but as i see in many examples and code many people work with This is much simpler and shorter:
-
Taking the last change from trigger
Say you have function that scans Table A with a usual FINDSET - NEXT loop and does something with some f.e. adds it up and writes the sum somewhere else, or finds the last date, or something like that. If you want to automatically run it every time a record was inserted or updated in Table A, it does not work, because…