-
NAvision Error
I don't know which seems to have a problem between my fin and OS. An error message keep on bothering me and eventually closes Navision. The error message goes this way--The Operating System returned the error (6): The handle is invalid. What could be the solution for this? Any help is highly appreciated! Regards!
-
variant in requisition worksheet
Hi To All memebers Plz sort out the problem as soon as possible How to calculate plan in requsition worksheet when Item is attached with varints.It is giving proper calculation when we are calculating for the first time.when we to try calculate plan again after posting it to create the Purchase Order using Function-->Carry…
-
Another French accent character problem
Sounds like a common problem, but I'm still searching for a solution, regarding French accent characters. I have already searched these forums for terms such as "Character Set", "Code Page", "Collation", etc - but no solutions that were evident for my situation (for example, I have downloaded and utilized the "Ansi2Ascii"…
-
How to allow the user.....?
How to allow the user to sell items from one location and to have the possibility to see items on other locations? Thnx
-
What's happened with W1 05-011: Navision Attain Development?
This exam doesn't exist anymore(PearsonVUE)................anyone know something about that??? :shock:
-
SQL user not found - 15401
Hi All, I have a client running Navision 3.10A with SQL Server. When I go into Navision and try Syncronise I receive the following: (Error Message 1) Click Ok if you want to revoke Windows login DOMAIN\User1 from Server SERVERNAME or click Cancel to allow login to remain granted. This message appears 4/5 times for…
-
Post Transfer with not enough quantity in Transfer-from loc.
Hello, we have problem with customer who insist to post Transfer Orders in case that there is not enough quantity on Location that is Transfer-from. We can modify Codeunit 22, just to ignore that original ERROR: ... WITH ItemJnlLine DO BEGIN IF ItemLedgEntry.Open THEN BEGIN IF (((ItemLedgEntry."Entry Type" IN…
-
Convert Date To Text
Hello: I need to filter by posting date the item ledger entry table, but I try with this code: ITEMLEDGERENTRY.SETFILTER(ITEMLEDGERENTRY."POSTING DATE", ''<=JOBJNLLINE."POSTING DATE"') The error message says that "JOBJNLLINE."POSTING DATE" it´s not a valid date I need to conver JOBJNLLINE."POSTING DATE" to a text? or are…
-
Password protection
Hello, im very new to navision and i want to set up passwords so people cant get into other people's files. does anyone know how to do that?
-
Mail merge in word
Is there a possiblility to merge with word using bookmarks. It is working it only generates 1 document of the first record that has been found. This is a short list of the code. NameBookmark := 'BLWNaam2'; WDApp.Visible :=TRUE; WDApp.ScreenUpdating(TRUE); WDBookmarks :=WDDoc.Bookmarks; WDBookmark :=…
-
Report to excel problem
When I run a report that exports data to excel it stops at 999 lines. Have anyone a solution this is the code i use CREATE(xlApp); xlBook :=xlApp.Workbooks.Add(-4167); xlSheet:=xlApp.ActiveSheet; xlSheet.Name:='Mailing'; IF Contact.Name = '' THEN BEGIN ERROR('Geen relatienaam bekend.')END ELSE BEGIN //Colom headers…
-
ExSION Reporting integrates Excel in Navision!
It has almost been a year since the introduction of ExSION Reporting for Navision. ExSION is based on Excel and it refreshes Excel-reports real-time, within seconds, from the Navision native- or SQL database. We have been pretty busy because the tool is really doing very well, specially after we added new functionality to…
-
Problem with debugger
Hi, I have a problem with Debugger in Navision Attain 3.60 - it simply doesn't work. I opens a empty window, and all the debugging options are grayed. I tried to remove it and then ran the reinstall, but no change. If anyone knows how to solve this, pls. let me know. Thanx.
-
Populating a field in the Vendor Ledger Entry table
Any ideas where to populate the "External Document No." when creating a "Financially Voided" transaction in the "Vendor Ledger Entry" table? This would allow our accounting department to filter on "External Document No." for a particular invoice number and have all entries returned that have to do with that invoice.…
-
Auditing - is there a way to track adding and removing users
Is there a way to track adding and removing users to Navision. This is for Navision 2.6 MS SQL Server option. (We need it to meet a Sarbanes-Oxley requirement.) All the users are via Windows login. The Windows Login table in SQL Server does not show the user name, just a character version of the SID. The only way I can see…
-
Objects as text, Developer Toolkit
We have a problem whith importing objects in text format becuse we must change a file to import it.This is because we have break lines on inappropriate places,usually on multilingual captions(ENU and localised) and when we have many parameters in some functions. We can't work with DevTool because of it. Do you have some…
-
Printing over Citrix
Does anyone have experience in printing Navision documents over Citrix? Our client can’t print with software combination: W2K SP4, Citrix MF 3.0, Navision 3.60, Novell iPrint (IPP - Internet Printing Protocol), Kyocera 1920. They say it's no problem if they print Word document over Citrix & Novell iPrint.
-
Change Base amount for Invoice Discount
Hi everybody, Is it posible to change base amount that will be used for calculation of invoice discount. I have line discount, but want to add invoice discount in percentage that will be calculate on Quantity*Unite Price not on Invoice Amount which is differenet (less) because of sales line discoun. Here is an example: -…
-
Outlook question for experts?
Hi. I have a small problem. I want users to be able add attachments to interaction from their custom outlook folder. Everything is ok until a outlook mail folder contains only a mail messages, but sometimes there are some tasks or appointments also. How to detect an item type (class). My code is something like this:…
-
Add Company Logo to Sales Invoice
Hi there, I am trying to add a picture (which is the company logo) to the sales invoice (Report 206 Sales - Invoice). Following are the steps which i have done to add the picture to the invoice: 1) Add a picture box at the PageLoop, Header (1) section 2) Then, I set SourceExpr = CompanyInfo.Picture But when i compiled and…
-
Native Database Recovery
Regarding my error. I had deleted my native database which on the local drive. :cry: I tried to recovery by easy recovery professional. It completed recovery without any error. However I cannot open this database. It is display the error message as follow: "The database file cannot be used with this version of the…
-
MessageQueue with Navision
Hi, I'm using webservices to communicate with Navision. I used the code present in html page :http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnav/html/nav_accbizlayerws.asp. I created two messagequeue: one to send message to navision and the other to receive the response of the message sent. The code of…
-
Database Corruption in 3.1 on Table Sales Invoice Line
Hi, Can anyone help me to recover the data from the below problem As soon as i login it says there was a corrupted area in the database and do test and all. I found there is a problem in the Sales Invoice line table. I am not able to do backup also, i am not able to restore the old backup which was taken recently and it…
-
Error Message in Navision Developers Toolkit
Hi!! I have a problem with Microsoft Business Solutiones-navision Developers Toolkit.I connect with the server and with the database but the problem is that when I try to access to the company, the following error message appers: "You do not have the permission to work with the Navision developers toolkit. Contact the…
-
Virtual Raid
Client of us is experiencing performance problems. I am from the hardware side of the industry and know very little about the DB architecture etc. I've read the strings on raid configs and that Raid 1(mirroring) is best but we experienced the following problems. We replaced the clients server - compaq 370 G2 with hp…
-
Navision Attain Client Software
Can I use 3.60 client software with 3.10a database? The reason I ask is that I'm having problems installing the 3.10a client on Windows 2003 terminal server (it rolls back - installation cancelled). Thanks, ](*,)
-
Amount (LCY)/Balance in Vendor/Cust. table + ledger entries
Hello everyone, We are using Navision 3.60 and I noticed some strange differences in table Vendor/Customer between Balance and Balance (LCY) and Amount/Amount(LCY) in Cust./Vendor ledger entries. They are both reffered to the samae detailed ledger entries, BUT: In VEndor/Custmer there is table filter for field…
-
Why SQL server cannot found until an hour later?
Hi all, I have the following scenario to share and I appreciate any feedback or advice: My client is on Navision 3.6 SQL server option (SQL2000). The complaint is that the SQL server cannot be found by Navision client after server reboot. He has to keep trying for about an hour before he is able to find the SQL server.…
-
Slow response in Navision and SQL server
Hi all, I have the following observation to share and I appreciate any feedback or sharing of information: My client is running SQL Server option for Navision 3.6 on SQL server 2000. Users have observed that Navision is slow in response for the first time they accessed Navision for the day. They shared with me that it…
-
Different Salesperson Code on Ship-To's
We have a few accounts that have 1 home office & 50 ship-to's. We had them all setup as seperate accounts but to make EDI a little easier I changed them to all ship-to codes. Now not every store has the same salesperson. I added a field to the Ship-to Address table called obviously "Ship-to Salesperson Code" How can I get…