-
Fixed Assets
Hi We have been left with an amount on a Fixed Asset below .01. Does anyone know of a way to clear off this final balance. This is in NAV2017
-
Can't populate user name on a report header
Hello! I have looked into this issue for a good time and can't seem to figure out what is going on, I'm hoping someone can shed some light. One of users is unable to show her user name on the header of the report. However, there are 2 of her team members that are showing correct, with a name. We have looked at permissions,…
-
Business Central- Update Listpart Page
Hi, can anyone tell me how can I update listPart page from another ListPart Page? for example, in Bank account reconciliation page there are two part pages, 'bank account statements' and 'bank acccount ledger entries', can i i update view on Bank account ledger entries part page from Bank account statement part page ? Is…
-
Webservice <Key> Tag
Hi, In NAV SOAP web service the Read method will return a Key value. E.g. For Chart of Accounts, the Key value returned is: <Key>20;DwAAAAJ7BDEAMAAwADA=7;52265190;</Key> Do you know how the value 52265190 is derived? Is this some sort of time stamp?
-
Non Business Central tables in BC database
Hi, Someone knows if having non BC tables in the database and use them via SQL stored procedure to save additional info can affect to the Business Central performance and locks? The scenario is that, just as there are tables like "dbo.CompanyName.Table," there are other tables created, such as info.OrderLog, and many of…
-
PDF Files Error (109) when opening in Adobe Acrobat Reader
Hi all, We have noticed that some of the PDFs generated by BC, that are attached in emails, won't open in Adobe's Acrobat Reader with the error "There was a problem reading this document (109)". They'll open fine in other applications such us Microsoft Edge. The scenario is sending email statements for customers in bulk.…
-
Outlook Integration - Prefers SaaS to OnPrem
Hi, Our config is completed according to Microsoft documentation. However, we have a SaaS Sandbox environment but using OnPrem for Production. We downloaded the outlook add-in files from the OnPrem installation and added them to Outlook. If you open it up, you can see everything is pointing to the OnPrem instance. However,…
-
Deploying Microsoft Dynamics Finance and Operations on Premise with minimal hardware requirements
We have a Microsoft Dynamics 365 on-premise with 7 server licenses, 5 full user licenses and 1 team license. Considering the usage of the system will not be that much, we were considering deploying on the following 1 AOS 1 Orchestrator 1 MSSQL Server 1 Reporting server Is the above possible as opposed to the…
-
Loading Posted Sales invoices to IC Outbox
Hello all, One of our users generated a sales invoice for an intercompany partner in Microsoft Business Central. However, due to the user’s restricted access to the other company, the invoice was successfully posted but is not showing up in the other company’s purchase invoices. Typically, I can locate such invoices from…
-
How to use SQLDataReader to Handle BLOB Fields in Business Central
Hi All, I'm wondering if anyone have any experience using SqlDataReader to handle Blob,RecordID fields. Specifically, I have Blob(images,pdf,excel) fields in SQL databases and need to import them into Business Central On-Premises. I did something like this but the files comes in BC corrupted. SqlBinaryValue :=…
-
Text lines "Multicurrency" on Statement
Hi I have seen some lines with the text "Multicurrency" on a statement i a NAV2013R2 client. The lines are not a part of the customer records. Where are the lines from?
-
Assist-Button not shown in Listpage
Hello, I have a somewhat strange problem with a newly created page. The page displays all lines of sales offers and sales blanket orders. The customer would like the map of the respective document to be called up when clicking on the document number. When I now open the page via the menu, the Assist button is not…
-
Include caption not working on report?
I am trying to "include caption" for a field on a Business Central report. I have added the property to the field in the dataset: The field has a caption in the table and it is translated: I have added it to the layout like this: But it just prints the raw text: Can anyone help?
-
Auto fit not happens(Excel) while scheduling the report through job queue
while generating a report using code unit- excel buffer through job queue , column auto fit and row merging feature of excel is not working, but the same is working once i tried to run the code unit manually , Is there is any provision to work the auto fit and merging in excel through job queue?
-
Custom Lines Page Show Open In Excel Top Right
Hi All I have created a customer subpage similar to the sales order lines. However I cannot see the option to Open In Excel on top right as below (option appears as a drop down on the left). How do you add a similar open in Excel function on custom page?
-
Issue with creating a new record when filters are set on a page - Business central
Hello, I have noticed a problem in Business Central in that when I want to insert a new record on the page, there is a "reload" and the first record is selected/highlighted instead of a new blank record in which I can put the new values. The problem appears in BC15 and higher when there is a filter set on the date type…
-
Data Integration Nav to Power BI
Can I configure Odata services to use real-time data? I need to see real-time data on a daily basis on the Power BI dashboard once I publish Nav data into Power BI.
-
Navision 2016 installation
Hi All, I have downloaded the demo version that was available on mibuso.com. When I click setup in the zip file, it pops up the message asking whether I should allow this to make changes in the system. But when I click yes, nothing opens to continue installation. Could someone help me figure out this?
-
Endpoint for "Item Charge Assignment"
Endpoint for "Item Charge Assignment" A requirement for an OData endpoint to fetch all the data of the "Item Charge assignment" table for integration with other software. Because the standard BC page does not return any data without the purchase or sales document context. Please see below the screenshots of calling the…
-
Opposite of UPPERLIMIT for CalcFormula?
Hello. I need to make a FlowField for G/L account, that sums up balance, but it needs to be filtered to 1 day before the date period in Date Filter. I know about existance of UPPERLIMIT, but could not find anything that could be used to get the "lower limit", and how do I even get 1 day before that date? Sorry if this is a…
-
NAV 2016 (9.0.50528.0) Docker
Greetings everyone, We are looking to migrate our NAV Servers and instances to on-prem Docker services, from my knowledge & research this doesn't seem possible, maybe I am wrong.. Does anyone have NAV v((9.0.50528.0)) running on Docker right now? If so can you please provide resources on how to accomplish this task.. Thank…
-
Can I determine the correct control add-in name for a third-party dll?
Hi - I have a third-party DotNet dll that I would like to deploy via the Control Add-ins table. However, we purchased this add-in, so I don't know what the internal "Name" property is. I assume that the Public Key Toek is the "PublicKeyToken" value on the variable definition in my codeunit:…
-
Incentive Co-op funds for BC migrations?
Simplanova invites Dynamics Partners to join our webinar: Incentive Co-op funds for BC migrations? What’s new in FY24 Event Agenda: -What’s new in Co-op Incentive program for FY24 - Cooperative Funds (Co-op) Overview - Co-op Planning - Co-op Management - Co-op Claiming Process and POE - Simplanova services under Co-op FY24…
-
Retired Dynamics NAV (and Business Central ) Courses
Hello, Does anyone know where to find retired video courses for Dynamics NAV 2017 and Business Central? Microsoft made them free to download for a while, but now there are nowhere to be found. Maybe someone downloaded and kept them. Here is the list of this videos retired, Thanks. NAV 2017 80949: Introduction to Dynamics…
-
Excel import container error.
Hello I got an error when trying to import Excel file. Its works fine when i run it from site. But on the container i got an error I tried reinstal the container, but it didn't help.
-
Import from Excel hide dialog Shipment Date <> workdate
Hi All I have tried below code to hide dialog when importing Sales Order lines but it's not working SalesLine.Init(); SalesLine.validate("Document No.", SalesHeader."No."); NextLineNo := NextLineNo + 1000; SalesLine."Line No." := NextLineNo; SalesLine.SetHideValidationDialog(True); SalesLine.Validate("Shipment Date",…
-
How to become a member of AppSource/MarketPlace
Hi Out of curiosity, how do an individual freelance developer (with proper certifications and experience) become a member to get their own object id range and sell their apps on the market place? Couldn't find a clear guidance on this, please
-
Business Central: Sales order document date and warehouse shipment posting date
Most of the time the document date on a sales order is automatically changed to warehouse shipment posting date as soon as the latter is posted. But there are times it is not. As the document date is used for calculating due dates, we need it to be constantly following the warehouse shipment posting date. Does anyone know…
-
cannot have any leading or trailing spaces
We are getting the following error for a couple of extensions, I was wondering if we will delete the space in that field, doesn't that change the ID for that field along with their records and data? Table/RecurringBillingLines.Table.al (53,18) - Error AL0770: The identifier '"Recurring Billing "' cannot have any leading or…
-
How do I translate from Danish using xlf files in Business Central cloud?
Hi experts. I have my own app in Business Central cloud. All captions etc. are written in Danish. Now the customer tell us that some users are going to use English and some are going to use Danish on the GUI. I guess that Business Central expect my app to be in en-US. Is that correct? Can I somehow set up my app to be in…