-
Nav 2009 on SQL Server 2012
HI I am trying to install Nav 2009 on SQL Server 2012 to see if those are compatible Its NAV 2009 without R2 or SP1 But I keep getting this error no matter what I do. I have done exactly what message saying but to no avail. Microsoft Dynamics NAV Classic The following SQL Server error or errors occurred:…
-
How to install Nav 2013 on a SQL Cluster Active-Active
Hello to everybody. It's possible to run the Nav 2013 version (or 2013 R2 in few time ... ), on a SQL Cluster 2012 R2 or 2014 Active-Active? If yes, are there significant performances improvement between this kind of installation instead of classic SQL Cluster Active-Passive? Thank's to everybody.
-
Updating a table when adding a field to another one
Hi everyone, I have a question that may be stupid but I just want to know if it is possible... Let's say I created a field to Table1 and put a value on it, is there a way in NAV that the same field be created to Table2 with the same value ??? Thanks a lot :mrgreen:
-
Export to Excel Item no. question
I have a client who have their Item no. as 00045648333443 and when I create a report to send it to excel it drops the leading 0's and just shows as 84453555 or sometimes shows as 8E+2E0 something like that. I am just using Excelbuf.Addcolum(item."No.",false,false) Is there any way you can format it such that it shows…
-
Connect to external webservice
Hi, I need to connect to an external webservice that has these specifications: I'm trying to connect to the webservice with this code: IF ISCLEAR(WinHttpRequest) THEN CREATE(WinHttpRequest);IF ISCLEAR(XMLDoc) THEN…
-
SOAP web services and NAV restrictions
Hello, I have to find a way to consume 3rd party web services within NAV classic clients (5.0 to 2009). I found no mention of WCF usage within NAV in neither this forum nor anywhere else. So I decided to create proxy SOAP services first and then consume those services in NAV. I did consume SOAP web services thanks to the…
-
Navision In Vietnamese
Is there anyway that I can display/input Navision 3.0 & above in Vietnamese? Can i change the whole program into Vietnamese?:?: If the language module can help, where can I download it? Thanks. Philip
-
Vietnam Currency - VND
Hello all, Have anyone experience how to setup VND currency? I've already setup myself but I'm not sure 100%. We can not find VND currency in Navision Currencies. I want to know how to setup: Invoice Rounding Precision Invoice Rounding Type Amount Rounding Precision Amount Decimal Places Unit-amount Rounding Precision…
-
Conditional FlowField
Hi everyone, I am new to Mibuso and also in NAV2013R2 so, be indulgent here but tell me if iam wrong :) What i am looking to do is a sum FlowField here's my Code: Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global…
-
Flowfield with company name as a filter
Hi everyone, I have created a flowfield in the item table with the following calcformula:Sum(MyTab.Quantity WHERE (Item No.=FIELD(No.),Status=FILTER(s1|s2),Location Code=FIELD(Location Filter),Requested Receipt Date=FIELD(Date Filter))) Since the table MyTab is shared between the companies (DataPerCompany=No) and there are…
-
Weird error from Dialog
Hi! I get an extremely weird error when trying to use the standard progress bar type dialog The code looks like this, it's basically copy-paste from report 81: Window.OPEN( Text001 + '\' + '@1@@@@@@@@@@@@@@@@@@@@@@@@@\' + '#2#########################\'); The weird thing is that it works beautifully if i change the global…
-
Issue: Jobs being stuck in Navision
Dear All, I have been experiencing an issue with jobs whereby there is a particular job being blocked with object type=0 and object id=0 and the field 'Active' is ticked but the 'process running' is unticked. The issue here is that this is blocking all other jobs and no jobs running at all after this. Note: The NAS has…
-
NAV 2009 mainstream support
Hi Nav 2009 mainstream support is ending in march 2015. What existing Nav 2009 end users need to do? The extended support ends in 2020 and what that means? Thanks
-
Upgrade NAV4 -> NAV2009 performance problem
Dear community, I'm working on upgrade from NAV4 to NAV2009. I'm using standard MS Upgrade Toolkit procedures and now stuck on the Upgrade NAV 2009 Step 2 codeunit. The problem it that upgrade takes so much time that it's impossible to finish it during weekend. Database size is about 400Gb. I already replaced some steps…
-
How to rename "Line No" in Purchase Line
Hi to all, I have a Purchase Order with this Line no:10000,20000,25000,30000,40000 I try to rename "Line No." in T:"Purchase Line" using the function Rename but stil give me a error: You cannot rename a Purchase Line. Any advance? Thanks a lot,
-
Print URL - Hyperlink from Customer Card on Document
The purpose of this question is that i need to create a report in Navision (vers. 2009) of all customers. Fields to display are customer no. - name - and url or hyperlink to open the customer card. The document needs to be printed and will be saved as a pdf The result is a pdf document that can be used to open directly the…
-
How to modify record on OnAfterGetRecord
Hello Imagine, user needs reminder about not matching field value when he opens form/page with possibly incorrect data. He is asked if he would like to change value to correct one. But he still has possibility to refuse suggestion because he does not need to change value. How it is supposed to work: on the form/page in the…
-
Inserting Lines on Transfer Order line
When you are on Transfer order and on the lines when you try to insert a new line between 2 existing lines the inserted line automatically gets inserted at the end, this does not happen on Sales order or Production order where in you can insert the lines between 2 existing lines as long you have line nos available between…
-
Roles management in NAV 2009
Hi everyone, I want to know how roles and permissions are managed in NAV 2009. I know there are tables such as User, Member of and Permission....but is there some code (a codeunit or so) that is executed when we try to access or execute an object? Thanks in advance :mrgreen:
-
Customer no changed in dynamic nav to another number suddenl
I have dynamic nav 2009 r2 in customer card i have customer no 3099 changed to 3064 automatically without any changed i dont have data port Are there are any function or option changed this from number to another number more explain Customer No 3099(before 1 day) (mention sample) JE-PSI-000115 22/04/2014 22000…
-
Negative stock
hi; how can i avoid a negative stock? Thanks
-
Permissions on tables
Hi, Can anybody explain why a user which has permission only to read vendors and doesn't have permission to insert, modify or delete in vendor table is able to change vendors' names and addresses :?: Thanks, Meri
-
Integrate CRM 2011 & NAV 4.0 SP3
Hi all, Our company has been using NAV 4.0 sp3 and now we want to improve Sales department with CRM2011. how can we connect them together?As i know, MS support connector for NAV 2009 R2 & CRM 2011. our CRM partner suggested Scribe connector . we want to get more information than existing mapping of Scribe. Scribe developer…
-
Posting date=system date
Hi every one; How i can make init value of Posting date (Table 36:Sales header) equal to system date. thks
-
Sales Quantity - monthly, by category and for 1 distributor
Hello together, First, I think this topic does have nothing to do with the new functions, so that I should be in the right corner of this board. I got the task to develop a report and due to the circumstances, that I have only started with Navision report development 2 months ago, this task seems to be unresolve able for…
-
RFID and NAV for warehousing purposes
Apologies if this is in the wrong place, first time poster. I have searched the forums, the products page and done some general online searching. My question is about using NAV in conjunction with RFID scanning equipment. Are there any user friendly programs or add ons which will work well to seamlessly integrate the…
-
Bigtext Memory Leak
If you use a bigtext in a function (or a codeunit) and you call that function (or codeunit) a lot of times, Navision doesn't free the memory for it. Not even with a CLEAR of the variable. In the taskmanager I notice that the Navision client (or NAS) takes a huge amount of memory. So the only way I found is to close…
-
NAV 5.0 Debugger stopped working
Anyone have any idea why my NAV debugger no longer works? I've tried creating a new database and used different client locally the debugger will not work. It was working a few weeks ago. Is it a windows setting possibly? I've tried with different licenses as well. I appreciate your input.
-
How to get Table-ID in OnModify() trigger
Hi, I have to do some coding in an OnModify trigger of a table. Is there a function or a variable I can use to get the ID of the appropriate table ? I also want to make a function in a codeunit which will use FieldRef to return all field names of a table. This function will be called by an external COM-application. My…
-
Where does Payment Registration Buffer takes its content fro
Hello, Where does the "Payment Registration Buffer" takes its content from. What I am trying to do is add a field to Payment Registration Buffer and when it is posted the new field's value should reflect to posting table. And if possible I would like save the value of the new field to reflect to the original table also.…