-
Posted Receipts not invoiced
We made a mistake by not invoicing our posted receipts. The supplier's invoice we payed in Financials. (We did not make a posted Purchase Invoice and matched the supplier's invoice) Several hundreds of Posted Receipts and Purchase Order are still open. Do someone how to solve this. (2 closed bookyears are included) How and…
-
Database Service fails to start when I reboot machine
I am on Navision 3.7 and everytime I reboot my server the database service fails to start. I have tried starting it manually but without success. When I try to start it manually manually I get the following error messages: The Navision Attain Database Server XXXXXXX service terminated with the following error: Incorrect…
-
Reopen Jobs
A 'inteligent' user set the Status of a Project (job) on 'stopped'. Before that, bookings (invoices) have been made on this project. These invoices can't be paid now because the job was stopped. how can i reopen this job or set the status back? Or is there another solution to get these invoices booked?
-
line nr counting in a report
Hi, I want to build a report that only writes 13 lines on one page and then prints the next 13 on the next page. I know i need to use NEWPAGE to generate the page break but How can I count the lines ? Thanks in advance, JBeck
-
NAS problem
NAS (using NAV 360 and a Win2k server, both database and NAS are on the same server) handle itself is working perfectly, but when the NAS service is stopped and the databae server and we restart it, first the database then the NAS we get te following problem: The NAS isn't working (trigger 99 in cu 1 cannot be found), all…
-
NAS and Web Users
I've been trying to get some detailed technical information regarding the use of specific products through the regular channels of Navision Support, but to no satisfactory end. A component of our vertical is an external automated data capture system. This application interfaces with bar-code scanners, weigh scales, label…
-
When Do I Need To Use LockTable?
Hi guys, If I create a form, with a button, which when this button pushed, it will explode several record into a custom table (inserting). If I do this in multi-user environment, do I need to lock the custom table ? so that other users won't interfere in the middle of inserting the records ? Thanks
-
Navision 3.70 doesn't executes under terminal server session
Hi all! I've a little problem. We have Navision 3.70 client installed on a Citrix Metaframe XPa Server Farm. That's works well with ICA Clients!.. but when I try to execute the application under a Terminal Server session or with ThinClients... this is another history, the client hangs... Somebody knows something to help…
-
Displaying Gantt Diagrams with Octocon OCX
Does anybody have experiance using the Octocon Gantth OCX in Navison? how scalable is it and does it support displaying hours and minutes?
-
problems after moving navision database
We have a navision database 15GB it runs under windows 2003 server std ml330 now we have a bigger server ml 350 g4p with mirror we copied the database and de database is very when it is searching can someone help us we have stopped the database when copied the database.
-
lowercase to UPPERCASE in CODE Fields
Hi I have to create a report to convert data in the CODE Field from Lower case to UPPERCASE as I have some bad data . This has occured as the data was entered from SQL not from the Navision Client. Can anybody help me out how to access the Fields in a Table with Data type "CODE" and to loop through all the tables as I have…
-
Upgrading from 3.01 (3.70) to 4.00 SQL Server
Hi, We finally intend to upgrade Navision but reading about all this SQL Server performance issues in the forum makes me suspicious. What are the main benefits from upgrading to SQL Server apart from using "Reporting Services"? Any experiences you would like to share? Thanks, Kaetchen
-
FlowFilter On List Form
On the purchase header, we have total order weight, which sums the line quantites (not sure if this a customization). If i wish to place this on the purchase order header list, then i notice performance issues. As i have read (on here i think!) place flow fields on list views is not recommended, then I am wondering if…
-
'Get Receipt Line' cannot close, system is currently working
Hi, I have added the code below to the Purchase Invoice - Get Receipt Lines functionality. This is producing the error message "'Get Receipt Lines' cannot close because the system is currently working". I have tried moving the code around the function and also playing with form modality to no avail. ](*,) Any suggestions?…
-
Problem with Navision Communication Component
Hi Folks, I have the following problem with the ComCom Component. What you see bellow are code snippets from the gComCom2::MessageReceived function which is automaticly created when you use a variable of type Automation subtype 'Navision Communication Component version 2'.CommunicationComponent. When I try to save an…
-
Installing ODBC on Version 3.6
Can anyone point me in the direction of how to do this? I have installed the driver from the installation CD so that when i go to set up an ODBC i have the C/ODBC option. However i am unable to get the ODBC to work. I am prompted for the database name and in here i have put the location of the fin.exe. However when i click…
-
Vertical Bar code
Hi All Is there a way to print vertical bar codes on report? Regards,
-
HotCopy can't find drive/directory
I'm trying to backup our database to a network share but HotCopy keep's complaining about this: C:\Documents and Settings\dataabc>"D:\Program Files\Navision Attain\Database Server"\hotcopy source=D:\NavisionDB\DT2KTEST.fdb destination=z: nettype=tcp servername=dt2ktest user=backup password=backupBackup W1 3.10.ABackup Tool…
-
Same code over multiple lines
I am new to the Navision C/AL code so am learning this as I go along. I am trying to use the SETFILTER option but have noticed that there is a limit to how much code can be put on one line. I simply tried to continue it on a new line but I get a syntax error. The maximum code it lets me enter one line is,…
-
Return A Specific Charater
Is there a way that i can return just a certain character from a string similar to Excel where i could use Left, right or mid? I only want to return the second character of a string and was unsure how to do this.
-
Return A Date Format
I have a date of 30042006. I want to return this as Apr 30,2006. Any ideas how i can do this?
-
Navision Attain 3.01b
I just have install WINDOWS VISTA RC 1, and ATTAIN 3.01B and it not runs ... Know anybody what's the problem is? cpuertolas@discebeba.com [/b]
-
Cannot open Database-SQL Server option
Hello Everybody When trying to open a SQL Server option Database using 3.60 client it shows an error message saying some problem with the Data type of "Wait Time" field in Session Table. I am using SQL Server 2005. The message is as follows: ******* The Session table contains a Microsoft Navision Attain field data type…
-
Picture sizes?!
We're using Navision 3.10. Whenever I take new pictures of our product, I resize them to a maximum of 500 pixels either wide or high. This has always worked fine so everyone can see the picture on their screens fine. Recently our company purchased a new machine. It's running Windows XP when the rest of us have Windows…
-
Programming conditions in import dataport
Hi all! I have an Excel document with fields I have to import to Navision table. Actually in Excel document there are item numbers, item translation and language code. I have to import this document to table Item Translation. But there is one problem I cannot deal with - some items has already their translations and I…
-
Upgrading Navision client 3.6 to 4.0 issues
After making an upgrade of our client to version 4.0 some tools in Windows Xp SP2 stops working. For examples : the search tools in the start menu ( file misssing ) or the help don't works anymore ( Script error in IE ). MSC.exe is still working but no way to run gpedit.msc for example.
-
Attain 3.6 & ADCS
Hi, The hand held Symbol terminal running vt100 starts to freeze, user has to re-boot so that operations can be resumed. We've tried the maintenance code recommendation found on this site dated Nov 30, 2005 - it speeded up the process but still the freezing continues, somewhat longer this time. Event viewer displays the…
-
Opening balances
Hi all, In Navision Attain 3.6, how to enter the opening balances for ledgers? These are supposed to be the starting entries (either + or -) for individual accounts. Thanks & regards, Rohit New Delhi
-
Item Ledger Compression in 3.6
One of our clients compressed their Item Ledger for the years 1999 - 2002 a few months ago with no issues. That is until now. During their last running of the Inventory Adjust Cost periodic, they received an error message of "There is no Item Ledger Entry in the Filter Prod. Order No. xxxx, Prod. Order Line No. xxxx, Entry…
-
Report 1301 Print ASCII File
Anybody know the purpose of this report - or if it's used anywhere?