-
How to create a bar code label printing report
It is the hardest suffering I had in this year, so I would like to share it. First, forget bar code fonts (do not work for non-English countries, it is a deep Navision bug of what fonts it accept). Use the BMP-generating download from the downloads. You will need to print more than one barcode per item, so you will need a…
-
Use dummy optionstrings
I've mentioned it before and after today, I will do so again. If you change a optionstring in Standard Nav, insert some dummy option values. Today I've upgraded one of my add-ons to 4.00 (a bit late I admit). I was glad when I discovered the ic-partner option in the G/L entry table that I had some blank options. Example…
-
Avoid RecordReference.SETTABLE-bug in 3.70
First : I don't know if this is fixed in 4.00. rerRecordReference.SETTABLE(recMyTable); If "rerRecordReference" has some filters or a certain index on it, these are reset with the command SETTABLE. What to do:rerRecordReference2 := rerRecordReference.DUPLICATE;rerRecordReference2.SETTABLE(recMyTable); With the DUPLICATE…
-
Fill SourceExpr from F5 list
I read today post somethink like that "Why i can't fill SourceExpr of control with f5" Answer on that post "Press f5, ctrl+C,Ctrl+v on sourceexpr" I do it in other way. Press F5 , select semething , press enter This don't work.. but.. Press F5 second time, select , press enter - It works.. :) ..maybe everyone know this…
-
Values to(from) file by dataport without request form
I need to import some data (orders for instance) to Navision from file. But there is no "customer no." in this file and user has to select "customer no." himself. Earlier, i would make request form in dataport where would give to user a textbox to select "Customer No.". There is a very good option in dataport: select…
-
Assignments
Instead of var := var + const you can write var += const; var := var - const you can write var -= const; var := var * const you can write var *= const; var := var / const you can write var /= const; (source: This tip was posted by jkiss to www.navision.net) Marcus Fabian m.fabian@thenet.ch +41 79 439 78 72
-
C/AL coding macros (auto-expand, auto-complete)
As my Navision Developer's Clipboard was not very successful (even I am not using it now - turned out to be too complicated...), there is another idea to speed up C/AL coding: 1. Go to www.autohotkey.com and download the software - this is a free macro tool. 2. Copypaste this macro: #Hotstring EndChars `t`n…
-
Editable lookupforms
Everybody who uses Navision knows that setup tables like posting groups are always editable. Normaly you need to change the userrights in order to prevent users from changing codes or you need to have 2 forms. A simple workaround is to add the following code to the OnOpenForm trigger CurrForm.EDITABLE(NOT…
-
Formatted texts / Word Plug-In / ocx
I'm looking for a way to handle formatted texts in a Navision Form (Word Plug-In?, ocx? ...) It's also requested to print the texts out of Navision. Any ideas or solutions ? Thanks in advance Axel :roll:
-
Use DB at 100% without filling the COMMIT-cache
NATIVE DB-ONLY!!! The following code can be used to fully occupy the DB, but without filling the COMMIT-cache and blocking other users. Use function "PerformanceSleep()" just after a COMMIT in your code. This function can be used in SQL without receiving an error-message, but will not do anything. PerformanceIndication() :…
-
How to Disable Zoom (Ctrl+F8) from a form
I've seen a few posts where it says that it is impossible to disable the ZOOM feature, Ctrl+F8, from a form in Navision without disabling the ZOOM privileges for all forms. But - there is a way to do it, quite simple really. Just add a new MenuButton to the form, and add a new option. Caption can be anything you want, for…
-
NAS 4.0 SQL Issue
After hours and hours of trying to figure it out..... ](*,) When you install NAS for 4.0, it puts 2 services in there, one for CLASSIC and one for SQL. The installer puts the machine name in here and you can change this. Let's call them NAS-CLASSIC and NAS-SQL. There is nothing wrong with the CLASSIC one, you can modify…
-
"MSSQLSERVER service could not be started"
It is common for consultants to have several MS SQL servers and multiple MBS products installed, f.e. Navi 3.7, Navi 4.0 and MS CRM Sales for Outlook. The problem is that all of these install MSDE (as a default instance). Today I hacked some translations in the fin.stx file, and found that it has a checksum so if I change…
-
Automatic login screen for another user
Have you users which are using same PC for work? (for example barcode reader with Win CE connected to the terminal server?) Do you need show the login form after previous user close the navision? Or you want to simplify the close-open process after importing the objects? There is simple way how to do it: Var Ending :…
-
Putting functionality into data
It is possible to put functionality into data, instead of developing them. Examples: 1) A company has 5 hierarchical levels of product groups. Instead of adding fields to Item Card, you could put into Item No. Any Item-related report and transaction has Item No. so users can filter for it. Of course, be very cautious to…
-
Some tips about user rights
Actually I cannot post a 200% working a wholeheartedly recommended hint here, just some experiences - but I hope it helps. 1) Standards roles are not very useful. For example, you have a role to post sales documents - it means you can post both Shipment and Invoice - it is of course ridiculous. You will need to rethink it…
-
Trouble moving Navision windows
I have this silly problem but it's getting really fustrating since i can't figure out how to solve it. Sometimes the window i'm working on in Navision it might move (or i might move it accidentally)at a point on my monitor that it just makes it difficult or impossible for me to work. I have tried number of ways to move…
-
Tricks to protect Inventory Value
In every installation we always get a phone call after 3 months of going live: "I can't understand why our margin is just 3% for this item..." or "Post Inventory Cost to G/L stops with a strange error message" or the most dreaded one: "Inventory value seems to be bit strange, would you check it?" and then we look at the…
-
Improving usability with colors
Do you want to really impress customers and collect much praises? Use coloring. For example in Customer List make a customer name bright red if they are over their Credit Limit: Name - OnFormat trigger: calcfields(balance); if balance>"credit limit" then begin currform.name.updateforecolor(255); //red…
-
Inventory Pick trick
Inventory Pick and Put-Away was really a big idea in 3.7: before that, the only way to have Bins was to implement full WMS which is really a complicated stuff. Inventory Picks are really simple and easy to use, suitable to many companies. But there is problem: you cannot have a pickink route by bin rankings. The trick is,…
-
change lcy
Hi, Is it possible to change local currency at the beginning of a new fiscal year ? If yes, what's the process for it ? Any batch that works to convert all accounts to the new lcy or is it all manual work ? Guess this had to be done in all the EUR countries in Europe. Thanks for any advice. daniel
-
How to copy a item-, vendor-, customer-card (or other Card)
How to copy the item-card (or customer-card or vendor-card or some other Card) 1) Go to the form of the card 2) SHIFT+SPACE. All fields will become blue. 3) CTRL+C to copy the card 4) F3 to create a new card 5) CTRL+V to insert the data. Navision will give an error that the card already exists. Hit Enter until you can…
-
Filters / Reports
Hello Reports: A "P" on a Date filter will return the To..From of the accounting period dates. Does anyone have a Tip/Trick for getting the prior accounting period? M,T,W,T,F will get you Monday - Fridays Date W, will get you the work date T, will get you todays date Any others? Thanks
-
Killing sessions in pre 4.0 Native database
Just had such problem in one daughter company where the licenses were used up. And - naturally the solution is quite simple. You can download a freeware application from SysInternals webpage http://www.sysinternals.com named "tcpview". This nice program displays all established TCP connections from your Native database…
-
Using out-of-licence tables
My associate here just discovered, that there is possible (at least up to version 3.7) to use tables, not allowed to be used by your license as temporary tables. It means that you can create a table (using your developer license) in the number range not accessible by your customer. You can use the table in your forms /…
-
mail with attachment
Hi, I would like to send e-mails with more than one attach. So I had modified the codeunit mail (397). When I do not use text I could not order the attachments and when I am trying to modifiy the function I get errors in the mailing system. //-002 IF DateiNameAnhängen2 <> '' THEN BEGIN MAPIMitteilungen.AttachmentIndex :=…
-
Get around divide by zero.
Here is an expression that returns 1 when x is zero (or the original value if it is not zero) x = figure below division line, also figure below division has max 2 decimals The 100 below is to cater for -0.01 <= x <= 0.01new value := x + 1 - round(x*100 / (x*100+1)) Regards, gus
-
Create Online Help for Navision 3.xx and 4.xx
With the additions to the mergetool is it possible to create Online Help for Navision Attain (3.xx) and 4.xx. This tool will use Microsoft Word as the editor and spell checker, A freeware HTML Help Compiler from Microsoft and additions to the Mergetool to create the HTML Files from the modified objects. It is also possible…
-
Object ranges in your license file
(I was looking for an answer to my problem and didn't find it here so i've added it ;) Here's a handy way to see which objects are allowed to be used in your database according to your license file: - Create a new form with source table: 2000000043 - License Permission - Set the type to Tabular-Type Form, press "OK" - Add…
-
Write to excel without automation (Part 2)
FileVendor File StreamVendor OutStream recVendor Record Vendor txtVendor text 250 FileVendor.CREATE('c:\vend.csv'); FileVendor.CREATEOUTSTREAM(streamVendor); FileVendor.TEXTMODE(TRUE); IF recVendor.FIND('-') THEN REPEAT txtVendor := ''; txtVendor := FORMAT(recVendor."No.") + ';'; txtVendor := txtVendor +…