-
How to save an ANSI file from Business Central?
Hi experts, This is regarding Business Central cloud. When I make a file, I can set the encoding to Windows, UTF-8, UTF-16 and MSDOS. Our customer need a file with ANSI encoding. How do I do that? Hope, you can help. Morten
-
When sending a document per e-mail, showing request page
Reproduction: open any posted invoice, click either on "send email" or "attach a copy", in both cases, no request page. It just runs. It is important if you have on the request page options about how it should look like. I have heard it can be changed maybe in "document handling", but my BC v18 shows no results for the…
-
Why does BC (on prem) have multiple SQL tables where NAV had one?
We have like 5 Sales_Invoice_Line_fsdfdws8. 250GB DB, maybe split up for performance, dunno. It makes SQL queries impossible, and I want to use SQL queries because I need reports over multiple different software and databases, servers. That is because we have basically 2 different ERP solutions for different subsidiaries.…
-
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…
-
Business central AL using Rendering for report layout
Hi Mibuso's, I'm using the new rendering possibilities in BC for the layout, but, I cannot select them through code. If I create a selection in a MenuItem, how to select the desired layout as it's in a [Report Layout List] Table and not as a custom layout in [Report Layout Selection] Thankx a lot for you help BR, Chris
-
Create New Server Instance and New Web Instance in BC On Prem 27
Hi All.. I want to create 2 Server Instances and 2 Web Server Instances pointing to the same database. some using windows, some using navuserpassword. 1st Windows was created from installation so i need to create 1 more for navuserpassword. created successfully… and already used cert thumbprint using self signed…
-
Codeunit.run vs TryFunction to record errors and contine
Hi All I'm trying to find when one is better than the other base on use cases. For example I want create job queue to release sales orders, if one of the SO fail to release , record the error on a error log table and continue. Here i'm committing after each sales order. Is there a difference if I use TryFunction like below…
-
How can I use two Media fields in a dynamic way to use on a Brick?
I have a record A with a Media field: "Specific Image". Then I also have a Media-flowfield, refering to some master data: "Master Image". Whenever I display this record A as a tile, I want to use Master Image to be used on my Brick, unless I have uploaded a Specific Image. Then I want to show that.
-
Purchase Return Order Line Insert Issue: falls into a loop
If “Tax Area Code” is mentioned, even if there is 0 tax, when user tries to insert a purchase return line (strangely the issue only starts at 4th line), the underlying code starts from OnNewRecord Trigger, then after some time control goes to OnAfterGetCurrentRecord, here code attempts to modify existing purchase lines in…
-
Hitting from Postman API to nav 2013 r2 service order
need help, recently I have been working on a service order where I'm facing 500 error when trying to hit through postman to nav 2013 r2. Note: Service order contains select job types with mapping fields based on general job category and job type. The error you can see also has the same content in JOB TYPE MASTER Body of…
-
SUPER user facing Permission Issue
Hi All, I am (SUPER user) getting the error message -"Sorry, the current permissions prevented the action. (TableData 79 Company Information Modify:" while attempting to update the company Badge using code below in Business Central SaaS. Please help me to solve this issue. Thanks, Navuser1
-
Dynamics NAV 2018 web client suspending connection to server.
I have an issue with Dynamics NAV 2018 web client. Its loading the role center page, but while clicking on any page or anything its giving error as "The connection to the server was suspended." Have the same issue in multiple servers. Dynamics NAV 2018 CU23 version installed. SQL server 2016 Express Already tried with…
-
BC25 Onprem -Cannot Create Company
Hi Just installed BC25 OnPrem and Cronus Working without any issue. Went to create a new company and getting an Error like this OnPrem SQL2019 Standard Server has previous versions and running without any issues. Is this a new requirement? Added SQL Server Full-Text Search feature in SQL Server Installation and tried again…
-
Dynamics 365 Field service Integration Failure
Hi, Anyone else had this issue where the solution deployment fails due to dependecies missing in field service including: msdyn_DataInsightsAndAnalyticsForFS I don't see that as an app available for install on power platform ? BC SAAS 26.4 , Latest FS app on PP. Thanks
-
Wrong Server in BC140 when adding new component.
Hello, I have to add the development environment on the local machine of a single user of one of our customers. When moving through the setup, I recognized that the wrong server is chosen (the customer partially shares infrastructure with another customer in a consolidation). The Servercomputername cannot be edited, so I…
-
[Solved] Open Page 42 with double-klick -> Filter disappears.
Hello, I'm currently having the following problem with one of our customers: If I set a filter for the orders on overview page 9305 (e.g., on the document numbers) and double-click the card for the order I'm currently on, the filter (filter group 0) is deleted. However, if I open the order using the View or Edit button,…
-
Tenant Media
Dear, I have an issue wrt datbase size. After 1 year of implementation, one of the database size has increased to 405gb, reason is the major change is size of tenant media table. What is suppose is that attachments of documents & auto email attachments are getting saved in db. I am thinking correct, if yes, how cani…
-
Wave 2 BC installation error
Dear Friends, I am facing problems when I tried to install 365 BC Wave 2 with Server //Microsoft Dynamics 365 Business Central Server Components Fatal error during installation. The service 'Microsoft Dynamics 365 Business Central Server [BC150]' (MicrosoftDynamicsNavServer$BC150) failed to start. This can be caused by one…
-
Excel Export Issue
Hi All, for context am using Microsoft Dynamics NAV 2017 am currently diagnosing an issue with one machine that fails to export an item ledger entry to excel here is the basic issue when we try to export few lines to excel it exports with no issues as soon as the lines grows to be a lot it fails with an error message "The…
-
NAV 2013 Permissons
Hi All, I am currently examining the mess that is the Permission Sets on NAV 2013. Is there a tool that I can use to list of the Pages/Tables/Reports etc that my users are using on a daily basis to help create more restrictive permission sets. There has to be an easily method than going through object by object? I…
-
Set language on web services
Hi experts, This is regarding Business Central cloud. When our users use Business Central, everything is in Danish due to the personal user setup. We have a specifik "user" that is used to connect from a C# program using web services. That user does also have the "da-DK" (Danish) language set on the personal user setup in…
-
Common ?? (seemingly no answer) - The request was aborted: Could not create SSL/TLS secure channel
Hello, I have searched the forum for this topic and found many threads that all ultimately end with no resolution. We have a legacy NAV2013 install that is being replaced by another ERP at some point soon :( I have written a REST API call in this NAV2013 instance to call FedEx to get shipping rates. The FedEx call requires…
-
GST TDS on Purchase in indian localisation
Please help me check if the GST TDS is not deducted in Business Central
-
BC v25 Synchronization between Online Main Site and Offline Remote Sites
Hi Fiends, I’m looking for a technical solution to synchronize two Business Central on-premises instances: Main site: Full BC installation with all master data Remote site: Local BC used for CMMS and inventory, with an unstable VSAT connection Requirements: One-way sync: Send master data (e.g., items) from the main site to…
-
BC Upgrade from v14 to v22
Hi All, I am doing BC upgrade on premise v14 to v22. but during this step Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15 AU\Applications\System Application\Source\Microsoft_System Application.app" Publish-NAVApp -ServerInstance BC220-Development -Path "C:\ACN Folder\BC220 CU 15…
-
Chart of Accounts Debit amount and G/L Entry debit amounts not matched
Hi Fiends, We are using Business central v18 onpremises. One particular date and some G/L Accounts in chart of accounts Debit Amounts, Credit Amounts, Net change showing higher values compare to G/L Entries. If I drilldown those column it is showing someother value from GL Entry. I gave only specific date filter in…
-
Accessing NAV in RTC but no Companies
Hi Guys Trying to add NAV on a new PC so backed up SQL database and restored okay on new PC. Dev Environment okay, setup in MS Dynamics NAV Server and running okay. When add new link in RTC - excepts okay but no companies indicated? Any body seen anything like this! With thanks Big_D
-
Report on a JobQueue sais execute is ok but when i check the changes it didnt do anyting
Hi im new here, I have 2 environment of nav 2017, one for development (in our servers) and one for production(in Azure). I develop a report that check records on a table, if they have Status = Awaiting it grab the record, block warehouse entry and insert the rec in it, go back to the table and change status Awaiting to…
-
Bulk Email Batch Size and Interval sugestions
Hi All I'm trying to create a codeunit send emails to all customers 2000 , what is the ideal batch size and interval in sec i can try? So Instead of sending all at once I can break into say batch of 30-100 and set a delay between. Anyoine who has played with settings like this. Using MS 0365 email.
-
How to transfer custom field from service order , service line (items) to Warehouse Entry Table
Hi All I'm trying to figure out a way to transfer custom fields from service line table to warehouse entry table. any ideas or events i can look at? Thanks