-
Light User Licnese in NAV 2009 R2
How to implement Light User License in NAV 2009 R2?
-
Giving access to external users
Some group of people in our company do not need NAV access. But they want to access navision data in sql. whats the best way to give them permission. they might run queries on excel. Thanks
-
Looking for NAV 3.7 W1 DVD/CD or just cronus database
Hi, Does anyone by any chance has Navision 3.7 W1 DVD or CD available (preferable with build 14988) for download ? Or a Cronus database Navision 3.7 would be also helpful. I need to upgrade a database from nav 3.7 to NAV 2009 so I would need a Cronus nav 3.7 database. I know there is NAV 3.7A available on Mibuso but I need…
-
PO approvers
Dear All I have a situation where one approver is off duty a higher lever approvers should be able to approve the PO, I.e. for X -> Y is the approver and for Y --> Z is the approver, when X sends a PO request approval can Z approve the PO without any interference of Y? Is it possible to configure in standard NAV. Thanks…
-
Effect of Get Posted Document Lines to Reverse
Dear All, Does the function "Get Posted Document Lines to Reverse" in Sales Credit Memo create any trace in the tabledata "Cust. Ledger Entry" (Generated by the Sales Order/Invoice Posting) to identify that the line is closed by the Sales Credit Memo ? I have gone "Work through" but unable to find any relation.
-
How Activate Excel Window after Open
After "XlsBuf.OpenBook" Excel Window stay minimized. How can I activate Excel Window and bring it to my screen? I try somwthing like: IF XlApp.WindowState = WindowState[1] THEN //minimized XlApp.WindowState(WindowState[2]); //normal XlApp.WindowState(WindowState[3]); //maximized XlApp.ShowWindowsInTaskbar(TRUE);…
-
Error starting DOT NET Application, Message Queue Related
Good Morning we are using a DOT NET application that uses Message Queues to work i have setup message queues on the Application Server and made sure that they are setup withing the NAV application, i have also made sure that the Everyone right is setup on the Message queues, there are no spelling mistakes and for some…
-
Production cost and Actual Cost
Dear Experts, I have a small issue in Production: The following the scenario, Lets say I have FG No: FG1 and FG2 with the overheads mentioned as 7.5 and 15, and my Raw Material cost to produce 1 qty is 100 and 100. to produce my 100 units of FG1 the cost will be so to 10000+750=10750 to produce my 100 units of FG2 the cost…
-
Import .txt object file error not a valid date
Hi. I have a very large object file in .txt format in which all object dates are in the form dd-mm-yy. When I import it I get the error '14-02-14;' is not a valid date. I can manually edit the file to change the dates to dd/mm/yy format, but that will take a while. I'm no VB whiz so that would take even longer (though a…
-
Restore issue
Hi everybody i need to create a test company for a customer, so i followed the usual "backup company - rename company - restore" cycle (using native NAV backup/restore in a 2009R2 classic environment with SQL Server 2008). It always worked even at that very customer. This time i get a "(companyname) already exist" error,…
-
Adjust Cost Item Entries Takes Too Long
Hi there, We have a manufacturing and fabrication customer that heavily uses the Manufacturing functional area of NAV 2009 Classic. One of their biggest challenges right now is that as their Item Ledger (and consequently their Value Ledger) grows, their Adjust Cost Item Entries (ACIE) routine takes a long time to process…
-
Common Dialog multiple file Selection
I'm trying to modify cu412, OpenFile() - functions. To add Multi File Selection support. According to that: http://msdn.microsoft.com/en-us/library ... 42(v=vs.60).aspx I need: cdlOFNAllowMultiselect OR cdlOFNExplorer OR cdlOFNLongNames So I add just this code: CommonDialogControl.Flags := 2621952; And that's work fine,…
-
Amount is 0 in customer ledger entries but has value in g l
Hi guys i have proplem i have more entries in my dynamic nav 2009 r2 have 0 amount in customer ledger entries and not any entries relation in details customer ledger entries why this problem happen and how i solve screen shoot of proplem in http://dynamicsuser.net/forums/p/75782/ ... spx#416049 so that why amount in…
-
passing large parameter to sql stored procedure
Hi I'm trying to pass a large text parameter to SQL stored procedure (where it declared as NVARCHAR(MAX) ) I do the following:paramHistoryTempList := myADOCommand.CreateParameter('@HistoryTempList',200,1,1024,HistoryTempList); where HistoryTempList is BigText And get error like this: If i trying to pass a variant,…
-
NAV 2.5 database?
One of our client is thinking about upgrading from NAV 2.5 to NAV 2013. They want to move their customizations to nav 2013. In order to give them a accurate price for this implementation, I need to go through their database and determine where modifications have been made and the extent of the modification/customization.…
-
NAV 2009 R2 Test Database
Hello, I recently took a full backup of our Live database and created a new training database to load some test objects in. My users are getting various permissions errors, one common one is "You do not have permission to read the Object table", not sure as to why due to the fact the permissions were copied over from the…
-
Dialog 2013r2
Hi there, I'm working with a vertical solution in 2009 r2 and I am Upgrading the solution to 2013 r2 to my new clients, and there is one thing that i dont know how to sort it out. Let me explain: I have a codeunit 50000, with around ten funcions and each of these functions are posting genjnlline--> calling to the codeunit…
-
Error while exporting report data to excel
Hi everyone, I am trying to export some report data to excel. I used the table 370 Excel buffer and specially the function AddColumn When I run the report, I get the following error: This message is for C/AL programmers: Could not invoke the member Range. The OLE control or Automation server returned an unknownerror code.…
-
XMLHTTP POST - string length
Hello, I use 'Microsoft XML, v6.0'.ServerXMLHTTP60' automation and "POST" method to send form data to www server. The problem is that I don't know how to send bigger amount of data (max accepted length of string for "send" method was 2079) (I was sending <=1024 Text chunks as parameter :…
-
How Restrict read Data on SQL Server level?
Hello, here is the task. Suppose, I don't want that users can browse information about few Vendors (in ledger tables, documens etc). Those Vendors have attribute - "Hide Entries" There are solutuions: 1) Create FlowField "Hide Entries" - in every table where I need restrict reading Access, and filter this Field on OpenForm…
-
Printing barcode with bars of 1.5pixels width
Hello. Im trying to make a specific barcode system using a custom-made C# program with Navision. The problem is, that I need the thin bars to have a with of 1.5pixels??? My solution is to make the bars 3.0pixels and scale the barcode 50% on printing. Now the question is... Can I scale the printing from navision?... Or is…
-
Nav sending email problems (TNEF Correlator)
Well, this is the situation: Nav standard SMTP creates the email and then are sent using linux sendmail server. Old email receipients are unable to read it (winmail.dat attachment) seems like NAV smtp codeunit (the automation inside it) adds this string to the emails: X-MS-TNEF-Correlator:…
-
NAV 2009 R2 and Outlook 2013
Hi everyone, Does NAV 2009 R2 support Outlook 2013? I am not able to send mails and I wonder if that is the cause... Thanks in advance :D
-
Using DotNet System.IO.Path in 2009 R2 Classic Client?
I read a blog post recently about using .NET in NAV (which, unfortunately, I can't find now). In it the author explained how easy it was to use .NET by creating a variable of type DotNet. The example he gave was using System.IO.Path to combine a directory and filename to get a full path without worrying about the presence…
-
Nav 5 SP1 in Windows 8 - Grid missing in forms
Hi Friends, My Customer showed me the navision sub form screens where the excel like grid is very thin or almost not seen when they changed OS to Windows 8. The user admin has to reduce the brightness in all the user PC to fix this temporarily. Any idea if NAV has released any patch for this problem Thanks Vineeth
-
Monthwise sales Person target maintain
Hi experts In Salesperson code I have maintained sales person details. Now I want to maintain monthwise salesperson target . Is there any provision to maintain monthwise salesperson target then plz guide me. Or otherwise please give details how I can maintain the target of each sales person monthwise.
-
Error "The G/L entry table does not exist any longer"
When i want to go in "Charts of accounts" i get this error: "The G/L entry table does not exist any longer". But table exists, table 17 and i can see the date in the table. I can use general ledger entries without problems too. I have upgraded from Dynamics NAV 5 (sql) to 5 sp 1. I make a backup and i restore in a new…
-
Check Date Format Error - Still in Rel 7
The message for U.S. customers when writing a check, "You cannot use the <blank> Check Date Format option with a Canadian Style Check. Please check Vendor XX." has been a problem for several releases and is still appearing in NAV2013. The 'fix' is to enter the date format and separator for every vendor, but I'm wondering…
-
Filter Item Tracking Summary Form
Hi guys, i want to filter the Lot No. (exclude the Lot Nos that end with these 3 letters'ZTS') to prevent the users to pick the wrong ones. How can i do this? I need to make the changes only when i'm in a Sales Order and Transfer Orders. Thanks for your help.
-
WshShell.SendKeys('%{F4}') Command
Dear All, My customer is using 2009 Classic, They do not want users with same ID to login twice. I tried the WshShell.SendKeys('%{F4}') in Codeunit 1 'CompanyOpen' trigger, and it works but the problem is I am not able to throw any message before killing the session. Can someone advise how can i display a message before…