-
Transfer order that have associated Lot No raise error
Hello, When I try to post a transfer order with items that have associated Lot No, a error occur: “Qty. To Handle (Base) must be x in Tracking Specification no. = 1”. The Qty. to Handle is correct for the specified item. What I spotted is that the system makes two item ledger entries for one item with the same lot no…. if…
-
Company Logo
I have several reports that have the company logo on. Is it possible to get this logo to auto resize depending on the size of the container that it goes into on the report. Thanks Mike
-
Navision Developer License
Hi all, Happy new year to everyone I'm having a serious problem, i have a 004 license for developing in 4.0, and i obtained it with a company i used to work for...now it's been one year for my lisence and it's almost time for the renewal ( or maintenance or whatever they call it) since i no longer work with my old company,…
-
last direct cost and rounding precision
Hi all, I have a big problem with the unit amount rounding precision: GLSetup : unit amount precision : 0,00001 Item last direct cost : 0,01234 After posting an item journal line with : Quantity : 1000 - Unit cost : 0,01234 the Item last direct cost is always : 0,01234 because new last direct cost is…
-
key sensitive search after migration to sql database
hi, after migrating a navision 3.6 database to sql 2000 the search function inside navision is key sensitive. someboyd know how to set it non key sensitive ? ](*,) mauro
-
Login error to database
Hi all, I have problem when trying open Navision database (3.60/Nativ server/Win XP). An error occured "The Object table does not exist any longer". Could any help me in this situation? Aidas
-
Teble Object error
I have Navision 3.6 database on MS Sql Server. When user tries to log in navision sends error: The Object table has a primary key constraint in the SQL Server table description that is not compatibile with Microsoft Navision Attain definition: Key fields: Type, Company Name, ID SQL primary key fields: Type, Company Name,…
-
What is the purpose of use INTEGER Table?
I've never used INTEGER Table, because I have had no needs to use it or how to use it. I haven't found any line in documentation about how to use it or where to use it. I have seen in some reports that INTEGER table is used as DataItem as some counter, but I don't think it is the only purpose of that table.. Help :oops:
-
check if printer is installed
hey everybody! i'm looking for a possibility to check if a certain printer is installed in my windows befor the output starts. can anyone tell me if this is possible through navision at all? OS: win2k NAV: 3.60 thanx so far
-
Multiline Textbox
Hi, I'm attempting to create a multiline textbox. I've got a Text field with length 250. I've set the Multiline property of the associated textbox to Multiline, but the control refuses to wrap over into a new line. Am I doing something wrong here? (Nav 3.6) Charl
-
Data Type
I created a field with data type option and set the option string with Yes, No. But in my current form everything is YES as default value. Is there any way to leave the option empty and let the user select one from the drop down list? Which value do I have to set in the property?
-
Eship/Email Setup
Using the email feature that came with Eship is great. But I (and I guess everyone else) really just used it (if you even did) for sending invoices or confirmations or whatever. Today I've been toying with send PO's using this method - yes PDF is easier (anyway) As far as it working for Vendors-IT DOESN't See…
-
How to count # of records?
I want to count the number of records per grouping. I tried CREATETOTALS (but it didn't work) ... I'm working with a string field. Help please and thanks, -S.
-
Latitude and Longitude
Hii, Can somebody tell , How to calculate the distance between two places on earth, given latitude and longitude of the given places in Navision. Roshan
-
Form
Is it any way to create one form based on several tables if we don't use adding subform. Thanks in advance!
-
Company security on a report
I have different companies in Navision 3.7. One of them is the holding to which none of the normal users have access. Through a report I want to enable users to view some information from that company via CHANGECOMPANY. How can I make this work without giving the different users access to the Company. With kind regards,…
-
Print different paper size
Hi, I want to print from Navision a report on dot matrix printer with page format 100/210 mm. Problem is that the printer (EPSON LX 300+) automatically feed A4 paper (is the system printer paper size). If I print from MS WORD a document with custom size the printer feed only the specified size, from Navision feed all the…
-
Delete Pic After Import
After Importing an Items' Picture. I would like it to ask if I want to delete file file off the drive. OnPush()PictureExists := Picture.HASVALUE;IF Picture.IMPORT('*.BMP',TRUE) = '' THEN EXIT;IF PictureExists THEN IF NOT CONFIRM(Text001,FALSE,TABLECAPTION,"No.") THEN EXIT;CurrForm.SAVERECORD; But unlike a dataport where I…
-
Excel automation: export message to office assistant
Hello, I am very happy user of the Excel automation tool in Navision (we are using 3.6). I wonder whether it is possible to send an instruction to the office assistant and let him display this message just after confirming some report with Excel automation / export. Or, when this is not possible, can I place a in Excel…
-
Error In Posting A Purchase Order
Hi, Can anyone tell me how to fix this? We don't use the account so I don't know why we are getting this message. I tried to search this site, but I didn't see how to fix it. Thanks Rosemarie
-
MSSQL numbers decimals are different from Navision decimals
Hi, I have a nice problem with some new features developed in Navision because of the numbers decimals. Even in Navison numbers are viewed with 2 decimals if I look on MSSQL 2000 tables on same records the numbers are stored with at least 15 decimals. It cause program to raise false errors. What can be done on Navision…
-
Records / Ifelse statements
Hi, I'm fairly new to Navision Attain / C/Side code, and I'm having some difficulties. When I run the following code, although there is more than 1 record which matches the criteria, it only brings back one record. If "Payroll Ledger Entry"."Journal Batch Name" = 'OFFICE PR' then "Payroll Ledger Entry".SETFILTER("Payroll…
-
have you ever installed navision server on novell
Hi friends, HAPPY NEW YEAR.we have a client that is running novell on their server and we need to install navision server for them and i was wondering if someone has ever done such an installation before.if u have ,let me know how to go about it.Thanks :roll:
-
How to kill sessions
How can this be done in 3.01A without restarting the Navision service? I got one user who is a certified whiner and one like this is enough to make me run here for help. Thanks.
-
Exchange Rate Gain
hi there folks: Right now everytime you got an exchange rate gain it goes to account 909900-0000. but the right account is 909902-0000. Where do I setup this? thanks a lot ](*,)
-
is this new trick on consignment ?
Hi again all. Can we do this trick : in inventory setup uncheck expected cost posting ? When we do purchase order, just posting receipt. The rest is just the same. Is it ? Thanx
-
Document form doesn't related to date server.
Hi again. I'm sorry for my ignorance. I'm new here. If battery for cmos in client computer empty, then all date on document form in client computer wouldn't accurate. Should i use server date ?
-
ver 3.01 -changing date in navision to allow for posting ?
hello, we cannot currently post in navision and the message we receive is "posting date is not within dates allowed for posting dates". can someone tell me howwhere to change the date to the new year? thanks brian :-k
-
Ctrl + B in form 113
Does anyone know why search or ctrl+b doesnt work in left side of form 113? Is it possible to make it work? If yes how?
-
Dynamic sum flowfield
First: happy New Year :D Second, a question: I need 2 SUM flowfields per 4 table fields. Like this: TotalQty = sum by Item Quantity for all dates and other stuff Qty = sum by Item Quantity for some dates and other stuff I need the same functionality for Outstanding Quantity and some other fields. The real question is: Is…