-
Most used type in column
Hello, friends. I have entries in the table, and I need to find the most popular ones. For example, in the table in the "Location code" column, I have two types of values: "RED" and "GREEN", I need to show the message: "The red value is used more often" when the table is started. Because records with RED 15 times, and only…
-
How to Append an Existing Text file
Dear Friends, Please advise how to append(add) values to an existing text file in Navision. thanks and regards vineeth.r
-
HOW to determine localization applied to a system
Hello, I ask you the best method to understand if an installation has some localization (country specific) applied. Is there a different method for different version of the system? Thank you
-
Which automations to use, how to find the appropriate one.
Hello everyone, can you write me how I can find out which automation I should to use? For instance I woluld like to check free disk space but I do not know how to find the suitable automation. I'm searching the internet to find an automation list with description but no seccess. Thank you for your hints.
-
Label printing: printer stops after every label
After previous discussions with several forum members I got very far with building tables, codeunit, forms, reports to build a label-tool directly from Dynamics NAV. From our tabular form of our Sales line, I push a button and the data from the selected line of the form is passed to a report. However, until there…
-
Manufacturing - I am posting an output journal for hours worked on machine centers.
I am posting an output journal for hours worked on machine centers. I am getting the following error -'The following combination Item Ledger Entry Type = ' ', Entry Type = Direct Cost and Expected Cost = NO is not allowed. Please assist. I am on NAV 2009 Classic
-
How can i inhibit price = 0 in sales orders (Nav 2015)
Hi, How can i inhibit price = 0 in sales orders (Nav 2015) thanks
-
External Secure Web Service Access
Hi, I am trying to use Centric software web service to get data into nav web services are secured, user need to login first and should have the session to access various data I am able to connect but I cannot read various data like customers etc. Can you please help me, how can I keep connection active between multiple…
-
Protected Tables in Nav
Hi, Can anybody plz tell me which are the Protected Tables in Navision.
-
OnScreen numeric pad on Classic Client
Hi, I need to set quantities (one active field => global variable) on touch-screen device. I've try it with Windows Scripting Host & SendKeys, but it doesn't work for me (only when pressed once). Do you have some idea how to solve it? thank you
-
read bridge in c#
hello my friends i really need to help me to reshape this problem i in the migration navioship 2009 R2 stage to the latest version 2017 so i have an application that connect to my bridges tilts so there is a file that retrieves the information received from the bridge the aplication and devlopper for windows xp, I need a…
-
Passing variables to request form of report
Hi all! Our company is still working with the Classic Client and 4.0 database. I've a question about passing data into variables on a request form.* I have a tabular form which has the table Sales Line as source * On this form I have a button which sets the filters to the record which is selected on the form and based on…
-
The most popular item in the table
Hi. I am having a table of identifiers and elements on how to calculate the number of entries with the same identifier to find out which one is most popular. I understand that I need to use filters SALESLIST.SETFILTER ("No", '<>% 1', "No"); SALESLIST.SETRANGE (ID, ID); but I can not find a solution to calculate the most…
-
Internal Error XXX in Module XXX - overview
Hi, I seem to recall that I have seen a complete list of the "internal error xxx in module xxx" messages. This is regarding NAV 2009. Can anyone point me in the right direction?
-
Unable to import Date from XML port to table.
Hi, I'm trying to fetch invoices through XMLPort and saving them in tables. All is going well except for the date where it says that '11-10-2016T 00:00:00' can not be saved in Date type field. In order to manipulate the date and make it compatible with 'Date' data type, I changed its datasource from 'field' to 'text' and…
-
GetValue() SetValue() Cell in Excel
I have some code that first write zeros in some values(with EnterCell() ) and now I need to modify this values, but I cant do it with EnterCell() is there some GetValue() / SetValue() function ?
-
Slow search
Working with NAV 2009. I have a query on Item ledger entry which is slow. It seems, that the first 2 iterations take a lot of time (about 1 minute), but after that it is fast (within the second). The code I use: ILE.RESET; ILE.SETRANGE(ILE."Item No.", "Item No."); ILE.SETRANGE(ILE.Open, TRUE); ILE.SETCURRENTKEY("Item…
-
Microsoft Nav 2009 R2 and 2.0 Avaya Tapi service provider
I'm looking for information between Microsoft Nav 2009 R2 and 2.0 Avaya Tapi service provider. The goal is to launch calls from Nav.
-
Function - Record won't initialize
Hello, I have been programming in C/AL for some time but I have a doubt in this particular case. I'm trying to get a cost of a particular product line from an order, in which the dividend is the result of another function, and the divisor will be a new variable as the code shows below: GetPVmin(VAR SalesLine : Record…
-
Bank Conciliation Report
Hi , i want to design bank reconciliation Report with Un-reconcile separately both payment and receipt .
-
Slow Performance & Windows opening in RDP-RemoteAPP - but not on "fat Client" ...
Hi all, i am experiencing some strange behaviour on my remote-App-Farm providing NAV (finsql.exe) Users are using NAV as a remoteapp provided by 3 loadbalanced 2012R2 Servers using a 2 Server HA-RDP-Gateway/Session broker. All Servers have huge CPU and RAM, looking at their usage shows that they really are "bored" the…
-
Can we insert two lists in stylesheet
Hi Guys, I tried to insert two lists in style sheet document. I have taken base record as Customer and created two Multi lines tables as "Customer Ledger entry" and "Detailed customer ledger entry". When i exported to word it is showing only "Customer ledger entry" list. But it is not showing detailed ledger entry list. it…
-
Customer statement in NAV 2016 CU04.
In connection with NAV 2016 I want to e-mail customer statement - I can choose to view account statements, PDF, e-mail, Excel and XML in the "Output Options". I choose e-mail but nothing happens, what am I doing wrong for nothing happens. I want to send customer statement to one customer per. e-mail.
-
SOLVED SQL Codepage 1250 (slowakisch) with SQL Server Option (NAV 2009 Classic Client )
Hi, my customer wants to implement Dynamics NAV 2009 Classic (Object 2.01) with SQL Server 2008 R2 I selected Codepage SQL_Slowak_CP1250_CI_AS and I also tried SQL_Latin1_General_CP1250_CIAS. I changed also my Codepage of the windows client es well as my keyboard. I also used the Virtual Keyboard from Windows 10. It's not…
-
Moving Nav Server To A Different Domain
Our Navision server was initially setup about 3 years ago on a Windows 2000 Active Directory domain called "abc.com". Two years ago we installed a new SBS 2003 Server and migrated all workstations over to a new Active Directory domain called "abc.local". The Navision server remains a member of the old domain, which…
-
Migrating existing configuration to new server
Hi all, I'm responsible for migrating an old 5.0 database from an old Windows 2003 server to a more current Windows 2012R2 server. I will not be upgrading the database, just moving everything that is existing from one server to the other. Is there a checklist around somewhere that I can use to guide this migration? cheers,
-
Getting an error like while restoring NAV 2009 fbk Backup
Hi All , This is my first question . I am getting below error while restoring Nav 2009 backup (.fbk) . " Microsoft Dynamics NAV ClassicThe Table Specific Infocode table contains a value in a Code field that cannot be used with Microsoft Dynamics NAV Classic:Field: Primary Key Value: 99001462€LL01ð19€FRGFTREDEE " . Database…
-
Retail item Card Field Restriction
Dear Experts. We are using NAV 5 SP1 with LS Retail. There is a new field created Arabic Desc (50020) in table 27 (Item Table) . We have 2 users A and B and both doing the item creations on the form 10000807 (Retail Item Card). User A has access to all fields and can modify, delete, create in Item card. Whereas, user B has…
-
Nav 2009 R2 With SQL Server 2008(SP4)
Hello Friends, We are using Nav 2009 R2 with (LS Retail). Total db size is about 350 GB with log file, we are continuously observing that performance of Nav is getting slow, mainly it takes time in posting. Can someone help me with suggestion to improve the performance?
-
Why Navision init line with number 10000¿?
A lot of table init number line with 10000 and add from 10000 each time 10000 20000 30000 Why? Init line 1,2,3,4... Metaphisic question...