-
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…
-
Report Extension - Modify existing column
Trying to sort the correct syntax for modifying the properties of an existing column thru a report extension. Can this be done thru a report extension?
-
OData web service endpoint with OAuth2
In a BC Cloud demo environment, I'm trying to call an OData web service using OAuth2 bearer token. It's working when calling a service based on a standard BC page, but not when calling a service based on a page added in an extension. I'm able to get the token. Like I said, the OData call works fine if it's for a standard…
-
Sales order using Codeunit
Hi I am new to Navision, how to create sales order with multiple line through the codeunit? (item 1000 to 1001) I would like to create sales order with two items through codeunit. help me Thanks.
-
How to reclass items which are trapped in "In Transit" location
Dear Mibuso Forum, I have been facing for the items which are trapped in "In Transit" location. We have got report from our client, that they found their Transfer Order Receipt was gone. After some checkings, we found that Transfer Order was deleted already, Transfer Shipment was posted first, it affected those items were…
-
Mixed language issue NAV2018 CU38 / CU47
Hello everyone, We recently upgraded to NAV2018 (CU38) from NAV2016. On nav2018 we now have this issue with the system text being in "mixed translation" between english and danish (our language). By system text I mean messages/errors that occur when you for example call: Record.GET('something'); and no record were found or…
-
We have to upgrade Microsoft Dynamics BC13 to BC14.
Dear folks, Please help with this upgradation BC13 to BC14 If you have any document relevant to this process please share it would be very helpful for me
-
Is there any option to import data from html to nav xmlport ?
Hi All, I am new to Navision. I know how to import data from Xml to Xmlport but how to import data from html file to Xmlport ? Please Let me know Thanks, Rajan