-
NAV 2017 Query to Excel 2016
Hey, i published a NAV 2017 query as Web Service and consume it in Excel 2017. If there is some Data found everything is fine, but if there is no data found, Excel shows an error. Table without columns from a Evaluate-Statement it is not possible. Some ideas?
-
Problem with SMTP in NAV 2017 and Office 365
Hello, I have configured the smtp mail in dynamics NAV 2017. I made the first tests and it works perfectly but a problem arises when in the email Item table (9500) I inform the field "From Address" so that each user can send from his account Mail and not use a generic. Because it does not work? Any solution?
-
Webservice Application opens a blank/clear window on every click
Hello Swarmknow, Maybe someone can help us with a uncommon issue. We run MS Dynamics NAV 2009 R2 with SQL and CC Now we are trying to implement an web-service application. In the webpage we have a link to orders, created in NAV. The link works well, NAV opens and shows the correct order. The problem we have, every browser…
-
Single Quantity Picks
Hi, I'm looking for some advice on automatically splitting quantities when creating picks from warehouse shipments so that the quantity is 1 per line. E.g. Create Transfer Order for Item A with Qty 10 Create Warehouse Shipment for Item A with Qty 10 Create Pick with Qty 1 x 10 lines for Item A - I know there's the Split…
-
Choose Column not showing
Hello I can't find the Choose Column option that gives the possibility to display or hide fields in the list, How does it work now in NAV2013 ?
-
Service Tax Setup
Hi, I want to know about service tax Setup. with example. What is use of interim accounts.
-
How to Add More Value to Your Microsoft Dynamics NAV Services
Enjoy our new blog post - How to Add More Value to Your Microsoft Dynamics NAV Services Hope it will be useful to You!
-
2017 Outlook add-in - Incorrect Reply URL
Hi All, I have an environment setup to run NAV using Access Control Service, allowing for single sign on with Office 365. We have the outlook integration setup to run with multiple database in the same domain. In a newly created environment, the Outlook-Add In launches within the outlook client, and prompts for login to…
-
Having an issue connecting from NAV APP Server to DB server (No Domain) NAV 2013 R2
Hi Guys, Please help me, I am having an issue connecting my NAV App Server hosted in Azure to my local NAV DB Server: Here's my log file:
-
Permissions logging tool for NAV2013?
I know there is Permissions Logger in Classic Client that can track a user's activity and build Roles and Permissions for the user: https://forum.mibuso.com/discussion/13453/permissions-logger I also found one for RTC in NAV2013R2: https://saurav-nav.blogspot.co.uk/2015/05/nav-2013-r2-role-permission-wizard.html Is there…
-
Converting SQL-Decimal to Navision-Decimal (NAV2017)
Hello, currently I try to import the value of a decimal field from a SQL database into a Navision database. I usually do this via ado recordset and a variable of type Variant. For decimal fields this does not seem to go if I have understood correctly because of the fact that the SQL decimal field are float 9-bit, whereas…
-
Could not create an instance of the OLE control or Automation server
Hie guys, my question is almost similar to some asked here a few years back. im getting : This message is for C/AL Programmers: Could not create an instance of the OLE control or Automation server identified by GUID={181E0F5D-D0C0-40E9-8620-2C1191CC00BC} 1.0:{BAD7EC8B-0E5B-4421-936E-F5AE2338BE32} UNknown Automation…
-
Updated MSDN documentation on SQL Server setup and configuration
We updated the MSDN documentation on SQL Server setup and configuration two months ago: https://msdn.microsoft.com/en-us/dynamics-nav/installation-considerations-for-microsoft-sql-server Hopefully, this covers most of the topics you need to consider when optimizing a SQL Server instance for optimal performance for Dynamics…
-
Dont show last selected Record in View again
Hi there, i have the following question. Navision 2016 always goes to the last selected Record in a Page like the "Item Ledger Entries". Is there a way to disable this feature. Because when you have millions of records, the page loads very slow.
-
Copying NAv 2016 Table Data to Excel
Hello All, When we copy Rows from a table or list page and paste to Excel, it seems the format is by default csv and this is creating some issue and decimal values with comma are creating extra columns and alignment of data is not as per table columns when in Excel. The same is with Print & Send->Excel. I sthere any way to…
-
How to Rounding off all Invoice values in Navision 4.0 SP3
Hi All, I want to post invoice with rounding off in all corresponding G/L accounts, customer accounts etc. like my invoice tax amount = 123.56 and total amount = 456.63 but i want to round it like this tax amount = 124.00 and total amount = 457.00 So i have done some setups as mentioned below :- Finance Managemnt - >…
-
Power Bi Hyperlinks to Excel
We use an OData Connection to connect to Power Bi. I use recordRef to get the bookmark for each record and I want to be able to apply this to our Power Bi table to act as an hyperlink to a Navision Page, Similar to how it works on Reports and Emails. So on the webservice page we use to connect to power bi…
-
Add a template view to an activity
Hi all, So we have a client template set up that needs to be checked off by two departments, For the life of me I can't figure out how to include either the template or a link to it into an activity. Pretend its KYC info, one person enters it then it needs to get double checked by their supervisor. I get to the task object…
-
apply-in from payment slips after posted the document
Hello my friends always delighted to ask my questions in this magnifest forum, my infinitely has everything and has all the people who make effort to answer my questions. I created the payment management process steps in dynamics nav classic client, creation of document from the payment slips, printing of checks ... then I…
-
Subcontractor Net Labour Error
Hi all We have made subcontractor payments for the first time using NAV. Unfortunately, some of the payments were marked as materials when they should have been labour. This has only been picked up when we went to make the monthly return to the tax man. We tried to put a credit memo through for materials and then match it…
-
Getting "precise" coordinates within NAV 2016
Hi, for a customer, we did a development which saves users current location to a record so after some time user can see the records location. But the problem is when we take coords from nav, they are not precise. When user takes the location from WhatsApp, the location (coords) are much more precise. How can make NAV use…
-
Manufacturing Run Time
Dear All, i got 1 scenario here: To Mix 1 Can- 25Liter Paint, my machine requires 10 minutes. But my machine can cope up till 500L ( 20 Cans). Thus when i create Production Order, system will propose me to occupy 10 minutes x 20 cans which about 200 minutes. But the actual time i use only 10 minutes..May i know any…
-
Template list popping up when added to Navigation Pane
Dear all, I have added Item Journal Template List under Activity Buttons under a group named Journals. Now when I click on the Journal I'm prompted to select the Journal template as a popup. Is there a way to avoid this, because if the user press cancel then they will not be able to see other items under the group. Thanks…
-
NAV2013 Implementing Manufacturing Module
Good Day everyone,I have a customer that is already using NAV2013 for 4 years. Just recently they decided to implement manufacturing module (a new company book). Is there anything to take note i.e. Server specification prior to the implementation? Or I shall say, what would be the guide to calculate the sizing of the…
-
2016, Events, Sales-Post, Item Ledger Entry already exists
Hello, So the solution I'm trying to build involves posting "extra" item ledger entries, when posting a Sales Order under certain conditions (when a INSERT record event is fired by a third party table), AND using events. So my sales order 1000 is containing these two lines: Line No Item 10000 1000 20000 1001 When…
-
Workflow Approval in NAV 2017
I have a customer who has numerous approval workflows for purchase orders of over 500. However all orders can be automatically approved if under 500. Does anyone know what the workflow steps should be for this? So that users still press Send for Approval, but it gets automatically released Thanks
-
ODataV4 and Patch not supported or not working?
Hi, I'm trying to update Sales Lines using ODataV4 and PATCH. Bumping in to the following problem every single time: { "error": { "code": "", "message": "'PATCH' requests for 'Collection' are not supported by Microsoft Dynamics NAV OData web services." }
} I've tried posting to Page 516 (List). Tried converting Page 516 to…
-
ERROR IN PAYMENT SLIPVALIDAT
HI AM CURENTLY WORK ON NAV 2099 R2 ?SO MY PROBLEME WHEN VALIDAT ON PAYMENT SLIPE I HAVE THIS SHORT IMAG ERROR //// the transaction cannot be completed because it will cause inconsistencies in the g/l entry table chech where and how the CONSISTENT function is used in the transaction to find the reason for the error CHECK…
-
NAV2017 change to Item Cross Reference?
I am not understanding a change in 2017 related to Item Cross Reference Table. In 2015 when I added an item to a Purchase Order I got the Description and "Description 2" from the Item Card. In 2017 however it puts Description on the Purchase Line to be := Description from Item Cross Reference Table. Meanwhile is simply…
-
error message in payment slips
nav 2009 error message the indexing -XXXX in the arrays outside of the permitted range when print report on payment slips .