-
NAV 2018 and Power BI
Hello, i'm trying to connect from the Power BI desktop application to a NAV 2018 instance. So far it seems like this should be possible but I can't get it to work and can't find a working example online to help me figure it out. We have NAV 2018 installed on an in-house server and Power BI running on my local system. As…
-
How to retrieve Access token from Azure in NAV2017 (using HTTPClient or Codeunit 6300)
Hi Guys How can I receive an access token from Azure located NAV Webclient either using HTTP Client or HTTP Post or using the Codeunit 6300 Azure AD Mgt. Trying to generate the access token from a NAV Action but is not working have provided proper parameters for HTTPRequest or HTTPClient using the format GET…
-
Initialize IFrame was not found in control add-in (Nav Web Client)
hi All, I just activate power BI in nav it works perfectly for Nav RTC, Mobile phone, tablet the only issue is when I open nav web client, then it show this error message if I untick the selected report power BI (in nav) then this error message was solved any idea what should I do?
-
How to use a Related Template?
I am using LS-Nav version 9.0.46621. I am creating item templates in Setup Master Templates. I get it that a Template uses the same table as the template that calls it, but how does one tie together the Related Templates? So for example, I want to automatically fill in the Item Unit of Measure for the newly created item,…
-
Amazon Marketplace invoicing from NAV
Does anyone have experience with this (or knows a consulting company who has)? The basic idea is they organize they delivery for you, you issue an invoice and they forward it in PDF. Of course you don't want to enter every invoice manually into NAV. Can they send a CSV file or something? Not EDIFACT, I know they use…
-
Access NAV 2018 on Azure SQL From Multiple Azure Domains via 0ffice 365 Authentication
Dear All, I have deployed a NAV 2018 database on Azure SQL and configured users as office 365 authentication. Now I need to ensure another office 365 users from a different domain to log in the same database. First of all is it possible to do so? And if yes what is the best practice for this kind of implementation? Thanks…
-
I have been trying to update Expected cost for each item. Not able to achieve this ! Pls help !!
Each item have a BOM and inside the BOM there will be other items which will also have BOM....so we need to update the last item first which do not have BOM and then we will move upward in flow chart until unless every item in BOM of first item gets updated. Then the item for which we use one action button to update…
-
How can I modified page (31) Item List, after I Post Item Journal
I wanna make alert while item in inventory <= safety stock quantity, so I create new field "Out Of Stock" in table Item (27), and I put this code in Page Item List (31) in OnAfterGetRecord() trigger. IF (Inventory <= "Safety Stock Quantity") THEN VALIDATE("Out Of Stock",TRUE) ELSE CLEAR("Out Of Stock"); It's working but if…
-
Get results from web service and display the results in a page
Hi, I have a page with a search string. When I enter a search string, OnValidate of the field, I call a codeunit which makes a call to a webservice and gets search results based on the string. I would like to display these results on the page where I have given my search string. I have a lead to use temporary tables, but…
-
Error with developing a report in AL code in Dynamics 365 BC
Hi eveyone, I don't know if this is the best place to ask this question. I'm developing a new report, and the issue is this. This is how the datset is defined:dataset { dataitem(Item;Item) { DataItemTableView=SORTING("No."); RequestFilterFields = "No.","Inventory Posting Group","Location Filter","Variant Filter" ; trigger…
-
Nav freezes while applying customer entries
Hi, Greetings! We have 2009 installed for one of client.The 2009 NAV is opened via Citrix.Now this is unique issue only ONE user is facing.When she drills on the customer card balance and tries to apply customer entries and selects more than 1 and applies(f9) the system freezes.This behaviour is observed only sometimes…
-
SQLTimestamp - Extension error
field(50000;"Timestamp";BigInteger)
{ SQLTimestamp = true;
} Causes the following error: "The request for path /nav/dev/apps?SchemaUpdateMode=synchronize failed with code InternalServerError. Reason: Specifying default value for timestamp column" Any suggestions on how to solve this?
-
Looking for SATUse_Codes.xml
Does anybody know where to find the file SATUse_Codes.xml? The support document https://support.microsoft.com/en-us/help/4056505/cfdi-new-layout-version-3-3-in-the-mexican-version-of-dynamics-nav says "Download the SATUse_Codes.xml from the downloads site to your local desktop". What downloads site??? I've downloaded all…
-
NAV RTC Field Group Lookup will not display one field
WE discovered that the way to control the fields that display in a Lookup page (the one defined by the LookupPageID property of a Table) is through the use of the Field Groups feature of the table. We can define a DropDown Field Group and get control of the fields displayed, but our problem is this: We define a DropDown…
-
IC management
I've used it in the past in some project but mostly to distribute expenses between companies, for example local rent, security services, etc. This kind of operations are against G/L and throw invoice and I've worked nicely but now I'm trying to manage items and starting in order. I've some problems and I want to know if…
-
Suisse Sepa CT payment
We are trying to get the Suisse Sepa CT payments to work for a customer, who is still working on 2009R2. We downgraded and merged the CH solution into their version but are struggling with the correct xml output of this solution. Like currxmlport.skip does not seem to work properly in this NAV version. Did anyone know a…
-
.net MainWindowHandle - twain scanner
Hi, i am trying to implement a .net assembly to integrate a twain scanner. To be able to aquire an image from an scanner i need to open the twain source selector. This call needs the windowhandle, i tried to use .net System.Diagnostics -> MainWindowHandle, but every time the code is called the RTC client looses it…
-
Import to Purchase Journal using Config. Package
I do an import to the Purchase Journal using Config.Package. I need to import the global and shortcut dimensions. I did everything necessary to import the dimensions and it works fine as long as the Balancing Account Type is GL Account or blank. As soon as I import a line with the Balancing Account Type equal to Bank,…
-
How to deauthorize Azure service for Embeded Powerbi reports in RTC
Hi, How can i deauthorize Azure services for Embeded PowerBi reports from role center, i need this to reauthorize with different o365 user i see Table 6301 Power BI Report Configuration but this is only for which selected report to show in role center but is not removing authorization when you delete the record for…
-
Connect NAV2018 with Field Service 365
Hi experts, I would like to integrate an instance NAV 2018 (on-premise) with a Dynamics 365 Field Service (on-cloud). Could you help me? Which entities I can sincronize directly? I would like to connect job journal in order the Field service works, sent the hours to the job journal. Do you think it is possible? I can have…
-
How to Fetch oAuth2 Access token from Javascript Client Control Add-in For external resource
I need to fetch access token for external endpoint from Azure AD . I'm able to call the Token endpoint in Azure AD but the hand over to NAV page doesn't happen I get the following error "Token renewal operation failed due to timeout" I can even share the code for the same
-
OCR Service integration
Hello, Does anyone actively use the recommended OCR service (KOFAX ReadSoft Online) by Microsoft? I've made a trial account and tried the service, sometimes it works but also sometimes it returns an error as OCR Status: Error but can't find the reason of the error, as another solution; Do you think will it be logical to…
-
BPost SOAP Call Address Validation
Hi I'm trying to connect a soap webservice api to validate addresses. Therefore the Belgian mail delivery company BPost has a free webservice platform to use it. In the SOAPUI , I could connect and try some requests and got some response. Unfortunately, I have some XML HTTP Status = 500 error when I try to connect in NAV…
-
error "No POS Menu Line Exists in #DT-GRAPH-GUEST for status 0" Ls retail
Hello everyone, I have some problem about ls retail (Microsoft Dynamic Nav 2017 Version w1 10.0.18197.0) for Food and beverage module. I create Dining area profile but when I run Client it pup-up error “No POS Menu Line Exists in #DT-GRAPH-GUEST for status 0” I test with version 10.0.15601.0 it didn’t have error like that.…
-
How can I see the approval status of a journal line
Hello, Please help me with this issue. I have an active workflow on journal lines and I can not find a status of the line in order for me to see if it was approved or rejected. For example in the sales order workflow after the request is sent the order status is "Pending Approval" and after approval it converts to…
-
Void Check Employees
Hi, When I try to void a check, I get the following: "The Currency does not exist. Identification fields and values: Code=" Thanks for the help Luis Salcedo
-
NAV-EDI buyer vs delivery party setup. What is best practice?
Hello, We have NAV 2017 and use EDI-Edifact to our satisfaction. However we wonder what is considered best practice in setting up the ´Delivery Party´s´ when the ´Buyer Party´ has multiple addresses and sometimes has an one-time drop shipment request? Our assumptions and setup so far:* an EDI ´Buying Party´ = NAV…
-
vendor detail trial balance and vendor balance to date not matching
The Vendor - balance to date and vendor detail trial balance are not matching in this case. Some entries are being shown from out of the date filter. Its only happening for the vendors. not the customers Not able to solve the problem. any suggestions?
-
NAV2017 CRM Integration - Date Only fields
Hi, I had to write integration for custom CRM entities. I created the table and field mappings and the integration happens through the standard Integration Codeunits. However, I noticed that Date fields are pulled through incorrectly. And I understand why, just not sure how to fix it and actually would expect it to be…
-
NAV2018 Debugging and Extension V1
Hi, we have extensions developed & running on NAV2017 and also for NAV2018. NAV Servers where extensions are published & installed, for 2017 & 2018 versions, are set up in the same way (debugging enabled and so on), but in NAV 2018 we can't see the code related to our extension when debugging, but we can in 2017. In both…