-
Running NAS with a scheduler
Hi all, I've spent the last two days reading most of the posts with regards to NAS but can't find the answer I'm looking for. I'm running NAV 3.6 server with application server installed. Everything works fine, and I have even managed to create new services and run them with diffirent parameters. My problem is that I have…
-
text to option string
we have a code unit for importing text files to create sales orders. for a short term measure, when we import, we need to use one of the data fields to trigger an option field.. the option field defaults to "No", and during the import the following is needed : if data[x] = ABC then option field := yes however, this leads,…
-
ocx and crystal report
i can connect to a database with ocx. Fill in the data in a datagrid. But is there a way to make a crystal report with the input the datagrid? or is there a way to use the ocx in the crystal report designer? only odbc and relevant options are there. using visual studio .net (c# project)
-
Ship to address Report problem-need help
hello when running the "ship to address" report i receive this error and the report does not print. OVERFLOW UNDER TYPE CONVERSION TEXT TO TEXT VALUE: THERMO ELECTRIC DIVISION i edited that particular customer thinking it was the only problem but the report just stops with the same error message and a new VALUE. any…
-
Budget form and G/L
Hi. My customer thinks the Budget form with all its flexibility is a good tool. You can choose periods, filter dates, dimensions and so on. Now he wants the same functionality, but with the g/l!!! First and foremost just the net change for each account spread over each month of the year with drill down capabilities.…
-
Version 3.6 W-2 report does not exist
I have a 3.6 client who started Payroll (US) this year. He would like to check the calculations by running the W-2's. That report does not seem to exist. I checked with VisionPay, and they have been unable to help. I downloaded the db.exe from the mbs site, and the object does not exist there either. I have tried bringing…
-
Vendor/Item Statistics
Hi, This happens on 3.10 for report Vendor/Item Statistics. If I ran this report for company A it works, and if I ran it for another company-B it did not work. I mean if I pull all the value entries for one item and filtered by Invoiced Quantity<>0 within a time rang, the total amount matched for company A but did not…
-
change Log
Hi, I knew version 4.0 have the ability to trace user’s changes on Navision. Does this function also exist on version3.10? Thanks
-
Reading the cancel button on reports
When running a form you can get back whether the user hits any of your buttons (ok, yes, no, cancel and so on). Can this be done with reports somehow? If the user runs the report, gets to the "print", "Preview" and "Cancel" buttons. How can you get back to your menu button (which called the report) whether the user hit…
-
Boolean resetting itself
I have a temporary table in a report. Its a temporary table of Type Purchase Header. And I am populating it with data from a few places. At one point i have this code: PHead."Document Type" := PHead."Document Type"::Order; PHead."No." := "Purch. Rcpt. Header"."Order No."; IF PHead.INSERT(FALSE) THEN BEGIN PHead."Completely…
-
How to block the list button
Hi Dear all, How can i block the list Button so that list form do not show entire list. Thanks in Advance With Regards, Jetinder :roll:
-
Mandatory Field
Hello everybody What's the BEST solution to make a Madatory field in a table?For example how to make the field "Name" in the Table "Company information" madatory?
-
Reserve key In Navision?
Is there anyone experience problem using some of the characters in Navision? I have a problem with FK1 fonts in Navision (CTRL+ALT+;) this character will show in other applications using FK1 fonts. But In Navision it doesn't work show nothing. ](*,)
-
Dynamic picture based on a condition in report
Hello, I am trying to design a report which shows a picture based on an if statement. I understand that it is possible to do this with pictures which are stored into a table as BLOB. Can anyone me explain step by step how this works? First I'd like to know how pictures are imported to a table and second, what code do I…
-
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…
-
Running forms on temporary tables
I am designing a report that reconstructs old purchase orders by adding together all the purchase receipts and constructing a single purchase order. The report then reports on this table. To test this I would like to see the contents of the tables I have created, which are temporary tables declared in my GLobal Variables…
-
Report cover sheet
Hello All When running sales quote for a range of documents i.e. remove the quote number, I want to insert a cover sheet for each document. I have tried a number of approaches i.e. insert an integer data item but anything I do seems to corrupt the layout of document so that the standard header prints twice on one page etc.…
-
Two database servers problem
Hi all. Does somebody know how to install two datbase servers on the same pc. I know you can install the first one and then copy the folder where you installled to another location. But still if you check the services in the control panel, there is just service for the first intalled server. How can I add the second…
-
Is it compatible?
We're going to change hardware. From one server to a cluster. Now we have a "standard" hardware setup : One server Compaq Proliant ML-370 1GB RAM Native database (3.60) Database size about 20 GB ... We're going to a cluster, ... Do we need to migrate to SQL, or we can stay at 3.60 with Native database? I don't know…
-
one line transfer order - several lines in item ledger
hi question's day :D 3.6 version i have the following situation: one transfer order with just one line. item x, ten pieces. when i post the shipment of all the ten pieces, the system does in item ledger entry several lines with different quantities. the sum of this quantities is ten, which is correct, since i've shipped…
-
I need a report to list my ship-to addresses
is there any report or way i can get a list of "ship to addresses" from navision? thanks brian
-
Planning Worksheet ,Inventory Shortage , Inventory Forca
Dear All, :roll: :cry: Please help me for the following to topics in navision. 1. How can i run the planning worksheet please write the steps. 2. How can i find the inventory shortage list for my production order. 3. On the basis of current production how can i forcase my inventory requirements if i want to increase my…
-
Client hangs on posting
The client is running 3.60 (upgrade in the works) with a 45 GB database. The server is undersized but posting were working fine (slowly) until yesterday. Now when a purchase invoice is posted, the client will hang (task manager list Navision as not responding). If the task is ended and then you go back into Navision, the…
-
how can we create folders ?
Hello, I have a problem, I want to create folders with Navision 3.10 but I don't know how I can do that with C/SIDE. Can you help us ? Thank you.
-
exporting Customer ship to addresses
hello i have many customers who have 1 bill-to address but several ship to addresses. where do i find the additional ship to addresses in navision so i can export them? thanks brian
-
how would i...
how would i export my sales orders. my question is actually -what record name do i need to call up to obtain all the info in my sales orders? thanks brian
-
Data retrieving from table
i am trying to get some data out of records from a database database is 3.6 and driver is 3.7 programmed this code in visual C# .net what i accieved: -connecting/disc to database -open/close company -listing of tables -open/close tables -listing of fields of a table I am trying to get the data out of a record with…
-
LS Retail Replication Error in SQL Server Database
Dear All, Whille trying to connect to SQL server for replication in LS Retail I found that application is throwing an error "The LSRetail40001_HO_Data.mdf database does not exist on the EIS37 server." Though in database--> information is showing the particular MDF file. To be more specific I am giving the details that I…
-
Multiple Navision servers problem
Hi guys. Does anyone know hot to instal multiple navision servers on the same pc? I would like to have all the servers listed in the services list. I heard that you just have to run the "Schemaxt.exe" that resides in the instalation folder. But things just don't go that easy. When I try to run that program, it said…
-
Comment Lines and Option Type
I put a new option in the Purch. Comment Line table. I added it to the end of the string for "Document Type". I have a copy of the Purchase Header form and on this i added a button to open the Purch. Comment Line table form. However when I look at the Table Filter (Ctrl + F7) on the comments the filter on Document Type…