-
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 .
-
US ACH file
Hello all, Does anybody managed to create ACH file, with data exchange definition?
-
Lotwise Inventory report
Dear all, Is there a lot wise item movement report in NAV? Thanks & Regards, Rahul
-
Power BI relationship between Vendor Ledger Entry and G L Entry tables
I am trying to build a dashboard that shows GL Account expense by Vendor. However, I am having trouble creating a relationship between GL Entry and Vendor Ledger Entry tables. If I create the relationship based on the Entry No, it works but it only reports the Accounts Payable account and not the expense accounts. I also…
-
DOTNET-Components on AZURE
Hello, In the same session I'am declaring to times the same DOTNET-component, as a local variable. But it seems that on Azure the second time, it is referring to the same object in memory. If I run first #1 and then #2, I get this message Een aanroep voor System.Xml.XmlElement.get_Count is mislukt met dit bericht: Het type…
-
How to SaveAsExcel as Excel 2003
Hello, I am using NAV 2016. Is there any way I can specify which Excel Version to save in using the SAVEASEXCEL function? This is because I need to save a report as Excel 2003 because that is what the client has. When I was using NAV 2013, it saved as Excel 2003 by default so there was no issue.
-
NAV 2017 Purchase Agent Activities page - slow!
Hi all, I am currently in test with an upgrade to CU4 NAV 2017 and the purchasing role center is extremely slow... Its the Activities page, I have done some SQL profiling on running the page/flowfields and reviewed the keys but to no avail. Anyone had any problems with this? There are lots of open orders but not enough to…
-
Employee turnover and Customer access information
Many of us here work for firms which have numerous customers whom we must access in order to provide support/updates/etc. I was wondering what strategies some might use when an employee is terminated who previously had access to this information. Do you alert your customers to change passwords? Do you proactively change…
-
Can we send Message/Error to Session ID?
There is a need to send a notification to the active user, knowing him session id. Have any suggestions?
-
Item Reserve - Always, but only for certain locations
Hi, I have a couple of simple questions. * Is it possible to set item reserve to always, but only for certain locations and possibly bins? (Without advanced warehousing) * If not, do you have any suggestions on how to set up/design such a modification? * If I were to develop such a modification, is it in any way a really…
-
Problem with the Outlook add in
Hi everyone, I'm trying to synchronize my NAV2017 with the Outlook 2016. The connection seems to work, as you can see in the next image: But when I try to use the add in, it doesnt load correctly, and I can see a red cross indicating an add in error, like this: Why can be this happening? The sinc seems to be OK, I have…
-
permission for generate campaign dimension in navision 2009
user can't able to generate campaign dimension in sales order in NAV 2009 its asking for permission how to assign rights anybody can advice?
-
e-commerce website with Navision ERP with LS Retail
I need help in guidance to how I can sync an e-commerce website with Navision ERP data Thank you in advance.
-
Consolidation Method Navision
Could anyone explain which is the difference among : average ( manual) rate, equity rate and composite rate during the multicurrency consolidation method? In the code i cannot see any difference, all three adjust the amounts to the average rate. Thanks