-
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…
-
Issue in passing a String from NAV to a DotNet Method
I was trying to pass a text variable txtStartDate from NAV2017 to a DotNet Method: SomeMethod(String StartDate) I found that when I pass a value directly to the DotNet Method like this (1) SomeMethod('2022-02-25T13:30:00') it behaves differently than when I pass (2) SomeMethod(txtStartDate) [although I have assigned…
-
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…
-
Item Ledger Entries - Cost Amount
I wish to import the Item Ledger Entry for an item in to Excel, using SQL and the SQL database as an External data source for Excel. When I do this the 'Cost Amount (actual)' does not pull through as it is not kept on the Item Ledger Entry table. Which table holds the financials that I can 'join' to the Item Ledger Entry…
-
Pegging Report
Is there a way to obtain a 'pegging' report for an item after MRP has been run? Nav 2009
-
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…
-
Do we have a solution to read the CSV file through XMLport even if the data is having comma(,) ?
Hi, I am facing issues while reading the CSV file through XMLport. Example: I am reading the Vendor's data from CSV file, "Address" field has value 10 North, Lake Avenue as there is a comma(,) after 10 North, CSV file treating it as a field separator and the Address field just holds the value till comma and the remaining…
-
Secure life in a Dynamics 365 Business Central tenant by Stefano Demiliani
New hot and really important topic – secure life in a Dynamics 365 Business Central tenant. Read Microsoft MVP for Business Applications Stefano Demiliani article on Simplanova blog: https://simplanova.com/blog/secure-life-in-a-dynamics-365-business-central-tenant/
-
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…
-
Cycle Count History
Hello All I am looking to assess our daily cycle count accuracy. As such I need to determine how many items / bins from each days count required an adjustment compared to those items / bin locations that did not require any adjustments. My question is how can I determine how many items did not require an adjustment? I am…
-
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…
-
SMTP Basic Authentication in Dynamics NAV 2018
Our software is built on the 2018 version of Dynamics NAV and it uses Microsoft Exchange and Office365's SMTP in order to send emails to customers. The issue that I've recently become aware of is that the only authentication option that we have for our Azure clients is Basic Authentication which will be discontinued later…
-
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…
-
Currency Error
There is no problem in cases where there is invoice and then payment, but when the payment and then the invoice are received and these two transactions are applied to each other, that is, when the application is made, there is a problem in the G/L Entry records and the realized loss or gain account line. This problem…
-
Problem with .NET XMLHTTPREQUEST
Hi everyone, i have a problem with this script to make an api call (Get) to the google maps web service. In this way it releases me a status other than 200. Through this script i would like the responce to be loaded in an xml witch i then pass to functions that decode and populate fields in the table. Thank you in advance,…
-
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.