-
Prerequisites of using Phone Dialing facility in Navision
Hello Friends, Right now I am working on Relationship Mgt. I need to know the prerequisites of Phone handling (Incoming and Outgoing) from within Navision. Customer requires to record phone call also.
-
RAID 0 and 5 Performance comparison
Hi All, Is there anyone have some information about SQL performance comparison between using RAID 5 and RAID 0? Previously I've seen a research from Siemens lab about this performance. Does anyone still have such information like that? Thans. BHT
-
User Ids are deleted when posting orders in P&P
Recently I had a problem when orders where created and strangely when posted the userIDs dropped off and are unretrievable. I have no idea what could cause this...i have trawled through hundreds of postings on different websites and this hasn't been posted as a problem. Has anyone seen this - or resolved this problem in…
-
Error when I start Business Analytics
Dear all When I follow these steps to start Microsoft Business Solutions - Business Analytics, I receive an error message: 1. On the toolbar, click Business Analytics. 2. Click the key symbol to log on to Microsoft Business Analytics. You receive the following error message translated from Russian: "Connection is corrupted…
-
Hide menu bar
Hello, Is there a way to hide the menu bar completely. I'm using Windows CE/Terminal Server and the menu bar takes up a lot of useless space. Reinder van der Veen
-
Error while Sales Order Post
When I am trying to post a sales error following error is coming: Another user has modified the record for this Sales Header after you retrieved it from the database. Enter your changes again in the updated window, or start the interrupted activity again. Identification fields and values: Document…
-
Item Application Entry table
Hi to all! We need help regarding Item Application Entry table. What is the primary use for this table and what parts of Navision business logic rely on it? We are heaving trouble understanding this table because there are no documentation about it (it's a table for internal use). For example, what problems could occur if…
-
Problem with Calculate Interest flag in Customer Ledger Entr
In Customer Ledger Entry there is a "Calculate Interest" flag. When it is set to TRUE, Finance Charge Memo can be created for this order. We are creating such a finance credit memos every month and issue them. After issuing, Calculate Interest flag became FALSE. Then, once issuing, is impossible to calculate finance charge…
-
Problem with XML Import
At 1st: thanks for your examples, roman. I solved several nodes beginning like this: <?xml version="1.0" encoding="ISO-8859-1" ?> - <ORDER> -<ORDER_HEADER> - <ORDER_INFO> <ORDER_ID>4501136617</ORDER_ID> with the code: OpenXMLDocument(filename,XMLDocument);…
-
c/odbc performance
I've got some performance issues with Navision 3.70 and the ODBC driver. the driver doesnt support datasets, i have to get them 1 by 1. test370 is a remote Database the sample is pointing to a local database My code (C# .net): OdbcConnection myConn = new OdbcConnection(); myConn.ConnectionString =…
-
Adjust Cost - Item Entries for one Item or all others
We all know that this batch is very tricky so I wanted to modify it so I can run it for: a) particular Item (infinite loop is killing me) b) all Items except that one With big help from "Guidelines for Loops in Adjust Cost Batch Job" document I solved a) case but I can't make b) case to work (or work properly) :cry: I…
-
FTP server
Hello I have just downloaded 'Xceed FTP Library v1.1'.XceedFtp and installed. Made this code in a codeunit. CREATE(ftp); ftp.ServerAddress('ftpskb.itgruppenas.dk'); ftp.UserName('Username'); ftp.Password('Password'); ftp.Connect(); ftp.ReceiveFile('/JAS/Codeunit90G.txt',0,'d:\JAS\Codeunit90G.txt'); ftp.Disconnect();…
-
Error "Overflow in calculation of 1000*2147491
When running a creation of new Analysis View I am getting this error message in Navision 3.01 "Overflow in calculation of 1000*2147491". We have a very large number of transactions posted on a regular basis, the size of the db is 24Gb. I read some postings relating this error message to journals with high number of lines -…
-
Navi and SAP Business Connector via XML?
Did anyone connect Navision to the SAP Business Connector via XML? Is there some standard code availible? Where can I find examples?
-
Find Field Case Sensitive on Navision SQL Migration V.3.10
Hello! I have recently migrated a Database Version 3.10 to SQL. Problem is while i was trying to search for a description in the item list, although the setting of "Match Case" is UNTICKED, Navision still does not find the Description. I.e. Description = 'ADESCRIPTION' if i type in the find window 'adescription' it is not…
-
Error exporting to excel
I am getting an error using the Excel Buffer table to export: - This message is for C/AL programmers An exception occurred from an external component. The component did not provide the exception description. Excel Table Buffer - CreateSheet(SheetName,ReportHeader,CompanyName,UserID2) REPEAT RecNo := RecNo + 1;…
-
W1 3.60 database with all hotfixes
I have a problem getting a clean W1 database with all hotfixes. PartnerSource site is completely messed up, and what it says is a W1 for most hotfixes contains some local objects. Can somebody send me a W1 3.60 database with all hotfixes applied or point me where I can download all corect W1 hotfixes. TIA, Damir
-
Calculating number of Working days in a month
Hi, Does anyone know how I would go about calculating the number of 'Working' Days in a calendar month? (We're closed Saturdays) Base Calendar does reflect this. I would imagine the CalendarMgt Codeunit would be used. But how? I basically need this to be able to report the percentage of time lapsed in a month for company…
-
Navision closed automatically
It happen just on few computer in some module, but the others are fine, run normally. Each time i click the button, navision closed automatically but in other computer it's not happen. What is it ? Thank you.
-
Put CompanyInfo.Picture into an Excel document
How does one put CompanyInfo.Picture into an Excel document? I am creating sales invoices in excel and need the Company Logo. Thanks Roddy
-
'Calculate Interest' Flag
When 'Calculate Interest' Flag in Table 21 (Cust. Ledger Entry) is set? It seems that it is set by some routine, because the value is changing without user interference... But I can't understand the target of this flag and when does it receive it's value? Help is only saying, that this field is used internally by Navision.…
-
Browsing and opening external files
Hi, i have to give user the possibility to open a file from navision like explorer does : with double click it opens the file with the correct program associated. I tried with dialog management (CU412) but i can call the dialog window only with open or save mode, so when i double click it gives the control back to navision…
-
Access data on Nav 3.6 through >= Nav 3.7 ???
I have to create a lot of reports (and growing to next and next and another reports) that can be done with BA, unfortunately BA only support for >= Nav 3.7. Any suggestion for this ? Perhaps, how to make a trick to run BA on Nav 3.6 ? Or a trick to run Nav 4 with Nav 3.6 database without upgrade it ? Or how to make a trick…
-
using diferent key in cfront
Im currently working with a handscanner. there's a new function needed for it. If someone wants to add a article-part to an order it needs to check if that part goes with the orders-article, clear huh :P example: coffeemachine A has a bucket X, but that bucket X goes with coffeemachine B and not A (doesnt fit) im using nav…
-
Validation of field
In the Sales Line table I have inserted a new field (Quantity in Sales unit). I am trying to validate field quantity by writing code in OnValidate trigger of the new field. The syntax is Validate(Quantity,<New Value>) Although the value in Quantity field is getting modified, but Validation of Quantity field is not…
-
error 1355 in module 19
Can someone translate please: 19 1355 #Err_DB_DBMNotReentrant DB_Err(1355) thnx
-
How to create a fin.stx file?
:( I couldn't find the language module for Japanese, so I had to translate it by myself. I succeeded in translate tables and forms. But the system menu is still English because I'm using the English fin.stx. I tried to modifiy the Menu Texts in fin.stx with a text editor and Navision general a error: There is a checksum…
-
Navision 3.60 and OLAP Cubes
Hello. I'm trying to build OLAP cubes (SQL Analysis services) over native navision DB. Most of the things are working, but I can't build Time dimension. It always gave me this error "Expected lexical element not found: <identifier>" I tried playing with identifier settings in c/odbc and/or language settings but nothing…
-
Date caculation for workdays only
Hello, Does anyone here know if there is a standard Navision function to calculate a date, using only days marked as workdays in the base calendar? So for instance I'd send a date in there, and a date expression (or a number of days, say 4 days), and the date that it returns would be 4 workdays from the date that I send…
-
Tracking user's attempts to access
Does anyone know if there is a way in Navision Attain 3.60 to track which tables a user tries to access. If a user doesn't have access to a table, and they try to access that table thru a form, is there a way to monitor that?