-
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…
-
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,…
-
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);…
-
Kill Session for Duplicate Login
Hi Friends, My customer do not want any user to login twice to navision with his/her ID. I decided the write the code in Codeunit 1 - CompanyOpen function. If i test the below code by logging in as 'SA' UserID then the code works and the duplicate session is killed. But the code fails if i login twice with any other user…
-
Error when add users through "Windows Logins"
Hi All Our company has been implemented NAV2009R2 for 1.5 years. Last week when I tried to add user through "Windows Logins", the following error message pop-up:- ================================================= The following SQL Server error or errors occurred: 15138,"42000",[Microsoft][ODBC SQL Server Driver][SQL…
-
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…
-
DataItems and Level of Indentation in Reports
Hi ALL, Can anybody tell me how many maximum no. of Data Items I can add in a NAV 2009 and NAV 2013 Reports? And According to my knowledge we have a maximum 10 Level Indentation (Limit) in NAV 2009 Reports, But in NAV 2013. What's the maximum limit for that? Thanks in advance.
-
Tagging Sales person code
hi experts I want to tag more than one sales person code in customer card. is it possible ? If yes please suggest me how can i do this?
-
Unit of Measure on Production Order
Hi Guys, I have a customer, who would like to produce packs of 6 pieces. They keep their inventory in pieces, so Base Unit of Measure is PCS. But because the items end up in 6-packs instead of producing say 24 pieces, they would rather produce 4 of those 6-packs - its easier to understand for the production staff. So, the…
-
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…
-
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…
-
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,…
-
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 :…
-
CU406 not copying all Items
I am trying to copying Item master from one company to another new in the same database using "Setup Checklist" feature. The old company has some 15,000 items and only around 10,000 are copying. I tried several times and still the same. What could be the reason? Have anyone experienced this?
-
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.…
-
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…
-
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.
-
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…
-
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…
-
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.
-
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…
-
Get filed Address form table Vendor
Dear EveryBody I'm sorry, my english is not very good. When I create one report Purchase Order, problem in here I can't insert field Address form table Purchase Header. I know it relation table Vendor. Everybody can help code to obtain field Vendor.Address insert in report. Thanks so much.
-
Budget Export to Excel by Accounting Period
HI, We need to export a NAV Budget to Excel by Accounting Period. The company is on a 4-4-5 schedule with the last Sunday of the month as the last day of the Accounting Period. Anyone know how we can export the budget with this date/period format? 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…
-
Navision 4.0 > Remaining Qty in Item ledger Entry Negative
Dear, I need help with to fix Total Remaining Qty of Item Ledger Entry, first i want to explain why this situation occurred. Before our database server got crashed and Table Item Ledger Entry got un-repaireable data. and then some one had inserted the Item Ledger Entry data with Value Entry completely (all including…
-
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.…
-
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…
-
GUID Missing
Hi Guys, I am working on 2009 SP1 SQL and am trying to compile the Sales Order form, before making any changes, and I am getting this error: Microsoft Dynamics NAV ClassicThe OLE control (GUID: {2ACF9AE6-2879-11D5-BFCB-93D3064BD23A}) could not be compiled because it was not registered properly. Try to register the OLE…