-
G/L Account lines add on sales line in Posted Sales Invoice
In NAV, fetch sales order from webshop in Microsoft dynamic NAV and posted right away by using standard codeunit 80.In posted sale invoice, G/L account type line will be created automatically. Please guide me about that how to overcome this problem.
-
How do I "Post & Print" to a printer and not to PDF in Business Central (19)
As the title states, how the heck do I in the general journal "Post & Print" to a printer, and not to a PDF file? I feel like I've looked everywhere, - I just can't find the answer. Best regards Marcus
-
Automatic Reservation after Undo Sales Shipment
Hello everyone, The scenario is a Service Order with a reservation automatically placed for 5 units of the item XYZ (Reserve=Always). 5 units are shipped, and then the shipment is undone. Advance Warehousing is in use. Is it possible to automatically restore the original reservation after the Service Order has been shipped…
-
NAV Web Services - SOAP Envelope Parameters
Hi, I'm calling a Web Service from within NAV as follows: XMLHttp.open('POST',WSURL + TargetCompany + PublishedObjectPath,0, WSAccount,WSPassword);XMLHttp.setRequestHeader('Content-Type', 'text/xml;…
-
Export Notes From NAV 2015 and Import To Business Central Online?
I am trying to export all the customer Notes from NAV 2015 to BC Online. I have developed an XMLPort to export the notes from "Record Link" table. For the Field "Note" of type BLOB i am reading the data into BigText using streams. The Export part is successfull and i have a file containing all the customer Notes. But now…
-
Cannot generate SSPI context State ID: HY000 - Sometimes only some users on terminal server
Hi We started this month to get this error when opening the NAV RTC: [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context State ID: HY000 I've seen https://www.sauravdhyani.com/2012/04/navision-cannot-generate-sspi-context.html But the host file fix does not seems to do anything for us. I then found, it may be a…
-
Is there any way to debug a BC 19 upgrade?
I am currently stuck in an update from BC14 to BC19 with an error saying ModuleName : Base Application af Microsoft WorkflowStep : OnUpgrade ExtensionName : Base Application ExtensionId : 437dbf0e-84ff-417a-965d-ed2bb9650972 ExtensionVersion : 19.0.29894.30693 ExecutionSourceId : 437dbf0e-84ff-417a-965d-ed2bb9650972…
-
Dataport - Item & Item Ledger Entry
I want to create a dataport to EXPORT all item ledger entries for only ITEMS that have a quantity on hand of > 0. So if the Item has 0 qty on hand, then I don't want any of the ledger entries exported. Any ideas?
-
Drag and drop functionality in NAV/BC
Hi all We have developed a function Drag&Drop on NAV standard fuctionality. You can find the code below: 1. On a page on the field choose attribute Control addin - WebPageViewer 2. This Control addin allows to display websites through the function SetContent. This function could have 2 parameters - HTML Code and Script on…
-
Report must be initialized.
For report 7391, there is a code on OnPreDataItem as follows I was wondering how is that correct! As the user will always get this error since it's on OnPreDataItem. Does anyone know the reason behind such a code and why it's there? As I'm trying to run the report but I'm getting that error all the time(obviously)
-
Word-Layout repeating DataItem OPNo_ProdOrderRtngLine - Report 99000762 Manufacturing Job Card
Hi all, I am trying to adjust the Word layout for report 99000762 to achieve a similar behaviour compared to the integrated RDLC layout: one page per production order routing line. Therefore I placed my report layout inside a 1x1 table with the following XML mapping:* 'OPNo_ProdOrderRtngLine' as a text-element inside the…
-
Order my Record Set on a FlowField
Hello everyone, I'm desperating ! I have a table with a field which is a FlowField. I declare a temp table (Record temporary) where I put some records from this table. Now I need to order my temp table on the base of this flowfield. No way to do this with Setcurrentkey or ascending :/ Who can help ? Thank you a lot Stefano
-
Wordlayout Mini Sales Header - Alignment of Decimal Fields
I've encountered a strange thing, when looking at the standard Mini Sales Header Reports of NAV 2016 (reports 1304,...,1307, 1316). For example in the word layout of report 1304 "Mini Sales - Quote", the columns Quantity_Line, VATPct_Line, etc. all appear right aligned, when printed, but in the word layout itself, I cannot…
-
Security protocol TLS 1.2 in Dynamics NAV 2013
Hi out there! I am trying to increase a web requests security protocol in order to access a web service which is requiring TLS 1.2. My default SSL is not accepted. The request is send from Dynamics NAV 2013 (7.00). I have of course searched for a solution to this problem elsewhere. One single line should be enough:…
-
Pass XML into function
Hi, i have an xml file that i import manually into the system using an xmlport. I then want to convert this whole xml file to text and pass the text to a function. Can someone tell me how i can do this please?
-
Dynamics 365 Business Central Email and Email Message
If you are interested, how to use the functionality of Dynamics 365 Business Central for sending emails, check Simplanova's latest blog post in which our developer Raimund reviews specific settings that enable additional functionality, such as adding attachments and recipients in a letter. Have a read here:…
-
Compare objects in two databases
I need to get BC140TEST updated to current data but am not certain if the objects currently match between PROD and TEST. I can't afford to delete the BC140TEST company until I know for sure. Can anyone please let me know how could I validate the two to allow for a data update into BC140TEST? I'm assuming there is a faster…
-
Find which tableextension a field belongs to
I have done a page that has system table Fields as source. It is very useful since you can filter on all the tables/fields and see data types, captions and so on. However, I'm missing a new important feature. I would like to know which table extension a field belongs to. Are there any system tables that I can use for this?
-
Read Windows Registry from NAV2016 C/AL
Hi all, I'm trying to read a registry value in NAV2016. I've defined a DotNetVariable as ProcessFileName Microsoft.Win32.Registry.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' If I look in Regedit, I see a registry key I'm looking for. I exported it to a .reg file and here is the contents:…
-
Closing inventory period - item has entries in this period that have not been adjusted
Hi All, Wondering if you can help ? We have a customer that is currently not able to close their inventory period on a regular basis because of the error above - it seems that the affected item isn't updating when running the adjust cost routine and we have been getting around this by removing the tick on the cost is…
-
How to add a Shortcut Dimension to a table/page
Hi, I'm a NAV Developer, and I'm using NAV 2018. Does anyone know how to add a Shortcut Dimension 4 Code to a table and to a page? Thank you!
-
I am retired, pleas remove or disable my account
Dear administrators, I am retired, please remove or disable my account. Regards, Rudolf Stammis.
-
Preview posting when using "Post batch"
Hi all, Is there a way to use the "Preview posting" functionality on multiple documents (purchase orders in my case) at the same time? I'm looking for a solution to do some kind of bulk check before actually launching Post batch, so all posting errors can be handled before posting any of the orders. Thanks for your answers!
-
Job market in Mexico
Hi, I might move to Mexico, how are job or freelance opportunities there in the NAV sector? I have to admit my spanish is more on a toddler level and this has to improve, obviously. But may be english is sufficient at first? Thanks!
-
LinkedInTransaction deprecated in BC19
I'm migrating some tables from BC14 (C / AL) version to BC19. These tables are external to the DB and have property "LinkedObject" = true. According with Microsoft in these cases LinkedInTransaction property is set to false: Now compiler show a warning because this property is deprecated and in future became an error. So…
-
Unable debugging Business Central 19 onprem
I'm trying to debug my BC19 installation but when I try I get the following error in VSCODE: Error: In the server event log I find the following error: My server configuration: Can anyone help me?
-
Guidelines for Partners: GIT with VS Code
In previous technical blog posts, we wrote about managing AL code with Git and VS Code. Within them, we recommended a tool called GitExtensions, for performing most Git actions. Since then, the amount of Git features and their availability has increased within VS Code. It is possible to perform most of Git actions without…
-
The server failed to resume the transaction
Hi, A user is on NAV2017 and Microsoft SQL Server 2016 Enterprise Edition. The error log for the NAV Service tier contains various rows with the error message "The server failed to resume the transaction". Does anyone have experience with this error and experience regarding how to solve it? Thanks in advance for any help
-
How to use OData URL and consume it.
Hi everyone, I want to share data of shipment method table using OData. I made a page of shipment method table for this and added it to web services and got the URL. If I am accessing this OData URL then I am seeing table data in XML format on the browser. [Please check below] <?xml version="1.0" encoding="utf-8"?><feed…
-
RDL or RDLC for Business Central development?
Hello all, Which type of file is recommended if you have to create an RDLC layout for a report or report extension in Business Central? RDLC or RDL? Or perhaps it does not matter? I prefer RDLC because I can use Visual Studio for faster development and a better experience, also standard reports use .rdlc files. But if you…