-
3.10 sql user login error
Hi all, we've just completed a migration from 3.10 cside to 3.10 SQL. A few users (only win2000 so far) have the following error message when logging in: "The current ANSI or OEM code page on your computer does not match the 437 code page of the SQL_Latin1_General_CP437_BIN collation for the sqlattain database. You must…
-
How to do that....Item.CALCSUMS("Sales (LCY)")???
I have a report and I want to do Item.CALCSUMS("Sales (LCY)"), but Sales (LCY) has complicated CalcFormula, and in Item table there aren't a key for that filter in CalcFormula. Anyone knows solution for that??? Thnx
-
Custom Functions with OPTIONAL parameters?
Can this be done?
-
Modify a contact with code from the contact-form ?
Hello I'm still a NAV-enduser-newbie, so forgive me if this is a really stupid question :-) I have an extra CustNo.-field on my Contacts-form. I want to take the value of the standard No.-field and put that in the CustNo.-field, but only after the menu-option Create As Customer was executed. I try it this way:…
-
Array of records!
Table: OurTable Field name....Type No................Code Value............Int ... On Card form we have: Variable name..........DataType..Subtype.....Dimensions property OurArrayVariable......Record.....OurTable....3 OurVariable..............Record.....OurTable.....<Undefined> What happens with the table record that…
-
Suggest Vendor Payment with 2 locations and 1 vendor
I have a customer that has 4 locations that share a number of vendors. Each location pays their own invoices, using the Suggest Vendor Payment function off of the Payment Journal. When they run the function, the journal is populated with invoices from all locations. There doesn't seem to be any method to filter out the…
-
Item tracking - Automated creation of Item Tracking Lines
Hi all I order to ensure that the right lot of purchased items is used when using subsequent transferorders, I am considering using Item Tracking So, I go to the PurchOrderlines, itemTrackingLines and key in the LOT info. (And yes, I have entered Item Tracking Code on the items) When I need to move the items using…
-
How to use Option Button ?
How to set two Option Buton ?
-
Export data from Navision to MySQL (Integer Type Field)
Hi everybody, I'm new at using and working with Navision and I have to develop an application in C++ using CFRONT to export data from Navision to a MySQL database but I have problems when the Data Type in a Field in Navision is Integer because it does not export de data (in all the other cases it works). Please can anybody…
-
TableRelation and Secondary key? - help
Can TableRelation property be used with secondary key?
-
Retreiving urls within Navision
Hello, I have a client who needs to retreive data from their credit card processor for reconcilation. This data comes in xml format, and can be retreived by entering in a certain url - if I enter the url (something like https://creditcardwebsite.com/creditcar ... d=password), and it displays the xml. I can then "save as"…
-
Link a table from Navision to Access
Hi, I want to link tables in a Navision database (not SQL-server) and use the native ODBC-driver C/ODBC 32 bit. I set up a file DSN. This works good with the small demo company "Cronus". But doing the same the huge production database > 80 Gbyte (the DBMS cach is set according to the documentation) I have problems. It is…
-
Problem with report....
Hi, I have some problem with my report(with new one - the old one works great).........well, I have 3 dataitems: Classes -->Item ---->Value Entry The old one gives me SUM of "Sales Amount (Actual)"(Value Entry) grouped by classes. The new one should be the same but I need also to show data by months: <labels> class class…
-
Report breaking by Posted Invoice No.
I am working on a report that prints Customer name, NIT No, Amouint and Reserve Tax. Must of the report it's a form I just need those values. I want to be able to type more than 1 invoice, and get a single page with the totals of Amount a Reserver Tax for the ones I enter. My problem is when I enter 2 invoice numbers and I…
-
Navision 4.0 on Windows98
Dear All, Based on Navision 4.0 requirements, the minimum OS is Win2k. Just wonder anyone out there able to connect to server (Windows 2003 with SQL2000) by using Windows98 PC? Thanks
-
error handling
Has anybody been able to handle Navision errors, without using NAS and timers? If there is a way of closing the error dialog boxes automatically without user intervention and continuing with code execution using something developed in VB.NET perhaps? Example code would be great Thanks in advance.
-
ASP - image(BLOB) sql server not showing image correctly ???
Help, The blob image is not populating in the asp page help. <% Dim oConn Dim oRs Dim sSQL Dim nFileID DIM RECB nFileID = Request.QueryString("FileID") 'If Not nFileID = "" And IsNumeric(nFileID) Then Set oConn = Server.CreateObject("ADODB.Connection") Set oRs = Server.CreateObject("ADODB.Recordset") ' Sometimes I…
-
Where did this info come from?
Hi all, I searched the forums to find info about showing the print dialog in word using Navision. After a little while I found a post where a chap said the following code would work: wrdApp.Dialogs.Item(88).Show Indeed it works most excellently. My question is where did he find this out? When I look through the Symbol menu…
-
Statistics screen for quotes
When viewing a quote you can press the F9 key to get stats about the quote. We run a system where the quotes can be in three different currencies; GBP, EUR and USD. Has anyone modified this form so it shows stats in the foreigh currency and could offer tips on how to do it?
-
Tab control VISIBLE properties - help
Is it posible to hide ONLY ONE tab in tab control?
-
Financial Portfolio Management in Navision
Is anyone aware of any add-in granules or of any company that is using Navision to manage an investment portfolio or similar activity? Thanks.
-
Windows Login Issue
Here is the situation. I have 2 servers running the SQL version of Navision Attain 3.6 on SQL Server 2000. The first server is our current live server which is running windows 2000. We are replacing it with a server with beefed up hardware on running windows 2003. Server 1 = Windows 2000 Server 2 = Windows 2003 Server 1 is…
-
Cannot display help.....Action Cancelled
When help is displayed the standard web browser "Action Cancelled" window comes up. This client has Navision installed on an Application server and all users access through the network. There have been no upgrades or (known) updates to IE or the server. Re-installing the client really isn't an option.
-
Expandit Client Control and Terminal Services
Hello, Can anyone let me know if the expandit client control can manage having different idle times for users on terminal services (where they are using the same file to run navision). The trial version counts down fine for individual users, but obviously you cannot specify times. If not is there a way around this or…
-
Error ODBC SQL server driver: Numeric value out of range
When executing report 795 Adjust Cost - Item Entries I get above mentioned error (after hours and hours of executing, so unfortunately impossible to retrace error with debugger) and there is no mention of the error in the SQL event log. Does anybody know where the problem could be? Which table? Which field? Thanks!
-
How to void Direct Deposit?
I was trying to void a direct deposit for an employee in 3.01 but it asked for Repayment Payroll Control Code in HR Setup. Which one do I set up? thanks! :?: :?:
-
debug message question
I searched the forum for an answer to this newb question, and was unable to find one. I was running the debugger in 3.6 to observe the financial voiding of a cheque payment, and encountered some blocks of code represented as "the source code is not available." I can continue to step through and witness changes being made…
-
Credit Memos and Exchange Rate
Hi fellows. This is my problem: We post invoices in Pesos and USD. LCY is Pesos. My problem is on Invoices on USD. Because if we issue a credit memo for this documents, when we post it takes USD values and calculates using Current Exchange Rate. Is this the right way to do it? I would preffer to change it and post using…
-
Difference of two datetime columns caused overflow at runtim
Lads, I got this error whenever a user tries to connect to Navision. A huge window pops-up with an SQL server error as follows: "Difference of two datetime columns caused overflow at runtime" "The statement has been terminated" Followed by a massive error message which you can see at:…
-
Memory Handles on Server overloading
Recently we've experience a problem with the memory handles on our server. One day last week, the server became unresponsive. Seems the issue was determined that the Handle count went up over 200 000 and exhausted paged pool memory. At that point no more clients could connect to the server. It was all we could do to reboot…