-
Having to click cancel to get a report to print
I have a report I created from the Purchase Receipt Report and changed to use the Purchase Header instead of the Receipt Header. When the report runs, it takes the Purchase Header and filters on all receipt lines with a qty. The problem is that sometimes the report hangs and the user has to click the cancel button on the…
-
GETLASTERRORTEXT in NAV 4.0 SP3
Hello, I used the function GETLASTERRORTEXT in version 5.0. Now I should use the same function in a db ver 4.00 sp 3 but I don't have this function. I need it to log if a codeunit goes wrong, returns false: Following is the code running on 5.0 IF NOT CODEUNIT.RUN(CODEUNIT::"Item Jnl.-Post Batch",gRecItemJournalLine) THEN…
-
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…
-
Obtain last 2 fields from a list
I am trying to obtain only the last 2 lines from a list. The report lists all the purchase values for items from the value entry table. How can I isolate the output to only the last 2 entries?
-
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…
-
Drill Down Issue
Hi Guys, I have problem about Drill Down. This is an example; I have develop a form that has drill down field, when I click the field than another form is open, and I input a value, let's say "500", then I click OK, the form is close, but this drill down field is still zero ( 0 ), it doesn't refresh to 500, but when I go…
-
Comparatives date formula
I am trying to create date filters based on the current and the equivalent previous financial year (ie. 0101..3112) without mentioning the year in the formula. I am using the CALCDATE function but I cannot get a value for 01/01 and its equivalent for the previous year. Can anyone help?
-
Navision Application Service Hang
Hi, Navision Application service is hanging and i need to restart it whenever it hangs and when it hangs no one can access the website or navision. Any idea? what could be the issue & how to resolve it? Thanks for your reply.
-
FlowField not calculating correctly in EDI
I am creating an outbound 810 EDI invoice in the lovely Lanham EDI module. It contains a FlowField in the Sales Invoice Header table. The FlowField sums the line amount with a where clause based on a field being checked. We will call this FlowField XField. I have mapped the XField into my 810 and generated an EDI file.…
-
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…
-
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…
-
"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!
-
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…
-
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…
-
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…
-
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…
-
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.
-
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!
-
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'…
-
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…
-
windows server 2008
Hi, We would like to upgrade our navision 3.60 native to sql server 2008. This will be not a full upgrade. but only data store upgrade. We are also planning to switch the servers. Now windows2008 is out. We want to use this instead of buying 2003. Is navision ready for Server 2008? Thanks in advance.
-
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…
-
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",…