-
Can't Filter on Item No.
I don't know when this started someone brought it up to me today. But when ever you are in the item card and click on the item # & then filter. When you press ok the filter doesn't stay. I've looked all around but can figure it out. Any ideas on what can stop a filter from staying. Did I get rid of some SETRANGE("No.")…
-
Behavior of code datatype in navision
hi Can anyone pls tell me how do code datatype behaves while used in setrange function. Is there any diff in its behavior with native database and sql database in navision.
-
Conversion of Integer to text
in a dataport i m using Filename property and the name of my file is date specific. So i m using DATE2DMY function which returns an integer value. Now I want to use this integer value and assign to FILENAME property in the C/AL code. So please help me in converting the integer value returned from this function to text. I m…
-
Navision 3.70 on Citrix
Hello We have a Navision 3.70 Client running on a Citrix 4.0 Server on Windows 2003 Server. We are using this connenction for some user from Dubai they will get a citirix desktop when they login. Now we have the problem that in the user profile under Application Data - Microsoft - Navision VIP - AgentAssemblies - many many…
-
how to use calcfields
hai all i calculated the total absences(flow field) of an employee with the filters employee no and month. and i want to use this flow field to calculate the paid days(total days per month - employee absences for that month) i know that flow fields are virtual fileds , and tried with calcfields function to update but…
-
Adjust Cost Report Blocked Dance
Hey All here's my question.. 3.10B On my Adjust cost - Item Entries report it only gives you a place for a date. No filtering possibilites. So Before I run this report I run another report I created that goes thru all the items and UNBLOCKS everything. Because nothing is more annoying than this Adjust Cost report running…
-
Eventlog error Cannot use FORM in NAS ??
Hi, We are using NAV 4 with NAS to print documents when picks en ships are finisched using a scanner device. Most of the time this works OK but sometimes they get the following error: The description for Event ID ( 20010 ) in Source ( SERVER-CLASSIC ) cannot be found. The local computer may not have the necessary registry…
-
Calculating Date
Hi, I am an apprentice in the first year and my englisch isn't very good. I have a database with two fields "Line Status" with Field-Value Option and a field names "Last Modified at". My problem is, if the "Last Modified at"-Date is older than a few days (for example 16 days) and the Value of "Line Status" is "finished",…
-
How to show Popups when the data is updated ????
Hi, I used one table for discount prices. now any one enter data in to that table then i will show popups (like for example 10 new records added.) how can i do that in this scenario???? Thanks & regards, Kishore.
-
How to change the message box font size,color???
I have one doubt. how to change the message box font size,color??? Is it possible in navision??? Thanks & Regards, Kishore.
-
How to change the Customized Icon for Menusuite ???
Hi, Iam using Navision 4.0 SP3. i want to change the menusuite icon. it will accept only 1 to 15. But i want to create my own Icon for some menus. How can i do that??? Thanks & Regards, Kishore.
-
Data not selected when i press enter?
Hi i created one form. In that form i used text box(like project number). In the source table -> project number field property -> table relation -> i gave the job.no. when i open the form then i click project No. field look up it show job list table. when i select some record and press enter the data was not coming. i gave…
-
restrict Store Person Can't see the DD Settings in LS-Retail
Hi, One of our client using LS-Retail with Data Director. In start menu-> Prgrams -> LS Retail Data Director -> Data Director Settings. If the store person will open that dd settings in start menu then they will see the super user password in connection string. By using that user id and password they will connect to the DB…
-
using onValidate() on a flowfield?
hi masters :) i am experiencing this problem: i have a table with a foregn key (Customer ID) and a flow field (customer name). customer name is being refreshed by calcfields in cusotmerID 'onValidate()'. now, i am developing a code unit which needs to validate if that field (customer name) is not empty. since it's a flow…
-
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…
-
Record Insert
Hi experts, In every sales, purchase , Gen.jnl…….. U have a Line no field. It is assigned by 10000 internally.. And autosplit keyProperty key for this line is yes. Up to now this is ok. AutoSplitKey Use this property to have the system automatically create a key for a new record placed between the current record and the…
-
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…
-
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?
-
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…
-
<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.
-
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">…
-
Navision E-mail logging error??
I installed Exchange server and NAS in our server. In navision E-mail logging tab in marketing setup -> when i press browsing then i got error. unknown automation server. Then i go to the Codeunit 5064(E-mail logging) in the Lokkup Profile function CDOSession subtype it is showing Unknown automation server. How can i…
-
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…
-
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…
-
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…
-
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.
-
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
-
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.…