-
Date Formats in Navision Server 2.60
Hi, I'm a SQL Server guy, so forgive the simplicity of this question. Are dates stored as true date values in Navision Server 2.60, i.e. as a numeric offset from January 01, 0000? Are they therefore stored in one way and one way only, i.e. regardless of the short date format on the server differing from the client, etc.,…
-
Link Department to user
We still use financials 2,01. Is there any way to link the bookings of a user to a single department? Also to link the user to a journal template so the invoices are booked in a separate journal. Thanks.
-
Automation Excel Move Worksheet to the end
I'm trying to move a worksheet in Excel to the end but get error message in Navision Financials: "Call to member Move failed" In Visual Basic it looks like: Sheets("Name").Move After:=Sheets(2)" Can anybody help me with the syntax in Navision. Thanks, Reinder
-
external data feeds
Hi, I've got a client who uses remote front-end data collection devices. Historically, these devices have uploaded Access database files to a central server over the phone line. We now want to connect these devices to Navision. What is the best vs easiest vs least expensive way to have Navision automatically pick up and…
-
Converting Unicode to ASCII through C/SIDE
Hi everyone, Maybe this is a non-sense question... I am reading some data from an external Data Source which uses Unicode. Obviously, when this data gets written into the Navision database, the text is wrong. Is there anyway to convert the Unicode text into ASCII text? Using a custom C/SIDE function or an external…
-
Mistake table blocked by another user
I have a form that uses several tables as variable. This form is used in many computers at the same time, and in any moment gives me the following mistake " it is possible to neither to insert nor modify the table UNDEFINED because this blocked one for the user XXX ". I need to know if there is some way of solving this or…
-
Message box
A user gets a message box only with ??? ??? in ??? ??? instead of the variable. Why is this? ps. The operating system is W2K Professional[/img]
-
Problem when wanting to liquidate outside of registration da
The problem is the following one: In the configuration of the accounting 2 options that are exist "it Allows registration from" and "it Allows registration until" they are dates in which it will allow to register movements in the accounting. Me as they go the months happening I go modifying the dates so that they cannot…
-
Code coverage
Hello, Is there a place where it's cool? Here's my question: Can anybody tell me how to start code coverage (like the client monitor)? If I open the help it only says a procedure to open Navision with a certain command line. But what I want to do is start the code coverage when Navision is already started and then using a…
-
Create directory
Hi, anyone know how to create a directory whitin Attain? Thanks.
-
Problem with Blob field
Hi, We've got a client on 2.60 Navison Server, whereas we use only 3.60 SQL Server. Client needed us to dataport data out of a backup table and into the production table under an emergency situation. Table has five blob fields, all containing text. Dataport wouldn't handle the blob fields, so we restored the key/value data…
-
Command box
Hello there, I've got the following question: I'm printing a label with the SHELL function. This gives me a command box when i'm printing a label. Is it possible to make this command box invisible??
-
MAPI is not installed
I have a win2000 server with service pack 3 in a Terminal Server Mode. When I try to use mail to send a report, windows show this message: MAPI is not installed. Please help me. Note: In NT 4.0 this message not appears. Thanks. :cry:
-
How to refer a control in a Report.
Ex: ShowClient As Boolean. If ShowClient Then Control11.Visible=True; (not work)
-
Print preview
I'm looking for a way to show the report on the preview fro RUNMODAL function without the dialog "Printer"; "Print preview";"Cancel"; "Help".
-
Will external SQL keys affect Navision?
I'm creating an EDI application for a customer, and am having to query Warehouse Ledger Entries to get item quantities. Due to the number of ledger entries, my SQL queries keep timing out. I've placed SQL keys on the Item No. and Zone Code fields to speed things up, but want to make sure that I'm not affecting Navision…
-
Boolean fields in keys
I have a report using a key and filter on the dataitem on two boolean fields in the table. When I run the report it only fetches the first record and ends the iteration of the report. If I do not use this key it takes up to 10 minutes to run the report as the table is large. ANY help would be greatly appreciated
-
Error 1355 in module 19 ?
Hi, we use Navision Financials 2.60F. If i try to create a new (on a Windows 2000 Server) a Database (48 GB) the the process aborts with the above errormessage. I need several (2-8) tries to create the database. After this i try to import a backup. Also there i get the above error. Exists there a patch or another solution.…
-
ODBC and NF 2.65
Anyone found a solution for this? Anyone out there using ODBC with NF 2.65? Background: Navision never released a odbc driver for this version as it was made while we where waiting for Attain - it is basically a NF 2.60 with the e-commerce of Attain.
-
Leading and trailing spaces in dataport
Hi, In 2.60 I've written a dataport which reads a text into the text variables: txtText1 1 250 txtText2 251 251 txtText3 502 251 The problem is that the dataport omits leading and trailing spaces in the text variables. So that if I write them back by command: file.WRITE(FORMAT(txtText1,250)+FORMAT(txtText2,251)+txtText3);…
-
Aged Account Receivable report to Excel
Hi, Has anyone created the functionality of spooling the standard Navisions aged accounts receivable report to Excel. If yes, can anyone email the object to sbhatbng@hotmail.com. Thanks for your help. Best regards Suresh.
-
Apache Server, Perl and Navision data
Hi all I'm currently experimenting with a combination of Apache Server, Perl and Navision data(extracting data through ODBC or ADO) on the Win32 platform(Windows95, Window98 And the 2000 release). If anyone would like to know about how my little project is progressing, I would be happy to share my experiences(both good or…
-
Mail body size limits
I'm currently trying to let Navision create a mail with a large filled body, formatted using HTML commands (using MAPI or direct Outlook Automation) but I'm running into the problem that the maximum body size is 800 characters for MAPI and 900 characters for direct Outlook Automation. There is also the problem that you…
-
Carriage Return to end of Dataport
Hello Everybody, Looking for some light at the end of the tunnel :lol: . Navison 2.6-D : I am currently exporting data using a standard Navision dataport and then FTP the Data to another server. Client requested that the file should be appended to the original file (Which works like a bom :shock: ) The problem I'm facing…
-
How maximize NOT all windows within Navision
Hello, may be that the following was often wished, but I didn't find anything. Is it possible that Navi does NOT maximize all windows when you maximize one form? How?
-
Total on grouped field
Hi all, Iam new to Navision.Can anybody say how to get the total on grouped field and also grand total for the same in the report. My target is to get the total for the groupedfield "Qualification".Say for eg.,if the "Qualification" is BE it should count no of BE from the table. From the report wizard i managed to get only…
-
Addition to Code Coverage?
Dear members, I am working with the Administrator tool Code Coverage, to organize the autorisation in Navision. :x Now I am wondering if there is an software addition to this Code Coverage tool, for making Permission Groups based for example on the permissions (read,insert, modify, delete, execute)? :roll: Best Wishes!
-
Newbie....stupid question
Hi, I am very familiar with Crystal Reports and Access reports, etc. But I am having a hard time with these navision reports...... I am simply trying to add a "grand" total field for a Calculated field in three group bodies (Group for total Invoices, total Orders, total Credit Memo's). It comes up blank if i copy/paste the…
-
sending multiple mail
Does anyone know how to send 2 mail address to customer Email field. I try address1;address2 but it doen't works. Pleaaaasssse Help me !!!!!!
-
Consolidation of Ultimo posting
We are working with NF 2.60A Dutch version and are trying to consolidate several companies to a consolidation company. This is working fine, but we also have some ultimo posts in the underlying companies and those posts are not in the consolidation company. Although my solution partner informed me that this is a bug in NF,…