-
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 ?
-
File Management limitations in SaaS using BlobStorages
One of the major limitations we face when upgrading to Business Central’s SaaS environment is the usage of our local or server’s file system. Quite often, various NAV or BC solutions use the file system to save files for archiving purposes or to be processed later by an automated job. There are multiple methods of…
-
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…
-
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…