-
Upgrade Client Process
Hi All, We currently run Navision Attain 3.60 running on SQL Server 2000. Performance and general stability have both been continuing issues to deal with but I've been advised on several occasions to upgrade the client to 3.70 as it's 'More Stable'. I went to log into our 3.60 database using a 3.70 client and got a message…
-
Attach document at 3.01 version
Hi There, Any one knows how to attach a document at Navision 3.01? Scenario: Attached a Sales.doc at the for a sales order document. How to go about it? Thank you. Cheers Rachel
-
Report transfooter printing on next page by itself
Have a report in Navision 2.6 where we print the company logo on the bottom of each page using the transfooter. Occasionally, the transfooter does not print at the bottom of the page, but at the top of the next page. The page numbers are printed on the report, so Navision knows it is on a new page. It seems to be tied to…
-
Inventory Management
Can anyone tell me where can i find the Inventory Management pdf manual?
-
No rights to read Change log, when is not activated
I have problems with the license, when using a customers license that has no right to this funtionality in a cronus database where this funtionality is not activated. When I try to do any change (for example insert a new Sale Order), I got the message ' No rights to read the table Change Log Setup'. All the tables…
-
Cust./Vend. Ledger Entry Bug or what?
Hi, I wonder did anyone notice and knows is there any purpose that fields Amount and Amount (LCY) in table Customer/Vendor Ledger Entry have the same CalcFormula?! They are both reffer to the same field in detail. cust/vend. ledg. entry - AMOUNT. Is there reasone for that (???), or it is just a small bug? Tnx, in advance!
-
Header and special type in XML document
I search for a solution to get the following results: The xml-Dokument should have a header like this: <?xml version="1.0" encoding="ISO-8859-1" ?> Some nodes should have the extension "type.." or "version.." <PARTY_ID type="buyer_specific">0662406</PARTY_ID> or <ORDERRESPONSE version="1.0"> How can i specialize a node…
-
SETFILTER & OPERATORS
what is the correct syntax for use logical operators with SETFILTER? I try with GCP.SETFILTER(GCP."Gen. Prod. Posting Group" , '<>''') but doesn´t work, The system tell me "the filter '<>'' is invalid, An apostrophe (') is missing in the filter". As you can view i need filter a non blank field. P.D. Sorry about my english…
-
How to receive the record selected on a lookup form?
Hello, I've a problem with a lookup form: this is the code in a field. When I enter the field a lookup form appears and the user can select a value. lrecschadeaard.RESET;lfrmschadeopties.fctSetParameters('PLAATS');lfrmschadeopties.LOOKUPMODE(TRUE);lfrmschadeopties.SETTABLEVIEW(lrecschadeaard);IF lfrmschadeopties.RUNMODAL =…
-
Automating adding jobs to Public Folders
Version Info: Currently, we are using 3.01, but will be upgrading to 4.0 this summer. We do not use SQL server version - just C/Side. Right now we have a lot of duplicate entry happening and I would like to set up some automation to resolve this. When a new job is set up in Navision, depending on the job posting type, it…
-
How to get Ext Doc No for 2 payments with same Doc No?
Hi all, How can i get the Ext Doc No for a payments in cust. Ledger Entry if there are more payments line with same Doc No? Scenario : At Payment journal, user key in information as below. Does not have balance amt for Line 10000 and 20000. The balance line is Line 30000 : Line No : Acc Type : Doc No : Ext Doc No : Amt…
-
Terminal Server installation loops
When I call the mail code unit from a terminal server client, Navision tries to install again. If the user has enough rights, it will finally loop enough times and open outlook. But the next time the same user calls the mail code unit, the install comes up again. I have read the previous posts about this and tried the…
-
Navision 4.0 Documentation
Does anyone know if there is Manufacturing or MRP documentation available yet for version 4.0?
-
Text conversion error
One of our clients running Navision SQL 3.60 gets an error message when they select Tools, Options. Error: “There are errors in the text conversion (text no. 2355-153 doesn’t exist in the .stx file) Internal error 47-1” . This happens in all workstations. They removed and reinstalled 3.60 and get the same error. They…
-
Do not Tax Area Code value on Customer Ledger Entry
I got Tax Area Code 99000000 that adds 15% to the sale. But the problem is with this Code number I do not want to include the tax amount to Customr Ledger Entry. Had anyone of you do it before? Thank you
-
computer name with environmental variable
hello! i'm looking for an easy way to find out the current computername. searching the forum i found a topic where the environmental variable %COMPUTERNAME% was mentioned. well, but how can i read this variable? i tried outsCN:= ENVIRON(Computername); but the result is nonsens. environment: windows 2000, navision 3.60 can…
-
Could not register a dll
I've try to reregister an dll in Navision 3.60 but I've receive the following message: <<Could not register a OLE control>> Is the first time when I try to work in C/AL with function from dll. This error came because is normal dll and not an activex dll or becase the dll wasn't make to be register in the system?
-
How to import 2000+ Item images
Hey! Can someone please tell me if (and how) it is possible to import over 2000 articles images with some code .. I know how to import them manually but 2000 is a lot of picture :shock: Thank you for your time!
-
Copy Company information from one company to the other
Can any body please tell me where i can get the objects for the information copying from one company information to the other Thanks in advance
-
SQL Navision Licensing Method
Hi All, I have a problem with flf files. This is the situation : i have a W2003 with SQL2000 server and a navision SQL database. My License do not permit to save it into db. What can i do to delete the messages like "This licenso do not permit a number of company > 0 and the name is CRONUS...bla bla bla" or like "This…
-
Navision NAS 3.6 error
After having updated W2K Server with KB834707,883935,841356,840987,841533,824151,833989 the NAS Server returns the following message when getting an inbound file from MS Biztalk through Navision Commerce Gateway Request Server: This message is for C/AL programmers: Could not invoke the member add. The OLE control or…
-
Excel automation + PDF
I need to create an Excel file from within Navision and then I need to save this excel file as a .PDF file, in order to do this I need to execute code similar to this excel macro from Navision " ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _ "Amyuni PDF Converter on LPT1:", Collate:=True" i have this…
-
Written Lookup for a FlowFilter
Hi all, I am trying to write a lookup code for a FlowFilter, I am able to retrive the filter i want into a temp Code variable, then i want to try and set the filter. It is not working very well, if i use SetFilter(<FlowFilter>, TempCode); it does set the fitler, but when i press "Ok" on the "FlowFiler" form, it does not…
-
C/SIDE 4.00 Bug?
I've got a nice one... . 1. Open a default CRONUS database. 2. Go to Object Designer, and Open form 201 (Job Journal) ... I've got 3 lines in my default CRONOS ... if you haven't, just insert some lines... . 3. Go to Designer, and go to "OnFindRecord" 4. Insert 1 comment line (e.g. "//***") 5. Run the form again ... . IT…
-
Navision and Windows 2003 server service pack 1
Does anyone know if Microsoft have released a statement regarding what versions of Navision are supported on Windows 2003 Server service pack 1. Thanks Chris Finlayson
-
Finding this word "O-Ring" on Description field fr
I know is something simple, but I do not have an idea how to do it. I need to block all items on the Item table, that includes "O-Ring" as part of the description because we can not import those items rightn now. (We do not have an special document our goverment is asking us and I do not want Customer Service to quote…
-
How To Import data from Excel into Navision table fields
Dear I am trying to import data from excel into navision using excell buffer table and report already existed (Ask for file name and sheet name). That works fine but the problem i am getting is that I want to import data from first two column (ie A , B) from excel sheet into my navision table in 2nd and 8th (column or…
-
Sample questions for Trade & Inventory Certification
Hi, Can somebody provide the sample questions for trade & Inventory certifications. Regards
-
Post and Print
I have encountered something I find very strange at one of my clients. When attempting to Post & Print from the General Journal, the batch posts, but nothing is printed. My client swears that it used to work and then one day "just quit working." Not truly believing that she was doing everything correctly, I reviewed it…
-
Inventory Card, inventory, date filter.
In table Item, there is a field Inventory :) But... it is flowfield and in its sum formula, it doesn't have reference to Date Filter. To simplifie, inventory value does not change if you change date filter. Does anybody knows why is this setted in this way? I notice that there is a field in customer, vendor and some other…