-
Changing report text to blank depending on user selection (NAV 2013)
I have a report set up which displays two values (Version Code, and Production BOM Number). I have an existing option which prints 2 of these when a 'double sided' option is selected however I need to add a option to remove these and make the areas blank. In the code below you can see the double sided one is called…
-
Custom Claim authentication
Hi, as anybody experience on this? We need to create a custom STS with claim authentication to use on a 2015 Nav environment, any type of information on this topic (sample code, links) will be very appreciated Best Regards LnZ
-
Adjust Exchange Rate - Questions
1) Does Adjust Exchange Rate (AER) only adjusts open transactions? Or does it work on closed entries. I did some research and I got mixed answers: The batch job processes all open customer ledger entries and vendor ledger entries. (https://msdn.microsoft.com/en-us/library/hh167262(v=nav.70).aspx) I also found a knowledge…
-
Please share link for download of TFS353595and HF377555 hotfix. I am unable to find them.
Please share link for download of TFS353595and HF377555 hotfix. I am unable to find them.
-
Inventory Pick in Starter Pack - NAV 2016
Hi Guys, i have a question about Inventory Pick functionality in NAV 2016, In my test environment (Cronus Company) i have location with only Require Pick, but if i want to use this warehouse in for example Sales Order and want to create Inventory Pick then i get the message: "You do not have the following permissions on…
-
Upgrading Sage 1000 to nav 2009 R2
hi Evry body i need your help am going to upgradeing my sage1000 database to dynamics nav 2009R2 but i don't work with the sage erp so can you give me your openion and how can do that thank you
-
Lanham EDI 856 Cancellation Issue
Hi, I am working on Lanham EDI module. when I receive 850 to create sales order it's works fine and to send advance shipment notice I created EDI 856 document which also works fine. But, I am not able to handle cancellation scenario with 856 file. below is the item line detail segment for both shipment and cancel line.…
-
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…