-
Excel Nav Add-in exciting sheets on new server
We are in test phase of moving a NAV 2017 to a new server. We are going from on prem AD to Azure ad. Customer has like 50 sheets with various BI like reporting made with the Excel Nav Add-in. We have the add-in on working new server. But the old sheets does not work. Is there any way of making the old sheets working?
-
Object License in Dynamics BC OnLine/OnPrem
Hi, In classic NAV (version NAV2018 and below), you would need to purchase objects if you use them in customisations. Is this still required for Dynamics BC Online or OnPrem?
-
BC 18 - Microsoft.Dynamics.Nav.Runtime.NavHttpContent variable not initialised.
Hi all, I am using On Prem BC 18 I have called API to BigCommerce... testing from my local is ok, no issue. I got this error message from production server. any idea what's wrong with my extension? thanks.
-
[solved]Use Default Synchronization Setup - Sorry, we just updated this page
Hi all, I have an issue with the BC-CRM integration through the dataverse. When I try to set the Default integration settings on the Integration Table Mappings I get the error "Sorry, we just updated this page. Reopen and try again.". Has anyone else got this error? The version is BC 19.3.34541.34662. I do have some…
-
Item Tracking in Business Central
Items are assigned Lot number and expiry dates when items are shipped, but on the receipt side either the Batch number or expiry date or both do not show. what could be the problem ?
-
Character XMLPort in soap UI
Hello: I don't understand why I get weird characters in soapUI when I mount a webservice with an xmlport. The definition is correct And the xmlport is simply the webservice works in SoapUi and Postman even though it has the characters, but the provider can't get it to work because of the characters. Any ideas?
-
Will stock adjustment function in Business central affect blocked items ?
If stock adjustment function is run in Business central, will the adjustment affect items which are blocked ?
-
Reading event in .NET from event in BC
Hello, To give some context regarding my issue. I currently have a codeunit set up with an event subscriber which looks out for the OnAfterInsertEvent event for a specific table. This is because I want to extract the newly added data I added to my specified table. I also set up a web service on C# from the codeunit…
-
Do we have a solution to integrate business central with Amazon Web Services S3 (AWS S3)?
Hello, We want to import the files from Amazon Web Services S3 (AWS S3) and export the files generated from business central (BC) to AWS S3. We found no references on the web on how to integrate business central with Amazon Web Services in perspective of AL coding, rather we found "No code integration". Some pointers in…
-
Modify Notes FactBox
How do you set the Notify field to TRUE once the user creates a new note? Thank you in advance.
-
Unable to Finish Production Orders
Hello, I'm having problems Finishing Production Orders. Let's say, for example, the Quantity is 30, the Finished Quantity is 0 and the Outstanding Quantity is 30. When i go to Change Production Order Status (99000914) and set the Output Quantity to 30, the boolean Finished to YES and then press Register, it says it…
-
[solved] Print and Send to Excel produces an empty sheet.
Hi there, an employee of one of our customers has the following problem: If he sends data from an overview to Excel by Print and Send, Excel opens, but the sheet remains empty, no error message, nothing. The addin for Navision in Excel is disabled, and that's the way it should be. When exporting to word it works. Does this…
-
[SOLVED]Could not find server AAA in Sys.Server - Linked Servers View - XACT_ABORT option
Hi all, We are facing an issue with a NAV(NAV2015) set up that has some views connected to Linked Server: after having migrated the databases of the linked server to a new server, there is one particular process that errors when we try to update data from the linked server, making reference to the old linked server.…
-
Unable to process table changes
Dear Sir, We're not able to compile any object in NAV 2016 Database while working remotely. Suppose NAV SERVER & SQL SERVER are installed in a Machine Called 'PC1' & we are trying to modify & compile its object from a Client Computer. The following error is popped up from the machine. The Firewall/Anti Virus application…
-
Is there any way to update Global Variables from subpages ?
Hello In BC14 is there any way to access and update global variables from subpages ? I know about UpdatePropagation but I don't think is what I need. I also read about protected var but this feature it's available for newer versions. In order to see global variables values on pagepart I have created a global function and…
-
I have a problem configuring the export of excel from business central
I have a problem configuring the export of excel from business central Here is the error message that appears
-
upgrade from nav2015 to bc19
hello NAV experts, I have just upgraded a client but got two issues with permissions - some did not get transferred across, not sure how this is even possible and when then importing them via rapidstart (xml did not work) got the following error - "The field Object ID of table Permissions contain a value xxx that cannot be…
-
SETRANGE not fetching values
SETRANGE is not fetching values. My code is as below. JobQueEntry.SETRANGE(ID, '{1938299-7788}'); JobQueEntry.SETRANGE("Parameter String",'%1','PostItem'); JobQueEntry.SETRANGE("Object ID to Run",70099); IF JobQueEntry.FIND('-') THEN BEGIN
-
BC DotNet file/directory functions - access denied
Hello, i am using BC OnPrem 18 (Cronus database) for testing. At this time, i want to translate some file/directory code from NAV2013 to BC180 and got "access denied" errors. C/AL: I can search all directories with dotnet „mscorelib“ functions without any problems. AL: I can only search local but no external directories. I…
-
The field 'Inventory' cannot be located. Removing fields is not allowed.
Trying to add a field in Transfer Order Subform that shows the "Remaining Quantity" from "Item Ledger Entry". Filtered by Open=true, Displaying the correct "Item No." and "Location Code" filtered by "Transfer-to Code". This is my "Transfer Line" table extension:tableextension 50100 "TransferLineExt" extends "Transfer Line"…
-
Sync Document Attachment from Company A to Company B
Hi All , how do we sync Document Attachment from Company A to Company B? let's say i have attachment in customer card. then this customer, i want to sync to another company. Customer table no issue. but document attachment has issue FromDocumentAttachment.reset;
FromDocumentAttachment.Setrange(FromDocumentAttachment."Table…
-
BC Custom connector with Oauth2.0. Authentication issues
We created an API connector to a PowerApp which works fine, but after some time (ccouple of hours) an error appears saying that the connection needs to be repaired which makes us relog in with the user for the connector. This is a problem because not all users have the account for the connector. We have tried giving…
-
BAS Calculation Sheet Import sample xml
Does anyone use BAS Calculation sheet or anyone has sample xml file for BAS calculation sheet?
-
Txt2AL Conversion Tool
Hey y'all, I must be mind blown, but just a quick one to be completely sure: Is Txt2AL Conversion Tool so sofisticated to automatically create Extension objects (TableExtension, PageExtension...) of customized standard objects on it`s own (and NOT working with delta files) or is it purely converting txt -> al and all the…
-
Upgrading to bus central
What are the best arguments you use when trying to persuade existing old version nav using companies to upgrade to Bus Central.
-
Depreciation calculation
My customer calculated depreciation for 31.12.21, then decided to revaluate their fixed asset book values on 31.12.21 by entering an appreciation record. now they want to calculate another depreciation for the same fixed assets for the same date expecting the system to calculate depreciation for the new book value, but it…
-
Application Errors
I've searched the forum but couldn't find a clear answer, so I'm writing this comment. 'even though “application method” field is set as “apply to oldest” in customer and vendor cards, payment and invoice transactions dont automatically apply to each other.' i am getting error. What could be the source of this problem and…
-
Can't see serial numbers at invoice screen
Purchased the product, whose serial number we tracked, into stock. We transferred to another location. Then we want to make sales from that location. However, it does not appear among the available serial numbers in the item tracking section of the sales invoice section. When we examine it from Ledger Entry, there is no…
-
How do we convert long datetime (text) to become date?
Hi All, how do we convert long datetime from json file to become date in BC? example : "Wed, 20 Oct 2021 03:26:25 +0000" Thanks.
-
Application Errors
I've searched the forum but couldn't find a clear answer, so I'm writing this comment. 'even though “application method” field is set as “apply to oldest” in customer and vendor cards, payment and invoice transactions dont automatically apply to each other.' i am getting error. What could be the source of this problem and…