-
Retrieve data from Navision 3.70 C-Side with .NET
We want to retrieve data from a Navision 3.70 C/Side database using .NET. We managed to create a DSN and retrieve data from the Navision database by using Excel or MSQuery. When i try to read data from my .NET application using the same DSN i get an error: ERROR[IM001][Microsoft][ODBC Driver Manager]Driver does not support…
-
[HELP] newbie in navision
help... i got problem on tracking specification.. first.. what is tracking specification? second... i got warning in tracking specification Entry No. '6015'.. what should i do... thanks for the reply.. please help i'm new in navision... [-o<
-
Job Scheduling in Navision
Hello I am begginer in microsoft navision, i just started working and i have first mission to do a automatic report, i can see c/al code of this report but i do not know how to use it in job scheduler, can someone explain how to make schedule job step by step, in wich place must pase c/al code?
-
Check for Duplicated Item No
Dear Expert, I have created a dataport that allow import of data from csv into a temporary table, it's working fine, but I would the system to check after import for duplication of ordered item No. As the duplication of item could create problem in the later stage. I would like to solve it at the temporary table first.…
-
TDS Revarsal
Dear All I got posted purchase invoice with TDS calculation. Now client wants to reverse this posted invoice, when i am using credit memo for the same requirement, at the time of posting system is showing me G/L Inconsistencies. Anybody has some idea about this please revert. Thanks In Advance
-
Interface online/direct with external system PLM
Hello everyone, we are evaluating the possibility to interface Navision with external packages. We have already done some developments already in production phase for some customer using text file and reading of them via NAV Report scheduled by NAS. We are studying if it is possible to interface it with a PLM system but we…
-
Inventory Valuation report
Hi, Inventory Valuation report does not match Inventory to GL Reconciliation Report. This happens on 3.6 with Std cost, after ran the periodic activities. I thought that the Unit Cost on Inventory Valuation report = Cost Amount (Actual) (on Item Ledger Entry) / Remaining Qty And INVENTORY VALUATION column on Inventory to…
-
Create New tables - getting error
Hi, We have bought new navision tables from Microsoft and then imported the new licence file and tried creating new tables and getting the below error. Can you please advise on this error. Thanks. Microsoft Navision AttainThe following SQL Server error(s) occurred: 4628,"01000",[Microsoft][ODBC SQL Server Driver][SQL…
-
SQL Server Runtime Edition License and Full Sql License
Hello, Could anyone please help me on the below required information. What is Sql Server Runtime Edition license. If I don't have a SQL License of any type, would i be able to run Microsoft SQL Server option for Navision. If no, then what would i need to do to make the SQL Server option run. As per the application…
-
How to configurate multiples printers with findtrays
Hi all & thanks in advance for yours topics. I have a problem with the configuration of the findtrays.exe and the "Paper tray" table (into nav). Three printers has been configurated in the same nav server. Two of them the same printer model (same printer provider). (Manual tray and three more trays. To use all) One of them…
-
Report ID and name on Report's footer
Is it possible to show report's name and ID on report's footer section and how to achieve this? I'd like to show report's name in small font on end of the document (report-section).
-
How to write to other company with CHANGECOMPANY function
Can anyone tell me how I can write to a table of another company within the same database using CHANGECOMPANY function? I enter code like below but the record is create in the SAME company instead of another company... ](*,) >>>>>>>>>>>> CHANGECOMPANY(fmrline1."Transfer to Company"); genline1.SETRANGE(genline1."Journal…
-
Upgrading 3.10A to 5sp1/6.00
I'm in the process of upgrading a customers DB from 3.1A to 5sp1/6.00 and i have a few questions. I'm aware that i have to go through 4sp3. Now isn't it possible to do the upgrade in the following manner without loss Only add any customized fields to standard nav-tables. Ignore code attached to these fields, that is i…
-
C/AL code editor
Hi! Who know a more efficient c/al code editor?
-
Finding highlighted rows?
Hello, I would like to do something simple like loop through the rows on the current form/tablebox and find the current selected/highlighted rows. I've searched the help and a property something like IsSelected doesn't pop out, nor a function to test if row is highlighted. Appreciate any tips/suggestings to this seemingly…
-
Swedish localisations - NAV3.10/NAV3.60
Hi I am currently reviewing the the differences between the UK3.60 objects and the Swedish 3.60 objects. I have noted the Swedish database contains a set of objects in the 11200 range with names such as Automatic Acc. Header and Periodic Template. Can anyone cast any light on the use of these objects and whether they have…
-
Number series with Month
I used the below way and it worked. viewtopic.php?f=14&t=1745&start=0 But i have one problem................... When I go to next line and change the date with different month, the document number does not change as required,, Like line no Posting date document no 1000 10/04/2010 04-00001 2000 10/05/2010 04-00002 its…
-
How to create Total in the beginning of a report
Hello experts, I'm trying to show the totals of the field "Amount" (Payment Header) of some records in the beginnig of the report. I've tried to use CalcSum but i can't, the field "Amount" is already a Flowfield and i can't create a sumIndexField in the flowfield. How can I do that? Thanks!!
-
How to import a CSV file from a shared folder in Server?
Hi Folks, I need your help for the following requirements. My requirements are: 1. I need to import a CSV file from a shared folder in a Server on a daily basis. The shared folder in the server contains the CSV file in the following format, <filename>-mmddyyyy. I need to check the latest file based on SYSTEM DATE or from…
-
NAS MSSQL related error - Login failed for user ''
Hi when trying to start NAS with SQL database, windows login authentification I get: Event Type: WarningEvent Source: tradepointEvent Category: NoneEvent ID: 20010Date: 5/14/2010Time: 9:11:28 AMUser: N/AComputer: W2K3ATHINADescription:The description for Event ID ( 20010 ) in Source ( tradepoint ) cannot be found. The…
-
Error handling
Hi , can anybody help me.i have created a form which have validations on.when ever an error comes up because of wrong input, the whole forms closes and all the other inputs i did on the form are deleted on open form.can i have a way such that when an error is popped to the screen and the error dialog is closed, the control…
-
C/ODBC - Access 2007 Field Limit
One of our customers is creating a link table in Access 2007 and there are more than 255 fields in their Item table (table they are creating the link). At first they did not know the problem, it would only show upto 255 fields, they just noticed that some of the fields they wanted to use were not there. Does anyone have a…
-
how does MS Visio and MS Dynamics NAV integration work?
Hi All, Can someone help me with MS Visio and MS dynamics NAV? There is an example given in Mibuso how different steps in a flow chart can be linked to the actual process in the system. Please guide me as to how to relate these to products of Microsoft. Regards, Satyajit
-
Sales Price - Change Log
Hi All I am using Navision 3.6 When sales department creates a new invoice, sales prices comes up automatically from the customers sales price groups. If the Price has to be changed, Few users have the rights to make change sales invoice Price, how do I record who is the person changed among the authorized users. Thanks…
-
C/ODBC access for SUPER failes with "no access"
I'm trying to gain access to a native Navision 3.60 DB using the C/ODBC Connector, license is installed on the NAVISION server, C/ODBC driver has been installed on a client, but every time I try to configure the ODBC datasource I'm getting a "no access" error when clicking the "company" button on the configuration dialog.…
-
Navision financials 3.01 A
We need instal Navision financials 3.01, Could any body providing us the client of this version including the setup? Thanks in advance. MC,
-
Dataport Export On Desktop
Hi there, On the dataport properties i have set the filename to C:\Documents and Settings\%username%\Desktop\test.csv but it cannot find the directory. I want the file to be created on the desktop of the user that is running the dataport. I've tried with several ways but couldnt find anything. Anybody has an idea? Thanks a…
-
From RecRef to Rec
I know how to get from Rec to RecRef. Using RecRec.SETABLE(Rec). My problem would be, how to get from RecRef back to Rec? The reason is that I did some processing in RecRef, and now I want the processed results back in Rec, so that I can pass it to a function. I know I can of course change the function to take in RecRef…
-
Blank record insert in table
hi, i have made a form(Tabular) based on purchase header, while putting only posting date in form record has inserted in table with blank primary key value. what's happening....
-
Unable to see dll in Automation List
I have been creating a .net dll which I have got working on my own machine fine and can see from the automation list in Nav. However, when i register this on another other PC/Server, etc, it cannot be seen in the Automation server list. It has a strong name, and delploys fine to the target machines (tried via setup…