-
Insert Decimal value Above the range of Decimal Type
Problem is about range of decimal fields I try some operation on decimals and figure this out. You can insert value of decimal only with range of Decimal to Decimal type Field/Variable , but next .. you can do some operation on this (like X 1000) to get the value above the range and unfortunatly save in table. Nav can take…
-
Easy to implement Show/Modify Feature
Hi everyone, sometimes customers ask for a Show/Modify button feature on some forms, and asks it on...let's say 20 forms. Usually we create 2 buttons one above the other and then show the visibility and manage the editablity of the form. Also they want the form to be "not editable" when opening it. (See the example if you…
-
RTC Ctrl+F10 Shortcut
Don't know if anybody has noticed this. But after opening RTC client press Ctr+F10 and u can notice system will give small numbers or alphabets under each and every action. Just press that number or alphabet and notice how it works. For example : Click on Sales Order link on LHS and press Ctrl+F10 and then press 1 twice a…
-
Simpler Developer Toolkit
Hi everyone, i was doing a manual merge of a big set of objects, and i was also bored to expand the toolkit tree: why? because when merging forms and reports, the tool marks them as changed even if only xpos and ypos are modified. I don't want to forgot some property, so i have to open each control or menus in menusuites…
-
Capacity Ledger Entries
I couldn't find a function to translate capacity unit of measures in standard nav, so I developed it by myself and i want to share it with you if you need it. It's a really stupid function that takes as parameters the value to translate, the code of the "from" and "to" unit of measures. The function translate the value in…
-
Menu shortcuts and zup files
Hello everybody, I've created a shortcut menu and now, I'd like to apply it to the other users.. I know I need to work with the zup files, but I don't know how.. I've read some topics related to that problem on this forum, but nothing helped me 8-[ Thank you for your attention
-
Tip #4 - Tuning VSift
After all the theory about VSift in my previous blog posts now a tip about how to tune VSIFT. Before I continue first this. VSift is not a bad technology but the implementation in NAV has one big downside. The good old SIFT levels have disapeared. In older versions of NAV there was a SIFT Level property. This enabled you…
-
Tip #2 - NAV 2009 Linked subpages
Last months I have been teaching a lot of NAV2009 upgrade workshops in The Netherlands, Belgium and the UK. One of the questions I am getting often is how to link a subpage to another subpage. In the UK workshop we started some experimenting. We found that when creating a subpage you get a field called provider ID in the…
-
Compare ctrl-f8 - zoom within Beyond compare 3
In the newest version of Beyond Compare 3 you can compare the value of all fields in record1 with record2: Record1: > ctrlf-f8 > ctrl-a, ctrl-c > Start Beyond compare 3 and choose New Data compare > In the left window choose Open clipboard Record2: > ctrlf-f8 > ctrl-a, ctrl-c > In the right window choose Open clipboard The…
-
Warning for using >1 NAS with printing on x64-OS
Since NAS (at least the versions I've seen) is a 32-bit application, it "suffers" from being "boxed" in the WOW64-mode in a 64-bit OS (Windows Server 2003 x64, Vista x64 a.s.o) The following link has Microsoft's view on things: http://support.microsoft.com/kb/923357 (someone please fix this in a better way [-o< ) But to be…
-
How use 5.0 Word/Excel export functionality in 4.0 database
First. You have to get your license updated. Export all the tables from 4.0. Uninstall 4.0. Install 5.0. Upgrade the db. Import all the tables. Open 5.0 Cronus. Export 690-694 Forms, and CU 403. Import them to the upgraded db. In 5.0 Cronus. Design CU 1. Goto Function. Copy and paste the following function to Upgraded db.…
-
Dataport
At the time creating a new Dataport, there is a hotkeys can be used for to select all the fields of that table. Can anyone knows?
-
Optimizing Tables in Job Scheduler
Hello Here is a form that does optemization based on script. Import it as a form, compile it. Optemize is a table with PK of "Table ID". In Optemize table you specify the tables you want to optemize. The form runs on a timer that excecutes the script. Enjoy . OBJECT Table 50009 optemize{ OBJECT-PROPERTIES { Date=03/02/06;…
-
How delete fields in record
Hi, I would like to delete values in fileds but not all record. I have one text field and one number filed. They are not keys. I've created report and write code in it and code looks like this: IF (object.txtFiled <> '') OR (object.intField <> 0) THEN BEGIN object.txtFiled := ''; object.intField := 0; END; It works just…
-
Filter objects from excel
how many times did you have an excel file with a list of object numbers and you wanted to filter them in object designer?the painful procedure to do is manually mark the objects reading them from excel... well, with this stupid form you can copy the excel column with the values, paste it in the textbox and click the…
-
"IF Validate" Function
with this codeunit, you can manage the possible validate errors (like overflow etc). OBJECT Codeunit 90000 If Validate Mgt{ OBJECT-PROPERTIES { Date=09/02/09; Time=12.23.59; Modified=Yes; Version List=; } PROPERTIES { OnRun=BEGIN FNTValidate; END; } CODE { VAR INTFieldNo@1101339002 : Integer; TXTNewValue@1101339001 :…
-
Single line, Make sure Directory Path ends with '\'
This is by no means a huge tip or trick, and it is quite bulky, but I think it's nifty. I use it all the time :mrgreen: DirPath := DELSTR(DirPath,STRLEN(DirPath),STRPOS(DirPath[STRLEN(DirPath)],'\'))+'\';
-
SETFILTER - Using Wildcard *
Applying the SETFILTER using a Wildcard filter against a value from another field does not work. For example if the OtherFieldValue is another field from a different table and you need to filter a text field for names begining with the letter 'G' You would expect the SETFILTER to return only records begining with 'G'…
-
C/AL indentation
The old DOS version of Navision used to have a handy function key for indenting all code and I heard it has come back as of NAV5.....so is the rumour true and if so what's the key please?? Thanks :mrgreen:
-
Jump to a Fieldname in tabledesign
I'm sure, everybody knows this "feature" (i know it since 6 years) but i doesn't found it here (or i've used the Search function incorrect with wrong keywords) ..... ](*,) if you are in the table design (for example table 18), the courser is in column "Field Name", and you press "Shift + Arrow up / Arrow down" the line is…
-
Square Root
How to do a square root in Navision: :whistle: sqrt := POWER(Input,1/2);
-
Google Maps - Show in Map / Show Route
I figured out how to show customers adresses in google maps without typing the adress manually in the browser. Just add a button with this code in the on push trigger to the customer card:HYPERLINK('http://www.google.de/maps?f=q&hl=en&q=' +Address+' '+"Post Code"+' '+City); For the route to the customer use…
-
Classic (matrix) forms in RTC (NAV 2009)
For Microsoft I have been teaching NAV 2009 upgrade classes. Last week we had a return day to exchange experiences. One of the subjects on the discussion list was using classic reports in the new Role Tailored Client. This is something everybody loves very much. But, we started experimeting with it. The first idea was to…
-
windows "Run..." function from NAV
hi everyone, actually this is not a tip, but i'm asking for a tip from somone more familiar with these things than me... in NAV 2009 you can run pages doing start, run, dynamicsnav:////runpage?page=[page number] i was wondering if there is a way to run automatically this from a form, passing page number as parameter...is…
-
Sorting without key (own index)
Hi Sometimes need sort some table by field without create addition key. I tried to do this in C/AL. Thank you for your attention. Below you can look for my result. OBJECT Table 50005 Sorting Data{ OBJECT-PROPERTIES { Date=24-11-08; Time=[12:00:00 ]; Version List=Sorting; } PROPERTIES { } FIELDS { { 1 ; ;No. ;Integer…
-
An editable field on a non-editable form
Today I 'discovered' a nice litte trick. Thought I'd share it with you. It was necessary to have an editable field on a non-editable form. In the OnAfterGetCurrRecord on the form there is the following code:CurrForm.EDITABLE(status = status::open); So if status is released the form is non-editable. But 1 field still has to…
-
Ask a filename without using Microsoft Common Dialog Control
I invented this function in the pre-Codeunit 412:"Common Dialog Management" era. AskFile(VAR PtexFileName : Text[1024];pblnImport : Boolean) : Boolean// AskFile// IMPORTANT : you can also use Codeunit 412:"Common Dialog Management"// Asks the user for a filename// PARAMETERS :// VAR PtexFileName : INPUT : Default filename…
-
Mapping LPT port - Windows Vista
I spent quite some time banging my head against the wall trying map an LPT port for redirecting zebra labels within NAV. NET USE LPT1: \\%computername%\sharename /persistent:yes This works all day long logged in as administrator on an XP box, however Vista is a different beast. Even running the Command Prompt as…
-
How to get duration in time between 2 time
f_duree(VAR _heuredebut : Time;VAR _heurefin : Time) _duree : Time // _Duree en hh:mm:ss IF (_heurefin<>0T) AND (_heuredebut <> 0T) THEN BEGIN _duration := _heurefin-_heuredebut; // duration = integer _duree := 000000T + _duration; // ***** not _Duration + 0000T ****** ](*,) INCREDIBLE !!! END; :D
-
NAV 5.0
From where can I download NAV 5.0 ?? Any link at partner source or as such??