-
Aged Accounts Receivables
I got a problem here. Maybe someone can have an idea what I need to check. First I got this value 3,139,772.95 as my 12/31/04 Agging value. It includes Pesos and Dolars invoices. And Dolars amount are taking original exchange rate of each document. Then I got 6,559,908.35 and 4,574,087.82 as my Detail Trial Balance for…
-
Reminders different levels
We used to send our customers one reminder with invoices in different reminder levels. From now this should change: for each level, there should be one reminder with the corresponding text. Our dealer doesn't provide a suitable solution, can anybody help me? :?:
-
ODBC error
I am trying to make a connection between an third party application (Clarisoft). Unfortunately the third party application is doing something wrong and the supplier don't know where to look. He asked me if I had sources (and of course we have MIBUSO =D> ) which could give him some clues to find an solution. Till now we…
-
How to use a flowfield in a report
Is it possible in a report to use a flowfield as a requested filter field?
-
Subcontracting and Manufacturing
Hi all, While deleting a Component Line from Prod. Order Conponent, an usual error came up. I found a BUG in the system. In the SynchSubConOrder() function, the 2nd IF condition do not have BEGIN .... END. So what happens is, the 2nd + 3rd + 4th line executed, even if the IF condition results in FALSE. The correct code…
-
Copy data from one table to another with filters
Hi. Currently I need to maintain some info in one table, and be able to copy this data to another table. The table structure is like this: Table 1 (blank) ____________ Table 2 (Main Item) ________________ 1 2 3 Table 3 (Item Value) _________________ 1 a 1 b 1 c Table 1 is the table I need to populate. Table 2 is the table…
-
Printing Invoices from within the Statement
I am running version 3.6 and the customer wants to print a statement, then all of the invoices that are on the statement, then the next statement, then all of the invoices that are on that statement, etc. So I added a little code to the PreSection of report 10072, HeaderFooter, Footer as follows:…
-
Navision CRM - Contact Search: Trouble with multiple Query
If you enter more than one word in "Query" on Contact Search Form #5177, Navision joines them with OR (you can see this by using the AssistButton). e.g. the user enters "Smith London", Navision creates two Search Detail Lines, joined by OR, so query is changed in "Smith | London", the Result is a list of customers whose…
-
Sending Faxes from Navision within windows 2003 server-
Hi, when I try to send a fax form Navision Attain 3.6 with the Fax Service that comes with W2003 Server, Navision Clients, gets completely freeze, what it's wrong?
-
Msqm
Hi I read quite a few articles on this board concerning MSMQ. However, I have some unsolved questions on that. 1) Is it possible to have a form open (for testing purpuses only) waiting for the CC2:MessageReveived event as mentioned in http://www.mibuso.com/forum/viewtopic.php?t=4185 2) I tried to make it work as described…
-
Using third party DLL / problem creating instance
I need to make a form within NF, which will be used to send data to industrial printers. For this we have a demo version (full version, but not yet paid) to test if this is possible. I also got an example of Visual Basic in which is detailed described how it can be done using COM / DCOM. Problem is that I don't have…
-
How to get computer name in Navision?
Hi All, How can i get the conputer name in Navision? Normally we can get the user ID who log in to Navision by using "USERID". So, how can i get the computer name? Thank you. Rachel
-
Decimal value to Fraction
On the Item table I fot Internal Diameter and External Diameter fields as Integers but I do like it this way. Because it changes the value to decimals. To avoid this on development I added Internal Diameter TXT and External Diameter TXT. How can I pass those value to the appropiate Internal and External diameter fields?
-
Adding a column
Hi, I need to have a new column added to the Sales Quote Form. Is this fairly easy to do? I have tried going to Designer and then just insert, but it isn't working. Can someone tell me how to do this? It just needs to be a text column and it doesn't have to show up on the printed quote. Thanks Rosemarie
-
PDF Mailer by Gotomax software GMBH
What a great piece of software, shame their technical department are not very responsive :x Has anyone integrated this with Navision (of ANY version) or does anyone know where I can lay my hands on an integration manual so that I can try it myself. TIA Dean
-
Altering Navision reports
I am working with a base Navision report that displays Aging Periods (ie. 0-30 Days, 31-60 Days, etc.) and need to make some changes. I have gone through the code and am trying to figure out how the arrays are being set and used to derive the correct values and am finding it quite confusing. I don't recall dealing with…
-
Zup file
We are using printer setup to print customer invoices to different printers based on customer settings. Once in a while, if the ZUP file is currupted then the invoices are printing to local printer. Only way to correct this problem is to rename or delete the existing zup file. Is there a way to avoid this problem? How can…
-
Due Date Calculation
We have a terms code called SUNTAN where regardless of the order date the payment is due 06/01 (June 1st) I have tried wd-wd+5m (work date minus work date plus 5 months) but the formula doesn't seem to work.. any ideas how I can get the terms to show June 1st? Thanks
-
xml dom
hi i am unable to create an instream object with the blob. I am using the XmlDom Document automation. it is giving me the error: 'This automation variable has not been instantiated .You can do it by either creating it or assigning it.' shikha
-
Help with report and multiple tables using a GET
Global Variables SH Record Sales Header OnAfterGetRecord SH.GET("Document Type","Document No.") In the Report field SH."Order Date" I am trying to use another table in the report. But I get an error The Sales Header does not exist. Identication fields and values. Document Type = 'Invoice', 'No.' = '106033' can someone…
-
Log used printer in Report
Hello Forum, i need to log the printing activities of a certain report. Every User is able to choose a printer of his choice. When writing the log-entry i want to store on which printer the report was printed. Is there any variable or function containing this Information? FindPrinter() from Codeunit1 would show only the…
-
Escape subform using ESC?
the standard forms in navision we can escape a form using esc, even if you are in the subform, when creating forms of our own, pressing esc in the subform doesn't do anything. what can we do so esc will exit the form? i guess it's a property or sth? thanx in advance
-
Arabic Navision Version
We have problem with the right alignment of data.Any idea of solution?
-
Find & Replace on Dot and Star characters
From a Run on a table, we can use the functionality Find & Replace. But ... when you put . (dot) or * (star) in the field "Find what", the field "replace with" becomes anavailable. Any trick to avoid that ? We have to replace all dots in "Phone No." (table Contact) with another character ... Thx and Regards,
-
consolidation
hi i am facing a problem regarding the consolidation of data between two companies. while consolidation,the original posting date is not there in the consolidation company, instead the consolidation date appears. Kindly, reply !!!!!! shikha
-
ERROR: Host is not Answering
Dear All, I have some problem. 1. My server use Navision Database Server (Navision service) 2. My Server is Windows 2000 3. My client is Windows XP and Windows 2000 My problem is some of client is cannot login. it's show error "Host is not Answering"......How to solve it? remark: 1. I already fix server ip address in file…
-
Creation Date on Transfer Orders
Hi guys: I got table 5740 that includes Creation Date field (70552 - Date) but it is only fill when you create a transfer from Location Replenishment Report. What do I need to do to fill it every time I create manual transfers? thank you in advance Paco
-
Insufficient memory - recursive function
We have a client running Nav 3.10A. They were trying to run the "Calculate Low-Level Code" function under Periodic Activities in Manufacturing. It stops on the same item each time (at about 18% complete) and the error says: "There is insufficient memory (stack) to execute this function. This can be due to the way that…
-
extreme cpu usage of landsteinar data director
hi everybody. I am using navision 3.60 with SQL.when i check the task manager the cpu usage most of the time is very high. I can't understand why this happens.when i stop data director service and i start again the cpu levels become normal for a few hours and then become extremely high. I using an HP ML350 with software…
-
Changing "Description" Entry
There are codes in Navision where you can type in the Description and the proper code appears. For example in Payment journal if I don't know the g/l for Inventory I can type in "INVE" and 15000 - Inventory would appear. Same goes true for order entry if i start to enter an item description into the item number it will pop…