-
Error: Could not load the selected type library
Hello, i'm experiencing this well-known error with a NAV2009 R2 version, with NST installed (user are using RTC client). I've installed the dll i want to use as automation on a NST server and registered it via RegAsm. Now, still on this NST server, i'm trying to compile codeunit that use that automation: - Open codeunit…
-
Load PDF file into NAV 2009R2 and parse into text file
Hi everybody, I would like to know if it is possible to load a pdf file (it contains a data set) into nav and parse it as if it was a text file? Obviously, what I need to do here is load the pdf file and transform it into a text file or anything similar so I can create my data set from it. Has anybody ever faced such…
-
Multiple 2 fields
Hello. I need to multiply two fields in Navision Production order Quantity and Item Gross Weight I make: - new field in Production order table -> Total Weight - Production order table -> OnValidate -> "Total Weight" := Item."Gross Weight" * Quantity; But it's not working.Where is the problem?
-
How to create Date filters?
Hey Guys! Let me know how to create Date filters in a walk through way. Thanks in advance.! :)
-
How to filter for installment invoices in CLE?
Hi Friends, [Version: NAV 2009 Classic] In Posted Sales Invoice there is an invoice no.12345. This invoice has multiple installments (say totally 10 installments) and in Customer Ledger Entry the transactions Document No. looks like.. INV12345-01 INV12345-02 INV12345-03 . . . INV12345-10. I need to sum-up the remaining…
-
Login issue for webservices using the service account.
Hi everyone, I have been digging around this for the past 2 days because of a strange issue here, I created and added a new service account to add it for Nav 2009 Services. It has sysadmin and dbowner rights in sql database. In NAV 2009 it has super permission. Yet still, we are unable to access any web services with the…
-
Compile report again and again?
Hi, My customer tells me that my former colleague has told him to compile a specific "processing only" report i NAV 2009. The story is that sometimes a function in a form doesn't work and there is no error messages. That problem would be fixed if the customer finds the report in the Object Designer and compile it. Can this…
-
Running on old code?
This question is concerning NAV 2009. I have a form that calls a "Processing Only" report. The report calls a codeunit. My customer has reported an error. I can reproduce the error again and again by pressing a button in the form. If I add messages in the codeunit, I can still reproduce the error, but I don't get the…
-
How to get the Caption(caption class) of a Global dimension in a Message or an Error text(NAV 2009)?
Hi all, I am currently looking into the global dimension in Item card. The Captions are received by the means of caption class '1,1,1'. I was hoping to look up this caption in a message or an error text. I looked up in web and found a function called CAPTIONCLASSTRANSLATE and how to use it…
-
Set Qty. to Handle(Base) to 0 when assigning Serial No.
HI all, is there a way to set Qty. to Handle (Base) to 0 when Assigning Serial No.? I need it for my customization. since I'm Assigning serial No. Manually using a bar code scanner, in my Warehouse Receipt. !! the reason is because when i Try to post the Receipt partially. It does not post. I've investigated. and it…
-
NAV table designer and Database
As I open the object designer and go to the table designer then it shows all the available tables in NAV, right? So, my question is that particular table(table designer) that contains all the tables in NAV, what is that table called? And is it itself a Navision table? I need to put all the navision tables that are present…
-
smtp error
Break On Error Message: The SMTP mail system returned the following error: "Mailbox unavailable. The server response was: 5.7.1 From Address different than actual Sender".OK
-
How to transfer User options from codeunit to the global function of a table via c/al code
Hi all, I have a table called custom table with 7 fields: - Custom Code datatype: Code; - Custom Picture datatype: BLOB; - Expiry Date of type: Date; - Toxity of type option the options are: , Caution, Danger, and Hazardous; - Custom Number of datatype: integer; - Custom Description of type: text and - Commission of type…
-
User set up as Windows login on one DB and Database login on other DB - changing both to be Windows?
Hi all, My client has Nav 5.0 - we are set up as a Windows login on their live DB but as a database login on their test DB. I often have to jump between the two numerous times in a session and it's a bit of a pain having to type the long, complex password each time I connect to the test DB. How can I change it to use only…
-
SELECTLATESTVERSION
I am curious about the SELECTLATESTVERSION function. The help says that this function "forces the latest version of the database to be used". How would it be possible to NOT be using the latest version of the database? I understand that in some cases I need to do appropriate locking to guarantee the latest version of a…
-
How to remove space between columns from exported Excel
Hello, I have a problem :smiley: I've made a report to calculate GL Trial Balance in 5 equal, and in Excel are exported with space between columns. How to remove that space ? Thank you :blush:
-
Distribute table with codeunit
Hi, I have a codeunit webservice for exporting products. Instead of exporting the entire item table in one batch, I'd like to split it up into smaller batches, and then have the consumer party request the web service continuously. I'm using a custom table to keep track of, how many records have been exported, so I would…
-
to pass record to form
Despite many years of programming in NAV2009 I cannot get the grasp of this. When opening the form "FormMailCustomer" it simply has forgotten all about the XXCustomer (blank). How to pass on the information to XXCustomer defined also in form as a global var.? Any help/suggestions would be appreciated. The code below is a…
-
Filter a Table on Login
I am trying to apply a filter through C/AL code on the G/L Account and G/L Entry table on login so that users can only see records from their responsibility center. Ideally I would like to leverage the LogInManagement codeunit's OnAfterLogInStart event to get the user's responsibility center and only show records with a…
-
Editable date field
Hello. I need to make something that doesn't work properly with my code. I need one of my date field to have different states of permission. For example: If date field is empty -> Everyone can type there. If date field is NOT empty, there must have a statement to check for user setup Allow Edit Date. Мy code working that…
-
Changing codeunit id
Hi, I had to import a codeunit into a NAV installation, where the codeunit id was already occupied. I did the following to work around this: 1: In my sandbox NAV I exported the codeunit and removed it. 2: I the imported the .fob file and renamed gave the codeunit a new id. 3: I compiled the code unit. 4: I exported the…
-
Designing an Object and the "The Definition of Table X Has Changed" error
Hi all, First post here so sorry if this isn't the right place. Probably a silly question too, but I just want to eliminate this from my investigation. We have a client that received the error message "The definition of Table 27 - Item has changed. Start your activity again," a fairly standard message, but when I…
-
How to fetch the date and time from a csv file name in NAV
Hi All, Can anyone tell me how I can fetch the date and time from csv filename (through code) in NAV having below format {CompanyCode}_{ddmmyyyy}_{hhmmss}.csv Thanks in advance
-
outlook add on error
Hi, I have managed to create the NAV add on that is linked to outlook but when I try to create a sales quote I get an error stating "Microsoft.Dynamics.NAV.Exchange.ServiceWrapperFactory.CreateServiceWrapperWithToken failed with this message: The given token is invalid." Is there a solution for this please? Thanks, Nicholas
-
Trouble with setselectionfilter
Hi all, Having difficulties in making it work. In a form want to call a codeunit (for sending e-mail with attachment). Rec have filters in number and category. Have a line saying SETSELECTIONFILTER(Rec) Call XCODEUNIT(Rec,TxtId); If selectionfilter is set the result is blank. Have remembered to mark Var in receiving…
-
Info-Code pop-up on an amount trigger
Hi Team We are using Navision Dynamics 2009 R2 We have an upcoming promotion where customers whose transaction value is 100$ or above will get a 'Discount Coupon' Points to note: 1)Discount coupon is a seperate entity,(ie. not printed with the system receipt). 2)Each Discount leaflet comes with a serial number. 3)This…
-
Barcode
Hi I am trying to create a barcode text in the EAN-13 standard The system reads the barcode but stays there waiting for the cashier to press enter. What I am trying to acheive is to have a trailing enter command at the end of the barcode so the barcode is automatically entered when scanned How can this be done
-
404 - File or directory not found''The resource you are looking for might have been removed..''
Hi all can I get some explanation I don't have much knowledge regarding to the below problem so I hope someone can help me with that our customer needs the DMZ server reachable from the Internet. The IIS is already installed and configured. Once the connection is ok, the site should be available under…
-
Replace the TEXT Red with the TEXT Blue
These are the functions I have so far, but the word red will not convert to blue. Custom Description - OnValidate() //-- Validation for Custom Description IF ("Custom Description" = UPPERCASE('RED')) THEN fConvertCustomDescription("Custom Description", 'RED', 'BLUE'); IF ("Custom Description" = LOWERCASE('red')) THEN…
-
Calculate difference between two dates?
Does anybody have an idea how to calculate the difference between two dates? I want to calculate the difference and get the result in form of three variables which will represent years, months, days. I need this to be able to show how long does an employee work for the company. That information will be presented in this…