-
Pivot Data in report
Hello, Good day. Im new to NAV, Does anyone know how to make a pivot report in navision using RDLC? thanks in advance
-
SQL Statement
Hi All, I have a question here whereby i am trying to write an sql statement for the following as an example from Nav 1. Table: sales order (Asia Area) Sales Order Number Customer Date SO001 Singapore Faire Price 2017.1.14 SO002 China Wu Mei 2017.1.30 SO003 Singapore Giant 2017.3.8 2. Table: sales order Detail (Asia Area)…
-
OData Connected Services VS2017 End Points Error
Hi guys. I have published a web service OData and it works fine .xml and all is good. I’m going to Visual Studio to develop an APP, which will use this data. First off I can't, as I normally would, go to references and add a service reference. Now we have to use the OData connected Services. No big deal... Just to to tools…
-
Exchange with external systems using WEB service and XSD
I need to write export to external system using the WEB service,WSDL and XSD. I have never written an exchange using the WEB. Tell me where to start. There is a method CreateOrderToSupplier (OrderToSupplier) and XSD <xs: schema xmlns: tns = "http://www.aaaaaaa.com/Navision/package" xmlns: xs =…
-
Facing some transactions in inventory interim account in navision
Hello to all, I am using nav2013 and facing negative amount in inventory interim account. In interim account there so many transactions with positive and negative adjustment and at the end of year it shows negative amount. In inventory GL Reconciliation it shows Direct posting as warning. How to resolve this? Please…
-
Document No. on Gen. Jnl. Line
Hi We recently had support case where a client suddenly had a bunch of Genereal Journal Lines lose their Account No.'s. The culprit is the following code on Table 81 that is called in the OnDelete Trigger (among others). ClearAppliedGenJnlLine()
IF "Applies-to Doc. No." = '' THEN EXIT;
GenJournalLine.SETRANGE("Journal…
-
Help to make a NAV query: That show records from table 1 that does NOT exist in table 2
hi Can anybody help on creating this query in NAV? In SQL it could be either one of 2 queries: SELECT * FROM Table1 LEFT OUTER JOIN Table2 ON Table1.name = Table2.name WHERE Table2.id IS NULL OR SELECT name, id from Table1 EXCEPT SELECT name,id FROM Table2
-
Openstack and devstack
Does devstack completely install openstack? I read somewhere that devStack is not and has never been intended to be a general OpenStack installer. So what does devstack actually install? Is there any other scripted method available to completely install openstack(grizzly release) or I need to follow the manual installation…
-
MS Dynamics Connector error
Hello guyz. Actually I m trying to install MS Dynamics Connector as I want to Integrate CRM 2016 with NAV 2015.But when I m installing it I m facing and error.Below is screenshot of error.. Please help me out if anyone gone through this. Thanks
-
NAV 2017 configure profile error
From the profile card page, I click Configure. I get error "A call to System.__ComObject.Run failed with this message: The system cannot find the file specified. (Exception from HRRESULT:0x80070002" The text constants for the apppath use 71 in the path instead of 100. So one must edit the text constants to replace 71 with…
-
Using Standard NAV 2017 for Project Management
Happy Friday all! Client requirement is to track tasks and their completion using standard NAV or with little modification. Has anyone used Jobs or Workflow or other to solution a requirement like this? General setup they are looking for: Task with a resource assigned to a work order, the work order assigned to a project,…
-
how i can post Free Of Cost materiel Purchase against delivery challan in GST regime in 2016.
hi all , in GST regime FOC materiel movement against Delivery challan and only show only quantity & Value of Materail in Delivery Challan. (if supplier not charged GST on purchase then receiver will not charge GST but when Receiver want to sell that FOC item that time GST will charge & sell against Delivery challan. 1)…
-
Excel File to NAV2015 Webservice
Hi, Can I send an excel file to a NAV2015 Webservice. I want to import the data in some NAV tables. I created a codeunit to publish as webservice. I created a function with a bigtext parameter, but I cannot get this to work. Any ideas how to do this?
-
POST request from NAV and open a weblink
I have requirement to open a webpage from NAV button using POST request, idea is to pass few details from NAV to webpage but do not show details in address bar. I have tried XMLHTTP object .OPEN and .SEND but that works for web service, how do I use POST method and open a webpage for user to use further? I am using NAV…
-
How can i inhibit price = 0 in sales orders (Nav 2015)
Hi, How can i inhibit price = 0 in sales orders (Nav 2015) thanks
-
Multiple taxes on a sales order
I'm attempting to ship two separate lines from a sales order to two different locations which have two different taxes, but it's not letting me change the "Tax Area Code" on the lines. How should I approach this? Thanks!
-
General Journal Line Workflow - with DR. G/L Account & CR. Bank Account
Hello Everyone, When i send a journal line for approval, it creates approval entries for the next approver in cases where i have either Dr. Vendor & Cr. Bank Account or Dr. Customer & Cr. Bank Account. However, when I send a journal line for approval where i have Dr. G/L Account & Cr. Bank Account. The journal line is…
-
Is internet explorer enterprise mode supported with NAV 2016 web client?
Hi everyone, I think that internet explorer enterprise mode is not supported with NAV 2016 web client, because web client is working only with Internet Explorer 10 or Internet Explorer 11 and enterprise mode is emulating older versions of IE. But just in case i am wrong,could anybody confirm the answer please? Kind regards
-
Difference when the ownership is user vs organizaion for a custom entity
What is the difference when the ownership is user vs organizaion for a custom entity?
-
Xamarin PCL Web Service Connection
Hi, I hope I can find someone who already tried to connect to NAV Web Service from am Xamarin.Forms Project inside the PCL and is willing to share his knowledge. I have trouble to connect to a simple Codeunit which has only one function with two parameters. I need to get the _Out Parameter back in a synchronous call. There…
-
Cant log into Customer Source
is anyone else having issues with logging into customer source , last week I was able to log in , but could not access eLearning. This I cant log into customer source at all. No errors , just a blank screen. I have tried adding the site as a trusted site and clearing the cache. I have tried different browsers as well same…
-
Login Error
Hello guyz..I m just tried to login in Dynamics 365 Developer network..But I could not login..i m getting error.. Please help me out.. Thanks
-
Microsoft Dynamics CRM 2015 SDK setup
am using Visual Studio 2015 and I have downloaded and unpacked MS Dynamics CRM 2015 SDK and UII (user interface integrations). In the readme file for SDK it says: "An updated Developer Toolkit for Microsoft Dynamics AX is planned for this release but it is not ready at this time. Please refer to the CRM 2013 SDK for…
-
parallel Multiple Jobs in Nav 2013r2
Hello everyone, Can we run parallel jobs i.e multiple jobs in same time , in Nav 2013 r2 ?? Thanks in advance.
-
Internal Error XXX in Module XXX - overview
Hi, I seem to recall that I have seen a complete list of the "internal error xxx in module xxx" messages. This is regarding NAV 2009. Can anyone point me in the right direction?
-
Outlook sync
Hello, I am in the process of trying to sync my nav contacts to outlook. When I test my connection to nav from outlook, it gives back OK. But when I try to do a sync for contacts I get following error: so I enabled the logging, and this is what is generated: I am only syncronizing the contacts of type person in to my…
-
"Reconnect Period" not working in NAV2013R2
Hi, I am testing to reconnect to a disconnected session. Steps1) Setup a Standard Demo NAV2013R2 server with "Reconnect Period" of 10min. 2) Connect a RTC client to the NAV2013R2 Server from a client PC. 3) Disable the Network adapter on the client PC. After 1 sec, reenable the adapter back. 4) When I clicked anywhere in…
-
I have an error while publishing extensions to a local server.
Hi, then I will indicate all the steps that I perform to publish an extension on my local server together with the error obtained: First step: - Configurations launch.json: app.json. Configuration of development part (Server Instance): Second step: - Download Symbols: Third step: - Publish the extension: (Code of…
-
Adding Parts to List
I am trying to Add PowerBI to NAV 2017, but the PART is not visible on the list to be able to add to the page? I have set-up all of the Azure stuff, connected the PowerBI to the Web Services, I just can't see the part available in the list to add into the home page.
-
You can only activate a standard cost costing type
I have an item ABC already assigned to a model group where the inventory model is 'standard'. However, when I go in the price setup and activate the price, I get the message 'Item ABC inventory model is at standard cost, you can only activate a standard cost costing type. Activation has not been performed.' What else is…