-
Nav 2016 Phone Client - adding field
Hi , Struggling to figure out how at add extra display fields on the phone client. For instance, if you look at the customer list, it by default shows the customer no., name and contact, but say i wanted to add an extra field to show (for instance balance), how do i do that? At first i thought it might be through Bricks,…
-
XMLPort Export with Nested Repeating Fields
Hi all, I want to create a webservice that returns some web roles that are stored in NAV. The roles are stored in the “Contact Login Permission Table” in NAV Contact No. Site Role ID CONT1 WEBSITE1.COM ADMIN CONT1 WEBSITE2.COM ADMIN CONT1 WEBSITE2.COM SECURITYMGR This is the structure of the XML output I’d like to…
-
Unrealised Gains and Losses differs between Transfer Shipment & Transfer Receipt Transactions
Dear Sir, Total absolute value in Unrealised Gains and Losses Account in G/L Entry table after posting a Transfer Shipment does not match with the G/L Entries of the Transfer Receipt Transaction. What is the reason ?
-
Posting Inventory cost in a previous period
Dear, I have this situation where my client is having item entries, and i have set upped to automatically post cost to GL and always do cost adjustment. however i have this situation where my client is closing the last period financially, but the cost adjustment is still posting in the previous period. how can i stop this…
-
Standard text in Gen. Journal
Hi NAV 2015/2016 Is it possible to use stanard texts ind Gen. Journal text field ? Thanks /Kenneth
-
Select first record in dataset when updating page
Hello all I have made a cardpage with a subpage. This subpage is a listpage, which is filtering on a dataset. On the the cardpage I have added the PingPong function, which updates the cardpage and through that the listpage. That is working as required. My issue is that on the listpage, new records are displayed above the…
-
Line discount for all Items
Hello Is it possible to give a customer for example 10% line discount on all items ? It will not Work giving the customer 10 % invoice discount - when using ressources or posting on a general ledger account, there must not be given discount.
-
How to add automatically a dimension to a transaction?
Hi, If we always want to add a dimension automatically, to a document? for example if someone creates a sales order, the system automatically add this dimension, later if the user wants to modified the value opens the dimension page and change the value. We want to add this feature to all documents and journals in NAV. I…
-
Tax amount calculate in Vat Settlement, if vat not calculate in sales invoice & cust. exempt in VAT
Hi everybody, I am using NAV2013R2 Indian localization, i create a sales order which customer exempted in VAT. in customer card VAT Exempted = Yes in Sales Order VAT Exempted = Yes when we post sales order then VAT not calculate in Invoice and no g/l entry made related to VAT. it's ok but in 'Detailed tax entry' tax amount…
-
Assembly BOM Explosion Report or Excel
Hi In NAV 2016 there is a Bom Explosion report for Productions BOM. BUT, as I can find - none for Assembly BOM. Can anyone give my an idea how to make a report, It could be in excel.. :) THANKS
-
NAV servers - Microsoft Office
Hello, we are considering to update Office 2016 in our NAV servers, have you guys encountered any problems with NAV 2009, 2013, 2015 and 2016 versions and Office 16? -pn7
-
Average Cost (AVCO) Method
Dear All I have a question on Average Cost (AVCO) Method. Item X has following ledger entries. January 1st Beginning Inventory 2 units @ $1000.00 per unit ie. amout $2000 June 30th Consumed 2 units @ $1000.00 per unit ie. amout $2000. December 31st Purchase 2 units @ $100,000.00 per unit ie. amout $200,000 No further…
-
Job Planning and Accrued Cost
In NAV 2009 and in Job Module I have a job for which I have created Job planning line as sales invoice of type G/L account. Unit Price is 80 and Unit Cost is 15 (Line type is 'Both Schedule and Contract') 15 is recorded as Accrued Cost. Now how can I link the purchase invoice that would come in later to clear the accrued…
-
Changing Collation Issues
Hello, I had one database with following collation: Latin1_General_100_CS_AS. (Case Sensitive, Accent Sensitive) I needed it to be Case and Accent Insensitive so I've created a new database with the collation Latin1_General_100_CI_AI and then exported/imported the data via powershell before synchronizing the data. So now…
-
How do I save the xmlfile from inside the XMLPort?
I have a scenario where a codeunit has been published, and all that the codeunit is doing is calling an xmlport that creates a purchase order based on the xml file being sent. Works like a charm and everybody is happy. However, every now and again there are strange data errors in the order being created; but I see nothing…
-
HowTo-UpgradeNAVDatabase and SQL Time in Backup step
I am working with a relatively small database (<6GB) and I am encountering an SQL time out error when the script performs the backup of the database in the "Backup the database before upgrade" step "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.". When I…
-
NAV 2016 - Interactive Sorting a Matrix
Hello, I am trying to implement interactive sorting in one of my reports which is using a matrix to display the dataset. The difficulty lies with getting the interactive sorting to sort the following way: Let's recreate the example to follow along.. - Row: Customer - Column: Month - Primary Key: Customers, Month - Every…
-
Variables on page not updating correctly if Display = FALSE on ListPart
So we encountered a rare issue this week where the ShortCutDim was not displaying correctly on cu6 NAV 2016. The values for ShortcutDimCode[3] - ShortcutDimCode[8] load correctly when viewing through the debugger and -some times- would display correctly. But depending on if you pressed 'edit' or 'view' or simply double…
-
NAV 2016 Web client URL - Changing Company Name in url ignores NAV security
We have installed and configured NAV 2016 web client. Works fine. However, it appears to be possible to simply change the company name element of the url and this by-passes NAV security. Example: Two NAV companies, Company A and Company B User only has access to Company A as per NAV security permissions URL for web client…
-
Research Study
My name is Donna, I am a student from Denmark at the moment I am doing my marketing research for a danish company as a part of my final exam on my study in Marketing Management. I am asking a 5 minutes of your time to answer my questionnaire completely. Thank you so much in advance and enjoy your 5 minutes answering my…
-
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
-
Error exporting to Word
Hello everyone, one more strange problem from my side: while throwing a page into Word (Ctrl + W) I get a proper Open/Save dialog. But not mater which option I choose there is an error in the end: There are no filters applied to the page. Actually it seems like I cannot export any page into Word. Does anyone have any…
-
Implementing Waterfall vs Agile
Many many years back waterfall was the way to go. It's what we did, and it's the way Navision (USA at least) were pushing partners to implement. ... Times changed and the push was for Agile. Agile fits the typical Navision customer from The PC&C days much closer than Waterfall. But both need certain circumstances to work…
-
Cannot create customer via Page services.
I am trying to create a customer using the page service. This is the xml packet <soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ins="urn:microsoft-dynamics-schemas/page/customercard">…
-
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.
-
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…
-
NAV RDL Report HTML
Hello, I'm using HTML in my Reports so I do not need to position 50 textfields in my header section. Instead I create my data by code with the caption and the value. So far so good ... What I try now is to get a table style Caption/Value list. I have a function where I place an amount of spaces after my caption that the…
-
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
-
Mininum Synch. Frequency with new CRM Integration
Hi, I try to understand the new CRM Integration in NAV 2016. From my understanding the synchronisation processes are run with the Job Queue functionality. Does that mean that the minimum frequency is 1 minute for snchronisation. Or can this job queue entry run more frequently? If I enter data in one system, I do not want…
-
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…