-
Nav 3.10A + Matriks 2.0 in Win7 XP mode
Hello ;) We are using ancient version of Nav 3.10A + Matriks doc 2.0 and now we migrated to Win7. Nav is running in virtual pc, XP mode. But i can't get Matriks to work in XP mode. It is used for viewing .pdf files, attached to items in Nav. Unfortunately i don't have any error log or message. When you try to run it, all…
-
Upgrade 3.6 to NAV 2009
Hi, Could anyone please explain the steps to upgrade Navision 3.6(sql 2000 version) to NAV 2009(sql 2005/2008)? Also the software & hardware requirements on the box where we do the upgrade? I know we have to do a two step upgrade from 3.6 to 4.0 to 2009. Our current version is highly customized, just an FYI. Thanks
-
Importing Item Journal Line from Excel.
I am using the Data Migration utility in navision to import the data from excel file. I am inserting the data in Item Journal Line Table. The issue is that when i import the data it imports every thing and shows the data fine. But it is not importing the Posting Date, Although it is there in the sheet and when i open the…
-
Native plugin ETL for Dynamics Nav - Navision 3.60: Talend
If someone of you are interested, here you can find a native plugin for Navision 3.60 for Talend.(using C/FRONT) With this one you can extract data and transform it easily with talend, and load it anywhere. You can maybe load data into Navision but I never test it. It's only working in Navision to 4.x version not higher…
-
Compare two reports?
Nav 3.10 Is there something used to compare to reports? For example, there's software I can compare two text files and find differences. I have some reports that should output data in the same format, but only now we noticed they are not. Sorry for all the description. I would show you screen shots, but our warehouse guy…
-
Cannot open navision table
Hi, I am trying to open a navision table and getting the below error. Can someone help. Thanks. Microsoft Navision AttainThe Object table contains a BLOB field with invalid compression data: Record: Type='Table',Company Name='',ID='36' Field: BLOB Reference OK
-
one field does not exist in Sql server table or view?
When I backup the database, navision give me a error: The Lot N?on quote field on the sales line buffer table does not exist in the SQL Server table or view. then backup stop. has anyone an idea?
-
Upgrade to NAV 09 - Rip off ?
Hi We are a small company still running Navision 3.6. Our Solution Center now offered us an upgrade to NAV 2009. Since we do not have a Licence Contract with Microsoft, we were told that we have to pay a penalty for all the months we didnt pay any fees. Apparently this is because thats the only way to keep our few licences…
-
Advantages and disadvantages using DB login and Windows Logi
HI ALL, Can I know the advantages and disadvantages of using DB login and Windows login In MS Dyanamics NAV 5.0. Look forward to your reply. Thanks, Sammera
-
Consume more material when using pick in production
Hi, Is there a way to consume more then expected qty on components when using pick in production? For example we need 10 components but during operation drilling we drill wrong diameter on 5 components so we need to get an extra 5. It's not possible to create a new pick without adding another 5 to the quantity in…
-
Call Navision dataport from other programming language
Hey people How can I call a Navision Dataport from an other programming language such as VB, C++ etc? I am planning to use the pre-defined dataport SalesOrder to send orders directly from web to Navision Attain 3.6 I have tried to find such functionality in the CFRONT API. But this API seems to be more like a data layer…
-
Determine superuser status?
I have a field that I want only SUPER users to be able to view. Can I determine programatically wheter a user is SUPER? Thanks...
-
Accidentally deleted a few fax #'s.. anyway to get back?
Navision 3.10 I accidentally made a boo boo! As you know I'm always looking to correct errors. I'm still going through and moving and removing wrong things on Customer Cards. For example, someone was putting excess spaces in random places, someone was writing email addresses in the website field, etc. Well, today I was in…
-
Set focus to a specific field if criteria not met
Hi there I want to test on the modify event of a table if a value entered is valid, if not I want to set the focus back to that field containing the invalid value and don't allow user to continue, unless he cancel the entry. The error statement causes a rollback and the all will be lost, so this is not a solution. Is the…
-
Sub Form button error : Field No. 6 is not defined
I have created a new form that sources the Tracking Spec table, I also have a sub form view to Item Tracking that sources the Item Ledger Table. On this sub form I have specified a button called Navigate that when clicked opens up the posted sales shipment document related to the line the user is focussed on. Now on the…
-
Format Problem
Hi, we are currently customising existing product navision 3.6 as per customers requirement, One of Customers requirement is that Amount shown in application should be in Rupees format(Indian Currency) i.e. amt 999,000,000.50 should be shown as 99,00,00,000.50 This change is required to be done applicationwide. Regards,…
-
group by month, quarter, year
Dear All, I'm new for NAV. and my project is to group field "amount" in "Purch. Inv. Header" classify by field "currency code" group by year, quarter, and month. pls help me Thank you very much.
-
convert number in text
Dear All, I've an decimal variable, in which iam assigning a value in loop, i need to copy this value in text. e.g. First Time 101.10, second - 2311.12 in Text variable - 'Detail' the data should be store like - 101.10,2311.12 please help. Regards, Jai
-
Adjust Exchange Rates Batch Job and Dimensions
When this batch job is posting exchange rate differences, where from is it pulling dimensions? It looks like it is pulling dimension from G/L Account but only two global dimensions. I consulted NA 3.60 Financial Management.pdf but there isn't anything in there about dimension. Any info? :-k
-
Nav 3.10 became slow maybe this week it started..
Navision has become a little slow lately.. maybe the past week. Here and there the hourglass pops up for maybe 3 - 5 seconds each time. It's never done this before. People have been complaining, but I don't know what to tell them since it's never happened before. I haven't done any modification to Navision or any server…
-
Change default of a option
I'm in Nav 3.10. Purchase and Payables, Orders Received. In there is an MenuButton that says "Posting". From there I have several options, one of them is "Post (F11)". When I hit post, it gives me three options Receive, Invoice, Receive and Invoice. It defaults to having Receive and Invoice button marked. I can't see to…
-
Upgrading navision 3.01 to NAV 2009
Hi, i have to upgrade navision 3.01 to NAV 2009. I havent worked before with navision but i have read about it for some weeks. Maybe somebody can give me some advice what is main steps to follow to do it. I watched one video and like i understand i need to make client non-customized objects file, client customized objects…
-
Payment by Credit Card
I have a vendor in the system which we now pay by credit card. Is there a way in the payment journal (or somewhere else), that when I chose to pay this vendor, I can have it post to the credit card vendor? For Example: We purchased services from Vendor 123 of $1,750 and paid by VISA. Vendor VISA has all the lines for…
-
Internal Error
Hi All, Any idea for this error, Internal error 1247 in Module 9 If I search in net I get only this, 19 1247 #Err_DB_NewWTAMissing DB_Err(1247) But I need to know why this happens and what's the solution, coz one user logs in and simply click on Contact list, then this error comes and navision log off. Plz help Rosh
-
Same problem
Did any solve this problem? I'm having the same issue. Thanks
-
how to group by record in NAV
Hi all, i've one table havig column below - Item Code Lot No MRP Location There are multiple MRP against multiple LOT No. now i want to group the record on screen with Item & MRP e.g. 1001 LOT1 200 XYZ 1001 LOT2 200 XYZ 1001 LOT3 300 XYZ Te ouput required 1001 200 1001 300 please help me Regards, Jai Verma
-
User permissios to add users
Hi there all, I have a customer who is on high level of security and need to have two kind of users. Do anybody know how to make permissions for these two users: User 1 He may add a new user and nothing else User 2 He may ad permissions to this new user I have tried nearly everything but cannont get it solved. Any help?
-
How to use DISTINCT(as in MSSQL) in NAV??
Hi All, I want to show some distinct reord in NAV Form, please let me know the way of same. e.g. Table Contain - Item Code & MRP 1001 200 1001 200 1001 300 On filter of Item 1001 the output required. 1001 200 1001 300 please help Jai
-
Navision: how to record transaction with cash advance?
Dear all Navision expert I'm not an expert in Nav. For the last 3 months, I've been hanging around with this application with lots of problem. i wish there is anyone in this forum could help me out. Here is the scenario: In real practice, I have transaction as below: 10-Oct-2010: Advance cash to vendor 1 for clearance…
-
FlowField to calculate duration
Hi, I would like to create a FlowField which calculates the diff between the values of two date fields of a table (the duration). Is it possible? As I can see the method referes only to one single field and there is no "Diff" method. Regards Michael