-
Changing IP adress change and domain name
Hi Folks I have a question regarding a job I have to do soon: our company was taken over by another and we now have to change IP adresses and domain name of the complete IT infrastructure to integrate into the network of them. We use Navision Attain 3.60 on 2 DB servers, one for working business, one for testing and backup…
-
Short cut ti find what table data is in
Hi, I remember there was a shortcut (with object designer?) when in the Navision front end to see which table was holding the data in. i.e it bring up the properties for that table. This would be very helpful - and i know i have seen it before. If not, what table are posted sales invoices held? Thanks
-
Change File Name By C/al
it´s posible to change a file name with a c/al code in a codeunit?
-
Problems sending automatic email after ASP request
Hello everybody, I have read some forum topics about problems with send mails in Navision. I have found topics with some similarities with my problem but not whole. I will now explain my case: I wish to send an automatic email when a outside customer do a change on the database through an ASP page. In that moment, the…
-
How To Print A Report To Pdf
I was reading a lot of documents in the forum about how to convert a report to a pdf and send it by mail, and every document is based on a printer driver. I know how i can print in distiller automatically with "printers selection" tables and without filename promt, but the user need the distiller too, and they can´t be…
-
Reverse G/L Tax accounts when doing Payments
Hi everybody: I got this problem. When we apply a payment I want to debit Tax accounts on the G/L. This is not happening. Example (This is G/L Entry) Invoice Affects Sales 364.94 Tax -54.70 Branch Account 419.64 Payments Affect Branch Account -419.64 Banks 419.64
-
Speed: temp Rec vs. Rec
Is there any performance gain in using temporary records instead normal records when I want to do some data investigation by using nested loops? I tried both on G/L Entry but I was surprised to see that by using temp records the speed was 2x slower! (not counting the filling of the temp rec) :?: First I have to fill the…
-
Thermal Printer really slow
Hi all: This is the big picture. I am using a Eltron Printer 2543 at a location outside the United States and we connect throught citrix but it take a while to get a label. What can I do to speed up the process? Thank you in advance
-
table box
hi all , i was wondering if there's a way to use a table box where the source is a temporary record that will be filled by user actions. If not is there a way that this can be implemented? maybe using arrays? thanks Saro
-
SCP Dll/ActiveX
Good Morning everyone, I have following Problem. I need an DLL/OCX to handle connections to an SCP (Secure Copy) / SFTP (Secure File Transfer) Server. I tested some Components, like weonlydo.com,Maverick ... But it is not possible to integrate them in Navision. The component must have following requirements :…
-
compressing customer ledger entries
Hello; I tried to compress customer ledger entries but without results. The entries are not opened and the year closed. Please do you have any idea about the reason of that?
-
Adjust Cost - Item Entries question
Hi What is the best way to filter Inventory->Periodic Activities->Adjust Cost - Item Entries report to run only for items with Item Ledger Entry posting dates <= than a given date? thank you
-
Item Ledger Entries Open Forever
I've been spending some time on our costing issues. I created a report to calculate our profit percentage using 2005 sales & current Unit Cost (line item by line item) - Then run the same report using Last Cost. When comparing the two we were off by 7% for the whole years profit. It's our unit cost that are off. Anyway…
-
bug in cost adjustment batch. (transfers and rounding)
I have found pretty strange problem with adjust cost - item entries batch. yes, there are a lot of problems with this batch but I haven't found any report here (nor on mbs.microsoft.com) about this. To recreate this problem do next: 1) create an item called ITEM (or whatever). 2) create positive adjustment of this item to…
-
Problem with lookup fields in a form
I have a form that has lookup fields, but the lookup symbol is missing. :( If I press F6 to open the lookup field and then return to the form the lookup symbol turns up. Has anyone had such a problem, any ideas? :?:
-
Navision - PHP/SQL search
Hi all. Having succesfully accessed Navision via C/ODBC I have started testing queries I would like to run on tables. Initially all seemed fine and SQL queries such as the below would work correctly and return correct results. $sql="SELECT * FROM Contact WHERE Name LIKE 'James'"; BUT if I were to try the following…
-
Error when installing Navision 3.60 on Windows 2003 Server
In connection with installing Navision 3.60 on Windows 2003 server Terminal Services I am using this guide: How to install Navision Attain 3.60 and 3.60a on a Server running Terminal Services or Citrix 1. Logon to the console of the Terminal Server as Administrator. 2. Copy the contents of the Client folder from the…
-
[FIXED] Navision ODBC connection with PHP
Hi all, Im not sure how much response I will get with this since web searches have been rather fruitless. Hopefully though someone may have a bit of information to get me going. I have created a system DSN on my Win Xp machine. The connection works fine I can get info from the Navision Db using the DSN connection in Excel…
-
Analysis by dimensions
hi, On Analysis by Dimensions when you do Export to excel, if your Language is set to French, the amounts on the excel is wrong. In fact when u export, the spaces in navision e.g 5 000 000,42 becomes 5ÿ000ÿ000,42. Any solution for this problem? ](*,)
-
Optimizing Tables in Job Scheduler
Does anyone know if it is possible to optimize the Navision tables in a batch run, such as the job scheduler? We are using the C/Side database, not the SQL. I know that for SQL there are many other options, but not for C/Side.
-
BA COnfigurator not running
Hi , I am using SQL 2005 analysis services. When i run the configurator from navision, it asks for password, and another window with caption "Checking requirements", which ends up with a error message "Error Querying SQL Server". Any idea why so? I am not able to complete the configuration Thanks in advance. Ajay
-
Borders in Export to Excel...
Hello I want to know that wheather we can create border in excel sheet while exporting to excel... Thanx
-
How are objects stored in a sql server database
Hi guys, I would like to compare (Object-Properties, Properties, Controls, Code...) and manage some objects from different databases. I don't want to use the Export (Files->Export) option , I prefer to work directly with the sql server database. So I would like to know in which tables are stored data that I get using the…
-
How to reset texbox to 0 !?
I have one Setup Form with one text box, Down Limit and one button - Reset to 0. This Setup Form is linked with one table NewTransport where i have record amount. My function, that i make in Code unit compare this two value (Amount and Down Limit). I define variables, set them to 0 in code unit ONPush triger. But my text…
-
Dataport changing foreign characters
Hi guys, Strange problem here. I have gotten around the import/export of foreign characters, in my case Russian Cyrillic. I did this by setting up windows regional settings so the character set for non unicode characters is Russian. So when i put russian in excel, save it as DOS TEXT format and import it into Navision it…
-
Permissions for reports
Hey, I have created a report by using the designer licence but now as a superuser i can not access the report. Comes up with a Permission error. Any ideas on where the permissions are kept for this? Nic
-
Login directly from link / shortcut on Terminal Server
Dear reader, We are using Navision 3.60 in a Terminal Server environment. I am wondering whether it is possible to login directly form a shortcut on the desktop. At this moment I have to take the following actions: 1 Click shortcut 2 Push F12 (login) 3 Enter user ID (Navision does not remember after earlier login) 4 Enter…
-
Eship UPS Maxicode Wrong!
I've been getting a few calls from UPS about our UPS Maxicode being wrong on our UPS labels. A Maxicode is -> http://www.datascan.co.uk/images/maxicode.gif It hasn't been a big deal "ever" but now they have a hub in Ohio that is fully automated and uses the Maxicode to sort all incoming boxes. They are in the process of…
-
Some Problem when connect to Navision Database Server
I use Navision Database Server and It has 2 service, One is Production and another is Test. In Hosts file , I add.... (I add in Server and All Client) 192.168.0.1 PRODUCTION 192.168.0.1 TEST In Service file, I add... (I add in Server and All Client) PRODUCTION 2431/TCP TEST 2432/TCP My Problem is when i use Navision to…
-
Problems with the export function
Hi guys, I would like to export objects in text format (File-> Export) but this message appears :You do not have permission to run the 'File, Export, Text' sytem".What is the problem?? Thanks