-
Apply Ledger Entries from different Locations
The issue I have starts with transfering negative stock. I know this problem has been discussed before on this forum but I have a specific problem releated to it. I have a client that wants to be able to transfer items where they don't have any in stock. (Don't ask...long story and they won't be talked out of it!. I'd much…
-
Link table
I’m trying to link two tables, in the same way that the sales header table and sales line table are linked. Can someone suggest the code to use so that the line document number is the same as the header document number for each line as well as generating a unique line number. And also someone can introduce me some book to…
-
FA Ledger Entry adjusted by Post Inventory to G/L batch job
Unfortunately I can't say for sure that is not a local functionality issue (we use Navision 3.60 RU), just hope it is not. Let's assume that there is some FA, that was initially built (acquisitioned) from some material, i.e. there was Negative Adjmt. Item Ledger Entry reffered to this FA through FA No. field. This Item…
-
Very Slowly Use Navision 3.01, please help ....
Hai, everybody ... I have this problem with my navision Attain database. It works very slowly some the time. I have installed the server database in the new workstations "HP" and use hardware like this : PROCESSOR INTEL XEON 2.33 GHz (HP DL380 G5 Dual Processor) RAM (HP 4 GB = 4 X 1 GB = 4 GB) HARDDISK (HP HDSAS72GB/15K 7…
-
Navision 3.10 backups..
Running Navision 3.10. In our old office we used to do backups on a daily basis. We would goto Tools -> Backup. It would create a backup and we'd zip it up to save some space. Since moving to our new office we got a new server because our old tape drive was defective. Since then we were told we don't need to do the backups…
-
Navision-Backup Error 1185
:( Navision version: Navision DB 2.6, converted to Navision 3.7 (Native DB) Problem description: After an electricity failure our internal Navision backup doesn’t work any longer. The backup aborts with the error message "Error 1185 in module 19". Seems to be a sure sign that the database space is too small and has to be…
-
Multiple costs for one item
I'm hoping someone can help me with this. We have items that are purchased from china, this one item can have two different costs on it. One cost applies if it is stocked by us in Canada, the other cost is if it is stocked in China. The cost variance doesn't have anything to do with transfer charges, the vendor actually…
-
Superuser permissions error [RESOLVED]
Hello all. I am having a problem with permissions in Navision that is not allowing me to make any change to an object. Version: US 3.01.B (3.60) Platform: SQL This is a long-standing Nav SQL installation and I have never had this problem until yesterday. My normal procedure is to open Navision, change the license to that…
-
MRP Order date and End date
Hi Anybody can explain me what is the Meaning and Relation between the 'Order date' and 'End date' that we enter during the MPS / MRP run ? Version 4.0
-
Hyperlink/URL problem in Navision 3.60 on win 2000 server
When I use the Hyperlink button in Navision 3.60 fx. on the customer card and put fx. http://www.mibuso.com in the field I get this result in IE: http://www.mibuso.com/%20"http://www.mibuso.com/" which can't be displayed. There are no spaces in the web address in Navision. It is a Windows 2000 SP4 server and the Internet…
-
Slowing down system!
I have this problem with my navision Attain database. It works very slowly all the time. I have installed the server database in the new workstations "Fujitsu Siemens" and the database works slower then in the old server. I have reached at the limits of my license and i have tested my database several times, but it didn't…
-
Hello Everybody!
I have this problem with my navision Attain database. It works very slowly all the time. I have installed the server database in the new workstations "Fujitsu Siemens" and the database works slower then in the old server. I have reached at the limits of my license and i have tested my database several times, but it didn't…
-
Adjust Cost routine
Hi guys, I am wondering if anyone has changed the Adjust Cost Routine to allow for filtering by Item (i.e run the routine for only one set of items at a time). I am using 3.60 db and no manufacturing or BOMs and using average costing. Thanks in advance, Cristi Nicola
-
Item "Average Cost" with Discount
Problem: Discounts should be considered for Average Cost calculation of an Item Details: In Item Card, there is one field "Average Cost LCY" (Invoicing Tab)... The calculation for this field is (("Cost Amount (Actual)" + "Cost Amount (Expected)") / "Item Ledger Entry Quantity")... where all the three fields are from…
-
Problem Starting Navision Database Service!
Hello i am new here. I have this problem that i can't start navision Service on the new workstations i have bought.I have installed different "Windows systems" like Windows 2000 Advanced Server, Windows 2003 standart+ enterprise and i have the same problem. Could not start the Navision Attain database server Error 1:…
-
Creating a Budget
hello experts! I need to create a budget based on last years G/L. How can I do that? would anyone know the steps and settings? I never see any data on the sheet... thank you very much missdeeh
-
Maintaining ZUP for multiple users
Hi All... For testing purpose navision is installed only in a test server... All other users are accessing this through remote desktop... How can I maintain different user's settings in the server... One user's settings should not be overwritten by another user's settings... Can i maintain this in one ZUP file itself or…
-
Sales Order Archive Setting
Is there a setting in Navision v5 to auto archive sales orders when they are deleted? We haven't written any code to do this, the client has been ours from day 1 a few months back, noone has been trained to archive a sales order and yet there has been a number of occassions where the client has deleted a sales order (which…
-
Copystr and strlen functions
Hi, I am in a report and i am trying to write some code in the "source expression" field. what I am attempting to do is to show the last 4 characters of the given field, however when i have a field that does not have any characters it gives me a "less then 0" error. This is the function that i have come up with:…
-
3.60 => 3.70B upgrade ... CurrReport.OBJECTID
Hi, I just performed a technical upgrade on a database from 3.60 to 3.70B. The client and server software where upgraded while we kept all the 3.60 objects. Everything is working fine except for one function: CurrReport.OBJECTID is now returning the object caption instead of the object name. Has anybody ever experienced…
-
Native to SQL ... now records not FILTERing in proper order!
Hello, We've always been using a CODE (10) type field on a table that holds basically what is a order number. We have two types of orders where one type is in range 1,000,000 to 9,999,999 and the other type is ranged 99,999,999 and greater. No comma's ... I'm just showing them for clarity of the numeric value. Problem.…
-
Build Number Difference between Fin.exe and ODBC.dll
Hi, I am not really a technical person thus this may sound odd for you.. Our client is using NAV 3.6 Build 11895 of fin.exe. They want to install C/ODBC, however with some reasons we do not have the same build nor the client as MS sent them V3.7. The build version we have is 11353. If we give this build of C/ODBC would it…
-
Random Number
I have managed to create a "random" number field, simply by RANDOMIZE; RndmNumber := RANDOM(12); Which gives me a number between 1 and 12. How do I give it a minimum? ( I only want 8 - 12) ? Thanks :)
-
Dimension not update in G/L entry
I need to populate default dimension value into "Shortcut Dimension 5" in Journal Entry based on Account No entered by user. I have no problem to display the dimension value in Journal Entry, however the dimension value is not update in Journal Line Dimension table. (Journal Entry - line button - dimension is emtpy).…
-
Is this a new Company?
Hello, I would like to ask some general questions about "company" as it pertains to Navision database/application usage. Our company has always just had one "company" defined in our Navision database so I am unfamiliar with how multiple companies work. We have recently acquired a another company that will operate as its…
-
Upgrade from Nav 3.60 to Nav 5.0
Hello Forum: I'm upgrading from Nav 3.60 to Nav 5.0 this year. Do you have any recommendations that I should keep in mind for the upgrade??? I have seen that the upgrade toolkit works for ver 3.70 ->5.0 and 4.0->5.0 does it works to upgrade from 3.60->5.0?? Thanks. :?
-
How can I filter viewing checks in Nav 3.60
Hello Forum: Is there any way that people from A/P A/R won’t be able to see payroll checks???? Currently when they go to General Ledger -> Bank Accounts and click on the scroll down arrow in Balance option then they are able to see all checks, for vendors but also from payroll, is the any way to filter that they be able to…
-
'Automation' is not an option
Hi, on Navision SQL 3.01b I try to work on some application for NAS I am following the indications of the NAS TUTORIEL that I found here on mibuso. In this tutorial it is said to create a CodeUnit and to declare a variable like this : Name NavisionTimer Datatype Automation Subtype Navision Timer 1.0'.Timer But the datatype…
-
Inventory Adjustment codeunit (5895) InsertAdjmtEntry 3.10?
Hi! A little while ago, one of our clients, who run 3.70, asked us to put in a negative stock check into their system, which we did. As part of this I put in an exception in, in codeunit 21, so that in the event that the transaction was an adjust costs one, then the check would be over looked. To get this to work I added…
-
Locking Question
Hi all, Im a little baffled by Navision locking here. There is a user here that posts a large job once a day. During this time everyone is able to post purchases and sales perfectly. No issues. However there is a scheduled job that fills a Gen. Journal for me. If I go in while the user is working to POST this journal I am…