-
Error when trying to Alter a Database
Hi Everybody, I was trying to expand a database when i encounterd this error ' you cannot enter 2147483648 in integer. the curser is in front of an invalid character. my database in sitting on SQL 2005. I later created another database, restored but the error was still there. i tried all the possible solutions i could…
-
"Cost Posted to G/L" <> "Adjusted Cost
I'm having a costing issue in Navision 2.6... There are some older item ledger entries where "Cost Posted to G/L" <> "Adjusted Cost (Invoiced Qty.)". What's worse is that these records are marked with "Cost is Adjusted" = TRUE. From this, I assume I won't be able properly adjust the cost on these records using any base…
-
fin.exe cpu usage on Windows Server 2003 Terminal Server
We have a terminal server running Windows Server 2003 SP1. Our version of Nav is 2.6b. Users have been complaining that the terminal server becomes very slow at times. When I check the CPU usage, I see that there is usually 1 or 2 fin.exe processes for different users using between 30-50% CPU. So when it happens with 2…
-
Comparing 2 instances of a Table not working!
Hello Everyone, I usually work in 4.0, and in that version, if you want to compare entries from the same table, you can simply nest a second instance of the table within a loop and can reset, setfilters on the second instance without affecting the instance in the outter loop. Unfortunatly I am having to write a codeunit…
-
report: showing if not present
Hallo, I want to make a report with the following functionality: 2 tables 1 with car numbers, and specifications 1 with driving hours of those cars. The report has to show me all the cars that do not have driving hours. I though with a find and than a curr. rep. skip but i am stuck... Thx in advance, daking
-
distinguish between the environments of test and production
Hello, i'd like to know what methods you use to distinguish between diferent environments. A colleague said to me that a consultant could change the appearance of the client but i don't know how to do it, do you know it? Thanks.
-
account schedule
Hi. all Originally check the new Fiscal year Yearly, I'm going to change the new Fiscal year Monthly I wonder how that's going to affect financial Report, system-integration thanks in advance
-
CaptionML in 2.00D db
Hi people. I need to upgrade a 2.00D DK base to 4.00 SP3 DK. Initially I want to find out what customizations have been made, so I want to compare the 2.00D DK customer db to a clean 2.00D DK db using eg. WinMerge. Here comes the problem: The customer db has "CaptionML=ENU=Tilbud;" i.e. ML captions for ENU but with Danish…
-
How get a record from a sub form
Hi all, I have a form and with a subform. Both refer to same table. But with differents filters. I have a button in the main form where I need gets the marked records of subform table. How can I do that ? I tried to use :CurrForm.Subform.FORM.GETRECORD( MyRecord ) ; But it didn't me bring the marked records.
-
How to lock a record while it is opened by a user ?
Hi, We work on a 2.60 Finanancials version w/ a SQL db. We would like to lock the records for all the headers of every purchase/sales documents. ie when a user is working on an quote/order/invoice... no one can et access to it while the record is opened. Do you see any way to do this ? Thanx in advance for yr help.
-
Windows VISTA & NAVISION 2.x
we have tested Windows VISTA Ultimate german and NAVISION 2.01 and 2.6 and both wont run. You get an error and a mesage "that you will informed when the problem is solved". I read in some other forum that navision 4 with sp2 will work but not with sp3. Have you any experience or hints?
-
problem with automatic charge in bank acccount
Hi, I have such a problem: For one vendor every time the purchase invoice is created the automatic charge is created in ING bank account. Could you tell me what settings are responsible for that, and where I can change that? Regards
-
Upgrading 2.60E,PE1.19BQ
Hello! I'm going to upgrade a customers database now. The problem is that I don't know the exact version of their original database. It's easier to see what customizations that was made when comparing the unmodified database to the modified. When I look in Help-About for their database it says that the version is…
-
newbie Report Sort Question
I am trying to add another field to the sort on report 308, I want to be able to sort the report by original expected date. I have added this to the keys for the purchase line document but when I get to the purchase line properties in the report the DataItemTableView is already filled in with; SORTING(Document Type,Pay-to…
-
phases, task, steps
if missing of phases, tasks, & steps then how adds in jobs.
-
Regarding Item Doubt
Hi, Suppose if i have three companies in navision (ex A,B,C). The item No.(ex 111) in the A company can be able to reflect in the B and C company. In the B and C company the same item No should not be reflected. Is it possible. Can anyone help me out?
-
Looking for Financials 2.01 database with German AddOn
I am looking for old Navision database – Financials 2.01 with German Add-On “Lohn/Gehahlt” - “Kostenrechnung”. Where can I download this old database?
-
How to bring the historical information (postings) in NAV?
Hello, first of all thanks for excellent forum. I'm beginer ERP consultant. I know functionality of Navision very well, but till had no "interaction" with it in real project. I have the following question: how to bring the historical information (postings) in NAV?.. if the company had 50,000 transactions(postings) up to…
-
Zero stock Items -Counting days since inventory became zero
Hi, I have very elementary knowledge of Navision coding. we are using navision Financials ver 2.6. I have created a report which gives a item wise list of items whose inventory Qty = 0 and list of purchase orders in the system (if any) for that item. I want to know if its possible to calculate(Count) the Numbers of days…
-
Navision Payroll
We are a Canadian company and are implementing Navision payroll, both US and Canadian versions. I don't see any payroll related items in this forum - does anyone know where I might find solid Navision payroll information? Thanks.
-
stability is bad when using NODBC
I tried to pick up the data from the navision sample database with NODBC, I found the stability was terrible. Sometimes the process is good, sometimes it is bad, it raised error message:Server was unable to process request. --> ERROR [S1000] [Simba][SimbaEngine ODBC Driver][DRM File Library]The operating system returned…
-
Extra license to navision Financial DK 2.01.A Dk 2.01.B
I need one extra license for navision financial to create one extra report. I am not familiar at all with this software. can any one tell me where i can purchase this extra license? It is kind of urgent. Your help is appreciated
-
Urgent. "the database files are not compatible" er
Hello, we have 2.50 DB on our file server (single-user access, one DB in 2 files each 2GB). My coworker copied the files to his computer but when opened the DB, the timestamps were mixed (the first part opened on his notebook, second one from the UNC path which was in the first part saved). Now we have only the two files…
-
Bookings vs. Billings
Hello. I was wondering if anyone knows of a way in Navision to track Bookings (sales based on orders) versus Billings (sales based on invoices). I am not sure if it is in the core product. We are open to a third party solution if anyone knows of one. Thank you very much, Kevin
-
Network problem??
Hello everyone, I have a problem at a client who is using Nav 2.60 with SQL. One a week they launch a treatment that prints about 5000 invoices for their customers. As you can imagine this process lasts a few hours, especially with them having to supply the printer with new paper once at 500 pages, but, this is not their…
-
Service Tax
Hi All, This is related to India Localisation. Can I calaculate service tax using Fixed Assets in the Purchase Invoice document? Regards, Bhushan
-
Installation Problems on Windows 2000 Server - SP4
I installed Navision Financials 2.6B onto Windows 2000 Server - service pack 4 and it does not seem to install it... it goes about 40% and then the bar expedites to the end and finishes... When I look for it, I don't see it installed. I see some files in my system but on execute it cannot launch
-
Need a new entry number for cust ledger entry
Hi, I have a problem. I need to start my new entries in a new range. My last entry is 550. I would like to start the new entries at 1000. How can I program this? Thanks in advance, JBeck
-
Where to get Navision version 2.00 and techn. version 2.60
We are using Navision and acquired a company that was using Navision version 2.00 and technical version 2.60 in the past. Can we download this versions somewhere to be able to open this historical data? We also have an account to Mibuso so if it is on the FTP site just tell me where so I can download it.
-
Reconciliation report ?
someone who has created a reconsiliation report(form?) - ex: vendor ledger / gl account cust entreis / gl account ???