-
Sales Order Shipment Date
Hey guys, this is from the tooltip for Sales Order Shipment Date field: "Specifies when items on the document are shipped or were shipped. A shipment date is usually calculated from a requested delivery date plus lead time." I created a simple sales order, input the requested delivery date 2 months ahead of today, but the…
-
Is it possible to change Sales Shipment Date, by changing Purchase Delivery Date using MPS/MRP ?
I have a sales order from a customer for a manufactured item to be delivered in 3 weeks. I have run MPS/MPR and the system have suggested the corresponding Production and Purchase Orders to be created. I have accepted the action messages from the planning worksheet and the orders have been created. One of the component…
-
2009R2 | Kerberos authentication problems between NAS and Webservice
Hi folks, I have a Kerberos or delegation issue with Dynamics NAV 2009 R2 web service. I hope you guys can help me. It is a somewhat unusual 2-tier model. The servertier runs with the same credentials as the webservice. Both share a process on the same computer. Portsharing is enabled. The NAS runs on port 7046, the WS on…
-
Calculating Invoice Qty And Amount Group by Month Year
Hi Everybody, I'm having problems with group quantity and Amount by the month of Posting Date (Month-Year) I wrote a Qty and Sales Amount calculation from the Value Entry table. But it is impossible to show the Posting Date Group by Month-Year. WITH ValueEntry DO BEGIN SETRANGE("Item No.", Item."No."); SETRANGE("Item…
-
How to consume an asmx web service from Business Central
I have no idea how to do it since I have not worked with SOAP before. I have read some docs and have seen that I have to create both a page and a table (I already have that), but I have not found a way to communicate with the server and extract the data. Can someone explain in detail what I should do? The information I…
-
do we have the barcode scanner in BC mobile device?
Hi, Is it possible to use the barcode scanner in BC mobile device? Can anyone know how to use it? Thank you Naidu
-
is it possible to capture the mobile device name or ID in BC
Hi, we are trying to capture the mobile client device name in BC. But we are not able to see any constant value in Active Session table. Can you help me how to do this. Thank you Naidu
-
Performance impact of table extensions without fields (only code)?
Hi! It is a known fact that due to the needed table joins a table extension can have an impact on the performance. But table extensions can also be used to store table related code - without extending the table structure. How does this impact the performance? Or are there other recommendations of storing such code? I don't…
-
Schema synchronization may result in deleted data referencing a table that doesn't exist
Running into an odd situation when trying to create a new table in NAV. Created a new table in NAV under my custom object range and when I go to compile the object I get the following error: The schema synchronization may result in deleted data... It then references a linked table that was from 5 years ago and deleted.…
-
Insert record in loop not find in the next iteration (Dynamics BC170)
I am trying to write this code ItemDistributions.SetRange("DSM Code", ordPlnHeader_rec.DMS); ItemDistributions.SetRange("Item No", itemNo); ItemDistributions.SetRange("Supplier Type", ItemDistributions."Supplier Type"::"Sole Supplier"); if ItemDistributions.FindFirst() then begin repeat PurchaseHeader.Reset();…
-
Modify Response for oData page webservice
In BC version 16 I have published an API page as a webservice and after inserting data successfully I would like to include specific data in the response that can be used by the application calling the webservice. Is this possible and if so how do I do this? Thank You
-
Regenerative Plan ignores free stock
Dear all, If you create a production order with some component, which is not reserved on stock, the regenerative planning will still recomend to purchase the component to match the demand. I was expecting the system to find the units on stock and reserve it automatically before recomending some purchases. What I'm doing or…
-
NAV2018 and PowerBI on local installation?
I have all necessary components installed on my local laptop. That is:* SQL Server 2016 * NAV 2018 * Power BI Desktop. Naturally I can access my NAV Data via Power BI and create reports from my data. So far so good. The problem is that I am not able to access Power BI reports from NAV: The default Power BI Report-Wizard…
-
Connection fails when I try to connect to PowerBI
Hello I have enabled web services and trying to connect to Power BI but i get a message says We couldn't authenticate with the credentials provided. Please try again. I don't know what I need to connect? Thank you
-
NAV2016 Webclient multitenant and singletenant on same server
On our server we have a multitenant database with 5 tenants. Now we have also created a singletenant database on this same server. When I try to reach the singletenant database with the webclient I get a login screen and after logging in I get this error: The tenant xxxxx was not found. Is there a solution so we can use…
-
Output Journal
We are operating out of Microsoft NAV Dynamics 2013R2. Hello, of our users cannot access to their output journals. She entered a line with incorrect production order by mistake, did not noticed until she tried to post and wasn't allowed. However, the this order was being finished in a 2nd user's journal about the same…
-
Modify a Record from a RequestPage
Hello NAV experts, Is it possible to modify a Record from a RequestPage ? Here is a code example that generates an Error "ID=0" dataset
{ dataitem(CalculLoyerEntete; "Calcul Loyer Entete") { DataItemTableView = SORTING("ID"); column(Name;Name) { } column(DateMail;FORMAT("Creation Date Last Mail",0,'<Day,2> <Month Text>…
-
The problem about get business central trials.
Hi everyone, I tried to get the business central trials from this link below. https://trials.dynamics.com/ I used work email (the email that have onmicrosoft.com in domain). After I click "GET STARTER" button I got this message "That didn't work We don’t support your country or region yet. We’ll add more countries and…
-
Webservice returning 413 Request entity too large
Hi all, On Navision 2015 CU30, I'm having a problem when I send a request to the navision webservice, the request contains a base64 encoded PDF, so the request is +100 000 charachters. I get the response 413 request entity too large.. I tried changing the max msg size in the instance admin console to the max value allowed…
-
Make it impossible to print report
Hey everyone, For a project at work, a report has to be altered so that is only possible to print the report if the report is run from a certain page. So for example, printing is only possible from the sales line page and not from the customer card page. In both pages, making a preview should still be possible. Is there a…
-
Not allow to modify a record in some conditions
trigger OnValidate() var StatusLbl: Label 'The status of the policy has changed to: %1', Comment = '"ESP = "El estado de la póliza ha cambiado a: %1"'; begin Rec.Reset(); // --- IF para comprobar si el estado de la póliza es Aceptada o Rechazada --- if (("Policy Status" = "Policy Status"::Approved) OR ("Policy Status" =…
-
BC 17 - cannot enter table ID in field mapping from a data exchange definition
Hi. I think this is something simple that I have missed but I am banging my head against a wall! I am setting up a simple payment export. I have created the new data exchange definition, set the details (variable text and all code units etc), entered the line, entered the columns and then I go to field mapping and I try to…
-
Set-NAVServerUser to add profile to user failing, after New-BcContainer for BC 17.0.16993.0
Hi, I am trying to add a profile (role) to a user. I have created a docker image/container using New-BcContainer and then using Set-NAVServerUser as below. However, I am getting an error. I have tried various profiles ACCOUNTANT, BOOKKEEPER etc. Regards & Thanks Roddy
-
NAV 2016 cu1 client does not run on terminal server
Hi, Strange problem here. I've installed NAV 2016 cumulative update 1 on a navision-server. Installed the client too on that server. It opens fine. Now when I install the client on the terminal server the installation seems succesfull, but when I start the client it crashes. In event viewer there's a ".NET runtime"-error.…
-
Network share as URL/Hyperlink in field
Hello! We are facing the following problem: In Business Central web client, we would like to use network share as clickable links. It's working for HTTP and https protocols but for file:// protocol it redirects us to about:blank#blocked, and the field trims the \\'s from the url \\machinename\share\file.ext to it's parsed…
-
VS Code compile errors for dotnet in BC17
Hi, I'm preparing a baseapp for BC17, it is all going well but I've had an issue after installing and then uninstalling NAV 2015 on my machine for an emergency. I'm now getting a handful of .dotnet compilation issues for BC17. Note, I have repaired/uninstalled/reinstalled BC17. I'm wondering in anyone has come accross this…
-
BC Task Scheduler Retry Flow
Hello all together. Our company is in the process of upgrading from NAV 2009 R2 to Business Central. I was looking into the Task Scheduler and came across the following. Under certain conditions (e.g. table lock) a task is restarted ("Retry Flow" or "Retry Process"). The first time after two minutes, then after four…
-
Can we capture mobile device ID in Dynamics 365 BC
Hi All, We are using MS Dynamics 365 business central on premises. User is accessing application from mobile. Can we capture his mobile device ID? If any user fill the data through mobile we have to capture his mobile device ID also. Please help how can we capture this? Thanks in advance. Regards, Kishore
-
Data migration from BC 14 to BC Online
Hi, I'm a bit lost and wonder if someone can give me some tips. I'm in a process of migrating data from BC 14 to BC Online After upgrading the data, I have many tables with "warning : The table does not exist in the local instance". Some of them are coming from extensions that are not in by BC 14 on prem but others are…
-
could not find a debug adapter descriptor for debug type 'al' (extension might have failed to activa
Hello I have been using vscode yesterdag, but todag i am getting the message: could not find a debug adapter descriptor for debug type 'al' (extension might have failed to activate) I couldnt finde something on google. thanks for the help. Kinde regards Firsa