-
ODBC - Call Failed
In MS Access I linked 2 tables from Navision Attain 310A that hold similar data. I then created a query for each linked table to show only the fields relevant. I then created a UNION SQL statement. When running the SQL statement SELECT No_,Description,Quantity FROM [Order Details] UNION SELECT No_,Description,Quantity FROM…
-
Combining tables in form?
Maybe I'm just too dumb to get those matrix boxes to work, maybe there's even a better way of doing it: My aim is to create a form (view only) for the "sales invoice lines" However, I'd need some fields from the "sales invoice header" , e.g. "currency code" and maybe some more. I thought Matrix Boxes would be the way to…
-
Hotfix for 3.60
Hi, I was wondering where can I download hotfixes? Thans in advnce Ivana
-
Problem with Item No.
Hi, Yesterday I found a problem with Item No. For Example. If you have an article with Item No.=CISCO and other article with Item No.=CISCO-00 and when I'm making an order and I want to select the Item with No. CISCO I can't because Navision is always refers to the other artice with No.=CISCO-00 Can this problem be solved?…
-
Report problem....
In design-time, some of the text controls have bg color and border, but in run-time they don't have either border or bg color........???? Why??? btw, BackTransparent property is set to No.
-
Requisition Worksheet Surplus calculation
Hi everybody! I am trying to use the Requisition Worksheet in Navision 3.70 with Replenishment System = Purchase, Manufacturing Policy = Make-to-Stock, Reordering Policy = Maximum Qty. All the other planning parameters (reorder point, maximum inventory, etc.) are set to zero. I don't use SKU. I have noticed that for some…
-
3.60 running on SQL. Problem with permissions / fob-import
Hi! I have a problem importing objects from a .fob-file into a DB running on SQL Server 2000. I use windows authentication to logon to the Database and my user has only ONE role attached which is SUPER and it is NOT restricted to one Company. The errors says: The following error occurred .. 3704,"42000",[Microsoft][ODBC…
-
3.01 database under a 3.10 database server
Does anybody know if I will encounter any problems when I use a 3.10 database server to run on a 3.01 database? :? Thanks in advance! :)
-
Logistic system in Navision
Hi Folks, Has anybody created Logistics system in Navision. Any information would be really appreciated. Regards SB.
-
ODBC Driver for 3.01
Where can i find ODBC Driver for version 3.01b
-
3.10a db into SQL
Hi all, IM trying to restore a 3.10 database to sql2000, I've run into lots of errors - mostly that SQL doesn't like the 4 digit year that navision puts in - fixed those and then backup - and restore again. Now I've run into a "Numeric value out of range State ID: 22003" Any idea where I can look, Perhaps Im going about…
-
Manuals for my company inside Navision's Help Topics
I want to start writing manuals for my company, and i want to put them inside Navision's Help Topics. Does anyone know how? I have Navision Attain 3.01b
-
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…
-
differences btw NAV.CMR and MS CRM
Hi! could anyone tell me which are the main features/differences between Microsoft CRM and Navision Attain CRM? How easy is it, or not, to link both packages to each other? Thanks. Zin
-
Dimension update in the record
The task is: I have new created form-card with 2 glob. dimensions. Also i've made code in those triggers onValidate() to get descriptions of the dimensions. When i change them dirctly on the form it's work ok, but when i try to update them from "default dimensions" form onValidate() triggers dose not work and descriptions…
-
Menu Designer
Hi everybody: How can I hide an option on the Menu Designer to be only visible for certain companies? I got Form 44 - Credit Memos, on the form I got Post button inside this button I added an option call Returh Authorization but I will like to let only certain companies to see it. Thank you in advance
-
HELP! Message status UNSENT in BizTalk Outbound Table
We have got two Navision db's communicating through BizTalk over the Internet. While being sent and received some messages on one site keep the status Unsent in the Outbound Table. What is going wrong? NAS performance problem? Did anyone ever setup an ISDN dial-up connection with BizTalk, I invite you to respond. Thanks,…
-
Dataport: Problems with Text >= 50 Chr
Hello, is there a limitation in the length of textvalues when im- or exporting through Dataports (additionally to the lenght of the Table field)? Example: Field of type "Text", lenght 200, part of primary key: Im- or Export stops if the value is more than 50 characters long. Error: "The lenght of the source exceeds the…
-
Navision Solution Center / Customer in Shanghai
Dear all I would like to share my experience in Shanghai with other Navision Customers/Users or would like the information which Navision Solution Centers in Shanghai are available. Can you give me any contact?
-
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.
-
How to use copy and paste with gimp ???
Hi folks, I would like to create a form with an image, in which I want to place an arrow. Therefore I would like to paste an arrow into gimp so that I can save this arrow as a picture. Does anybody know how to place/paste an arrow (or any picture) into gimp? Thank you very much!!!
-
Problem with 2.60 fin compressed I/L
Hi, i'm trying to migrate our customer from 2.60 fin to 3.70A Navision and having trouble with compressed I/L entries & codeunit 104049 in UpdateItemApplEntry(). This function takes place after the UpdateItemLedgEntry(). Some of his Item Ledger Entries have been compressed & it seems the migration processes the I/L but is…
-
Problem using HotCopy
I’m getting an error message when using HotCopy. I’d tried everything but I don’t know what to do anymore. Does someone have any suggestions? Thanks, Henry
-
License problem
Hy ! i have a very big problem with license in Navision(Sql option)! Every time i try to enter in the database,i receive the following error message: You do not have permission to run the per -database license System! i used my developer license first,and then my client license! Can you please help me?
-
Dimension problem
I have the following problem... When introducing dimensions in General Journal,in the journal lines(using Shortcut Dimension Code 1 and Shortcut Dimension Code 2),sometimes it coppies the dimensions into the Journal Line Dimension,sometimes not! Can somebody tell me what to do? I heard about about a hotfix who solves this…
-
User Portal developer's Guide
from where can I download User Portal developer's Guide?
-
C-AL problem...
How can I get all records from some table, for example: FOR i:=firstrecord to lastrecord DO BEGIN price:=price * 80; END; This is just an example what I want to do, but I don't know how :(
-
Non Stock items/ Service items transactions
for service item, where do you set them up on Navision so as you can process them on a sales order. for instance Transport services, cabling services... If you set them as item, they will go to negative stock. If it is on GL, there are too many services to set them up on GL accounts. pls advise
-
problem with Upgrade 2.0 to 3.7
I am using the Upgrade 3.07-06 tools I am encountering and error message with codeunit 104048. Error message reads: The remaining invoice quantity -6 of date compressed Item Ledger entry 2195 cannot be assigned properly to Invoiced Quantity of related item ledger entries. You have to update the related item ledger entries,…
-
Alternating colour lines on reports
Greetings, I'm busily writing reports for Navision. I do have a sylistic question in regards to reports though. I've just finished creating a report that shows which part is used in which product and their count... but the readout is hard to follow. Instead of separating everything with a bit of whitespace, I was wondering…