-
Using CODBC in .NET
I am trying to update a table using CODBC connection in .NET. I am able to connect to Navision Database and with the following Code string mySelectQuery = "SELECT * from <Table Name>"; OdbcConnection conODBC = new OdbcConnection("DSN=Cronus_Connect"); OdbcCommand myCommand = new OdbcCommand(mySelectQuery,conODBC);…
-
Automate 5 Task Builder
I need Build a Task with the program "Automate 5 Task Builder". This Task register invoices, in Navision, in differents companys in my database SQL. I need to Know when the process (register invoices) has finish in a company for change company and run the next process (register invoices). Regards.
-
Run codeunits
It's possible to run a codeunit outside navision? for example: from a vb application?
-
3 tier processing for Navision 3.7 SQL & max no. of user
Good day, 2 questions :- 1) I read in the PDF manual w1w1adg.PDF (Appendix A.1) that the maximum number of concurrent users for Navision DBMS are 500. Does this apply to Navision database only or to SQL Server as well? 2) Is it possible to have 3 tier processing for Navision Attain 3.7 SQL? Can Navision Application Server…
-
Analyses by Dimensions is wrong
Has anybody experienced some problems with "Analyses by Dimensions"? The values in this inquiry are wrong . They don´t match with the values in our Chart of Account. This is now the second time within the last 6 months that this problem happens. We are running batch update of our analyses (not at each transaction) and…
-
automatic backup
is ther a schduler on Navision 3.60 sql version to make an authomatic backup????
-
Developed Inventory stock system use for pocket PC
I would like to know about developmention inventory stock used for pocketPC..........Please
-
Adjust cost - item entries
When our client runs the adjust cost - item entries functionality the system is busy for approx 2 days. There are +-20.000 items in the database and +- 110.000 finished production orders. How long does it normally take to run this batch and what are the necessary steps ? What can we do to speedup this process ?
-
C/odbc with MSSQL
Hi to everyone. I create a linked server to navision database with c/odbc in enterprise manager. then i create a view in mssql. when i try to get the field Classe type code from the navison database, i get the error message: Unexpected data length returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]',…
-
mbsonline is down?
Microsoft Business Solution User Group www.mbsonline.org is down? anybody knows what happened? it's really a wonderful forum.
-
Navision Overview Questionnaries
Hi all, I got these questions in my navision overview exam,which really was confusing and unable to answer. If any one have the idea about the following questions can send me a reply with correct answers to: rajufss@yahoo.com I had planned to write my navision overview exam by this month. If u have a question bunch like…
-
Considering purchasing Navision...please help!
Please Help! We are a mid sized manufacturing company who is looking to implement an ERP solution, one step at a time, starting with the accounting portion. A reseller has just informed us that Navision is offering an 85% discount of their product for current accpac users such as ourselves, but that the offer expires on…
-
C/front
i'm trying to connect a navision database with c/front. i have no problems when i try to retrieve information from the navision database, but when i try to modify or insert a record i get this error message: it's not possible to make changes in the database with this trigger ( message translated. the original message has…
-
pulling hair out trying to get c# -> cfront.dll working
Hi all, I see that other people are also looking at using the cfront.dll functions from within c#, I also been playing with this. From what I have read here and elsewhere I think the following code should work. However I am getting; "Internal Error 182 in module 1." According to WinHelp 182L is ERROR_INVALID_ORDINAL,…
-
Group documents based on field from another table
Dear friends, I need some help. I have to redesign report 4 "Detail Trial Balance", just to display totals for documents, not for every line. It works fine ("GroupTotalFields":"Document No." etc.), but - in case of incoming/purchase documents, I need to sumarize amounts for documents with same "Blanket Order No." I tried…
-
Navision Overview Questionnaries
Hi all, I have got this questions in my navision overview exam,which really was confusing and unable to answer. Since my basic qualification is not from functional i couldn't answer it. If any one have the idea about the following questions can send me a reply to: rajufss@yahoo.com Questions 1. What is prerequisite for a…
-
Archive
hi, I just started to explore Navision 3.70 and i m from NAvision 3.01 user. There are this function Archive document in Sales Order function interest me. I have no idea where to retrived all the archived document data. Please help..thank you
-
Expanit IT Backup and Windows 2000 Server
Hello everyone! Hope you all are keeping well. I have Expand IT Backup installed on our Navision Attain Server, but I ahve a few questions I would like answered that are not covered in the help file: 1. Do I use the Windows Task Sheduler to run the backup? As far as I can see, ExpantIT Backup does not have its own…
-
Inserting one record in multiple company
I want to insert one record in to mulitple companies when inserted in any company.Any body knows the script lines ..pls tell..
-
Need help on Work In Progress(WIP - Manufacturing)
hi all, I have to show a demo to the customer in which there is a need of explaining about Work In Progress (WIP - Manufacturing) . How could i explain this to the customer. I haven't got an clear idea on that. Can anyone help regarding this with regards,
-
How to fill a tablebox, with data of a table of database
How to fill a tablebox, with data of a table of database?
-
Problem with DBL_SetMessageShowHandler and c#
Hi to all, i have casting DBL_SetMessageShowHandler in c#, this works fine, but only first time :( , at second error my function is not execute. Any ideas? regards, Arek P.S. sorry for my bad english using System;using System.Runtime.InteropServices; namespace TestAppNav{ delegate void _ErrorShowProc(string Message, int…
-
Is there some kind of a standard Sales Invoice import?
I do not know Navision at all as I am SAP consultant but one of my customer uses both SAP and Navision and their Navision consultant does not seem to be the brightest one around ... :-( Anyway, my question is - is there some kind of a standard to import data into sales and process it as regular sales invoices. What we are…
-
Security Filters and Flowfields
I tried to apply Security Filters. The straightforward approach works fine, but this isn't enoung! I want to filter my G/L entries on Global Dimension Code 1. I now get error messages on Accounts that sum entries (Balance and Net Change) with other Global dimension 1 values. Appearantly it has to be able to read these…
-
Changes in Service Contracts from 3.60 to 3.70
Hy everyone, can anybody explain to me, why in Attain 3.60 it is not possible to create more service contracts for one and the same service item. In 3.70 this does work. What do I have to do to create more service contracts for one service item in 3.60? Thx a lot
-
Outlook Integration
Hi all, Who of you is using the outlook synchronization function in Navision Relationship Management? I need to do a massive use of Meeting type to-dos and Meeting Invitations... Is it possible to include a custom text for any invitation? Is it possible to include in this custom text some merge field like the location and…
-
Need a help in Navision Overview
hi guys, i need a help of somebody else...... i need some basic navisioin overview questions . since i had planned to write the exam by next week.. Also i need some docs for crm module . since most of the people said that the questions will be coming from out of the book .. Is there anybody to help me.... my mail id :…
-
Kill Navision from Inside
Good Evening, how can i kill a navision client from his code? for example, if a form timer arrives at 15 minutes, kill navision. is possible? Thank you so much
-
How to take Online Backup
Dear Friends, I am trying to take Online Backup, I mean even though some users are online we are trying to take backup but we could not able to do this. We Have multiple location so its very difficult us to ask all to logout at the time of taking back up. my Data Base size is : 1.2 GB Server Using : Citrix. Please help me…
-
How much is the license?
I was just curious - who paid how much for a license for Attain? We are a non for profit that is trying to get 5 more user licenses - our NSC is asking $10,000 ($2K a piece) :shock: Any ideas to get a good deall will be appreciated