-
Hi Esteemed Colleagues,
Please, I would need your kind assistance with this question: I really want to know if Microsoft Dynamics 365 Business Central On-premise but deployed on Azure has the capability to get Apps from Microsoft Appsource? Anyone who has done any work around to get this done can please assist. Thank you.
-
Set Permission automatically.
we create a new extension. This new extension has some Tables, pages, codeunits. Is it possible to create the required permission to all roles automatically?
-
A qüestion concerning a sales invoice report layout with BC and Report Builder
Hi mates: I want to implement the possibility of reseting the page number and the total pages for each DocumentNo in my report of Sales Invoice. I found the functionality to reset de "Page Number" field in this article: https://docs.microsoft.com/en-us/dynamics-nav/how-to--reset-report-page-numbers. The fact is that it…
-
XML to JSON forcing XMLNode to be an Array
When using XMLPorts and NewtonSoft to create a json message where we have nested nodes these should be converted to a json array. But when such a node only contains one "record" it will not convert to a json array. How to get this working is explained at the newtonsoft website…
-
Allow Sales Credit Memos to blocked Customers
Hi, i'm a rookie searching for assistance. I have a codeunit where I set to All the field Block from Customer when its credit limit is up to 120%. Now i need to allow blocked customers to do sales credit memos. How can I implement this? Lots of thanks!
-
Is it possible to enable the Arabic language in Business Central On Premise?
Hi All, One of my client is asking to enable the Arabic language in Business Central On Premise. Please can you help me do we have language module for Arabic to show the system in Arabic. Thank you Naidu
-
Converting Text to Date
Hi, can anyone say to me if it's possible to convert Text Data to a Date Data? I'm importing a CSV text file to headers and lines and I want to pass one information to the Order Date date field. Thanks!
-
BC TechTalk - a FREE virtual event for technical BC people starts tomorrow!
BC TechTalk - a virtual event for technical BC people starts tomorrow.⏰ Be prepared for: ✅17 sessions on trending and insightful topics for the BC community. ✅21 BC professionals from all over the world. ✅Q&A after each session - find answers to all of your technical questions. See you on Thursday! Claim your…
-
Join the webinar👉 How to convert Classic NAV report to RDLC and AL format, success story
Join the webinar on How to convert Classic NAV report to RDLC and AL format, success story. The following topics will be explored during the online webinar: -Common problems while upgrading Classic NAV reports to Extensions -Introduction of Simplanova Tools and Report converter -Demonstration of how to convert customized…
-
Dynamics NAV Development Environment in Azure VM used locally
Hi Group Members, We have a situation, where we are trying to use Azure VM as our NAV Server and SQL Database Server and when we trying to save changes in the Table. We get the following error. Please find below further more environment details for your information. NAV Server and SQL Server is hosted on AZURE VM NAV…
-
LIKE In RDLC Report
Hello, I use a navision 2013 I would filter the databox with two chaine The expression =Fields!ItemNo_ItemLedgerEntry.Value like "*paac" and "KIT-PA*" Could you please help me
-
Join the Webinar
Interested in How to convert Classic NAV report to RDLC and AL format? In this webinar, Simplanova Head of Sales Domas not only will show the whole process but also will share various tips and tricks on the conversion and tell the success story of Isatech. Save your spot now on 25th of November, 4:00 PM CET by registering…
-
Computer Name and/or IP Address
Hi How can I find out from a navision code unit on what computer (computer name, eg. xyws27) and/or its IP Address the code is currently running? Thanks Thomas
-
Upload Files from NAV 2018 to AWS S3 Bucket
Hi, Can you please help to know the possible ways to upload file(*.CSV) on AWS bucket s3?? Please help me Thanks so much
-
Item tracking
Hi NAV Experts, I am new to NAV. And I am working on Item re-classification. (Generally moving some items to another location.) When I click on item Tracking Lines and on the Item tracking Page I see the Serial number and lot number. On Assist of Serial number, I am able to view the available serial numbers and the Lot…
-
Order of triggers in Table
Hello NAV experts, What is the order of triggers execution in a Table Object? exemple: is onModify before onValidate ? Regards.
-
How to find table 2000000041 ("Field") in MS SQL?
People. Tell me please - where table 2000000041 ("Field") is stored in MS SQL. - how to find table 2000000041 ("Field") in MS SQL. Field numbers of the tables in view sys.columns do not match the actual field numbers in the tables. Is there a way to get the actual field numbers?
-
Use a value in a Request Page's field
Hello, I want to use a value from a record in a request page's field. I used a method "SetParam" to transfer the Primary Key to the report in order to select the right record. This is the code in the Card Page: trigger OnAction(); var locCalculLoyerEntete : Record "Calcul Loyer Entete"; repDCL01FDL : Report "DCL 01 FDL";…
-
Copy a BLOB to another record
Hello, What am I missing to copy the BLOB "Texte" to the BLOB "Documents Manquants" ?if locExtendedTextHeader.Get(locExtendedTextHeader."Table Name"::"Standard Text",'DCLDOCSMAN','FRB',1) then begin locExtendedTextHeader.CalcFields(Texte); Validate("Documents Manquants",locExtendedTextHeader.Texte); end; Thanks in advance.
-
import AR Balance
Is there an easy way to import open AR so that both the Original amount and the remaining amount show? Often this is different depending upon payments made to reduce.
-
Display Text BLOB in Word Layout
Hello, I am working on extensions for NAV2018. I tried to show a Text from a BLOB field in a Word Layout. But I am having the following result : I used a "Repeating" Content Control in the Word Layout and CalcFields in the trigger OnAfterGetRecord() : Thanks in advance.
-
.al file preview in Windows Explorer preview pane
Don’t like to wait for Visual Studio Code to boot up when you’re looking for a specific .al file? With this trick, you can preview .al files in Windows 10 without opening. . .. To view more visit : https://mrinmax.blogspot.com/2020/02/al-file-preview-in-windows-explorer.html
-
Invitation to a FREE Business Central Virtual Event for Technical People
We invite you to the Business Central Virtual Event for Technical People - 'BC TechTalk', which will be happening on the 3-4 of December. It is a free 2-day virtual learning event for Microsoft Dynamics 365 Business Central technical people or anyone enthusiastic about the technological advancements in BC. Expert speakers,…
-
code to get salesperson code to automatically populate on credit memo
same code for assigneduserID to automatically populate
-
Clear setfilter on a field
Hello, I am developing extensions for NAV2018 (with AL code) I am trying to clear a filter that I used on a field. I tried withrecord.setfilter(theField); but VScode is showing that an argument is missing. Thanks in advance.
-
DMS Universal XMLport For Dynamics Business Central on premise
Hey guy , I already convert DMS for import data old version (2013-2018) to BC , in below https://drive.google.com/file/d/1rzTwhd7VKyB37CpFNJedf-kBSG0DYm4r/view?usp=sharing :) anyone have idea to upgrade to on extension ?
-
Update a field when a value in another field is validated
Hello, Why the following code is not updating the value of "No. Contrat" when a new value of "Code Client" is seleted (this code is in a Card page) field("Code Client"; "Code Client") { CaptionML = FRB = 'Code client'; trigger OnValidate(); var locContrat : Record Contrat; locContratDetail : Record "Contrat Detail"; begin…
-
Automatic cost adjustment - Never
Dear Friends, As we all know we can set Automatic cost adjustment to "Never" on inventory setup in order to speed up the process and same we have to run the report - Adjust Cost – Item Entries for pass required cost entries in side in the NAV. My question is, If we are configured above as "Always", Are we need to again…
-
Join the webinar: How to effectively use Power Platform with Dynamics 365 Business Central
We are happy to announce that our Fall Webinar Series will start soon❗️ Do not miss the first webinar on How to effectively use Power Platform with Dynamics 365 Business Central by Aleksandar Totovic - an experienced professional in this field. Mark September 23th on the calendar, and save your spot here👉…
-
Can we apply OrderBy on any field in NAV Services?
I am fetching data on scrolling in a table. On each scroll it fetches 100 records. Now i want to apply sorting on each field so that when user click on a specific heading it sort data on fetch data on scroll. Issue what i am getting is sorting with scrolling is working fine for Date values and Invoice numbers but not…