-
Overhead Applied Account in General Posting Setup
Hi! Can someone give me a brief overview of the importance and use of the Overhead Applied Account in the General Posting Setup window? In our actual setup of posting groups, we have not entered any G/L Account in the Overhead Applied Account field and we could post our invoices. But just today, while posting an invoice,…
-
cant bookmark page
hi, is there a property or something so a page can be bookmarked? i cant bookmark a certain page?
-
NAV2013R2 and Microsoft Server2012 R2
Hi all, We are having some trouble getting 2013R2 working on an Server 2012R2. First there was an issue on OCsetup and the .NET framework 3.5 (took a while) but finaly the install on a 3-tier is working (development is working). Problem is we cannot get the service tier running, the administration tool shows running, RTC…
-
Go to specific line in grid
Hi experts, In Axapta 4.0, I have a grid with lines/records. The user can create records and change field values. When a field is modified, the form must change values on the current record and on some other records in the same form. And then it must refresh itself. It works fine, except that when all that is done (from…
-
Problem using RecordRef and Changecompany
Hi. I am trying to copy a lot of tables from one company to another using RecordRef. But it seems that the OPEN method doesn't work as planned. This is the code I am trying to execute, (I have set filter on just one table here to test..) rTables is of record 2000000028 with information about tables. sOldCompany :=…
-
Deactivate Change Tracking on SQL server (Performance tuning)
Hi, Have a customer with performance problems. They have a SQL consultant looking into SQL performance. He says that Change Tracking is activated on database, and that gives performance issues. Can we deactivate Change Tracking on SQL database without problems for the running NAV 2018? Are there any other areas to do…
-
List all object and get description
Hi, in previous version (NAV) there is a table (object) which allowed me to obtain the description by indicating the type and idnumber of an object. Now in BC there is a way to do same?
-
Read files content from server on SAAS
Microsoft has a development for North America to generate some files and saves them into disc. My problem is that I can not read these files from disc because SAAS does not allow me to use any function that reads file content from disc. Could someone please help me how to proceed with this issue? Is there any possibility…
-
BC/NAV career prospects
It's 2023 you are to become a junior developer, do you choose the path of Business Central/NAV develper role? Why yes and why not?
-
Adding extension to Preview Posting Business Central AL Extension
Hi, I have an event EventSubscriber for SampleTable OnAfterInsertEvent to populate the tempSampleEnty temp table and another EventSubscriber to another Codeunit 20 (Posting Preview Event Handler) for the event "OnAfterFillDocumentEntry" to add new row in POSTING PREVIEW window but my temporary table is uninitialized or…
-
Issue and solution for Import Excel to Cloud BC Table
I was trying to import some records to a Cloud BC table from Excel. I could not use these following Methods in Cloud BC, which was good for on-premises BC. This is due to the scope of the methods (onPremise vs Cloud). ServerFileName := FileMgt.UploadFile(WindowTitle : Text[50];ClientFileName : Text); SheetName :=…
-
Entries applied to an Outbound Transfer cannot be unapplied
Hi Experts, I got the error msg "Entries applied to an Outbound Transfer cannot be unapplied" when trying to post Purchase Return Order. What should I do to avoid this error? Thanks,
-
User log in error: NAVCancelCredentialPromptException
Hi, I have an database upgraded from BC15 to BC20.6 onprem using AAD for authentication. At times users are not able to log in and it appears the browser is processing something on the log in screen. Users can only log in after clearing the cookies for the BC website. In the event log I am seeing the following error:
-
SendRequestAndReadResponse - HTTP Web Request Mgt - Procedure
Dear all! The case : I am having to do a post request using http method. What i need to know is , when exactly, does the post request in the sendrequestandreadresponse procedure, occurs? Because there are times that i am getting a timeout error in the getwebresponse , which is called by getresponse procedure ( codeunit…
-
Can ChatGPT be used for answering Business Central end-user functional-related questions?
Can ChatGPT be used for answering Business Central end-user functional-related questions? Let's compare it to a trained Q&A type chatbot built on Microsoft’s Bot Framework: https://simplanova.com/blog/chatgpt/
-
Add file in encrypted ZIP file
Hi to all, Adding files into a .zip file is possible using FileManagement and functions for adding file to zip archive. But, is it possible in NAV to encrypt the ZIP file when it's created with pre-defined password in the system? I'll be grateful for any experience or advice. Best Regards
-
Getdata function of Report builder
Hi all, I didn't know how the getdata function works in report builder. specifically in report 206, CustAddr is variable that has dimensions=8. here how CustAddr storing the customer details into the dimentions(Address, city, state, zip code)? thanks, Rajan.
-
Business central + mermaid.js
Hi everybody I need to create a gantt diagram in Business Central, and I am thinking about doing it with mermaid.js (https://mermaid-js.github.io/mermaid/) but I can not manage to make it work in a Control AddIn i business central. Has anyone managed to do it, or something similar? Thank you in advance.
-
Google Worksheets manipulation on NAV 2017
Hello everyone, is it possible to import/export data to and from web-based google worksheet link?
-
How can I use my dll in cside (NAV 2018)
I want to create a cside variable of type DotNet of my custom dll. What do i need to do? The dll contains a function to generate some key. It's NAV 2018.
-
How to get a field/value from page to codeunit & also how can i use that value in my entire codeunit
In business central I am using existing page, so in that i need a field/ value to use in the Codeunit. So, in codeunit I want to use that value in entire Code unit. Is it possible? Thank You for your answer.
-
Problem with Base64 conversion and Excel files
Hello, I have an application that gets Excel files encoded in Base64 I try to decode the Base64, put the obtained text into a blob to download it later with DownloadFromStream But I get corrupted Excelfiles I developped a little procedure (see link) to see if Base64-coding and Base64-decoding is altering the data. The…
-
Lot No does not work when it is generated by code in transfer lines
I am creating transfer order by code and it works but i want to assign lot no also i wrote this code procedure AssignLotNO(transLine: Record "Transfer Line") var EntryNo: Integer; begin if LastTRackingSPecs.FindLast() then EntryNo := LastTRackingSPecs."Entry No." + 1; GetItem(transLine."Item No.");…
-
Creating functionality to TEXT a phone number when backorder get received
I am looking for new functionality to have NAV 2018 automatically send a TEXT message to a specific phone number to alert the customer the backorder sales line is received in - is this possible?
-
Overwriting "Send To" on report request page
Hi! Whenever you run a request page, there is the "Send To" button, that allows user to use different files type. The thing is, that if the user choose the "Microsoft Word" file type, the file is going to be editable when saved, unlike the PDF. Is there any way, to prevent user to use this "Send To" button on request pages?
-
How the warehouse Entries are processing?
Hi all, Can anyone tell me how the warehouse entries are managed/Stored when the Register inventory movement done and which codeunit helps to store the data in warehouse entry table in Nav ? Thanks, Rajan.
-
Callback URL for Cloud BC
Hi All, I am pulling data from 3rd party system. so they will give me callback url. how do we do callback url in BC? any advise? Thanks.
-
Can't delete a company in Sandbox
So I am working with SaaS Business Central that is: Version: W1 20.2 (Platform 20.0.41086.43114 + Application 20.2.41144.41547) The user I am logged in with, has Super, Security, Full Business, Extension Management - Admin rights for all the entities. I have total of 3 entities and wish to keep just one. Whenever I try to…
-
Show all tables data
Hello experts, I have two fields in my table, TableID and RecordID. TableID is for selecting the Id of any table in NAV, I have no problem with that, but the second field, RecordID must contain all records of the table that I had selected when I filled the field TableID. EXP : I entered 18 in the field TableID, so the…
-
Debugging NAS Code
Hoping someone can help me solve an issue. I have a virtual machine set up with ADCS, NAS, and the 2009 R2 Classic client and have it pointed at a test copy of my SQL Database. I'm trying to debug a new codeunit that I'm writing for ADCS. I'm running the client as admin, have opened up the codeunit in the designer, set a…