-
ExcelBuffer and NumFormat
I'm having trouble with NumFormat while creating an Excel file I'm looping a record and doing some calculations and then a second loop over time. The results are written to ExcelBuffer with one line per record iteration and one column per time period I got a request to reduce the number of decimals to two to enhance…
-
Issue in Importing the Object in NAV 2013 - Upgrade Issue
Dear Everyone, I need one urgent help for the following issue. Currently I am doing one Data Upgradation for one customer. I am following the steps as per the quick Guide which comes with the Product CD. While importing the NAV 2013 Merging Objects after converting the Database, I am facing the following error for few…
-
SMTP Email sending Issue
Hi All, I am getting following error while sending email from NAV5 (on SQL Server) using SMTP. I am using GMAIL for sending emails and it uses port 587. For providing Port No. as parameter, I have updated the objects as described in Hot Fix (knowledge artcile KB981354 https://mbs2.microsoft.com/Knowledgebas ...…
-
Changing SMTP port on Codeunit 400
Hi, Has anyone found a way to be able to change the SMTP port on codeunit 400? The internet ISP changed their SMTP port from the default 25 to 587, now the mail will not send.
-
Difference between purchase return order and undo receipt
Hi everyone, I want to know the difference between creating a purchase return order and undo receipt from a posted purchase receipt. When to use each of them??? Thanks in advance :)
-
Adjust Cost Item Entries Batch JOB - Error
Hi Experts, Greetings To All! I am facing a serious issue while running Adjust cost Item Entries Batch Job. I ran this batch job for one item which is having more transactions, it ran nearly for four days but it doesn't get completed.On fourth day it got stopped with the ODBC Error. Kindly find the screen shot.Please…
-
Ideas Welcome
We will be offering lamps in which we will wire for international configurations (EU, AU, UK, etc…). These re-wired lamps are actually US wired lamps that are re-purposed. (unwired and re-wired). Our hope was to not create an inventory number for each lamp as it makes product management a nightmare as we have (10+) version…
-
Error when changing the structure of the tables
Hello everyone! When I try to change (with client license) length of text field in table in user's range (5025400) 30 symbols --> 50 and to save object, system retrive error "You do not have permission to modify records in the G/L Entry table". What it means? Why I get error about 17 table? What I should check? Permission…
-
Import Worksheet Table type
What table type is the "Import Worksheet" made of. I want to copy the content of the "Import Worksheet" form and paste it into a self made form. In order to be able to do so, i have to create my form with the same type of table, as the "Import Worksheet" uses. I have tried using "2000000001 Object" but that dosn't work.
-
How to set Global dimensions are mandatory in JVs - NAV 2009
Hi, I face one issue about Global dimension, I have set the global dimension1 and 2. But while JV posting, posting is happening without dimensions. Any one can helpme? Muhammed Faizal ERP Admin
-
Login Issue - 'The file DCMEMSTREAM contains a record...'
Dear Everyone, I am doing Data migration from 2009 to 2013. (I have completed Transfer Data for step 1 successfully.) After this while converting the database from 2009 to 2013 I got the following issue.(I didn't get 'Successfully converted' message even.) The Conversion process was running some few hours. Now, While…
-
application entry
hi experts If i have deleted a sales invoice and associated all the table entries and item application entry for that ledger entry no has been deleted . there will be any impact pr not. plz suggest me.
-
Probably a stupid mistake, but can't FINDFIRST in dataset...
This is probably a really stupid mistake, but I can't spot the problem so maybe a second set of eyes on it will help. I'm trying to have some Whse. Item Journal batches require a Reason Code, so I added a Boolean field called 'Require Reason Code' on the batch record. If this is true, then the code should cycle through all…
-
Reading of uncommited data
Hi I know, there have been some threads about this, but I'd really appreciate some more details about this behaviour. Let's make an example, a simple codeunit.Rec1.INIT;Rec1.pk := 1;Rec1.INSERT;Rec2.LOCKTABLE;Rec2.GET(1); Rec2.GET(1) is successful, altthough Rec1.INSERT is not commited yet. My questions so far: 1: Is this…
-
Using same printing( or pdf) method with different reports
This is the goal: Printing report X to pdf then report Y ( part of the printing process of X) also needs to be printed to PDF. In case I printed X to a printer , then also Y should be printed to the printer. How can I determine what method is used and how to use this when printing the second report???? Printing to word…
-
Why navision does not have debit memo?
As stated in the subject, why is it debit memo being remove from Navision v4.0+?
-
Shortcut in C/AL Editor
Hi Some time ago I have seen some nice shortcuts for C/AL Editor, but I don't remember anymore where it was... The shortcuts were about how to jump to the next period, word, etc. Anybody can help me? Thanks in advance Thomas
-
Dataport Standard Cost
Good day! Is there a way to import item standard cost using dataport? We are using NAV2009 SP1. I appreciate your kind assistance. Thank you.
-
Synchronizing two tables
Hi everyone, I have two tables with the same primary key and many identical boolean fields(same id,same value). I want that when I delete a record from table1, the boolean in table2 take all the value false. Example: record in table1: key=xxx, bool1=true bool2=true record in table2: key=xxx, bool1=true bool2=true If I…
-
Lookup - Best Way and The Difference
I tried to created 4 methods to lookup table by using C/AL in the Control. All are have the same result (lookup the table, get the value, and put it to field or variable). What is the best way? are they any difference among this 4 methods? "Test Lookup" is new field in Customer table. In the form, pull "Test Lookup" and…
-
Table 2000000009 has no name
Hi Everyone, Recently we are facing a error "Table 2000000009 has no name " while syncing users / importing objects / compiling objects which are using session table as a variable. Additional info: This database is working fine from last two year but recently have this error for certain actions. Database version is NAV…
-
TableData 0 Does Not Exist
Creating a report using the Excel buffer, nothing fancy just some Production Order/Line data. Have done this before, but when I compile this one I get the above message. Double checked the field names etc. Has anyone else come across this before? Thanks
-
connet to Nav from NAV sending a request by XML
hi, I have published how webservice a codeunit NAV2013, now I need to call it from onother codeunit NAV2013 sended a file XML, like this, thanks : XMLHttp.open('POST','http://www.sgatetest.anci.it/sgate-gas-web-services/services',FALSE); XMLDocument.loadXML('<soapenv:Envelope…
-
Job Queue in NAV 4.0?
Hi yall, Has anyone been able to implement Job Queue functionality from NAV 5.0 to NAV 4.0. One of our customer is still using NAV4.0 and they want some reports to get executed automatically. Therefore, we decided to use NAS. However, rather than modifying CU 1 all the time, I was wondering has anyone been able to…
-
Colour coding for editable/non-editable fields is messed up
A customer, who's running 2009 R2, recently implemented a Citrix environment. They immediately realized that they were no longer able to distinguish between editable and non-editable fields on a form: field that were editable appeared non-editable and vice versa. The problem was not consistent, though: for some fields the…
-
Windows error raises when trying to log in
Hi all, Hope someone can help. After the migration from Navision 4 to nav 2009R2 classic client seems like it doesn´t work for any user. I tried to delete all roles, keep just the super and try but it doesn´t work. Seems like if they add new users it works so It must be some kind of problem with old users. This happens…
-
User Menu Level already exists
Dear Experts, We are using NAV 2009 SP1 classic version DB is in SQL 2012.We took native backup .fbk and restoring on new DB (created using Finsql), after 100% database restoration we are getting following error : The User Menu Level already exists Identification fields and values: ID='Super',ID Type='Database',Level='User…
-
Could not create an instance of the OLE control
Hello Dynamics NAV 2009 R2 Classic on Windows7 I tried to install Shauravs smtp port code at http://saurav-nav.blogspot.fr/2013/12/before-nav-2013-smtp-setup-with-port-no.html but it did not work : even if the controlk registered successfully, it diappeared in dynamics and so automation variable was not more declared So I…
-
Last year shipment returning this year
hi friends, My sales department people shipped some quantity as part of sales in last year (2013). later 2013 financial year is closed. Customer returned some quantity in this year. What should I do? 1. I cant undo shipment because it effect last year stock value. 2. If do sales return this year , stock will be ok, but it…
-
Cust. ledger entry flow after Posting SO
Hi, After posting a Sales order the data is hit Cust. ledger entry table, that we can see by Navigate on Posted Sales Invoice. How the entries are hit to Cust. ledger entry table, i know its somewhere linked to Cdu 80.