-
SMTP Mail Setup (NAV 2009SP1)
What are steps for setting up outlook for my nav 2009 sp1? I go to nav>> Administration>> IT administration >> General Setup >> SMTP Mail Setup and then what? It is asking SMTP Server, Authentication(Anonynous,NTLM, Basic ) and if is basic it wants User ID and Password. I tried all but When I try to send a quote It doesn't…
-
Export objects by commandline
Hi, I hope some1 can help. I did this for NAV 2015 long ago (or similar): finsql.exe command=exportobjects, servername=EC1DEVDB01, database=Test_March_17, file "c:\temp\testfob.txt", filter="Modified=Yes;Date=+echo %date%",ntauthentication=yes For some reason in NAV2009 classic client, it keeps telling me "the program…
-
Trial balance difference
There was a sales invoice for 1000 for the April Month. Sales credit was posted in May for the mentioned sales invoice. But it needs to be posted for the April. So I posted a sales invoice for Sales credit memo for May to clear the sales credit memo. Then I posted a sales credit memo for April for the earlier sales…
-
NAV 2009 classic report designer error: supported version of visual studio could not be found
This never happen in the past. But suddenly, all our PCs are unable to load the report designer. I have tried to install Visual Studio 2008SP1 with Report Viewer and NAV 2009 classic end up opening a blank report inside the Visual Studio Report Viewer instead of NAV 2009 Classic Report Designer. I have search thru this…
-
Optimize NAV native DB objects
Hi all, I hope some1 can help. Is there any way to optimize by command line/job a native database objects? Like sql server job but something similar. thanks!
-
FINDSET REPEAT UNTIL
Hi All, Previously, I've got issue after looping, not all my records are modified as I forgot to use second table variable after reading topic FINDSET on other forum. However, I saw there are 2 approaches as the following: Rec1.SETRANGE(Field1,Value1); IF Rec1.FINDSET THEN REPEAT Rec2.GET(Rec1.PrimaryKey); Rec2.Field1 =…
-
How to set filter on boolean record to both true and false?!
I made a table in which I have a boolean field. Also, I made a form for this table on which I want to put three buttons. One to filter the records by the boolean variable field: value = TRUE, one to filter the records by the boolean variable field: value = FALSE. But also I want to put one button on the form to show all…
-
Nil Stock of Items
Hi I have some items in stock which have nil stock but still it shows some value in decimals. How value can be corrected. Thanks
-
drill down report
Hi How to create a drill down report to display detail data in navision Thanks
-
Reversing a customer ledger entry using Functions>reverse transaction. I am getting extra line
Reversing a customer ledger entry using Functions>reverse transaction. I am getting extra line that is reversing a FA/GL entry for depreciation. I cant delete the extra line. Please help how can I just get the correct lines to reverse the entry.
-
NAV 4.03 SP3 and Changing Domain Function Level
We are in the process of de-commissioning a Windows 2003 Server that is one of our domain controllers. Due to its' presence, the Domain Function Level for our network is set to Windows Server 2003. When I replace this DC with a new one, the minimum DFL support will be Windows Server 2008. I am trying to find out if our NAV…
-
Can't solve the error Definition of field Cooperativa was changed after the object was saved
Trying to execute the verify option in Form 39 (General Journal) i'm having a common error "the definition of the field Cooperativa was changed after the object was saved. Old Type Code New Text". The problem is I ca'nt find the origin of the error... In table General Journal Line (81) I've add a field Cooperativa of type…
-
No. Series Relation
Hi, I have the S-ORD number series specified in S&R setup. Then in the number series relationship table for S-ORD, I added two other number series - S-BKT and S-SPC. This way, I can click the ellipsis button on the sales order and choose any of the three number series. What I need to do is relate each ORDER number series…
-
Sales Credit Memo Discount Error
Sales Invoice had a discount of 25%. When a sales return is made Sales Credit Memo has picked 30%. The Sales Credit Memo has posted with the incorrect discount. How can we solve this error?
-
Dynamics NAV QR generated are with with empty fields
Dear all , thank you all for your contributions in this wonderful site i have used sbinesh terrific objects to create QR blob image BUT UNFORTUNATELY the fields in the scanned output QR image is empty is with no data Any help , highly appreciated???
-
NAV 4.0 and domain functional level
Does anyone know what domain functional level older NAV clients require? Take MBS Navision 4.0 as an example. The Windows authentication on a C/SIDE server does not work when moved to a new domain running Windows Server 2008R2 as DC. The old domain was running Windows 2003 Server as DC. I'm guessing some issues with domain…
-
[solved] Problem setting up the webservice
Hi there, I have problem calling the webservice on NAV2009 R2. I Installed the service on the same machine the sql server is installed. I set up a WS in Form 810 and published it. The service is running and I can open the service wsdl http://[servername]:7047/DynamicsNAV/WS/Services |…
-
Download JSON String with Nav 2009 R2 Classic Client
Hi there, I hope that I did not miss any existing answer regarding my question. Simple and short question: Is it possible to download and deserialize a JSON string in Nav 2009 R2 and if so, how? I hope you can help me. Best regards Kami
-
Expand collapse button not appearing
Hi I am making drill down report but expand collapse button not appearing Thanks
-
Job Queue_Navision 5.0_Urgent help is appreciated.
HI All, I am facing issue with job queue in Navision 5.0 Every time I need to restart Navision service then only I can see the job queue log entries created, which is actually not possible when users are working. Please note this is not SQL database instead Navision local database. Can you provide any insights on this.…
-
RENAME BY USING INSERT/DELETE
Hi All, I'm using the following codes to change one of Comment Line Key but I realized some records are deleted (insert was failed) :( . my intention is that I want to rename number comment line by using insert-delete method. Is there any better way? CommentLine.RESET; CommentLine.SETRANGE("No.",'XXX'); IF…
-
"Table already exists" during migration to SQL Server
Trying to convert my NAV4.0-database to SQL Server. Imported "migration.fob", and ran codeunits 104010 and 104015 and fixed the incorrect dates. After that I've made an backup of this native database, created an new empty SQL-database en tried to import the backup. After a while, Navision reports that an table already…
-
Count working days between an established range
Hello, I have a DATEFORMULA type value that establishes the number of working days and an initial date that establishes the date on which the count begins. How can I get the amount placed in the DATEFORMULA field and use it to set only working days and from this formula to have a final date?
-
Stock Keeping Units Necessary?
Hi, If we are planning for one location only, do I still need to create stock keeping units? I see that if I don't, I still get results when running the planning worksheet, though the results appear to be somewhat different if I have a sku setup. Thanks, Steve
-
Getting the error while export a table as Excel file
In Data migration, I am trying to export a table as an Excel file. But it throws a below error. Microsoft Dynamics NAV ClassicThis message is for C/AL programmers: The call to member text failed. msxml6.dll returned the following message: An invalid character was found in text content. Please assist me to clear this error.…
-
Export to Excel - Drawing a frame
Hi everyone, I am trying to export some data to excel... The customer wants each row to be surrounded by a frame...and the whole data to be surronded by a bold frame, just like the picture below: Does anyone knows how to do this????
-
Short/Excess Qty
Hi How we can manage Excess/Short inventory . Can we specify different Document Type or Entry Type to differentiate these Document No or Items Thanks
-
Send Free SMS from Dynamics NAV using Hyperlink Working Fine
Dear Experts, I have found the method to send Free SMS from Dynamics NAV using Hyperlinks and it is working very fine. logic: I have just call the weblink using Hyperlink (where i had pass Authentication & Message Detail) !!!! So Simple =P~…
-
Any books on C/AL?
Hey hey! Anyone know of any kind of book written about C/AL? It'd be so nice to be able to go to Barnes & Nobel and pick up a C/AL book or two to learn this language. I feel like that's my biggest roadblock to doing more complicated things with Navision right now -- I know how I *should* be able to do things based on…
-
How to convert text to hexadecimal in Nav 2005
Hi, I need to export data by XMLPort but as a hexadecimal values. Since Nav 2009R2 is possible by DotNet but in nav 5.0 is not possible to use it, I think. Do anyone have some ideas how text could be converted to hex in this ver. of Navision? Regards Malintus