-
Current Date in CODBC
Hello, Can anyone help me with this - I am trying to transfer (export) data from navision to Sql server using DTS. I need to bring a few records that have a date filter - date < current date - 5 days. eg. select * from job where "Last Midifed Date" < getDate() - 5 days How to get the current date in codbc. and how to…
-
Webshop: IP address has changed - Navision Financials 2.6
Hello all, because of an IP renumbering the URL of our webshop has changed. All links in the webshop doesn't work (mscsPage.URL). Now I want to set the new IP address in the Navision Financials configuration - but I can't find any field describing an IP. Where can I edit the IP/URL of the webshop? TIA Kai
-
Payment Discount Tolerance date
I think I found a problem, has anyone else found this: A customer has no Payment Discount date calculation formula set up. An invoice is posted with a different posting date from the document date. Result - the Pmt Discount date gets populated with the document date, but the Pmt Disc Tolerance date equals the date plus the…
-
C/ODBC too slow
Hello, I read on this forum how to optimize SQL query using C/ODBC driver. (ORDER BY Key1,Key2 ...) It seams this solution doesn't improve as well my queries. Do you know other solution to make C/ODBC faster ? For information, i'm using Navision Financials 2.60A with C/OBDC driver 2.60.01.5350 ; i'm developping with .net…
-
Cannot start Nav Server service on Win 2003 server
Hi there, When I install the Navision server(s) 2.60 on windows 2003 server and place the database(s) on that server everything works fine. When I try to attach a database that is located on a shared network drive the Navision Server service can’t start. I get this error: Could not start the Financials Server XXXXX service…
-
Navision native database and Windows login
Hi all, we would like to use the Windows authentification login in combination with the Navision native database (local databases and server connections). When we select "Windows Authentification" an error appears: Navision Financials has not been set up to allow you to use Windows Login. What do we have to do pls? Thanks…
-
WIP and Finished Goods account
Hi all, Can any one provide me the steps by following which I can update 'Work In Process' and "Finished Good Inventory" accounts? With what values 'Work In Process' and "Finished Good Inventory" account will be updated? what happens when WIP is moved to Finished Goods.? Please help. [-o<
-
Navision - VB application integration
We have just started Navision in integration with a hospital management software which is in VB. Is it possible to code posting groups in VB/VB.net instead of navision. Our requirement is actually like this, we want to be able to use the finance module of Navision without opening the application. That is, whenever a…
-
Insurance for current Asset?
Dear Experts Does Base nav support a feature where I can assign Insuance for current assets like raw materials lying in the warehouse??????? If yes how do i treat this??? If no do i've to customise this feature? Thanks in advance! Warm Regards Shilpa
-
Experience with faxing from navision 2.6?
Hello everyone, I was searching the forum for a solution to fax sales order directly from navision. I found a lot of topics about this subject but they dindt exactly answer my questions. We are looking as said for a solution to send faxes from navision straight away. We have found some options and want to know if there…
-
Nav 2.60 on Windows 2003 server
Hi all, Can Navision 2.60 run on Windows 2003 server? Have a client who just upgraded to Windows 2003 server and was inquiring whether Navision would have any problems running or not. Thanks David
-
Undo Shipment for version 2.60
Hi, I want to try to copy the 'Undo Shipment' functionality into a 2.60 version. Is that possible and, if yes, has anyone done that before? Many thanks. Roelof.
-
how to see profit/loss in given date range
Does anyone know how to see profit/loss as date range given by user. Thanks, Sandip
-
updating server license
Hi folks, can anyone help me with changing the server license ,after it has been installed.Lets say am using a certain license and i want to change or import or replace with another one,how can i do that? :roll:
-
Transfering of Opening balances
Hi All I am in the learning stage of Navision Could any one help me how to transfer the opening balances while implementation is done
-
Capacity Planning
We are considering adding the Navision capacity planning functionality to our live environment. Please comment if you are using this and if you have found it to be a useful tool.
-
Cash Flow Statement in Financial Module????
Dear Experts Is there anything called "CASH FLOW STATEMENT" in Financial module???? If yes where can I find it????? and is it in a form of a report???? PLease reply me ASAP ... My client wants to know like YESTERDAY Shilpa
-
Financials 1.20 question
I am trying to track report usage, I have noticed that running any report triggers CodeUnit 1 - Application Management.FindPrinter, passing the report ID. So, I made a new Table "Report Usage" with two fields "ReportID" and "Frequency" - both integers, then added this code to CodeUnit 1 - Application…
-
I am Navision-screwed.
I have a problem, it's a bit of a story so bear with me. This company bought Navision around three years ago. They have been using it with whatever db software that comes with it (i dont know) and have never upgraded. When I started working here the SysAdmin knew more than anyone about Navision and he never bothered to…
-
Mutiple line posting
Hi Folks,can anyone help with this?if i have a form with the Autosplit Key property set to yes to enable the entry of more than one line of transaction.How and what will be the best way to post these transactions into the Gen. Journal Line without repeating or re-inserting an already inserted or posted transaction. it…
-
Sales Order
Experts, I have a question regarding the sales order. Recently I tested data and found even if I posted the sales order, this order is still left in the sales order form. I want to know in what situations it happens. Thanks in advance!
-
Consolidated Sales Invoices
Hi, I would like to create sales invoices/orders for multiple clients (branches) and consolidate those to one invoice for 1 client (head quarter). Does anyone know whether this is possible? Thanks, Kaetchen
-
Applies from Entry
Dear All, What is the use of Applies from Entry field in Item Journal? Can someone explain with an example? Regards, Bhushan Teredesai
-
How to define the payment team for partial payment
Dear Expert, Could you please teach me how to define the payment team for partial payment in Navision? Or have any workaround solution for the partial payment. For example: This company is selling the customzie goods. And the production lead time is very long, maybe more than one year. Their customer agree to pay them by…
-
c/odbc visual basic .net
I am trying to update a table using CODBC connection in .NET. I am able to connect to Navision Database and I am be able to read data But If I try to update the database with the following code Dim conStr As String = "DSN=Navi;CN=company;UID=user;CC=Yes;NType=tcp;RO=No;OPT=Text;BE=Yes;SName=ip;IT=All…
-
Problem with automation
Hello I can't use variables automation because i can't select this datatype in the list. I have license for it because i have the granule 1,1750 /ocx. My version is Navision 2.60 D. I have used this varibles in previous times without problems but in this moment is imposible. Thank you for the help
-
Navision asking for non-existing no series
Hi all, I recently created a sales invoice in Navision 2.6 and proceeded to post it when Navision prompted me with an error msg saying "No. series TSB-PSINV" does not exist. This TSB-PSINV no series used to be my old posting number but I have changed it some time ago and has been deleted. This sales invoice I created is a…
-
How to edit License File
I want to add session from 22 to 30 or more Because my office run navision Fully Session My Navision Program version W1.2.00.A Thank you.
-
letter problems exporting with dataport
Dear people, I've made a dataport with dataitem:Item and dataport fields No. and Description. If I run this dataport and save the file as a txt file and I open this file, letters like an e with dubble dots are changed in signs like ‡ or something else. My question to all of you is: How can I change my dataport in such a…
-
Navision 2.0 on SBS2003
We are planning to install our exisiting Navision on a new SBS2003 Server. Does anyone have some expirience with this issue? SQL Server is not needed because we are running the native DB version. Thx, Cello