-
How to recover username and password of Nav database.
Hi All I have a customer who have an older DB which they have forget the username and password of. The problem is now they have to get access to the DB, what can they do?? I really don't know how to help them, especially not since it's a new client and we don't have any super username to the DB. Does anyone know how we can…
-
Find and read text files
Hi, i would like to look (with a c/side code) if a Textfile exists in a surtain Directory and if yes, get the Name of it and open it for reading. The practical use is to Import tracking numbers generated by a DPD application. Any help will be very apreciated. Kind regards Urs Küng
-
NAV 2013 R2 - Editing Session List page 9506
Hi all, I was trying to follow the steps listed in the link below to add an Action to kill off Active Sessions. https://www.olofsimren.com/kill-session ... amics-nav/ However when I tried to compile the page, NAV Development prompts me "You do not have permission to modify the 'Session List' page. Please contact your…
-
Error sending data to excel
suddenly get this message when I try to export data to excel The parameter string "for the Microsoft Excel" program is not valid. Contact your system administrator. thanks for your help!!
-
Warning: Dimension <dimension> can't be found.
Hi Friends, Can any one tell me why the following warning message is showing? I am trying to adjust the currency exchange rate through Adjust Exchange Rate batch job and am getting the below error. Error: "Dimension PROFIT CENTER can't be found." In Financial Management > General Ledger setup > Dimensions tab, Global…
-
[CC] 2009 Replacing NAS with SQL Jobs and Webservice
Hi, i came across from here , but i can't leave a comment , my mibuso login don't work on the blog ... i have some questions about that, perhaps anybody can help me. i have downloaded the example, and register the downloaded dll on a sql server 2008 , then i create a sql job like in the example : But how must be the…
-
Get first day of year
Hello everyone, I am new here so sorry if my question sounds a little bit stupid :) But cant find anywhere this what I need. So, I want my user to enter year on Request Page like just 2015. Then I must in my code somehow get the first day of that year and the last day of that year. It would be like this - user enter 2015…
-
SQL Function & ADO.NET
Dear all, Is it possible to call sql function to get the return value from it using CAL in Nav 2013 R2 Environment ? Please let me know.
-
Object Table in NAV 2013 R2 Database
Dear Sir, A Client working on NAV 2013 R2 Database and I'm astonished to see that the Object Table (ID-2000000001) is not available in the database. How is it possible ?
-
Sales Document - Test upgrade to 2013 or 15
Dear Friends, Can anybody help how to upgrade Sales Document - Test (202) to new version either 2013 or 2015. This report I am using as invoice in current my company requirements. Little format is done but content is same. VAT sections removed. Please help me. WARM Regards KMK
-
Where do I download a fully Hotfixed 2009R2 Object set from
Good Morning, I am working on an upgrade to 2009 (its an interim step in a 3 phased upgrade ultimately to 2015) - I have been trying to find where to download a version of the GB 2009 R2 database with all of the cumulative application hotfixes Applied and I cannot find it - Question is does such a thing exist? I have…
-
Vendor Payment Restrictions
Does Navision have the functionality to set the vendor up as an "Electronic Payment" (Wires/ACH etc), so the invoice payments do not pull into the regular check payment run.? Automatic control based on Payment method or any setup?
-
How to update G/L Entry and CLE in Sales Order Prepayment?
Hi Friends, I have created a new option field (Name: OptionField with optionstrings Blank,Option1, Option2) in Sales Order (Table: "Sales Header") with an field ID 50000. With the same field ID, field name and options value, I created a new field in Posted Sales Invoice (Table: "Sales Invoice Header"), "G/L Entry", "Cust.…
-
Calculating current quarter start and end
Hi, I have a dropdown on a form that allows the user to select Monthly,Quarterly etc. I need to calculate a period depending on what is selected. e.g. if monthly is selected then I got to calculate the period in the format: DD MM YY - DD MMM YY where the first DD MMM YY is the first day of the current month and the second…
-
Data Migration (Rapid Implementation Methodlogy Toolkit)
Hi All, Can anyone please share the link of videos to understand the basic functionality on Data Migration (Rapid Implementation Methodology Toolkit) for NAV 2009 SP1 or R2 Thanks in advance
-
Error at Creating Account in GCoA (Varchar Datetime)
Hello Alltogether, we are getting this error when we try to add a new Account in the Group Chart of Accounts. May this connect to the Compatibility on the Database or Server, or Maybe on Regional Settings on Application or Database Server? Thanks in Advance for your help. Regards, Thalasos
-
service tax entry passing
hi experts I want to pass service tax ecess and shecess amount into the service tax bed amount from excise cenvat claim screen. How i will do this .plz guide me.
-
Deny permission to link Table directly in MenuDuite
I have a user with almost super-user rights. He is denied of Object designer but allowed to design MenuSuite and assign users to it. Our problem is, IF this user wanted to access any data directly at the table level, he just create a link or menu item in menu suite for the table and open it. So, no point in hiding Object…
-
NAV 2013 Web Client Document Attachment
Hi, Any one experienced in handing document attachments in NAV 2013 web client pages? We have developed leave application in NAV 2013 windows client. And provided the NAV 2013 web client URL in SharePoint website as a link to access it in intranet. Since users are not able to attach any documents through 'Links'…
-
Upgrading from 2009 R2 --> 2015
Hi, I am about to upgrade a NAV 2009 database to NAV 2015 and this is my first time. First I assume that I have to get rid of all the customization which has been implemented in the NAV 2009 database in order to make the upgrade. How do I do this proberly? At first I tried to write SQL scripts which deleted all the custom…
-
Statement Posting Error in NAV2013
While we are trying to Post a Statement for a Store we are getting the below error message: You cannot post these lines because you have not entered a quantity on one or more of the lines. I checked the table "Trans. Sales Entry" & it has Quantity in all the lines. The error is coming from the codeunit 21 (Item Jnl.-Check…
-
NAV 2009 - SQL Error During Check Database Integrity
Hi all, stuck with one SQL Related Issue in NAV 2009 SP1. ](*,) Below is the error message appear as a result of Test Database - Microsoft Dynamics NAV ClassicThe following SQL Server error or errors occurred: 8909,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 0, index ID -1, partition ID 0,…
-
Report 120 - Aged Accounts Receivable in NAVISION 4.0 SP.3
Hi, I have a problem with a report 120. When run a report for multiple recipients, to one (it seems that random), the report assigns transakcji.wszystkich outstanding customer records, not just this one). And for other clients result is correct. When run a report for only one client, the report shows all records unsettled…
-
Update from NAV2009 to NAV2015 - what is not possible?
Hello around, we're planing the next big step with Navision - update from NAV2009 to NAV2015! Because we're working only with the Classic Client until now that's a big change for us. We could already found a lot of informations in the MSDN blog about what can't be used any more in NAV2015. But we're a bit confused because…
-
Delete Windows Login from Native Server Database
Dear all, How to delete the garbage record from the Windows Login Table ( ID 2000000054) ? The record contains blank value in ID Column(PK) and Text value in SID Column. System ( DB Server ) gets hang when trying to delete this record and giving following error message. .... TCP/IP error ECONNREFUSED ... We are using Nav…
-
Manage Muliple Office Versions on one Dev. Machine
Hi, I'm working for a Solution center that supports multiple Companies with different Versions of NAV and different Version of MS Office on their Terminals. We already have a custom-made solution to manage all the different Builts of NAV on each Developers machine, which is also tricky, but solved - so don't worry about…
-
Object Translation in NAV 2009 R2 or SP1
Hi All, Can anybody provide me any relevant link or study stuff on how to do Object Translation in NAV 2009 Thanks in advance!
-
Very strange RENAME behaviour
Hi Everyone, I think that i have found something very wierd in NAV 3.70. Here is what I do: I have a custom table where i have to rename some records. But when I call RENAME command with the new values Navision starts to Search some other tables(every time DIFFERENT table) and I get error message: Sales Header Table is not…
-
Navision 4.0 SP3 Build 26565 Client
Does anybody by any chance have the download for this build or a link to the download? I have been searching for this for awhile. I have access to PartnerSource and Customer Source but cannot find this build. Thanks
-
Formatting numbers in NAV
Hello, I am working on a report which gets exported to Excel. I am struggling the the formatting the numbers to the required format. The required format is 2 decimal places after a number and use of , for the numbers above 1000. I am using this in my code. FORMAT(Amount,0,'<Precision,2:2><Standard Format,3>') When the…