-
Printing duplex in NAV 2009 RTC Layout.
Hi, I have a problem with printing duplex in nav 2009 rtc layout. Today customer prints Sales-Shipment document from classic client. He have there an option "Print without duplex" - there is a MOD 2 / NEWPAGE solution. How to add this option to 2009 RTC Layout? I need to have same or similar solution that will print the…
-
Stop when hyperlink is called
Hi all Hope someone knows the answer as I cannot figure it out myself: From a codeunit I call HYPERLINK with URL.......... A web-page is called - and I want the NAV-code to pause until web-page is closed. NAV 2009 SP1 Classic. Any ideas?
-
Base NAV5.0 database - cannot attach to SQL Server
Hi guys, I'd like to attach existing NAV 5.0 demo database to my instance of SQL Server 2012, but it's impossible. I received an error which says that this version is incompatible with my mssql. So I'm looking for clean NAV5.0 database, or another possibility - clean NAV5.0 objects fob. Do you have any resources with this?…
-
WebService "OperationTimeout" doesn't really time out. Why?
Hello, I have an issue with NAV web service timeout setting. We set the Web Services "OperationTimeout" property to 00:00:59 from original value "MaxValue" so web services calls would timeout in 59 seconds. I put a SLEEP(100 * 65) command at the end of the NAV function to make it wait enough. The web service-call indeed…
-
Can't get the field value in Capacity Ledger Entry Table
Dear all, Nav version :5.0 we create a report for showing some fields of Capacity Ledger Entry Table, the command as below: CapLedgEntry.RESET; CapLedgEntry.SETCURRENTKEY("Prod. Order No."); CapLedgEntry.SETRANGE("Prod. Order No.","Production Order"."No."); CapLedgEntry.SETFILTER("Quantity",'<>%1',0); IF…
-
Basics about importing data from Excel to NAV 2009
Hi All, I suddenly was asked last week by my manager to use the microsoft dynamics navision 2009, as a new tool, to create quotation and process the incoming orders. I was given a very basic and armatures training in 30 minutes to create a New Customer / New Contact and finally New Sales Quote. I construct the offering…
-
database restore to SQL - field is not defined in table
Hi, I have problem with database restore from native to SQL server. database and client are 5.0 SP1, client is newest build. SQL is 2012. During restore process, I am running into problem: error message Field No ### is not defined in the ### table. I tried to recompile all objects, deleted objects with compilation error,…
-
Cost Posting to GL Issue
Hi, Need help in finding the root cause of issue Version : NAV 2009 R2 Problem Statement : When User Posted Negative Inventory Adjustment in September last year the Cost of Adjustment was not completely posted to GL. Rather remaining Cost was posted in subsequent months until April 2015 By Adjust Cost- Item Entries Report.…
-
Difference between Database Used and sum of table size
Hi, In NAV 2009 R2, we see a difference between : - File -> Database -> Information -> Database Used (KB) - Sum of Size (KB) in Table information Sometimes the difference is small, sometimes there is a big difference. For example we have a database where Database Used in Database information is 2.506.400 KB, and the sum of…
-
clearing the Mail Variables for CodeUnit 397
I am new to this forum and to Microsoft NAV development. I am hoping someone can shed some light on this for me. I have a query that I am reading to get data for an email. Right before I loop to the next record I send the email. The issue I'm having is that the Email Body is not clearing out when it goes through the loop…
-
USEREQUESTFORM - NAV 2009 Classic running on Citrix
We had the weirdest issue after a driver update on our printers. It seems that something different happens depending on whether or not USEREQUESTFORM is TRUE or FALSE. This bit of code went well, and the report printed as it was supposed to: CLEAR(MyReport); MyReport.USEREQUESTFORM := TRUE; MyReport.RUN; But with this bit…
-
Cannot Start Windows Service for Navision
I have created a new Nas Service using "nas.exe" but when i am going to start, its giving an error Could not start the Application Server for Microsoft Dynamics NAV Classic (Service Instance Name) service on Local Computer. Error 1: Incorrect function. I have given the system paswd on Logon Tab of NAS Service form. And…
-
Microsoft Dynamics NAV Synchronization
Microsoft Dynamics NAV Synchronization Add-in Error OccurredThe connection to Microsoft Dynamics NAV failed. The program returned the following error: Microsoft Dynamics NAV asynchronous call completed with error: Method "ExportSchema" is invalid!; . Synchronization for is not set up in Microsoft Dynamics NAV. Verify your…
-
Navision to Word, Table and Variable Problem
Hi. I am pretty new to NAV and i am struggling with with some problems in NAV. First i want to update the content of an existing DOCVARIABLE in Word. I know how to add a new oneVariable := Variables.Add(VariablenName);Variable.Value := 'XXXX';Name DataType Subtype LengthVariable Automation Unknown Automation…
-
Prepayment Invoice deduction realized gains/loss wrong
2009 SP1. Make a purchase invoice in a foreign currency i.e. import. 100% prepayment. Make prepayment invoice, pay it. Then receive the goods and post the final invoice on a different rate and different exchang rate in the Get Receipt Lines way. Sometimes - it is not fully reproducible, but sometimes - you get entirely…
-
Searching Windows Login
Hi, I have a few users who are experiencing problems when opening a few custom forms "searching windows login". We recently transferred the login details from one active directory domain to another. Most users work correctly, but a few have the problems. We have synchronized all users, ensured that all setup is similar.…
-
Issue in Invoice creation with Service Contract
Hi All, I am facing an issue in Service Contract (NAV 2009 SP1). There is already a service contract (SC0001) with one line item was created and locked. The workdate is, say 15-06-15. For some Invoice Periods few invoices were created and posted. Then, the same Service Contract (SC0001) is opened and and added a new line…
-
Company Information Picture Issue
Hi, When i import bmp picture(40Kb) in company information, it shows like this please help me out on this.
-
Grouping in NAV 2009 RTC
Hello: I am new to MS Dynamics NAV and learning from beginning. I am trying to print the bills which has to generate 3 copies for different purpose and this is an upgrade from 2009 classic to RTC and I am stuck at grouping part. I tried to study all the forums and links. The values to be printed are defined as the global…
-
Permissions - Question
Hi guys, I have a job on a Job queue that should populate a table. For some reason when the job runs automatically at night it doesn't populate the table. If I run the job manually, it will. The user that is associated with the Application Server service has a Role associated. Check the Role Permissions and for this table…
-
NAV 2009 R2 Classic Client crashes when sending email
Dear ALL, I am using Microsoft Dynamics NAV 2009 R2 build 6.00.32012. In one customized form, I try to detect all changes done in the customer record and send a notifcation email containing old and new values. The concerned function is called in The OnModify trigger. I use codeunit 400 to prepare and send the email.…
-
Wrong Posted Purchase Invoice Amount
What is the best way to fix the cost for this scenario: 1. User wrongly posted a purchase invoice for an item at $14,000 when the correct cost was $14.00. Inventory period was from a previous period and has been closed. 2. The item sold already and is no longer on inventory. 3. The Accounts Payable user did not catch the…
-
Click-to-Call Button on Phone Numbers
Hi folks, So anywhere in NAV next to phone number fields, there is a little phone button which brings up a Skype dialer, but it doesn't populate the phone number. Is there a way to get that to auto-populate? Thanks! Bryan
-
Report development on C/al Code
Hi, Refer to the attach pic and I want to have the sum of column 'Quantity' where Type = Resource and for Order No where Customer Group Code = GARANTIE Please note that where type = Resource, Customer Group Code is blank. Any idea how to do the above in C/AL CODE? Thanks for your response
-
Connect to Web Serice from Excel VBA - Parameter is null err
Hi I am trying to connect to a Web Service from VBA in Excel. It is working fine; I have connected to the Web Service and I have started the code execution in the Codeunit I connect to. Now I wish to add a parameter to the Web Service and it keeps giving me an error that the parameter "pdepartment" is Null!. I have…
-
Defualt value for a report filter?
Is it possible to set a defualt value for a report filter? At the moment I filter using a date range calculated using code (first day of month-last day of month), but I want make possible for end user to change this range.
-
NAV2009SP1 Classic on Windows 10
Hi all, As Microsoft automatically offer Win10 as update, more and more customers ask whether they dare to upgrade. Have installed Win10 preview in a virtual machine to check out, and apart from having to install Microsoft .NET 3.51SP1 it seems to work fine. Have had some troubles with ZUP-files not "remembering" the users…
-
Attachment not being attached from NAV
Hello we are using NAV 2009 classic We have customized NAV report which populates data onto Excel and then Excel gets attached to Outlook (composing new email) but the email doesnt get it send as user would like to review first before manually sending. Anyways, for one user the excel doesnt get attachment on outlook. thats…
-
Proble with Outlook addin
Hello, I'am on Nav 2009 R2. I have a problem with the Outlook plugin. For all tables already set it works well (contact, salesperson...).. I wanted to set the employee table (id 5200) like this one: The synchronization to outlook show blanks lines. Number of records are good but fields are empty. However, if I sync to Nav,…
-
Tax On Cigarettes (Indian Localization only)
Dear All, Indian Government has changed the Tax policy on Cigarettes products. The new Tax calculation policy is based on the SOLD quantity and the size of the Item. But in default scenario in MS Dynamics NAV (IN Version) the Tax policy is based on the goods instead of sold quantity. [ Here I would like to mentioned that…