-
Hidden filter when calling a form from Item LedgerE
Hi there, I have a form 38 Item Ledger Entries which has a Source No. field, on which the assist button calls e.g. Customer table, namely form 22 Customer List. I only get active customers, i can tell that by using GETFILTER onOpen form 22. I am breaking my head to find where this filter is being set, can anyone please…
-
Table Locks on the No. Series Table
I am having a problem when a user runs a process and the procees needs to lock the No. Series Table. They get an error message and it blows the the process off. Most table locks just give a message and let the user wait untill the table is unlocked and the the process finishes. I need to be able to change the error message…
-
Reverse a string
Hello, is there any function to reverse a string (like: String_1= "ABC", String_2="CBA") ? In other programming languages there are special functions for that but I haven't figured out a function solving this problem in Nav.
-
"general" triggers
are there in navision kind of general triggers (i.e. in CU 1...?!) which are fired if someone starts any report or any form or...?! thanks in advance, claus!
-
Report "filtern"
good morning everyone :) i have the following problem: if a report starts, i want that all concerning lines are filtered, so that every user can only see the lines, he is allowed to see... but we don't wana modify every single report and so my question is, if there is a solution for this problem... the user doesn't have to…
-
Converting String to Text
Hi, I hope you can help me, cause is have a string on this is a date like "01.08.08" then i modified this var because i need 4 places for the year like "01.08.2008". This is all fine but now i want to bring this string var into a date var and i dont know what i must do to success this step. Do Anyone here know, how can i…
-
Are Windows Logins also Users ???
Hi all, This is my secong attempt to find out what I am missing. We use SQL server and windows auth accounts. I can successfully create/add new accounts via Security - Windows Logins, and assign roles. User can then log on and run Navision application as needed. Now what about the 2000000002 "User" table. Right now it is…
-
Lanham E-Ship & Labels
We use Lanham eship I think it comes with a "Labels" addition where you can create your own labels. I've done all i can do with the E-mail functionality But now wanted to play around with the create your own "labels" functionality. But It has no help file - I was wondering if anyone had some pdf or word doc with…
-
receipt
Hi all, I have a problem in wharehouse receipt, sometimes we have to receive more qty than whe have enter in the purchase order (for exemple, we purshase a truck of one product 33000Kg but the vendor can't send exactly le qty sometime we have less and sometimes we have more) In nav we can't receive more that we purchase do…
-
Error with SMTP
please guys i need help i am try to send mail with smtp but i have error message ( unknown class returned........) I think the error in 'Microsoft CDO For Exchange 2000 ibrary' because i wok on XP // objEmailConf -- 'Microsoft CDO For Exchange 2000 ibrary'.Configuration // objEmail -- 'Microsoft CDO For Exchange 2000…
-
Service Credit Memo Not Returning Stock
Hi, I have a problem with one of our customer's Service Credit Memos (3.10). When they create a service credit memo, it is not returning the stock but the stock went out when they did the Service Invoice. I don’t know if it is just a user error. Reproducible Steps: 1. Create Service Order for faulty item (Service Item not…
-
Changing S & H..
Edited: I figured out how to do this myself.
-
Date Compression with Average Costing
We have a 3.10B native database and we use average costing. The database size is over 150GB and we're planning to do some date compressions and history cleanups to reduce the database size and increase performance. I don't want to get into any performance debates, I just want to ask the experts if we should attempt to run…
-
How to find unused indexes
We have a 3.10 native database running on a 3.7 executable. I would like to know if there is any easy way to determine if there are unused indexes.
-
Could not load the selected type library
Hi, I have installed NAV 5.0 SP1 australian version. We are running NAV with SQL Server version. I have installed the NAV 5.0 Sp1 client & application server with "Employee portal, Outlook integration and other stuffs". Now the problem is When i compile the objects i get errors on objects related with Outlook. I have…
-
EDI Outbound 850 and Purch. Comment Lines
Does anyone have experience mapping Purch. Comment Lines into an Outbound 850 from Lanham's Gen2 EDI system? We have also created a customized table that stores Purch. Line Comments and we would like to map those also. Any suggestions??? Thanks!
-
Missing Item tracking lines
I have run into another tracking lines problem. The user entered a transfer into the Reclass journal for a qty of 200. In the Item Ledger Entry table there is a postive adj and a negative adj for 200. For the neg adj there is 200 item tracking lines with the correct serial numbers. (so far all is good) But on the positive…
-
Navision Application Server Error
Hi, I have 2 Nav database services running on a server and I now want to install a NAS service for each of them. I have successfully installed the first NAS but after installing the second NAS I get the following error in the Event Viewer on startup : 'You do not have permission to run the 'Appln. Server Management'…
-
Dos grouptotalsfields work in nav2.5
Hey all u out there. I’m working on a version w1 2.5 (4.0 SP3) doing a raport and I can’t get the grouptotalsfields working ](*,) . Can it be that this functionality doesn’t work in such old version of Nav? and i'm only wasting my time trying w:-k Thanks
-
[solved] Convert Date Formula to Days in Report
I wish to convert the time.lead times to a consistant type within a report. During setup, the user could have entered 1W, 7D, 1M, 30D etc so in a report I would like this to show 7, 7, 30, 30 etc etc so that a comparison can be made out of Navision. Is there anyway to do it? Thanks :)
-
Modify Customer Code
Hi all, Excuse by advance for my english. I work with Navision 3.60 When i modify manually a customer code. It works, and the history is also modify. Now, i'd like to do that with a report because i must modify all customer Code (they are not no series code). How can i do that ? I tested with the MODIFY function but…
-
Internal error 2 in module 10
Hi Experts, When I am Opening DB , a window is POP's Up and showing a message Internal error 2 in module 10 and the DB is getting closed. Even some times DB is Opening , but when I pressed ESC Button again it showing the same message.. The Db is closing .. I don't whatz the wrong. Please help in finding this error Thanks…
-
how to launch navision codeunit from outside (v3.6)
hello, i see here more information but can't find suitable :( we have v3.6 on native navision db and need to run in example navision codeunit from outside application. what solutions are possible? thanks in advice :)
-
Item Tracking + get receipt where multiple receipts problem
Navision Attain 3.10.A An item tracking purchase line for a quantity of 13 has been received in 2 parts, qty 1 receipt A and qty 12 receipt B When I try and invoice the lines using the "Get receipt Lines" function, all seems OK in the Invoice but I get an error on posting; "The Purch. Inv. Tracking Line already exists",…
-
Aplying customer's entries
Hi I am looking for a documentation that describe how NAV applies custommer ledger entries? when i try to apply N positive amounts and N negative amounts, how does NAV work ? Thanks for your help
-
Item Tracking Mess - Urgent!
I have a client on Navision 3.1 with a data problem. Somehow the SN Specific Tracking field became unchecked. Now they have thousands of tracking lines that are incorrect. Sales - These transaction created negative tracking entries but did not apply to the positive entry for that serial number. Now there is both a positive…
-
Problem with msxml3.dll
Hi guys, When I try to assign a password for a user on e-commerce or when I try to post some acknowledgments, the follow error appears: This message is for C/AL programmers: The call to member save failed. msxml3.dll returned the following message: The system cannot find the path specified. This problem is happen on my…
-
Fin.zup
Fin.Zup is a temp file witch save all your settings under navision, when users use citrix, the file is saved on citrix server under c:\program files\user name\application data\fin.zup you must delete the file, if the problem persist, rename the user folder as .OLD and create a new one
-
Permissions for C/FRONT
Hi, I have a problem with C/FRONT. I have created some CFRONT formulas that I have validated with user that have SUPER role. I get the expected results from Navision. The problems arrive when I try to access to these formulas from Excel with an user without SUPER-role. In this case, when I try to use the formulas i can't…
-
Multiprocessor / Multi-core
We have one 2.60 and one 3.60 database running, both native, on one server. Most clients use a terminal server client from which they connect to their Navision. So all TS’s have 2.60 and 3.60 clients installed and running. Because our users experience a drop down in performance several times a day we are investigating all…