-
Lock Table & Job Queue
Hi All, I have a job (Job1) that runs every minute in a Job Queue which posts journal entries. There is another job (Job2) that runs at the end of the day which locks the ledger table. When that happens Job Queue for Job1 crashes and the Job Queue Status gets updated to Error. I'd like Job1 to run only if it the ledger…
-
CRM 2013 and Exchange 2016
Hello everybody, I'm new here and in the CRM's World. I had to connect the CRM 2013 to Exchange 2016, i follow this tips : https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/mt622062(v=crm.8) But i still the "in progress" status, not failed or wish i'll prefer the success status.…
-
Start-NavDataUpgrade during upgrade to v17/18 - how to detec when it is finished?
I am running upgrade to V17 according to this MS guideline Upgrading Customized C/AL Application to Microsoft Base Application Version 17 . Everything is fine but... Task 10 point 1 when I run Start-NavDataUpgrade is asynchronous :( In next point they say: "To view the progress of the data upgrade, you can run…
-
Double validation if same value entered
Hello, I have very specific problem which I cannot find any information on. I am working on Microsoft Dynamics NAV 2017. I have created custom Page, where I use variables on fields. These fields have custom ControlAddIns (to change color or sizes of the fields). I have the case where I have to validate same value two times…
-
XLPivot .SubTotals
Hi, In excel vba - i can turn subtotals off for a field in a pivot table.. e.g. below.. For Each pt In ActiveSheet.PivotTables For Each pf In pt.PivotFields 'First, set index 1 (Automatic) to True, 'so all other values are set to False pf.Subtotals(1) = True pf.Subtotals(1) = False Next pf Next pt but in NAV - ( First 2…
-
Rec.Skip in PageType = List
it's possible to skip a record from a page list given certain conditions that cannot be added in filters (SourceTableView)? In a report it's possible with record.skip but in the list page it's not available
-
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…
-
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.…
-
PO with UK VAT, EU VAT and ROW VAT all in one consolidated invoice from popular parcel service.
Customer ships all over the world and at some point in the past we've modded the Purchase Order and Purchase Invoice Subform pages to allow line level access to the VAT Business Posting Groups. So, when the delivery company sends in their consolidated invoice, they can setup an Invoice that matches what they were sent.…
-
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…
-
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…
-
Create/Import Blanket Sales Order using dataport from csv file in NAV 2009 R2.
Hi Everyone, I tried to create 'Blanket Sales order' using one dataport from csv file. In csv file suppose: have 8 mandatory column in one row, 3 from sales header and remaining 5 from sales line. How will i linked each other so that data will import from single row that is from two different table? or, can be exported the…
-
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…
-
Show SSRS report within NAV Page
Guys, Has anyone found a way to show native SSRS reports within NAV page? Thanks
-
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?
-
GS1 Datamatrix in NAV classic report
Hi, does anyone know solution for generating 2D GS1 Datamatrix code on classic report?
-
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…
-
NAV 2017 connection to Dynamics 365 (CRM) just stopped working
Hi all, not sure if anything has changed in the last day or two but our connection from NAV2017 to Dynamics 365 has stopped working. It's been working fine for a few years and just stopped working yesterday. The error we get when we try the 'test connection' is "Unable to login to Dynamics CRM". I have checked the login…
-
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?
-
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…
-
Sending PDF's with a Password protection layer.
Hello, I would like to know how it's possible in Nav 2017 to send PDF's with some form of password protection. Thank you.
-
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…
-
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…
-
Is this the most stupid thing in AL coding?
Well, I've been pulling my hair out trying to figure out how to pass a parameter to a code unit and the way NAV/BC does this is not intuitive at all. here's an example from Github https://github.com/microsoft/AL/issues/3845 Quote "Teaching AL development to an experienced outside developer is an many aspects interesting.…
-
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…
-
SFTP for NAV 2009
Hi, I was using FTP on classic client which was working fine Now it has been changed to SFTP can you please tell me how can I use SFTP WinSCP does not work on classic client 2009 Any other standard/free api/automation ? Thanks
-
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?
-
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…
-
Installl NAV 5.0 SP1 CSIDE Client on Server 2019 (x64)
Goodmorning, Question: is there way to install NAV 5.0 SP1 CSIDE Client on Server 2019 (x64)? I try to install this "download" https://mibuso.com/downloads/microsoft-dynamics-nav-w1-50-sp1 And i'm using the setup icon: I constantly get the Error: I think i have installed all the redistributables: Does anyone know if this i…