-
Data conversion problem with Excel automation objects
Hello, I made a development using Excel automation server in order to get some data from Excel worksheets into Navision. Everything seems ok until I get an error concerning a data conversion. I'm warned that text could not be converted to date. The entry on the Excel sheet is a legitimate entry but Navision doesn't accept…
-
Implement WMS Bins in a live Location - 3.60
Hi there peeps, Our customer currently uses v3.60 HF26. They have a number of locations with no WMS. We need to implement WMS, Zones and Bins etc, and have selected the Use Zone and Bins tick box. We have followed the recommended steps of checking and resolving negative invetory, and the process has created Whse Entries…
-
Cannot Filter On Primary Key
Something strange has happened & I'm wondering if anyone has experienced this. For some reason I can no longer filter on Cust#, Item# or Vend#. I can filter on anything else ...city, st , zip , etc... i'm talking about F7 filter here. Yes I deleted the zup and nothing changed. I can filter on order & po #'s too It may have…
-
Error writing a xml content with MSMQ
Hi everyone, I'm trying to send a xml file content to a MSMQ that will be read by a C# application. The NAV code set a Item record filter by "Service Item Group" and than use u XMLPort to get the data generated. For now, i've simplified the code just to print the xml content, and i'm getting this error: The length of the…
-
Upgrade 2.6 db to 3.6 db after opened 2.6 db with 3.6 clien
Hi! I have an customer who is using 2.6 db and client. Due to some changes in the remittance functionality they have to use a 3.6 client. If I open the database with a 3.7 client, is it possible to later upgrade the database to 3.7?
-
SQL replication and Navision attain 3.60
Hi everyone, I'm testing SQL replication as another backup method. The replication seems to work fine. That is until I run the Navision Attain client 3.60 and came up with the following message "The <database name> database on <server name> server does not contain Microsoft Navision Attain system objects and cannot be…
-
Purchase Receipts and GL Entries
Can anyone give me specifics on when Purchase Receipts produce general ledger entries and when they do not? I believe it is tied to the Inventory Posting Group on the Item Card and deals with direct and indirect costs, but I'd like some confirmation. Thanks in advance for your help!
-
Version error
Hello All, I've programming an application in c#.net which should open a connection to navision 3.60 database. I have added a refference from the cfront.ocx to my project. When I try to open a connection to my database, the following error occurs: The server and workstation don't have the same versionnumber. What could…
-
Integrate Navision With RFID
Hi all, We are trying to integrate Navision with RFID... The question is, how to do that? Should we make use of the ADCS functionality that is availalbe in Navision? If yes, how should we make use of that? How to communicate with the RFID devices? Is it just something like reading from barcode devices? But for barcode…
-
Error 1232 in module 19 - Attain 3.10
A client is experiencing occurances of Error 1232 in module 19 in the event log on their server multiple times during a working day. All postings refer to this error as packet problems on the network recommending that the network should be check. My dilemma is that the network has been checked and no problems have been…
-
I'm a stupid man - Erase a database part
Hi every body... I'm a stupid man, but I need some help, your are my last chance... I had a big database 20 Go (space use 17 Go) and (because I'm stupid) I have extend it with a little part (100 Mo) just for test... And of course I have erase the fdb file of 100 Mo... because I forgot what it is... 8-[ Now my problem, I…
-
Showing prices of what we sold for..
Navision 3.10: I am trying to pull up a list of all items we sold last year to Sears and at what prices we sold them to them for. Anyone know how I can do this?! Here's what I have figured out currently: Goto Inventory -> Item Reports -> Item Sales by Customer Then click Item Ledger Entry and under Source No. put SEARS001…
-
Does Navision use one license?
Our company has 8 licenses. One came with Navision 3.10 and 7 we purchased via a yearly fee. We are not running Jet Reports that I know of because nobody in the office knows what they are. We can only have 7 people in at one time, so I'm guessing Navision uses one of those licenses?! .. and if so why does it have to?!
-
Filtering by pictures?
Is there anyway to filter Navision 3.10 to show me only items that do NOT have a picture? Then I can copy them into Excel and print out. I'm trying to easily find all new items for the 2007 season that I need to add pictures to.
-
Chart creation via Excel automation
I automate the Chart creation via Excel and use code like this: VAR XlApplication: 'Microsoft Excel 11.0 Object Library'.Application"; XlWorkBook: 'Microsoft Excel 11.0 Object Library'.Workbook"; XlWorkSheet: 'Microsoft Excel 11.0 Object Library'.Worksheet"; XlRange: 'Microsoft Excel 11.0 Object Library'.Range"; XlChart:…
-
Navision 3.60 native
dear all, I have a problem when setting default printers in navision. I have four kyocera FS 3900DN installed on a server (each printing to another drawer of the same printer). On a few clients I simply add these printers and then go to printer selections on one pc. I change each report so it prints on the correct drawer…
-
Navision 3.60 Payroll Eear End Update.
Anyone using Navision Payroll with 3.60 customers? WHat are you doing for year end updates of W2, W3, Mag-media etc.?
-
Batch post - error
Hi All, When I am running batch post (purchase invoice), It doesn't give me the error message , just come out of the code and says ' 0 out of 1 invoices has been posted". But when I run post invoice, it gives me the error message. is there a global error handler which knows if its batch posting not to show message?? ](*,)…
-
Close Navision automatically
I want to close Navision automatically, so I use the following sentences in a form: CREATE(wscript); wscript.SendKeys('%{F4}'); This executes ALT+F4 and close the aplication. This is running ok, but the problem is the use of SendKeys. If the user it’s running another one aplication, the system close this aplication but not…
-
Navision 3.60 Cache limit 600 MB
I have a problem with Cache limit of 600.000 on a Navision server v3.60, in servers manual it sayes that cache can be set to 1GB, but i can not start the server if cache is set to more than 600MB. Do any one have a solution on this issue?
-
Dataport misses first key field.
Hello all, I am new to Navision, so apologies if this is a basic question, but I am getting a strange problem when importing data from a CSV file into the Item table. Here is an example of the file: "115124","","","BINDERS, Medium (Mechanical)" "115131","Cont. Binders","Cont. Binders","BINDERS, Contaminated"…
-
Problems while starting NAS
When we start a NAS it works until it gets to a Validate, then it gives next error: Your program license does not permit use of the datatype action. We tried with our partnerlicense, with almost everything enabled, still the same error. Anybody ever had this before?? Please help, we're getting desperate
-
Problem while making receipts in cash receipt journals
Dear Friends, Here is the problem which I am facing while making receipts through cash receipt journals and general journals. 1. For the first time when journal line is filled and moved to the next line the previous line is getting deleted and is getting stored in the general journal table ( Suppose the Line No. be 10000)…
-
Backups
Hi ! We use navision with SQL-server database. Every now and then we create a fresh test environment by using Navision total backup from the production. But in this case the windows usergroups are also created from prod. basis. And we also lose all reports under construction in developement. What would be the best way to…
-
Navision performance issue
Hi all, I have a performance issue for a Navision 3.6 SQL option database. The details are as follows. 1. server Nec 5800 120 lh, 4 GB Ram, raid 5 (5 hdd on 10000 rpm) - recently full updated will drivers and others 2. database on raid 5 and t-log on different sata hdd. 3. 30 concurent users on 13 gb database (9 months of…
-
Installing Navision / Pointing to database..
Our network tech formatted one of our machines and reinstalled the Operating System. He installed Office. He installed Navision. He didn't point Navision to our database before he left (he lives over an hour away from our office) and we can't use Navision on that machine. I know how to do it, but it's giving me the message…
-
Reverse receipt when inventory WAS negative
i need to reverse out a purchase receipt BUT when the receipt was done, inventory was negative. For example: Inventory was sitting at -2, guy came and received 3 on purcahse receipt bringing inventory up to +1. He realizes that he shouldn't have done the receipt and ask me to reverse it for him. When I try to reverse the…
-
Date Not Equals To 0DT
Is there any way within a SETRANGE or SETFILTER i can specify the date is not equal to 0DT?? Thanks
-
[INCADEA] Service Management
Problem: I have an order in the service management menu with an already invoiced labour line... All items have also been posted but not invoices. How do I delete this order if the entries have already been posted and there's one labour line already invoiced?
-
Blocked Items
:?: Hello All, I am using Nav 3.6, and it allows me to enter in a blocked item on a service quote, is this standard a bug or is there something else on the item card that needs to be done. Thanks in Advanced Thanks Mark, At the moment our sytem is set to show a message when entering in a blocked item, currently this…