-
scrap weight calaculations
how to calculate the particular scrap weight of items in subform and update the header level for example in item table i craeted a scrap filed data type boolean when click true items only calculate in the line level i choose 3 items line level scrap weight so three items calculate and update the header also give me…
-
QR Code Generation and Save to Blob Field
Business Central On Prem - Latest Could some one help to create a QR code and save it to a blob or image field? Later to display it on a page as an image? In reports, they say it is easy use a 2D font. but, here want to create and save internally.
-
Find Functions in navision
What is diff b/w FindFirst & Find ('-'),and Findlast & Find('+') Give me the example and if you will have any reference give me
-
Delete a file on ftp server with use of .net
Hi Can someone tell me how to delete a file on ftp server using .net. FTPUpload (Working fine) FileRec.SETRANGE(Path,FTPSetup."Path to Files"); FileRec.SETRANGE("Is a file",TRUE); IF FileRec.FINDSET THEN REPEAT FTPWebRequest := FTPWebRequest.Create(FTPSetup."FTP Server" + FTPSetup."Path on FTP Server" +…
-
Report with Images
I have a report that has a maximum of 3 pages. The report must display either 2 images or only 1 image on page 2. I added a rectangle and assigned the two images there. Only one image should be displayed on page 3. But now the images should only be displayed if there is an entry in the corresponding image path. And…
-
Restrict back dating and future date when selecting calendar date
I have a date field which the user will select from the calendar dropdown, now I want only the current date to be selected, future date and backdating should not be allowed. I am using NAV 2018.
-
Hi, I have a column in my report which is not in the dataitem/table, but I want it to filter.
Hi, I have a column/field in my report which is not in the dataitem/table but I want users to be able to filter for records in the table based on the value in my field. The values in my field are gotten onaftergetrecord. Any help?
-
how to rearrange substring within the string ..
String : played5year9Postponed1be4UAE7IPL2in6will3this8 Task : Every word has sequence no. at end of the word in string. Following these no. arrange this string as a proper sentence using string function as below : final correct string : Postponed IPL will be played in UAE this year.
-
Join the webinar: SALT Demo and Partner migration experience from Xitec
Join the demonstration of how simple C/AL code to AL conversion can be with automated Simplanova AL Tools (SALT), and hear from Xitec (NL) how they apply SALT in their add-on upgrade from C/AL to AL. During the webinar, you will also learn that SALT will be available for download on Visual Studio Code Marketplace. Register…
-
Permission to execute XML port
I'm trying to use XML port in code unit for web services. But, once I call code unit, web service returns below error even I can execute the XML port manually. I followed tutorial https://www.kauffmann.nl/2011/01/15/how-to-use-xmlports-in-web-services-1/. Why I'm getting the error and how can I fix the issue? Thank you.…
-
Prevent user triggered changes via Table Subscriber
Hi, I am trying to prevent user triggered changes to a Vendor table. Changes done indirectly is allowed e.g. Changes done via C/AL MODIFY, INSERT or DELETE statements are allowed. I am looking at the triggers for the Vendor table, but I cannot find any suitable events. The most suitable I can find is to use the…
-
Copy Document pattern
How Do I Implement the Copy Document pattern any reference plz tell me
-
report bilder
Hello, I have MS Dynamics NAV version W1 10.0, I would like you to point me to an application with which I can edit the layout of the reports. Thanks.
-
Item and unit of measure Tracking In Navision
Hi All, I am new to Nav, I am trying to track the item changes using events but while tracking it makes multiple records/rows against single item creation process. I have attached the screenshots. if anyone know, help me. Thanks. Rajan.
-
Half year rule for fixed asset additions
Hello, I have several fixed asset cards where I need to record additions monthly. I need the additions to follow the half year convention/rule, while the original book value of the asset depreciates normally. Does anyone know how I can make this work? The half year rule works during the first year of the fixed asset card,…
-
Add column to temp dataitem using report extension
Need to add Location Code to Sales Shipment report but the Sales Shipment Line is temp dataitem, is there a way to add the column using report extension?
-
Page list too slow
I've converted to BC19 an old nav2015 DB. In this there is a page list that shows linked table with 20 million record. In RTC page load after 1 minute. In BC19 the page never loads. The loading icon remains and after 15 minutes show timeout message Why this difference? There is a way to solve?
-
help for a barcode font
i have to do a report with a barcode in format pdf 412, where i can find this font free?? thank you
-
Why does a team member's licence not allow a user to create purchase orders via sales orders?
What is the proper user licence for users?
-
Convert C/AL code to events in AL
This video demonstrates how SALT converts standard object changes to events in AL, in an add-on upgrade project. SALT is a tool platform that supports you throughout your full Business Central C/AL code to AL conversion. SALT automatically applies many of the fixes you would normally search for and apply manually, provides…
-
VAT Statement - credit memo
I want to have the value but only considering the entries of credit memos of a certain VAT, business group, etc.
-
One or more return document lines were not copied. This is because quantities on the posted documen
Hi, how to reverse a transaction for this? Thank you.
-
Error message currency : The request was aborted: Could not create SSL/TLS secure channel.
Hello Error : Microsoft Dynamics NAV A call to System.Xml.XmlDocument.Load failed with this message: The request was aborted: Could not create SSL/TLS secure channel.OK No problem to access with Explorer to https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml but error when I try to update with NAS or Update…
-
NAV 2009 RTC Export to Excel not working occasionally
Hi there everyone! I have a user who uses CTRL+E to export sales orders to excel and this works normally but every so often this stops working. When attempting to export the blue busy circle is appearing briefly but it isn't opening excel or anything. I've attempted exporting the same order on my machine and it works…
-
D365 Business Central v 20.5, company hub
page Company Hub, how the requests to approve column is updated? users have requests to approve but the column is not updated, displays 0 instead of the number of request to be approved by the user. Additionally, can you please let me know what is the filters that the company hub uses for the field Vendors - Payment on…
-
Unusual behavior calling external web service NAV2013
Hi all, I've written some functions to call a provider's web service from NAV2013 and process the response. Thanks to great examples found here on Mibuso, it all works... for the most part. Here is where it gets weird. The first time I run either of the two functions I created after a NAV service restart, it always fails.…
-
Trying to set up a codeunit to consume External REST API
Hi! I'm trying to learn a bit about APIs but not getting very far. Can anyone help me? I had a browse for some APIs I could mess around with and decided to use this one as it seemed to have a lot of documentation. Free Public football API. I'm struggling to get my code to work with it however. Currently I am only trying to…
-
MSXML.XMLHTTPRequest Replacement
Hi, to challenge an update from NAV to BC I have to refactor the code, because some of the libaries doesn't exist anymore: MSXML.DOMDocumentClass.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' MSXML.XMLHTTPRequest.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral,…
-
The server has rejected the client credentials
Hi all, In a SOAP web service we get sometimes the error 'The server has rejected the client credentials'. If we get this error we must restart the instance. After restart everything is working fine again. In the eventviewer we don't see any warning or error when this error occurs. Does someone have a suggestion for me?…
-
GetRangeMax and GetRangeMin
Can you explain the Both Function give me the examples and where should I sue this two function while develop the code what is the use of this two