-
Safety measures in deployment window (BC/AL)
Hi Guys, Happy New Year! :) Since the introduction of AL apps it has become even more critical to prevent data changes in the system during app deployment windows. Changes sources could be users, web services, job queues. During app installation some of the existing ones are getting uninstalled and during that time their…
-
hi, Can one help how to make repeat control under another repeat control - word layout
Hi, I am unable to make repeat control under another repeat control in word layout. Example I have job task and for each job task there are repeating Job planning lines. I am unable to do the same. it is only job task are repeated and job planning lines repeated at the last Warm Regards Kris
-
2009R2 classic| how to check if directory exists in network
Hello, I have a problem, when running codeunit from classic client it checks if in the directory (which is in the network for example \\vision3new\data\) is some files in File system table. All is good, when network is running, but sometimes when network is down for some reason I get a message "The network path cannot be…
-
DataItemTableview - filter on multiple doc types
Hi All I want to have a report that runs identically from sales orders and blanket sales orders. Is it possible to change the where clause below to Order or Blanket Order: DataItemTableView = SORTING("Document Type", "No.") WHERE("Document Type" = CONST("Blanket Order"));
-
Hostname Webclient
how can I determine the hostname for the webclient
-
Long Item Description
Hello, I need a field with long description in the Item Card (1000 symbols). I tried with BLOB everything was good, but client wants to import/export this field with configuration packages, so BLOB field is not good in this situation. I thought about new Table, in which will contain data with item No. and Description,…
-
Purch. Invoice Preview Posting Error
Hello Good day. We encounter a really weird bug. this is the 1st time I've seen this. In purchase Invoice Module, Every time we do Preview posting there is this error that always popping up. As I do debugging session. I found out that the error triggered in Codeunit 90 FillInvoicePostBuffer Function. it's just weird that…
-
Does anyone else have problems with exporting Item Lines on Excel using Ctrl+E ?
My customer is trying to export some Item Lines in excel using Ctrl+E. Problem is, some of his Inventory values differ from what's in the Item Lines. For example, one Item has a value in Available equal to 1500, but the value displays 0 when exported to excel. I've never had this problem before, and neither have my…
-
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
-
Does anyone have the client download for Attain 3.01?
Hi all. I need to get the above client installed on a local PC but all I can find on MIBUSO and the web are links to Attain 3.10 and 3.60. I need Attain 3.01 client and preferable the GB version. Does anyone have the client or know of web link that has the client? Many thanks. Neil
-
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…
-
what is meant by test case and how to write it
Please!Explain it Clearly Thanks in Advance
-
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…