-
Input Dialog
Can anyone give me a quick example of how to use the Input Dialog? In other programming languages (like VB, for example) I can use an Input dialog to ask the user a question, and get an answer. Is this how it works in C/AL? Can anyone give me a quick example how? Thanks.
-
can you access another codeunits variables during runtime via a get-Function?
Hi, so i wonder how long (global ) variable values are stored during runtime. Lets say i want to pass an error message (from CodeUnit A ) to another code unit ( CU B ) . could i for example store it in a global variable in CU A , call another CU B and then pull the global variable from CU A through a get-function? Or is…
-
Posted sales invoice line not posted to GL and other table
Hi, i'm using NAV 2009 R2 build 32012 and currently i have a problem which randomly occured. The problem is when i posted sales invoice one of the line, usually the last line, aren't completely posted to every table. Here's the sample of the posted document when i navigate them Document No X001 Posted Sales Invoice Line 01…
-
NAV 2009 R2 - Error while restoring database
Hi, I need a help regarding this issue. I'm restoring a database from FBK file. After a long time restoring the database, suddenly this error message occured when it's almost done. What's the cause of this and is there anything i can do to complete the database restore process ? Edit : For more information, i'm using NAV…
-
Replace a string by another
I want to change every occurance of & to and The CONVERTSTR function does not let me do that since & and and have different number of characters.. Does anyone know of a way of doing this??
-
SMTP server error
Hello team, am trying to send an email to users on the same server. I get a pop up message that the mail has been sent, however the users don't see it in their inbox. What could be the issue? I need a quick fix...Thanks
-
How focus on a field when pressing an action? +NAV2018
As I could focus on a specific field by pressing a button, I have tried the activate function but it does not work in this version. Does anyone know how this can be done that I need? Thank you
-
GETLASTERRORTEXT returns nothing with XMLport
Hi. I'm calling an XMLPort from a codeunit and I want to catch cases where the XMLPort fails because of a badly formed file, a condition I haven't forseen, etc. So I have this: IF NOT XML_Port.IMPORT THEN BEGIN ErrorText := GETLASTERRORTEXT; CLEARLASTERROR;END;MESAGE(ErrorText); The trouble is, ErrorText (returned by…
-
Dataport For Record Link Table
Dear Friends, Our customer wants a dataport for Record Link table but when i tried to do it i am getting this error, its not allowing me to have the field "Record ID" of type RecordID and "Note" of type Blob in dataport. It prompts me the error as attached. Please advise how to create dataport for this. How to export…
-
How to delete non-printable control characters
So we have some non-printable control characters like line feeds and carriage returns in some contacs table fields ... is there a way to make them visible and or delete them?
-
set deleteallowed option using c/al code
Hi everyone! I need to set the option delete allowed according to the USERID. My problem is to do this using the code because i don't want to block ALL the users, just a specific understand? My struggle is how to get this page object property in the code.. I want to do something like IF USERID='john' THEN…
-
Dynamics NAV 2009 R2 Security Issues
Hi, One of Client using NAV 2009 R2 Classic client. They had done penetration testing from the internal network and they use Windows Authentication. They had found few security issues. One of them is they mentioned "Inadequate access Controls in Place". It means Pentester is able to intercept TCP data and capture the SID…
-
Plz help! strange errors in NAV
Hi All, I am running Navision 2009 R2 with SQL server and I got errors as figures below that I dont know how to resolve them. I am beginner in NAV, so have anyone can help me to fix these errors? Thank you so much.
-
Excel Buffer Expand
Hello Guys I will slowly despair... I have a problem. I need to expand the "Excel Buffer" with a function with 2 parameters. First parameter "From Cell" second Parameter "To Cell". Then i need somehow to Delete all Rows between this 2 Parameters. Somehow i have tried with multiple DotNet's but nothing works!! It should be…
-
Posting procedure
Hi all, Is there any documentation where I can learn more about journal posting procedures, how to set up a new posting procedure, e.g. docs about journal template, journal batch, journal line,... Thanx
-
How to check max number of licensed users?
Hi, Does anyone know how I can check the max number of users allowed by the license? Thanks
-
How to open all files (eg *.xml) in batch in a folder ???
Hi ALL, I have an question about open files in Navision. I have a Codeunit which used to import XMLport. TestFile.OPEN('C:\Output\PO1.xml');TestFile.CREATEINSTREAM(TestStream);XMLPORT.IMPORT(50003,TestStream); Besides PO1.xml, there are also other xml eg PO2.xml, PO3.xml, etc in the Output folder. And what I want to do is…
-
Calc and post VAT Settlement
error message ' document no' is missing
-
Change Company without relogin
NAV2009 - 2.01B Hi, how is it possible to change the Company without getting the login window. I thought this behaviour is usual or standard, because I never get a login window. But some of my colleagues, have to relogin and other do not. I don't see a different to change this behaviour.
-
Inserting BLOB into external SQL table
Hello, I am trying to do the following, not very successful until now. Maybe somebody can give me a hint. Basically I want to create a XML file in Navision and store it into an external table. 1. I do not use XML ports, I am building the XML in a codeunit and store it into a Navision BLOB field. This is done already. 2.…
-
Any Editor for C/AL??
Hello, Do yo know any aditor (apart from standard) to write C/AL code?? For example, with color to remark key words, etc etc Thanks Asier
-
Sum Routing Line table field
Hello. I need to sum a field real time, where center no is M-150. I need to do it without flowfield. I make this, but gives me only 0 as result. Routing Line table -> new field -> Sum M-150 as decimal field Routing Line table -> new funcition -> SumTotal150 Variables for this funcion -> RoutLine, datatype is record,…
-
Concatenate multiple comments
Hello. I need from table 5414 Prod. Order Comment Line take all comments for one production order and store all comments in table 5405 Production Order as one field. One production order can have multiple comments. Can you give me advice?
-
Start Time/End Time on Production Order
Hi, I'm aware that the start time and end time are related by the routing time. However, we are wanting to override the Start Time that is derived from the backward scheduling. However, any change we make to the Start Time always updates the end time, by the amount of the routing time. Is there any way to bypass this, so…
-
How to apply code for decode base64 Zip File and extract the XML File in NAV2009 Classic Client?.
Hi, how to apply code to decode Base64 Zip File in Blob Field and extract the File from Zip Folder in NAV2009Classic Client. Now with existing code it works fine when attachment in XML file is PDF, it is properly encoded and write the file details in Blob field and read (decode) in Navision. But when it is Zip File, it…
-
Calling a report from another - Setting variables
Hi I'm calling a report from another. The report I'm calling has a request form, wich I set as unable in the RUN command. But I need to set some variables to filter a table, etc. Lets say report A calls report B. In report B, I set a variable X in C/AL Globals. Then, I define a function InitX(value) wich does: InitX( Value…
-
Any PDA Solution for NAV 5.0
Hi, is there any PDA solution to do warehouse transactions still available that can work with Navision 5.0?
-
LS Retail Pos Screen
Hi How to create Input Dialog Box on LS retail Pos Screen so that user can input some information. Thanks
-
Error While entering data is date formula field in Russian Language
Hi All, I am struggling with an Issue in Navision Russia. Whenever I am entering data in Russian Language in "Dateformula" Field, system is throwing an error as attached in screen-shot. In Russian language '1D' in dateformula is equal to ''1Д'' but system is parsing ''1Д'' as '1O' which is causing the issue. Version detail…
-
Format validation of GUID Field
Hi everyone, I have created a Text data type for a "GUID" field. I need to VALIDATE it. Now i know how to use the validation function. But i need to validate so when the GUID is manually entered through a form in NAV, I need to check if the format is correct or not. If it has an incorrect format. It has to throw an error.…