-
Missing DotNet System.Linq.Expression assembly
Hi , I am trying connect NAV to SharePoint and i need dotNet Variable System.Linq.Expressions.Expression. I have figured that DotNet Assembly Subtypes System.Linq.*** are not available under the Assembly list in NAV 365BC 130. Please, Can someone advice, What should I do to get those assemblies? Thanks a lot, Dominik
-
Create Docker Container that can access host's network resources
Hi, Is there a best practise for this? Our nav solution needs to access another system outside (not BC/NAV) the container. Regards Roddy
-
Filters page not loading on Workflow condition Assist Edit
Hey, Am working with Dynamics business central Version W1 13.1 13.0.27183.0 and can't open the filters page to specify conditions for a workflow. The assist edit button marked below yields nothing. Please help
-
Table WebHook Subscription not available on cloud
Hello, Me and my colleagues are creating an extension of a WebHook menu, where you can view all subscription, create, delete and update. Because we use BC16 on-Cloud, we are having some complications. We do not have access to the 'WebHook Subscription' table. Problem: The type or method 'Webhook Subscription' cannot be…
-
NAV 2013 Upgrade: Dimension Value ID Error
Hi together, I currently try to upgrade a database from NAV 2009 R2 to NAV 2013. Now I'm on step 2. While upgrading the "Document Dimension Archive" table I get the Error "Dimension Value ID must have a value in Dimension Set Entry: Dimension Set ID=0, Dimension Code=PROJECT. It cannto be zero or empty." But this table…
-
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…