-
How to set relation of multiple table in common report
How to set relation of multiple table in common report ?
-
Error 1190
How can I correct error: 1190 in modul 19 = #Err_DB_AlphaTypeIncorrect DB_Err(1190)
-
Table Not found
Hi, i want to get data out of a table ("Customer Different Addresses") so i set IT=a-z,0-9,A-Z,_ with fields i could just do field_name instead of "Field Name" but i cannot get to this table either with "Customer Different Addresses" or Customer_Different_Addresses Does anyone know how i could get to that table? Renaming…
-
dataport and thousands separator
Hello to all, I`ve got a problem. I`ve created a simple dataport which exports a few columns from a table Item. One of these columns is quantity of items on stock. Sometimes quantity value gets over 999 pieces and here comes my problem. Dataport separates thousands with ˙ symbol and so for exaple MS Excel consider this…
-
I need help for designing a business process.
Hi Folks, I`ve created a form in Navision, that shows the whole order procedure as a business process. Thus, you do not need to click on several functions in the main menu any more. The form shows all necessary activities from getting the order to delivery. All activities can be executed through buttons. I now NEED HELP…
-
Delete files in a directory
In a dataport, I want first to verify if there are files in a directory and after delete them. REPERTOIRE.SETFILTER(REPERTOIRE.path,'\\Srvpv2\commun\6_SAM\Fichiers tests\2004_10_22\'); REPERTOIRE.SETFILTER(REPERTOIRE.name,'*.txt'); IF REPERTOIRE.FIND('-') THEN REPEAT erase(REPERTOIRE.path+REPERTOIRE.name); UNTIL…
-
Auto explode Bill of Materials when quote converted to order
Hi all, We have a situation where we wish to keep BOM's unexploded on quotes but wish to have them exploded on order screens. Currently the Order Processor has to manually explode any BOMs that are on orders that have been created from quotes. Could someone point me to the code unit that would require a mod to change this…
-
ISAM Error
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Navision a/s][Navision Attain ODBC Driver]ISAM error /weblink/dataio.asp, line 5 at line 5: if conn.State = adStateClosed then conn.open(session("dsn")) session("dsn"): Set conn = Server.CreateObject("ADODB.Connection") dsn = "DRIVER={C/ODBC 32 bit};" dsn…
-
Log Navision User connexions
It is possibel to log the daily connexions of the Navision User :?: Thanks
-
Sql Nas
Hello, I have a problem with running a NAS. I have installed the NAS properly (for SQL), but when i start this service after it has been installed, i got the following warning in my event viewer. The current ANSI or OEM code page on your computer does not match the 850 code page of the SQL_AltDiction_CP850_CI_AS collation…
-
Reports Similar to Matrix Forms
Hi. I have to develop a report that looks similar to "Analyses by Dimensions", meaning I'll have a variable no of columns and rows. Is there anyway to accomplish this, as I know C/AL doesn't allow dynamic casting of arrays , and I have to use a variable length array to display columns. If such a report is impossible in…
-
Help on Invoices
We're using Navision 3.6 and at this point most of our reports (i.e. Invoices) are standard out of the box configuration. Needless to say, most of the users are dissappointed with the way the invoices look, and I would like to start working on them to "spiff" them up a bit. Are there any resources where I can see examples…
-
Attain and SQL
I post this question because i want to know if someone have the right answer on SQL Server and NAVISION 3.70. My question is quite simple but the answer seems to be very difficult : Do i need CAL SQL licences for the users who are using finsql.exe client. Some people from Microsoft say YES, Others from MBS say NO (include…
-
3.10A: graphical problems after XP SP2
Hi! After installing SP2 for Win XP we encountered, that there were new 'strange-looking' icons and nearly all textfields were displaced. We found out, that if we change the Theme of XP everything works fine in Navision Attain as follows:classical theme: old icons, correct placed textfields, everything like beforewhen we…
-
How to conver integer to time value
I want to convert a integer value to time value.... any suggestions please?
-
Job Scheduler
Hi folks, I need to run a codeunit at the same time every night and intend to use the job scheduler. Are there any issues with running the Job Scheduler in the following configurations? Will there be performance degradation? 1. A PC set aside to run the job scheduler. 2. An instance of Navision running on the Navision…
-
Problem with Average cost and Unit cost
We have upgraded from version 2.50 to 3.60 and since then we have problems with Average cost and Unit cost. I know the Averge cost dosn't work like in version 2.50 but Unit cost shoud work. After all Periodic Activities ("Adjust Cost - &Item Entries", "P&ost Inventory Cost to G/L"), the Unit cost is still not wright. Has…
-
Extremly slowly for insert
I have a big problem. When I insert a record in a table, I lock it for a much seconds.
-
Language = neutral
Hi, I want to make a connection to a Navision native DB. I use ASP and make my connection in code i saw when creating the DSN in the system, you could specify a language, and language neutral is which i want to use. In code you have something sortlike, it is called ML=.... 1033 for ENU but what is it for neutral? Does…
-
commerce portal
I'm a developer at a private company and haven't had formal training with commerce portal, but we have an existing one set up that works. I have been trying to set up a testing box for development and I can't seem to get the data to synchronize to sql. What application actually reads the synch information from the…
-
Electronic banking in the UK
HI, I will have to setup electronic banking for a company in the UK. Does any body know where I can get some documentation about this (if there is any) ? When viewing the product cd for the uk (ATTAIN 3.70A) I did not see any objects for electronic banking, so it's probably a add-on. Does anyone know where to download it ?…
-
Running reports and parameters
Hi all and thanks in advance for your help... I have a problem passing parameters and datas between a form and a report... I have inserted this code: ... REPORT.RUN([report no.],TRUE,FALSE,Rec); ... in the Purchase Invoice form, in the OnPush event of a Command Button trigger. Then i've created a report that has the…
-
Problem ExpandIT Backup
For the backup of our database of Navision (v3.60) we use ExpandIT (v2.1e) The backup path in ExpandIT isE:\MBS_Navision\Nav360\%WEEKDAYNAME%.fbk The backup result is 2 fbk files(first 2Go, second 1.5Go) Do you know why the second fbk file want to go in the E:\MBS_Navision\Nav361\%WEEKDAYNAME%.fbk directory ?? Temporarily…
-
Fixed asset depreciation
I have the following situation: a fixed asset should be depreciated: 50 % in the first month and then straight line. How can this be done in Navision 3.6 ? Thank you for your support!
-
How do i select fields from different tables when writing re
Hi there How do i select fields from different tables when writing reports... What i am trying to do is.. lets say the name of the table that i am working on is called e.g. Price line Table and i want to include maybe( e.g Price) as one of the fields in my report section Remember that "Price" is from a different table. I…
-
Input Mask in Navision
Hi all, How can I create an input mask in Navision ? Can I use Format propriety for a field in a form ? Thanks in advance.
-
Expected Cost Posting in the Inventory Setup Version 3.1
Hi, We are currently using the expected cost functionality in Attain v3.1 Now we want to turn this functionality off without having to invoice all of the purchase orders that have been received, which created the G/L entries. What would be the consequences here? I will test it in our backup system but wanted to your expert…
-
Navision Development 3.01 course - classdisk?
I'm currently self-studying the Navision Development course 3.01 (thats the only dev exam currently available in BE). The course constantly refers to .fobs and other files on the classdisk, but i only have the course itself. Does anyone have this classdisk of the 3.01 courseware for me? TIA
-
How to create a function like TIME2DEC
I want to convert a time value to a decimal value... any suggestions?
-
A question regarding the certification
Hi everyone, I am in US now and I am going to be a certified Navision developer, till now I have taken the following tests through Pearson VUE system (www.vue.com): 1. US 00-003: Gateway to Navision Attain 2. US 05-010: Navision Attain Programming. As far as I know, I should take one more test to get my own developer…