-
Printing report sections
Hi all and thanks in advance for your help.. I have a question about reports... Is there a way, during report sections running, to use C/AL code to invoke printing of another section of the report? I try explain me: in the OnPreSection trigger of a section of my report i have a call to CurrReport.NEWPAGE; when it run,…
-
How can I get to the "posted" purchase orders?
Hello, Once a purchase order is invoiced, it's deleted from the purchase order tables. What if I need to lookup an invoiced PO? Is there a way to see those POs? maybe in a different table? Thanks, Tim
-
error 1706 whith navision 3.60
I have installed Navison 3.60 while being logged in as the Administrator and everything worked fine. However, when I use a different login and try to run Navision 3.60, the Windows Installer gives me a 1706 error. has anybody an idea? :roll:
-
Installing 2.6 & 3.6 fails on Terminal Server
We have windows terminal server 2003 running on top of vmware software. We have tried to install both 2.6 & 3.6 and both fail. The installation goes *all* the way to the very end, then rolls all the way back and says there has been an error without anymore information. Anybody seen this and/or have recommendations for a…
-
Replication?MS SQL Server vs DataDirector
Hello! My team and I have some doubts about replication solution for Navision customer. Customer insists on replication between distant locations (7 locations) and the central location. We have opportunity to buy DataDirector (Landsteiner) solution for replication, but also a solution to use SQL Server replication. We are…
-
How to insert new line in navision when writing reports
HI THERE... I AM NEW TO NAVISION AND SO FAR SO GOOD. BUT MY PROBLEM IS THAT I DONT KNOW HOW TO INSERT A NEW LINE.. WHAT I AM TRYING TO DO IS: I AM CALCULATING INVENTORY(E.G. MAYBE ITS = 1000) BAL AND QUANTITY(E.G. =800) AND IF SAY QUANTITY IS LESS THAT INVENTORY MY REPORT SHOULD BE ABLE TO INSERT A NEW LINE WHICH HAS THE…
-
Enumerating controls on form
Is there any way to enumerate controls on a form in Navision? I want to go through all controls on form an see which are visible. TIA, Damir
-
SQL Optimization of Navision SQL DB
Customer runs SQL 3.60, the DB size is about 12GB (with >1GB growth/month). They have scheduled SQL Optimization every Saturday. This procedure does a lot of reorganizations in DB and makes log file also as big as 12GB. Then the backup of log is made to truncate and this procedure need additional 12GB of space. Totally…
-
automatic Windows Access creation at Attain 3.70
I try to program a Report which should create Windows Access automaticly by copieng an existing User. Now I think i have an Problem with the SID. IT would be great if anybody can tell me how I can get these identifieres. René Müller
-
Error using Change log
Hi all I get the error "Change log entry no. 0 already exists". I have bought a new Navision Server, so I made a backup of Navision cerated a new database on the new server and restored the backup. Everything works fine, exept Change log entry. When I make a change on a customer I get the error "Change log entry no. 0…
-
How to focus to Sales Header form from sales subform ?
Hi Friends ! As you know SalesHeader.Status contains 2 options (Open & Released ) . I add a additional option "Overdue" to SalesHeader.Status. At time, SalesHeader.Status contains 3 options (Open, Released, Overdue). When I enter to quantity in sales line, it may the customer of this order be overdue and I update…
-
Getting Navison in front while using Excel
Is there a possibility (Statement, program or so) to get the Navision-Application in front while using another application (Excel).
-
temporally slow / unknown path / slave.exe
Hello, sometimes we have the problem that Navision is slowing down. Then we get an warning in the eventlog: Event-ID: 109 Message: Error 18 in module 244. e:\Samos\11353\Source\Ide\server\SERVER.C(372) OS: Win2k Server SP4 Version: Navision Attain Version DE 3.60 CPU: Intel Xeon-A 2.6 GHz RAM: 2.0 GB HDDs: RAID-1 SCSI…
-
tooltips permanent disable
Hi all, is it possible to disable tooltips permamently under attain 3.10, although you can disable it via the tools menu, it can be re-activated upon deletion of the zup file. So can this be done programmatically ? Tooltips cause the CPU usage on a citrix server (with attain clients) to rocket to 50% - 1user or 100% -…
-
Job scheduler with NAS
Hi :lol: , I need to make a job scheduler with NAS. An xml config file (config.xml) contains all my jobs and their configurations. So, I use timer automation variables to run a job in a specific time. The problem is: I wand to create these timer variables dynamically, according to the job configuration set in config.xml.…
-
Having Problems With My Report
hi there I am new to navision and i have manage to write good reports so far... my bproblem is, i have no idea how to create a dummy field which will only appear when lets say: if say inventory balance is1000 and quantity delivered can only total to 800(not enough shipment to cover the inventory balance). So i want the…
-
Reports: Preventing a DataItem from running
Hi, I have a report structure like customer cust. ledger entry On the Request Form, I created a checkbox to let the user choose if he wants to see the records from Cust. Ledger Entry. This means that I should be able to prevent the Cust. Ledger Entry-dataitem from running at all. I could use SKIP in OnAfterGetRecord, which…
-
Importing serial number to the batch Item Traking Lines
Good morning all, I use Item Journal to enter items in inventory. When there are a lot of serial number, I must enter them one by one. It's very hard!!! My question is : how can I import serial numbers of an item to the batch Item Traking Lines from EXCEL file ? Can I use the table Excel Buffer (ID 370) ? Thank you in…
-
Internal Error 2 in Module 10
I am getting an "Internal Error 2 in Module 10" when I escape from the main menu (my own dbase - not a client's, so no worries). The partnerguide website suggests that I delete the zup file. Did that, but the problem still persists. Any idea how to overcome this? tx
-
How to kill Navision session on SQL Server
Hi all developers, Sometimes, users forget to close their session when they don't work on it. We have a limited number of sessions in our licence, so I must gain these sessions for other users. Thus, how can I kill Navision session on SQL Server 2000 ? Thank you for all in advance.
-
Active Directory Services
Hello, My Network Admin comes to me with a problem that I can't answer, it is. When viewing Windows logins The Id column is displaying SID's and not user names, and an error occurs stating: The system fail to retrieve the global catalog from Active Directory. This may be cause by a network problem, or may be cause by a…
-
I Need Help
HI THERE.. :cry: I AM WRITTING A REPORT AND ALMOST THERE BUT SOMETHING IS JUST AINT WRITE. IF SAY INVENTORY BALANCE IS 1000 AND QUANTITY DELIVERED CAN ONLY TOTAL TO 800(NOT ENOUGH TO COVER THE BALANCE). SO HOW CAN I FEEL IN THE DETAIL OF THE REMAINING 200. HOW EVER IF THIS IS THE CASE A NEW BOOLEAN FIELD SHOULD BE FLAGGED…
-
Problem posting a sale invoice
Hi for all, When I post a sale invoice, the message "Item Ledger Entry Entry No '0' does not exits.". Any one can help me ? Thank you for your support.
-
Startup switches
Can anyone tell me if there 's any documentation about startup parametersof the navision client ? f.e. the ID switch to give each shortcut its own ZUP. Are there others that may be useful? Thx, scOOb
-
Create to-do from single button click
Hi all, Is it possible to create a new to-do from a single button push without brining up the wizard? So when the button is clicked a new to-do is created without the user needing to fill any fields in. I have a single task that needs completing by the same user, so in effect the task is always the same and is always…
-
new server migration
Hey all, my first post. We are going to a new faster server to keep us going. The old has P3 1ghz 1.5gb ram. raid 1 for disks the new has P4 3ghz xeon and 2gb ram. raid 1 for disks db is 20gb and divided into 4 files across sep disks. Questions I have. 1) What cache settings should i set on the new server? 2) is copying…
-
TASK: Assigned by field populated with logged in username
Hi all, My users have grumbled anout not being able to see who assigned them a particular task, would it be possible to define a new "assigned by" field and auto populate this with the logged in users code? If so, where do I look to start on this? Cheers
-
How to display data from related table in textbox?
Hello everybody. I'm developing simple CRM system in Navision Attain 3.10. I hope that someone can help me to do following task. I have a Form with data from the table Companies in my database. It looks like that. CompanyID | Name | Address | City | Phone no. | ***************************************************** 0001 |…
-
Cfront with Navision
Good Morning I try to connect a Navision Database from a Navision Database with Cfront but it doesn´t work. I shows me always an "Invalid Handle" Error on FindRec. Has somebody a example source code for me. Or is there an alternative to solve this problem. Best Regards dietmarruef
-
Optional parameters in functions
Hi I'm writing some codeunits, and tries to find out how to make a function with optional parameter(s). Is this possible, and if, how?