-
What does this statement do?
Hi all, Sometimes I see a line of code that seems incomplete but it's not, and I am just wondering what it means and why it's written this way. Below is an example: IF ShipmentMethod.GET("Sales Shipment Header"."Shipment Method Code") THEN BEGIN END; My question is specifically related to the THEN BEGIN ?? END part. Thanks…
-
How to stop CAL waitin for Form
My God, have forgotten how to fix this - haven't done for the last 10 years. Having a menuitem calling spec. posting of salesorder. In code I have placed a FORM.RUN(the number). This form is for making some speciel comments(drawing ref.) in own comment-table and has nothing to do with Rec. How do I stop the following code…
-
testing the smtp connection
Hi all I have a job running through som sub-jobs (among other, posting invoices) and at the end it calls a codeunit sending an e-mail with invoice as PDF-attachm. If internet connection is lost all jobs has been done, but the mail is missing. How do I check whether I have connection to the SMTP server before running the…
-
Multi company Item's
Hola, tenemos una empresa con NAV 5 y en el sistema se tienen 5 empresas, el problema que tenemos es que tenemos que tener en todas las empresas los productos (solo algunos campos), clientes y proveedores con la misma información. Y el proceso de hacerse manual ha impactado en muchos errores. Tienen alguna solución o…
-
Integer field view style as decimal/separate digits
hello everyone, how i can set view style of integer field as decimal field? ex.:"200 000" - sepatare digits thank you and sorry for my english
-
XMLNS Problem
Hello, i make my code to create XML Sepa file, work fine!!!!! but have only one error, is write a attribute XMLNS and i can't remove, ex: I need: <?xml version="1.0" encoding="UTF-8"?> <Document xmlns="urn:iso:std:iso:20022:tech:xsd:pain.001.001.03" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <CstmrCdtTrfInitn>…
-
Error message; Customer: The Sales Header does not exist. NAV 2013
Hi, I receive the following error message when opening customer card: Customer: The Sales Header does not exist. Identification fields and values: Document Type='Invoice', No.=XXXXXX' I don't manage to find the related order and no trace in the customer ledger entries. Does a manually created invoice with that number if…
-
Import Item Journal Line through XML port validate Amount
I am trying to import item journal Line through XML Port in Navision 2013 R2. i want to validate Amount in the item journal Line If the Value Is Zero else it should not validate i did the following steps Defined the Amount Node Name Node Type Source Type Data Source Amount Element Text <Amount> Added following Code…
-
How to generate the month wise report of inventory valuation?
i want to generate the report month wise of inventory valuation..i want to develop two field according to month increase and decrease.can any body help me how to develop.
-
C-Form pending quarry quarter wise
Please help sql quarry of Navision 2009 Classic C-Form pending F.y. year wise Quarter wise. Thanks Chetan
-
Question to hide\show report columns dynamically
Hi to all, I need to dinamically display or hide 2 columns of an existing report, I've looked at several possible solutions but I can't find anything.....can someone suggest me a way to do this action ? Thank you in advance for your help. Best regards Fabrizio
-
Fast Excel export from Navision 2016 to Classic? (Report Builder)
Hello, in NAV 2016 there is a fast solution to excel export - Report Builder. You can read about it here: https://community.dynamics.com/nav/b/vikosnavblog/archive/2014/08/30/template-based-excel-reports-functionality-in-nav-2013-r2-ru It's fast and convinient. But it's only in Russian database? How I could import this…
-
BA Configurator file for Nav 2009 (SQL Server 2008)
Hi, From where can I download the BA Configurator file for Nav 2009 (Sql Server 2008)? Thanks & Regards
-
Data upgrade NAV 2009 to NAV 2016
Hi, I am working in NAV 2009 to 2016 upgrade project, I have completed the Code upgrade part from NAV 2009 to 2016, Now i am doing Data upgrade from NAV 2009 to NAV 2015, i have completed the first step (Upgrade601800.[Country].1.fob) and after synchronizing tables in NAV 2015 i need to import NAV 2015 objects, I don't…
-
Item Availability by Location filter
Hi, Is it possible to filter Item availability by Location (form 515) to show only locations where inventory is not 0? Thanks, Y_1716
-
Replication, Field List.. help
hello everyone.. i have table on two different pc, and one field[option] that can be replicated olny if field<>option::0... this field added to exclude list.... i think what need to choose conversion type ... but what?... sorry for my english and thank you for answers
-
logging in to NAV RDP from accross the planet, too slow
We need to provide read-only access to our NAV Classic 2009 through RPD to accountants, auditors living halfway across the planet and it is unusably slow. IT tells me it is the laws of nature, bouncing electrons to 8000km always has latency. Not having the new versions in some of our subsidiaries web access is not an…
-
Filter Option values in Form
Hi :) I have a form with a text box of type Option, and it has values in the OptionString property ; <Senior Manager, Manager, Senior Partner, Partner> Is it possible to filter these depending on a criteria? Thanks, Y_1716
-
Fully subcontracted / outsourced production order caveats?
I when you don't own a factory, it is outsourced, but you still manage your BOMs and all that and it is going to be complicated so you decide to use the Manufacturing granules. NAV2009. As typical, I have to implement it without any sort of a testing period or pilot project, one day we are going to sign a contract with a…
-
How to access Other Outlook Client in NAV 2009 R2
Dear Sir, Is it possible in NAV 2009 R2 (Classic environment System) to access a Particular MS Outlook Client from the different NAV Clients. Every NAV Client will use CU 397 to create a draft email in the Particular Outlook Client. Kindly reply.
-
Evaluating NAV2016. We are on 3.70 & really could use some screen tips.
Some of my key users have started to evaluate the Demo version of NAV 2016. But oh boy, the UI/screen layouts are very different from our current 3.70 version. As such, my testers are becoming frustrated (even irritated..) because it's taking them 2-4x as long to perform any work-process, because they can't find their way…
-
Insert new line for a string in C/AL Code
Dear Could you please tell now to insert new for string A := "Welcome" B :="Cambodia" how can i make C become 2 lines ? C := A + B waiting for your kindly reply.
-
Outlook Automation : Appointment Item
Hi I am trying to create appointments in folders form Navision using outllok atuomation as follows: CREATE(oApp); oNS := oApp.GetNamespace('mapi'); oRecipient := oNS.CreateRecipient(Recipient); oFolder := oNS.GetSharedDefaultFolder(oRecipient,9); //9 is constant for Outlook.OlDefaultCalendar.olFolderCalendar oAppt :=…
-
How to make connection between NAV 2009 on terminal server and outlook on the local machines?
I'm new to NAV, make a research, but I can find, that everybody mentioning 'the TS is going to be very tricky when it comes to synchronising with Outlook on local machines'... But haven't found any decision yet. We're using NAV 2009 Classic Client (exclusively) and use a Terminal Server to run NAV. All other programs…
-
Incoming http Request Modifying NAV Table [NAV 2009 R2]
Hi there, I am designing a code unit and a xmlport in order to modify NAV contact table record from an external .net http-request. (Avoiding physical xml-files in the process is preferred). However the method below is only good for inserting new records into the NAV table. Modifying is also required. A XMLport has the…
-
i create a no series on table or page but when insert new record then enter on document no dont get
when assist on document no and select the series then get the correct ddocument no please suggest me how can do that
-
The validation for file:///C:/Users/Wasiu/Desktop/Nav 2009 R2 W1/TransformationTool
The validation for file:///C:/Users/Wasiu/Desktop/Nav 2009 R2 W1/TransformationTool/ApplicationObjects.xsd.tmp.xml failed. Detailed Information: LineNumber=5, LinePosition=8
-
You can'tcreate an Automationobject"XlApp"on Microsoft DynamicsNAV Server. mustcreate it on compter
You cannot create an Automation object "XlApp" on Microsoft Dynamics NAV Server. You must create it on a client computer.
-
COGS and Inventory Accounts Suddenly Not Posting
We have noticed that our COGS and Inventory Accounts are suddenly not posting. Invoiced sales no longer show these 2 accounts in the G/L. We are running Adjust Cost - Item Entries. Any ideas as to what might be causing this? Thank you, headley27
-
PCI compliance issue with Navision 2009R2 MSXML on Server 2012 with SSL/TLS 1.0 turned off
We have a 2008R2 Webserver with IIS 7 that we access from Navision Webservices using msxml3 automation. Everything is working correctly. We created a new 2012 server with IIS 8 and was forced to shutdown ssl and tls 1.0 (due to PCI compliance). When we run our Navision msxml automation routine in Windows 8 or 2012 server…