-
XMLport - use codeunit to Output through 3 XMLports to same file.... FIXED format
Hi I'm thinking about using the XMLport for at FIXED-formatted file. I think the scenario like this : - I have 3 XMLPORT's - - Line1, Line2, Line3 - From a codeunit I run a Loop through a table, and run Line1,Line2 and Line3 xmlports... My File have to look like this. PrefixLine Line1 Line2 Line3 Line1 Line2 Line3…
-
Strategy / project management for information interfacing
It is NOT a technical question. Rather would like to pick your experiences about how to manage / plan such projects, what are the best ways. So basically your employer has subsidiaries abroad that use various non-Navision accounting software. In order to keep track of their business, you need to daily upload their…
-
Combining NAV2009->NAV2015 and NAV2015->NAV2016 steps
Hi, I've posted a couple of questions recently about upgrading from NAV2009 SP2 to NAV2016. One person suggested it might be possible to merge the data upgrade steps from 2009->2015 and 2015->2016. I assume this would mean merging the instructions in the "TableSyncSetup" function and adding the other related objects from…
-
How to make "Read Only" status visible in a word document opened as an interaction attachment
Dear Navisioneers. I am using mibuso.com for years and have found many many usefull tips and tricks and insider knowledge. Thanks to all of you for this great help you give to users and developers! But for my current problem I could not find any suggestions: A logged interaction is for NAV a posted Information and therefor…
-
NAV 2016, O365 Mail error
Hi, We get an error trying to use O365 smtp setup in NAV 2016 CU 0. Entering the mail information in the SMTP setup window and then testing setup gives following error: A call to Microsoft.Dynamics.Nav.SMTP.MailHelpers.TryGetEmailAddressFromActiveDirectory failed with the following error: An object of type…
-
Importing xml document using XMLDOM automation
Hi All, im trying to import a XML document containing invoice lines via XMLDOM Automation. Code: //Import Invoice Lines IF XMLDOMMgmt.FindNodes(CurrNode, '/rsm:CrossIndustryDocument/rsm:SpecifiedSupplyChainTradeTransaction/' + 'ram:IncludedSupplyChainTradeLineItem', CurrNodeList) THEN BEGIN NoOfCurr := CurrNodeList.length;…
-
Show Reserved Physical in SO Lines
Hello, i need help. i want to show the Reserved Physical in SO Lines here is how to get the Reserved Physical: get the (12) reserved physical and show it in Sales OrderLines: how to do it? can you show me code please? thanks
-
How to downgrade assembley with .NET Framework 4.5 into 3.5?
Hello All, I have some .dll files without source project that created on VS2013 C++. It works fine on NAV2013 and 2016. But it doesnt work on NAV2009R2 because of .NET Framework. I cant change .NET framework target on VS because I dont have source project of these .dll. How to change target framework? Regards, Undy
-
Does anyone use "Build restriction"?
Hi, all! Does anyone use "Build restriction" function on service tier setup? By default it is set to WarnClient which should produce warning message if client with different build connects to a server, but I always receive error message that my build is different. I've tried this on number of different clients, NAV…
-
NAV2016 SPN
Hello, When typing : setspn -l domain\computername$ I have the impreesion that I don't get all spn's When I try to add an spn with : setspn -A ... I get a long list of spn's and the indication that there is already an entry In this long list there are more spn's for the machine than I can see with the -l option
-
NAV 2009/2013/2015/2016 on SQL2014 - Use Delayed Durability = FORCE or ALLOWED during data upgrade?
Someone in another thread mentioned using Delayed Durability = FORCE or ALLOWED during data upgrades if the SQL Server is SQL2014. The article he referenced is: http://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014 If you do a demo install of NAV2016, Delayed Durability is set to "Disabled".…
-
NAV 2015 (2013, 2013r2) and ADCS (error The Field does not exist.)
Hello all. Got an error when trying to connect to adcs (all installed, setup done, all services started): Does anyone have an idea how to fix this? Some extra info (maybe useful): Investigation showed that table 2000000002 is User table in NAV <=2009r2 In NAV >=2013 User table has ID 2000000120.
-
CU400 sends special Characters to Hotmail, Gmail etc.
My client Running 2009 R2 has trouble sending emails with attachments to for example hotmail and gmails but not to xxx@[company].com mails. The subject and name of the attachments is strange characters looking like Chinese or something. In the overview list, the subject looks fine, but when you open the male noone can read…
-
How do I write the code in the PostCharge function trigger so that the function does the following
1. For each record in the Seminar Charge table that corresponds with the Seminar Registration Header, the function sets the JobLedgEntryNo to the result of the PostJobJnlLine function (run with a parameter of 1) and runs the PostSeminarJnlLine function (with a parameter of 3). 2. Sets the JobLedgEntryNo to 0.
-
Can I call assembly in assembly?
Hello developers, I have to use an unmanaged C++ assembly on NAV. But I cant import this .dll file into NAV. How can I import it by Control Add-in or Automation into NAV? This .dll assembley has below functions. How can I call these functions on Class library? If I can call these functions on my created new class library,…
-
Reports from NAV 2015/2013R2 import to 2016 - special character
Hi I have a report fra 2013R2. I imported it to 2016. Then there suddenly appears some special characters. See attached file. Can someone help me out here. THANKS :)
-
Remote klient crash periodically on file import
Hi, Got a modified bank statement import codeunit/page on a NAV 2016 Build 42815. Server is hosted on azure, so clients are running click-once. About 50-70 % of the time when I import, I get .net error and client crash. I cannot make client crash when running directly on server. Webclient seems to crash as well. If I use…
-
Problem with ReturnURL Dynamics NAV 2016 with Azure AD and Office 365 login
Hi all, i am trying to configure Dynamics NAV 2016 to work with an Azure AD and the Office 365 Login. What I achieved so far is that the login works. NAV knows the users of the Azure AD and I can sign in. If we use the web client with by “httsp://NAMEOFSERVER/DynamicsNAV90/WebClient/ it directs to the Office 365 Login…
-
Duplicating Tag Numbers and Item numbers in Inventory Variance Report NAV 2009 R2
When we took the Year End Inventory counts for all of our Items we posted all counts into our Data Entry table. We run the Variance Report before we post so we can try to vet out any possible issues before posting to the G/L. For some reason the Variance Report is showing all Items and Tags twice. Is there a way to not get…
-
Scheduler Job Error Sales invoice already exists
I run ICT Header of scheduler job and it show message for attach file. Who can help me? Thank you for this help.
-
Archive Purchase Order within Invoice process
Hi All, In the codeunit 90 Purch.-Post, OnRun trigger, we have two following lines of C/AL code: IF Receive OR Ship THEN ArchiveUnpostedOrder; // has a COMMIT; Here, by the standard NAV functionality, if we do Receive lines for the Purchase Order (not Receive&Invoice), archive version will be created, but than if we change…
-
NAV 2016 SPN error while logging in from specific PC when not in the office.
Strange problem; I have setup a NAV 2016 "Three tier on 2 machines"; So SQL and NAV are on the same server for this demo environment. When People logon to the service from their notebooks being connected to the company LAN; everything works fine, no errors. One specific notebook however will not work from external…
-
NAV2015 Upgrade Step 2 Error
Hi Experts, i am upgrading 2009r2 to 2015 , during step 2 am getting the below error for this particular company(Stockholm Köpenhamn AB). rest of the 16 companies done. if anyone have faced earlier this issue please let me know..... PS C:\Users\navadmin> Get-NAVDataUpgrade ShineUpgrade -ErrorOnly SessionId : 14 CodeunitId…
-
Text encoding outstream -> BLOB field
Hi all, When saving an HTML string to a blob, all special characters fail to save correctly. I know my input string is correct. Html = original HTML string with correct encoding. EditorContent = BigText EditorOutstream = OutStream "HTML Data" = BLOB field <code> CLEAR(EditorContent); EditorContent.ADDTEXT(Html); "HTML…
-
Can Job Queue rollback?
Hello all, I have to schedule a CodeUnit with Job Queue. If this job queue cant run because of any reason(network,electrical) problem, Can it rollback to run by scheduled job? Regards, Undy
-
Terminal Service Printing issue
Hi all, Has anyone else experienced this issue with 2015? https://blogs.msdn.microsoft.com/nav/2013/02/25/nav-2013-reports-may-be-difficult-to-read-when-printing-over-terminal-services/ We had exactly this issue with Nav2015 Terminal Services on Windows Server 2008 R2. We installed the recommended patch…
-
NAV DotNet Excel.WorkSheet.ChartObjects
I want to create an Excel file and include a chart from scratch, and I'm using DotNet functions but when trying to get hold of a handle to ChartObjects I get an error: Exception HRESULT: 0x800A03EC The C/AL code: XlApp := XlApp.ApplicationClass; XlWrkBk := XlApp.Workbooks.Add(-4167); XlWrkSht := XlApp.ActiveSheet;…
-
Unit Cost is different than unit amount
Can someone explain to me why the unit cost can be different than the unit amount when posting a negative adjustment through the item journal? This is in NAV 2013 and the costing method is set to "average" for the item by location. They are using indirect cost % for purchase items however the item in question is a prod.…
-
NAV 2016 new language translation
Hi, I would like to ask if there is a PLLP toolkit for NAV 2016 or I can use the one for NAV 2013 R2 for translating NAV 2016. Thanks in advance.
-
Navision ver 5 on Sections vs Navision 2015 customization trial balance report
I have the following customization in trial balance report on version 5. under sections of report - integer Body 2 - Presection IF CurrReport.SHOWOUTPUT THEN BEGIN IF ("G/L Account"."Balance at Date"=0) THEN BEGIN IF ("G/L Account"."Balance at Date" <> "G/L Account"."Net Change") THEN CurrReport.SHOWOUTPUT(TRUE) ELSE…