-
Flowfield all the same
I have a flowfilter on another table which looks at another table. The Calformula is made up of fields and flowfilter fields. And is made up of store number, date, type etc. The quantity field is being summed. A similar example would be if i was looking at the purchase lines table and was filtering on type, item no. date…
-
Transparent Email - possible?
Hi guys, I was asked if it would be possible that "once a support record is closed an email is sent to the saleperson responsible for the customer the incident is related to without any user intervention" This is only in the 'could this be done' stage. So does anyone know if this would be at all possible? I think I know…
-
Date Compression ->Item Ledger Entry
Does anybody know in what consist the date compression of Item ledger entry batch ?
-
Direct Cost applied account
Would soeone be able to explain to me what the purpose of the direct cost applied account is please?
-
How to address a printer's paper tray from Navision
Hello We have some problems with Navision and printers. Acutally we have to add a printer twice, one time per paper tray we want to print in. This is very hard work with many printers and sometimes 2 or 3 paper trays. Are there any other possibilities to address a paper tray directly out of Navision? Are there any tools to…
-
Filtering table on the basis of number series in reports
Dear All Please let me know the Can i filter the table on the basis of number seriel through coding in reports. For example in posted Invoices i have lotes of entries and entries are differenciate on the basis of number series. Like for simple purchase we have number series POSP0001.... Purchase for Research we have number…
-
Debugger Crashing constantly
The Debugger and the code coverage in Attain constantly crashes fin.exe on us, even when using a developers licence or our clients license. This is in Windows XP with the firewall on or off, doesnt matter. Is there a known issue with this debugger on this platform?
-
Problem of using same FA Card
Dear All :cry: :cry: Can i use the same fixed assets card for multiple FA purchase instesd of creating the new FA card for purchasing the same item. and can we keep the information for no of qty. of FA purchase items in the system. Problem is that suppose a company purchase 100 chairs and create a FA card for that…
-
Problem for user rights
Dear all I am facing a problem that "You do no have read permission for Change Log Setup (Field) table please contact your....." as soon as i create an Interaction and press the Finish button. I already give all the RM-roles to the user except Super. The problem is solved if i give super rights to that user but it is not…
-
Expanding Native database above 132Gb
I have a question regarding Expanding a Native Database. I have just joined a new End User, and their retail database implementation includes a Head Office database, Native Server v3.6. The database is presently ONE file of 132Gb !!! ( [-X I know). Database usage is presently at 83%, and growing at 0.3% per day. The plan…
-
Open another database
Hi again. I want to open another database from navision (Ms. Access). I'm using Microsoft ActiveX Data Objects 2.8 Library. But i have problem with recordset. How to use it ? Thank you.
-
SIFT calculation bug for SQL Server Option 3.60
I have a situation with wrong Amount calculated on GL Entry for "G/L Account No.,Posting Date" key. If I sum all amounts in GL entry for specified account, the result is not the same as calculated Amount field on that same account. I found a difference between tables $17$0 and G_L Entry for a specific date and account (for…
-
Problems with SQL permissions using LinkedObject (views)
Hey, I've got the following setup: 2 x Attain 3.7B SQL databases (dB1 and dB2) running on the same MS SQL Server (2000 SP4). I use windows login. The objective is to connect certain tables in dB1 and dB2 through the LinkedObject property on the tables. E.g I create a view in dB2 (v_dB1_Item) that returns all rows from Item…
-
format cells excel export with excel buffer
we use table 137 : Excel Buffer. But, we have a big trouble. :shock: we can't change format of cells or rows or columns. How can we specify columns width for excel export ? How can we change alignment ... ? thx for your help. [-o< batigoooal
-
Error 2 in module 10
Hy! i've tried to open navision Atain and i get this error"Internal error 2 in module 10".I've reinstalled Navision and i got the same error! Can somebody tell me what can i do and why i got this error.
-
Enter only Numbers and Letters
Hi, Is there any way just to control the user input in a filed only digits 0 to 9 and only letters A to Z. Can somebody tell plz
-
syntax for Changeing color of a particular cell
Dear all, I want to show the color of particular cell in red. but i am unable to find the syntax for setting the color. i have searched the forum but all i could get the nos. for the color. Please guide me. thanks
-
Trouble with SELECT query via C/ODBC, Navision 3.60
We want to read some records from the Navision 3.60 Native database via C/ODBC. As far as I know, it is the latest version of C/ODBC for the Navision 3.60. The structure of the SELECT query is a simple SELECT Str FROM KPR WHERE Str = '1000xxx' AND Knj = 0 We are trying to do that with the use of Server-side JavaScript. It…
-
Help! Reconsolidate Sales Invoices and Cust. Ledger Entry
We have a request from a client which is unusual and they are intent on getting it in exactly the way described: - They are producing sales invoices in the usual manner. However, they want to print sales invoices with a different consolidation level, that is by Customer, by VAT Product Posting Group. So we have 3 Sales…
-
automate printing of tiff files
I need to automate the printing of tif files (after a report is printed). Does anyone know of the best way to do this?
-
Get external file properties from Navision?
Importing a file with a dataport. Want a confirm dialog box that will show the last date modified and last time modified for the file I'm importing. Is there a way to do this? Thanks
-
Report Headers on Every Page, but PrintOnEveryPage=No
I have 2 headers on a report. One has the PrintOnEveryPage set to Yes and one has it set to No. For some reason they are both printing on every page. What am I missing? Thanks.
-
helo
hi all we just upgraded the memory on our navision server and i need to run the application on the server to increase the DBMS cache. when i run the navision application file on the navision server i am getting a weird error message There was an error in the text conversion. blah blah blah before even the application runs,…
-
CurrFieldNo
I haven't noticed this stuff before.. I was checking on the Sales Line table code and encountered a variable named "CurrFieldNo". What this variables stores is the fieldno of the active field. I've checked the declaration and found no trace of this particular variable. Is this a sort of Navision predefined variable, or…
-
Determining if a key is used
Hi I want to fine tune our Navision installation to improve performance. According to the docs, I should disable unused table keys. But, how do I know if a key is ever used? So far, I found only three ways: 1) Browsing through hundreds of forms/reports and thousands of lines of C/AL code looking what keys are used 2)…
-
migration 2.60 to 4.0 SP1
Hello, we made a database migration from the version 2.60 to the 4.0 SP1. Now, The problem is that the information contained in the database in v2.60 has changed during the migration process, and reinserting it in the new one is not the right way i think :x So we decided to import the FOB file containing all objects of…
-
Read a *.txt in Navision
Hi How can Navision see there is a *.txt file in a folder. I have tried to use file table. Javaid
-
Brazilian language for Navision 3.60
Hello, I need to have the Brazilian language for Navision 3.60. I'd like to know where I can download/get it. Thx.
-
variant in c#
recently i made a topic cause of a problem to use the GetFieldData, i got a reply on a dutch forum to use the stringbuilder :) now it works BUT cause its a string, decimal/dates/etc are not showns properly, strings got a ÿ in front it(code field). numbers got a square in front of it (char 255)(codefield, value's in % are…
-
Nav SP1 Server & Active Directory
Hi, I have installed Nav SP1 Server from the CD on a Win 2003 Server machine. This has created a Navision service for me. I have also extended the Active Directory Schema in an attempt to be able to select the database when connecting from a client (rather than typing in a name or IP address). This does not work though - I…