-
Consolidation and Translation
I am currently trying to consolidate 2 companies, one of which must also be translated, and am running into a few issues. I am on version3.01. 1. When running consolidation, if not all dimensions and g/l accounts are present in the consolidated company, the process errors out. I must then manually add the dimension/gl…
-
NAV 3.60 SQL / XML from MSMQ -> Textfields squared
Hi, I'm having a curious problem. I work for a customer having NAV 3.60 [Build 15069] on SQL 2000. Reading MSMQ XMLs and inserting into database tables, only Interger and Decimal fields are inserted correctly. The data in Text and Code fields is only a "square"-sign like this: ◘ The XML in the MSMQ is totally clean and the…
-
ODBC & MS Access
Hello, We use Navision 3.7. We do some custom reports pulling the Navision data into Access using CODBC 3.7. We have one problem with this process and hope someone can help us. We are unable to filter on dates using any of the standard Access data operands such as Between or > or <. We get an error "Invalid operand for…
-
Restricted access to a company
Hi everybody: We got 6 different companies on Attain. The user I got have access to US and Mexico companies. as well as the others. But I am creating a backup of actual company and I need only 4 users to have access. Is there a way to let only certain people to access?
-
Removing table field.. (fixed I think)
Navision 3.10 I did a table filter on my customer list to only show a certain state and customer. How do I remove the filter? I come across this problem regularly, but don't remember the solution to getting rid of the filter. If I go back into table filter and erase everything I wrote then back out, it doesn't work. I can…
-
Sales Header in 3.10
Have Navision 3.10.. where would I find what I need to change the Sales Header? When we print out sales orders it has our old address and phone number. I have access to design reports and what not, just need to locate it. Oh, I should mention this is "Sales Order for Major".
-
Upgrade Projects Hot fixes Problem??
Hi, Recently I involved upgrade from 3.7 to Nav4.0 SP3. After Upgrading the project some hot fixes was came. In some codeunits are customised. suppose if i import the Hotfixes the Forms & CodeUnits are not merged. it will replaced. For example In Codenit 80 some customisation is there. In hot fix also codeunit is there. In…
-
Fax again (urgently)
I need send reports, i have zetafax, i save the report as html and add the code for fax number, save and print for fax printer driver. its terrible. The lines not fit. I think how can i do. convert first in pdf, jpg, ... somebody use zetafax with navision (attain 360)? thx.
-
Read a XML file
Hello I want to read this xml file in Navision program. <?xml version="1.0"?> <Report> <Items Type = "A"> <Item No = "70000"> <Description>Side Panel</Description> <UnitPrice>30,70</UnitPrice> </Item> <Item No = "70001"> <Description>Base</Description> <UnitPrice>40,30</UnitPrice> </Item> <Item No = "70002">…
-
<RESOLVED> Crystal Reports and Date Time Field
I have a real simple report i wrote in crystal report. But when i set up a date time parameter field, it only pulls the first date in the parameter. if i run it with no parameter, i get all the data. has anyone had this problem before, if so how can i resolve this so thati can use a data time field parameter.
-
Filter Table with Form Record
hi there... i am having some problems with filters. In the Item Card I made a new tab and added there one table that I made previously. I have there 4 fields. in one of them i have Item."No.", number from the Item table (I am entering that number). what I need is, when I select one Item on the General tab ex. Item0005, the…
-
label size barcode
I have to print barcode from navision, but my problem is that I can't find right label (paper) dimension. is there any chance to set it manualy (custom)? paper dimension is 28 x 89 mm
-
SQL 2005 to Navision 2.6 Via linked Server
Hi, I am working with a customer who has a C/Side 2.6 DB, and 3.6 shell. I am trying to setup an ODBC connection from MSSQL 2005 on Win2003. I have tried C/ODBC 3.6 drivers and received ISAM errors in SQL, probably due to the MDAC version in Win2003. The customer has indicated that they have now installed the ODBC granual,…
-
How to Integrate Web form to Navision?
we will use one web form(like Tmesheets ). By using web the employees enter the timesheet data in web page. how can i integrate web page data to navision database? wht is required for this scenario???? Thanks & Regards, kishore.
-
Link Customer ledger entries to Payroll
I am wondering if anyone has developed the following functionality: my customer is a fishing company. They have fishermen set up as employees. The also have their fishermen set up as customers. The fishermen buy things from the company (our customer) and therefore they create sales invoices because the fishermen will buy…
-
Database is slowing down [Code Suspected]
Hello, We have some development work done in the past and we noticed that the database takes a long time to display line items in various places For example in a sales order Navision will stall when adding lines and in the footer of the application the following message is displayed “Counting records in the Sales Invoice…
-
Problem inserting: Last row replace.
Hi, I’m trying to insert new lines in the "Journal Line Dimension" table, but at least it just inserts the last one, the others are replaced by the last. I think the primary key is ok in each record, so I don’t know what could be wrong. Does anybody know why this happens? Here is a piece of code where I do the insert.…
-
Doubt in Navision ActiveControlOnOpen control?
i created two forms.(list form and card form). In card form i used 4 tabs. when i go to the card form from list form it automatically goes to 3rd tab not 1st tab. i set ActiveControlOnOpen control in form properties i used f1st tab 1st field ID. but some records it goes to 1st tab and some recors it goes to 3rd tab. how…
-
Problem oppening navision 3.10.
I'm trying to open navision but i get an error: "The file name <H:\My Documents\Temp> contains a character that may not be used" Anyone knows what can I do to change the file path? Thanks
-
NAVNO3.60 - Base Version
Hi, Where can I find a clean CRONUS database for NAV3.60 Norway (NAVNO3.60)??? The only downloadable version from PartnerSource is W1... Thanks
-
the indexing 0 in the array is outside of the permitted rang
I amgetting this error right when i am trying to open an upgraded company (3.7 to 5.0) interestingly, i am not getting this error when its opened from my laptop, only when opened from client's server's terminal session.
-
SQL Date Fix Tool
I am looking for the tool that you run on the NAV 3.6 database to fix the dates for importing in to SQL I have looked through the tools on the site and have searched google for this tool but unless I am just searching for the wrong tool I have had no luck. I have someone who is going to probably do the import for me but I…
-
Printing Check with different account type in a single check
Does anyone know or experienced printing checks with combination of 2 entry lines and Account type "Vendor" & "GL Account" on which net amount total for one check only ? the GL account has a negative amount.(a deduction to payment to vendor). Im using Navision Attain 3.10 Thanks!
-
Display a picture in an array?
I made a Label-Typ report to create labels which should include the Item.Picture field. I can't find any good example in the C/AL reference guide how to accomplish this, all outstream examples uses text. When I try to assign the following to a variant variable the compiler doesn't like the syntax.…
-
Mandatory Fields
In Nav 3.6A I am trying to instill mandatory fields on a form but if the user doesn't key on the field the notBlank does not trigger, if I do a test in the onbeforeputs and send a message this doesn't stop the system from progressing to the new record if the user decides to advance to the next record, the message appears…
-
How to take the navision backup automatically???
Hi, Iam using Navision native database. Now i want to take the backup automatically by using navision code not the backup tools. I want to take the backup and tht backup will store on another drive(like D). Is it possible to take the backup with out 3rd party tools??? Give ur valuable suggestions. Thanks & Regards, Kishore.
-
Editing Vendor Ledger Entries
I am fairly new to Navision and my company has been running NAV 4.0 for about a year now. We are have difficulty with a module that was made for prepayments to vendors. Insteading of closing entries in the Vendor Ledger like the module should, it has been keeping them open. Is it possible to edit Vendor Ledger Entries so…
-
Export to CSV allowing "£" to show as "£"
Hi Folks Im trying to export a report to a CSV file. I can successfully export but if the field has a "£" sign in it, it shows as example "Postage charge where value of total order > œ15" the "œ" being the "£" i know i need to use convertstr and format(chr) but i have no idea where to place it in the code. :-k See an…
-
Navision 3.60 Database upgrade to Navision 4.03 MSSQL 2005.
from: Navision Client 3.60 Navision DB 3.60 Native Navision DB to: Navision Client 4.03 Navision DB 3.60 MS SQL 2005 We are working with our partners to discuss this and this is what they have suggested. I would like to get other peoples comments and suggestions on whether this is a good move and what all it really takes…
-
A crashing 3.60 client.
One of our users has an issue around 3PM every once in a while where there FIN.EXE crashes and closes their client. When this happens they have to reset all of their customized columns etc. Are these being set on the client like I suspect and something is either not being saved or getting corrupted and they are having to…