-
Rounding
Hi All, In my Inventory Valuation report ,As of Date - >Value field i can see the value though iam having quantity=0 I think something in rounding?? If iam correct plz help me to solve Cheers, Sumathi
-
Change Log
G'day I am having the following problem at a Navision AU 3.60 client. I have a new table (50006 Service Order). In this table there are two fields, 26: Order Sent (boolean) and 27 Date Sent (boolean). You tick the Order Sent box and it either updates the Date Sent with WORKDATE or clears it. Pretty straightforward. I have…
-
OnModify does not execute (From table or form)
Hi all, I've put some codes in OnModify trigger in production order line table to execute when I modify a record. However, when i change some value in some fields (ie. quantity), the onmodify trigger does not execute. I tried to put a message box in the onmodify trigger to see if it executes or not but it seems that the…
-
Add text in middle of existing file
I want to be able to read from file, then find a certain position, (matching text). I then close the file and open it again for writemode = true. Now I want to find that same position and INSERT some text at that position WITHOUT losing the rest of the writing. Because the file is very big, I DO NOT want to stream from one…
-
Cannot start Navision Attain Database Server
I've been searching the forums and doing all previous recommendations but still cannot open the service. Still getting the infamous: "Could not start the Navision Attain Database Server XXXXX service on Local Computer. Error 1: Incorrect function." :x -The license is correct and with the granule -The parameters are not…
-
Hiding Confirmation/Messages
when entering a sales order, there is a function which is called from the insert/modify section of the table which prompts the user to (not) accept changes. this works fine. however, when changing the delivery dates etc on the header, then this also updates the lines. Of course, this then reasks the questions all over…
-
Analysis view error
Hi, I use Analysis view for analysis by dimensions in NAV 3.60. Analysis view is updated by posting process. It works fine, but sometimes some data in this view are deleted. Simply, some rows in table "Analysis View Entry" don't exist any more. I don't know why, I can't find where's problem. When I recreate view all data…
-
Version 4.02
Hi All, Has anyone encountered any issues in regards to upgrading to v4.02. I have just done an upgrade from 3.60 to 4.02 and all reports' right margin have been set to 2000 by default. Even in 4.02 Cronus, 2000 is the set default for Right Margin. Does anyone know the reason why?? Any suggestions will be much appreciated.…
-
ADCS Installation
Hi All, I am facing the problem while installing the ADCS (Automated data Capture system),I have followed all the Procedure in the manual for 3.60 Beta Version,But still the problem is not solved.Kindly provide with some manual or suggestions at brijesh@euroinfosys.com
-
How Do I Schedule Navision Backup & Restore
Hi, I need to taka backup of 2 companies from our production database and restore that in a different database. How do I schedule this to happen at a later time? I know that I could schedule a SQL server job to do this but that includes the whole database. I just need 2 companies from 30 companies in our database. Thanks…
-
calcsums and filtering table containing flowfield
Hi all, Something I have never come across before. I have a table of sales lead entries, the table contains a field that is a flowfield. So when I run the code below I get the following error: If I comment out the filter on the product flowfield the report runs just fine but obviously I am not getting back the results I…
-
Filtering customer list by sales..
Navision 3.10 Once again I need to print out labels of our customer list in Navision. There are some customers we don't want. Is there a way to show only the customers who have done business with us in 2005 and 2006?! So far I have close to 1000 customers who aren't blocked or major accounts. If I can take only customers…
-
Navision 3.01 DB Restore
Hi, We are using navision 3.01. The database size is more than 180 GB, so the db is spread in to four diffrent disks. unfortunately one of the disk is crashed and i cannot retrieve the fdb file. Is there any way to open the database or get some of the data out from the database files that are there in the other three…
-
Permissions
I dont think this can be done, but I would just like to confirm with somebody Is it possible to block a particular user from veiwing the comments in sales invoices? Thanks in advance
-
Credit Memo on Reminders/Finance Charge
Hi, This questions is whehter Navision(4.0 or up) calculate interest for credit memo on Reminders/Finance Charge. I tested and do not think so but just want to confirm. Thanks Trin
-
removing zeros
hi guys last week the Zimbabwean Central Bank slashed off 3 zeros from our currency, which means that 1 000 000 is now 1 000. I need help with some code which will do this thing in navision automatically. A program whcih will go into all the table changing the 3 zeros or just dividing by a thousands.
-
Accessing Backup Split Database
Back before ths split database I could copy the Whole database ' as is' to my C:\ Drive if I wanted to and File->Database->Open {It locally} Then I could play around with my copy as much as I wanted. Now that it's split I can put both halfs on my C:\Drive c:\Database.fdb c:\Database1.fdb But I can't access them as a local…
-
How do I print unique records from a table
Hi, I have a dataitem on a report that linked to a table that has duplicate records. I want to print only unique records from the table. How do I achieve that? Thanks
-
How To Split A Database
I'm about to split out database into 2. Does someone have all the steps involved - so I don't screw it up. including do I stopthe service & restart.. Parameter changes, etc etc. right now it's on E:\DATABASE.FDB I'm Gonna make it E:\DATABASE.FDB+F:\DATABASE.FDB
-
AutoFormatExpr
Hi there! What defines autoformat rules when no currency is entered in the field, which is used as AutoformatExpr? Help says then LCY is used, when Currency is empty, but how do i change formatting rules for LCY? Thanks in advance
-
Fixed assets - Asset Quantities
Hi we are running Nav Attain 3.1 and have just implemented FA. Our question is how does Attain account for quantities. eg. WE buy 10 desks and record these as one FA. the Quantity purchased is held in FA ledger Entries bt does not show on FA Card or reports. WE are wondering how you tell how many assets you (should) have.…
-
Optimizing Navision Attain 3.10A
Hello. I’m an admin who administrate a windows 2003 server with Navision Attain 3.10A installed. The installation is using the normal build in database (not SQL) Is there any way that I should optimize the database, should I do any maintenance things other than hotcopy-backup? The other day I needed to expand the database,…
-
Xbrl
Can somebody please direct me to a user guide / instructions / how to ... on the use of XBRL in Navision. I would like to use xbrl in issuing Annual Financial statements according to IFRS. Can the taxonomy that is available at http://xbrl.iasb.org/int/fr/ifrs/gp/200 ... y_page.htm be used as is? Are there any websites that…
-
Compile Excel Buffer Table
Hi, I want to make changes to the excel buffer table but am getting an error message "could not load selected library" ](*,) . What do I need to change and compile this table? Thanks in advance :D
-
flowfield troubles
I created a flowfield on the item card, which calculates and works as expected. However, I've had problems when I try to assign the value of this flowfield to a Normal field in a nother table. I put the following code in the Item No. - OnValidate trigger (table Whse. Worksheet Line) Item.GET("Item No.");…
-
Import txt file and autonumber
I want to import txt files with a dataport and then use autonumber. But the problem is when I use autoincrement in my table and there are more lines in the text file the line are overwritten. Can someone help me? ThanX
-
Make fieldlength 50 for Item Description
Does someone have a complete description of fields, variables, etc. that has to be changed when the fieldlength of Item Description has to be enlarged (e.g. 30--> 50).
-
Strange error when inserting new sales order
We've been running Navision for over three years now, and all of a sudden today, when we tried to insert a new sales order we got this error. You do not have read permission for the Sales Header Archive table Which is correct, we don't have that granual (5160 i think). I ran the debugger and this is the code from Sales…
-
Advantages in using SQL server
can anybody tell me the advantages of using Sql server database than the navision native database. Please also tell me the plus points of Native database regards,suresh :^o
-
BOM for variants
Hi We are trying to use variants. The same materials is shipped in different kind of packing. eaching packing has got its own BOM. if i want to use the packing spec as variant can i have different bill of mateiral for each variant. regards,suresh