-
Cannot create companies in Business Central OnPrem
Dear all, We have BC 19 Spring Edition on a SQL Server 2019 standard edition. When I want to create a company or copy a company I get the following error: "Online index operations can only be performed in Enterprise Edition of SQL Server". Is there a way I can disable Online Index operations? Or do I have to upgrade to SQL…
-
Upgrade from NAV 2017 to BC. NA version to CA or US?
Hello One of my client is upgrading from 2017 NA to BC and they have companies in US and Canada. Since they have split the databases, which version will they be upgrading? Has MS released a document on this?
-
OK button in BC
Hello, I have an issue when running a page using runmodal = lookupok The source of the page is a temporary table And when this table is empty the OK button is disabled Is there any way to enable it?
-
Manufacturing Policy - Make-to-Stock subassembly
Hi, we are struggeling to set up the following scenario and are hoping for some helpful insights. We have a manufacturing item A001 that contains subassemblies B001, B002 and B003. We want to produce B001 and B002 together with item A001. Therefor we set Manufacturing Policy on all 3 items to "Make-to-Order". B003 should…
-
The logic behind Report 5756 "Create Warehouse Location"
Hi everybody, we have lots of item ledger entries and a slow server and this report is running for 24 hours and has made 3% progress so far. I need to speed things up. I don't understand why this report is looping through all item ledger entries regardless of the location that is to be converted to using bins. It would…
-
XMLport Import Text Element not clearing itself - still filled on next loop
Hello I got a problem while importing an xml file. Somehow I can't find anyone having the same problem on google ._. So my structure is following MLIST - M - DATA1 - DATA2 I do processing in the M - Import::OnAfterAssignVariable() Now let's assume DATA1 is always filled and DATA2 like every third loop only. So it's filled…
-
How to check Where-Used List from Other company?
Hi all, how do I check Where-Used List from other entity (Same database) I just need to know how many records from this Where-used List. I created my own function to get this counted Where-Used List. but it only detect in own company. from company A want to check how many records in company B (For the same GL Account) it…
-
Xmlport export
Simple one, but not getting it right. I have a custom Boolean field in purchase header called 'exported'. It gets checked when a purchase order gets exported. Now I want to export purchase lines which are not already exported using a variable text XMLport. Wondering what would be the right way to filter purchase lines as I…
-
Show SSRS report within NAV Page
Guys, Has anyone found a way to show native SSRS reports within NAV page? Thanks
-
How to format date bound to Custom Xml Part
We are using Word document layouts for customer facing Business Central 365 (SaaS) reports. When binding a date to a Text Content Control, how do you format said date?
-
Promoted action is shown in the wrong category
Hi experts, In Business Central cloud on page "Posted Sales Invoice", there is these promoted action categories: PromotedActionCategories = 'New,Process,Report,Invoice,Correct,Print/Send,Navigate'; On the same page, the action "AttachAsPDF" has this promoted category: PromotedCategory = Category6; It is shown under…
-
How to get a list of all orders and archived orders if order deleted
Hi all I'm trying to extract a list of sales orders and archived sales orders (in case the order is deleted due to fully shipped/invoiced). Sales orders part is easy but getting the archived orders, I'm struggling to do this in AL code. In SQL I'd write a query something like: Select Sales Archive Header.No where Sales…
-
Calculated Field for Cust Aging
I want to add some new fields to display the 30 Day, 60 Day and 90 Day aging customer balance on the customer list page, instead of having to run a report each time, can anyone help me with how to achieve this?
-
Cannot Install Dynamics NAV 2016 in Windows Server 2012 R2 Standard.
Hi All, Can some suggest the solution for the below error log: We are using Windows Server 2012 R2 Standard with SQL 2014 Express edition. === Logging started: 2021/05/12 13:05:50 === Executable: C:\Program Files (x86)\Common Files\Microsoft Dynamics NAV\90\Setup\setup.exe v9.0.52162.0 Computer : DYNAMICS_TEST --- logging…
-
AL: change the standard No. Series management functionality
Hi All, I have a task to change the standard functionality of assigning a numbering series to created documents for known customers; this means that, as user creates a sales quote for a known customer, user would typically first go to a customer page, filter for customer and then click on button: "New Document" -> "Create…
-
Adobe Reader loaded via control add-in stopped working after Windows security update
We use the Adobe Reader to view pdf files from within NAV and it's been working great for the past year and a half, however, with the most recent Windows security update (KB5003637) it stopped working. The odd part is that it's only happening to some but not all PC's. Has anyone else experience similar issues? Our only…
-
Unable to Read a table in NAV
Hi All, I'm running into a weird issue where I'm unable to read a table in Live but I'm able to read it in DEV. Also, I'm able to design that table but I just can't read it! Please note the following,* I have a developer license uploaded * I have a SUPER role permission * I'm within the range, I also changed the ID to…
-
Setting up a Control AddIn as a DotNet Variable in a codeunit, is it possible?
I am testing the TinyMCEEditor Control AddIn (https://github.com/navaddins/TinyMCEEditor-AL) and I have done some modifications, so that I can have several configuration settings (i.e. Inside NAV Mail Client Page should be differently set up as a Requestpage of different reports, etc.). I am trying to make it as easy as…
-
Regarding Performance issue
Hi I have Written a code Line in the OnAction on the page object, In the second case I have commented the Object and created the Codeunit, Will there be any performance Related Issue. Which is the suggestable method of writing the code.
-
Regarding customer number and balance.
Hi, I have created a card which has customer number and balance. When we select customer number then we need to get the balance of the customer. By default it is taking first customer and giving the balance. But when we select other customers then it is showing an error. Can anyone suggest on this.
-
Regarding sales order post/cust.ledger entry
Hi, I want to create two fields in sales header and sales line and i need to transfer it to customer ledger entry can anyone help me the flow of table in microsoft dynamics. please suggest how the data is transferred from sales header and sales line to customer ledger entry table by codeunit.
-
Using StartSession
Is it possible to capture an error that may have been generated by using StartSession? In my example i want to raise a sales order in another company based on a trigger. If, say the customer was blocked in the company that startsession was used, is there a way i can get the last error and save it somewhere? By using a…
-
Time limit for permission recorder?
Hello everyone. I'm close to starting to define clear and concise permission sets in our NAV 2015 install. Up until now the company hasn't placed any emphasis on tracking/controlling the necessary permissions so i'm basically starting from scratch. I would like to use the recorder to capture the necessary permissions of a…
-
Customer/Vendor Invoice Load
Hi all, what is the best way to load open customer/vendor invoices into the system prior to Go-Live?
-
Log in Perm set
Hello all, I want to create a user with the minimum permissions. So I just created new permission set via the "Record permission" function. It's all good, but it's not enough because I cannot "record" what is happening when users log in. I started manually adding codeunits one by one but looks there are too many of them.…
-
"Could not create SSL/TLS secure channel"
Trying to fetch data from external web service using BC client, but keep on getting the error "Could not create SSL/TLS secure channel". When using web browser the service response is OK. Any idea? Regards
-
Dynamics BC Online Production environment Upload Extension Error
I face the error below when attempting to open "Extensions Page" in BC Online Production environment. What is curious is, I can open this same page in a SandBox environment. I just cannot do this in Production environment. And I am logged with the same user with the same permissions. Permissions assigned to the current…
-
In standard NAV, is approving an Approval Request supposed to send an email to the requestor?
Hi Can't quite figure out this one, so decided it's easier to ask the community! Looking at the code in Codeunit 439 "Approvals Management", function ApproveApprovalRequest(), I don't think it is programmed to do it. Anyone here able to confirm or otherwise?
-
BC: Change fields displayed on pages
Hi I have difficulties changing the displayed fields: "No.", "Sell-To Customer Name" o Page ID 41 - "Sales Quote" How to hide any of those fields Thanks
-
Creating Sales Order Lines gets error "Standard Code Text does not exist...."
Hello, I exposed page Sales Order (id 36) as web service, I'm following some guides to create Sales Order Header and Sales Order Lines, the Header can be created successfully, but the Sales Lines always get error "Standard Code Text does not exist..." SOWS.Sales_Order_VS_Service testcreateSO = new…