-
how to calculate totals when writing reports
hi there: I am new to navision and i am trying to get sub totals and grand totals for my report. for sub totals i have the following fields: invt, cost , and value1 and i have manage to get the sub totals write by using the following code: invt:= inventory cost:= standard cost, etc but now i get the same for grand total…
-
Service Management
Good Morning, Newbie here - I was hoping to find some users who are utilizing the Service Management Module in Navision. Is anyone recieving the equipment in through the system? I'm not sure how to do this - and when I clikc the Service Item box on the warehouse reciept, it gives me this error message: "The CalcFormula for…
-
Slow DB performance after restore
After almost a year and a half and no optimizations, a backup was done of a 14.5GB database (Used 94%) (I know, horrible). The database was restored into a 13 GB empty database, now occupying only 9GB (!). One physical file, before and after. Anyway, great - 5GB of optimizations - however, some batch jobs (like Adjust Cost…
-
Batch Receipt Posting in Whse Managment
We are running into troubles when we are posting batch receipts in warehouse management. An error "warehouse entry # already exists" occurs in the middle of posting and when this happens everything up to this error posts and then we can post again for the rest of the receipt. This wouldn't be a problem but a put-away…
-
attain 3.10.a on server2003
Hi all, Im trying an installation of attain 3.10.A on a server2003 box, the installation gets going, and just after the MDAC2.60 part of the installation, you see a roll-back screen, and then a screen saying: "The wizard was interrupted before the installation of Navision Attain 3.10.A was complete. Your system has not…
-
Disable A column of lines On Basis of Header
Hi Everybody, I want to disable a column for a particular Blanket order only when an option field at Header of that order will have a particular value. How can I do this. Pls suggest. Thanks in advance, Seema
-
Prob Install first Database Part in other Location than C:\
Hi, I tried to install Attain 3.60 Database Server in userdefined mode in order to put both the binaries and the first database part into Path H:\Navision instead of using the standard Path C:\Program Files\Navision Database\. When i use the client for creating a database, Attain now creates the first database file (which…
-
Integration of Navision 3.10 with MSDE
Hi, please tell me the way to integrate Navision 3.10 and MSDE database.. Purpose: To pull the data in MSDE into Navision 3.10.. thanks and regards Ganesh.
-
Problem with ADO.Command.ActiveConnection:=aConnection
I have the following code in a PROCEDURE (Navision Attain 3.10) : CREATE(aConnection); aConnection.ConnectionString := LBGen.GetConnectionString; aConnection.Open; IF aConnection.State = 1 THEN BEGIN // adStateOpen = 1 CREATE(aCommand); aCommand.ActiveConnection := aConnection; aCommand.CommandType := 4; //adCmdStoredProc…
-
How to write a query with Navision tables with SQL Server
Hi All, I want to write a query using Query Anlyser of SQL Server 2000. I write the following "select [document No] from dbo.<Society_Name>$[Item Ledger Entry]". The system don't accept this syntax. There is any one who can help me ? Thank you in advance :)
-
c/front dll calling from within manganed c# code
First: We know the the .net wrapper class provided in the download section. But because of the OCX Call Interface is very slow we are trying to connect our application via the cfront.dll to navsion. The casting-problems with ref object-Parameters in DBL_GetFieldData() and DBL_AssignField() are soved by come methods using…
-
backup on client
hi ppl, can anyoane give me a solution for the following situation : i have a main server located in one city and many clients located all over the country, the clients are connected to the server over the internet through user portal module; i want to cover the situation that the connection to the internet fails at one…
-
user report training
Hi there ppl, In about 1 1/2 months time I have to give a 2 day training session to one of my clients on report design and development. The users are not the most technological advanced or comfortable ppl. I am wondering if anyone knows of any good documentation anywhere to which I can have access to, that I can use to…
-
Non permission to read Change Log Setup (Table)
Hi all, When a user is logged in NAVISION ATTAIN and when he try to click on a module, he has a message that he hasn't the permission to read "Change Log Setup (Table)" table. I activated the Change Log fonctionnality. Any one can help me ? Thanks for all.
-
Error Using CPHandler with ASP
Hello I´m creating un ASP page with CP Handler to send XML files to a Queue I use the same code in Visual Basic 6, Viasual Basic .Net and ASP.Net and it works fine But if i use this code in ASP, the server returns this message "Microsoft VBScript en RunTime Error (0x800A000D)" I add my ASP Code Thanks <HTML> <BODY> <%…
-
Flowfields
hi!...any idea for this scenario? i have 2 tables, Tables A and B...both contains customer information...table A has a field that is defined as a flowfield...the field's name is "Amount"...then in table B, i have a field (named "Total Amount") that is also a flowfield and that needs to get the sum of values in the "Amount"…
-
New structure "Chart of Accounts"
Has anybody a solution, which allows to change the structure or the numbers of the CoA on a specific date and to keep the CoA from this date on with two account-numbers? Old number valid until 31.12.04 New number valid from 1.1.05 Standard reports should be available with both numbers. Thank's for any feedback! :) Cheers
-
Wrong PROFIT value because Sales Line-Unit Cost
Please help us about next problem: we think that MBS Navision has wrong concept about field PROFIT (value and Percentage), because it seems to work wrong. We noticed that sometimes our profit is 100% without any sensse. Then we found: - Navision uses field "Unit Cost (LCY)" as referent value when calculate Profit, but we…
-
Printing on continuous paper
Hi! I have a problem with printing on continuous paper from navision attain 3.60. In OS windows xp printer has all the rights properties set to paper format Fanfold 210 x 305 mm - the standard continuous paper format. When I am prompted to print a report from navison the print properties are not set to Fanfold 210 x 305…
-
Display picture in a report
I want to show picture (BitMap file) in the picture box on a report. It I tried with bitmaplist property but get an error "Invalid Device-independent Bitmap file". Can you help me? Thanks
-
calculate a field lenght while typing
hello, I'm trying to put a message any time the lenght description of a sales line become greater than 60 characters (the description accept 100 in the database). But I don't find where navision "stocks" the variable before changing the record. can anyone help?
-
Missing Error messages when post Warehouse receipt
If the reciept have some kind of error, When I try to post receipt in WMS, the message that the system shows for example is "Number of source documents posted: 0 out of...” OK but there is no way to understand what errors occur during the posting process And this is terrible. For some reason the system do not show the…
-
"Nothing to Post" Error
Hi! New to Navision here. During the sales ordering, what are the reasons that may cause the error "There is nothing to post". I was trying to create an order. There is an inventory for the item that I am ordering. But when I try to post the order, the error "There is nothing to post" appears. Hope somebody can help.…
-
Date Formula to Integer
I got the following code EVALUATE(LeadTime,FORMAT(USItem."Lead Time Calculation")+'+4D') How can I change this to Integer? Does any one of you have a manual on C/AL commands? Thank you
-
Fax software to fax PO's as a batch
Can anyone recommend a Fax Software that will work in conjunction with Navision to fax our Purchase Orders as a batch, not individually? We want to be able to hit print and send the entire range for the day to the fax program and have them fax automatically, without having to enter the individual fax numbers each time.…
-
report and his frame
Hi. Have a question. Designing my report I found that I cannot make a frame covering whole my report (and don't you know that report contains a footer that must be shown at the bottom of the page). Putting several shapes and looking at this I found that all of my solutions of this problem seem to fail.
-
Warehouse Management Manual
I am looking for the Warehouse Management Manual for Navision 3.6. I couldn't find it anywhere. Does anyone knows where i can find this manual? I would greatly appreciate it!
-
Retrieving Record from SQL Server 2000 table using navision
Hi, I wonder what is the best way to retrieve a record from a SQL Server 2000 database table with using navision tools. I must write a codeunit that takes required records from a Sql table (for example from the employee table in Northwind database), and want to record them to a navision table; So what is the best and…
-
Codbc
Hi, If I want to couple a table with the CODBC driver I get a choice menu within the different tables. However all tables prevention twice. Does anyone have an idea to resolve that problem? Thanks
-
User Permission on G/L Accounts
This is certainly a problem everybody has encoutered sometimes and concerns permission settings. Giving a user journal posting permissions in purchasing and sales, opens access to G/L Account overview, Balances and Postings. This is due to read permission on G/L Account included in Standard Purchasing and Sales Roles.…