-
Importing UTF-8 bigtext variable to XMLPort
Hi guys, I'm currently working on importing XML file into XMLPort. My file (or text, whatever) is placed in someVar of type bigtext. Now I'm writing this someVar into output stream and finally I have inStream to import. The problem is that somewhere between assigning XML to someVar and importing it into XMLPort there is a…
-
Cursor on First Line
i am trying to keep the Cursor on First line if sorting is done Ascending or descending the cursor should remain on first record. need help..
-
Navision server cannot be found
I’ve noticed strange thing in my NAV installation. Occasionally, different users can’t get an access to Navision server. There is a warning message like: The Navision server cannot be found. Try again later or contact your system administrator. Or The 192.168.XX.XX server cannot be found. Try again later or contact your…
-
Can't see row/column dividing lines in NAV Classic Windows 8
Hi all, Has anyone noticed that in Classic Client on a Windows 8 machine, you can't see the dividing lines in any grid, e.g. table or list type form? Apparently, the "Windows Classic" theme has disappeared from Windows 8, and I haven't found a way to replicate it. I've tried a few third-party themes that claim to emulate…
-
item ledger entries sort by newest first
Good afternoon I am new user of NAVISION 2013 (in the past I used to use AXAPTA). When I go to an item and then to item ledger entries I configure NAV to sort the list as "sort descending" (From Z to A). But to go to the first entry I must go to the top of the list (Ctrl+home) How can I configuro NAV to goes directly to…
-
Xrec equals Rec when calling Validate from XMLPort
I am inserting records into the sales line table using an XMLPort in NAV2013 R2. I use the following statement to assign the item code, which is read into the SKU text variable."Sales Line".Type := "Sales Line".Type::Item;"Sales Line".VALIDATE("No.",SKU); However this fails to execute the following code in the No. -…
-
Binding = Order-to-order
Hi All, Could someone please describe me what does the following information mean? "You cannot state Serial No. or Lot No. on a demant when it is linked to a supply by Binding = Order-to-order"? It shows when I want to post Shipment from Sales order. I have not assigned Serial numbers yet to the lines so I think it might…
-
Is possible store a mail sent Through codeunit 400
I have to send many mails in a process, but i don´t know how to watch if those mails have been sent correctly. Is possible store mails in a outlook client or on another site?. i have been thought insert a record in a table when i call to send function, but this function doesn´t give an error when the mail send is wrong…
-
irrelevant data copied on clicking "Export to Excel" NAV2009
Hi All , My form is designed such a way, if data persists then the corresponding textboxes and labels will be visible else the textboxes, labels in the form will be invisible. In a case where there are no visible fields in the form, some irrelevant data is copied to Excel on clicking Export to Excel(Microsoft's inbuilt…
-
Static variable in XMLPort
Hello guys, I'm currently working on connecting my new Codeunit with some XmlPorts. Is it possible to make it in this way: 1. Set global variable in xmlport through Codeunit CU => XMLPORT 2. Execute some logic in XMLPort 3. Return variable from step 1. from another function CU => GetSomeGlobalVarFromXmlPort(); As far as I…
-
Encoding issue in NAV2009SP1 Classic Client
I need to convert an XML document to a BigText in NAV2009SP1, so I don’t have any .NET Interop. First I made this simple function: CLEAR(p_BigText);p_BigText.ADDTEXT(p_XMLdoc.xml); This works perfect at both the ServiceTier and in the Classic Client, except the Classic Client only support small xml-files. Once the xml-file…
-
Weird Revaluation Journal Issue
Today, we found few items do not show up in Revaluation journal calculate inventory process. I even tried directly giving the item no. in calculate inventory report filter. and event went through Debugger ad could not find any filter. Item table not filled (some secret filter, i think). No customization of this area and…
-
Compress or Shrink Large Size NAV Databases.
Hi All, Can anyone help me out, I need to compress the Size of the NAV (Testing) Databases, Lets say I have an database Size of around 400 GB or 500 GB. I need to compress these kind of databases to half of their original Size What all possible option are available to do that, as SQL Database Shrink option will not help me…
-
Substitution of Purchase Return Order
Dear all, This problem is driving me crasy #-o . The situation is like that. A user posted purchase receipt, posting date = 24/07/2014 Then, user created a purchase invoice, got receipt lines and posted, posting date wrongly inserted 24/08/2014. Suppose it should be 24/07/2014 Finally, the Ledger Entry posting dates are…
-
Nav Account Schedule, Include/Exclude Closing entries
Hi can any one help me in understanding, in nav Accounting Schedule we don't have option to include/exclude closing entries, in Nav 4.0 this functionality was available, as i know upgrading means add on the new features, but they removed this feature, is this functionality is available in anyother area, kindly let me know…
-
BA Business Analytics on Windows 2012 / SQL 2012
Did someone manage to install and run the basic BA package on a W12, SQL12 machine? I tried installing and running the 2009R2 Classic Client and the BA configurator exe (2008 Version 4.0.0.27) on a W12, SQL 12 test box but the configurator wouldn't even start. Error: ProblemEventName: CLR20r3,…
-
ER-4 Report
hi I need to ER-4 Report, ANNUAL FINANCIAL STATEMENT . Is there any ER-4 Report present in navision.If any please give me the Report Id or give any suggestion that how I will do this?.
-
NAS (nassql.exe) stops working when applying hotfix 36259
I have a NAS service (build 32012) which works perfectly on a Windows 2008 R2 server. When I install hotfix 36259 (by simply copying the hotfix files into my NAS folder), I can no longer start my NAS service. I get an error saying "Error 1053: The service did not respond to the start or control request in a timely…
-
Synchronizing contacts between companies
Hi. I'm working in a company which has 7 companies inside Dynamics NAV. Most of them are only using accounting module. They've just created a new company which it's going to work with a own module based on contacts module. As they need to work with contacts already created in the "master" company, I need to share them…
-
Discount Percentage on Sales Header
Dear All, Does any body has the code that need to be added to the Sales Statistics Page in NAV 2013 R2 to allow invoice Discount Percentage. Please I need it very Urgently. Best HAYAN
-
Sorting by Flowfield - on demand/timer, frm already filtered
Hi all, I have a form based on the Sales Order List, that has a filter applied to the Credit Status field. It refreshed using OnTimer every 10 seconds. What I would like to do is sort it by Credit Status, however it is a flowfield. I am wondering if anyone would object to the following way I am doing things: On the Sales…
-
Build Bigtext and pass through to OSendMail."To" := ToName;
Hi guys, I'm trying to get NAV to go through a list of members, build up a list of email addresses with a ';' between each entry and then to create an Outlook Mail and pass the bigtext through to the .To or .CC or .BCC option. I have tried several difference senarios, from writing the email to a text file, reading the…
-
error ending date when import consolidation database
Dear All I got this error message when import database from business unit (NAV 2009 R2) : " The Ending Date 01/31/14 of Business Unit A, is not the Ending Date of the fiscal year of company A" I want to consolidate 2 company within the same database, both of them using LCY. here is the step: 1. I made a new company : "…
-
PortableDeviceAPI 1.0 automation in NAV 6.0 R2
Hi, For one of our customers I need to write a new codeunit that controls a camera attached to a NAV 6.0 R2 Windows Classic Client. I need to be able to take pictures and attach the picture taken to an Item in Navision. Previously this was done with a codeunit that used the WIA drivers. The NAV 6.0 R2 Windows Classic…
-
applies to document no empty when i make return order
When i want to return invoiced purchase order it is accept to return order and applied to doc no is blank and applies document type is blank. I think the posted invoiced is not applies so that i make the following steps : 1- go to Vendor card select vendor no to invoice i need to return 2-select vendor ledger entries then…
-
Update rec in form by command button condition based filter
Hi ALL, I have a doubt in Form update. In form, If one GL entry is checked & made boolean tick mark then & other entries of same Document no should also be boolean ticked. then if i click on update button it should filter the rest of entries which is not reviewed. Can anyone tell me how I can make the update of entries…
-
Hide Module in MenuSuite
I want to hide module based on company using Navision Codeunit. Ex: I'm having Company X and Company Y Module 1(Service):Finance Module 2(Service):Warehouse For Company X both Module(Services) should be display. For Company Y Module 1(Service) should be display and Module 2(Service) should hide
-
Disabling a field when some condition is true
Can we diable a field when some condition is satisfied? Suppose i have checked a check box ,now i want some text field to be non- editable. What can be done for it?
-
Update sales orders in a page
Hi, Does anybody know an easy way to update multiple records on a page without having to open every record. The example here is the sales order list. When I'm on the page 'Purchase Order List (9307)' I would like to update a date for a bunch of sales orders. The only way (as far as I know) to do this is open every order en…
-
Question: Flowfield Performance Key
Hi guys, A newbie question about FlowField performance (Native database). On the Customer table I have this field: Field: Balance Type: Decimal FieldClass=FlowField; CalcFormula=Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Customer No.=FIELD(No.), Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter), Initial…