-
Records, RecordIDs, and RecordRefs OH MY!
Arg. Ok, I grew up on MS C/Side documentation examples like: Sally works in finance, and likes cats. Not all cats, just fluffy ones. Sally wants to know how often a customer has ordered a particular item. So she asks Todd in I.T., but he' been unable to overcome his breakup with Sally and is off sick from severe allergy…
-
How to send item picture to SOAP web service?
Hi experts, I need to create a SOAP web service codeunit that gets an item number and returns the picture that is on that item in Business Central cloud. (I think there can be more that one picture, but I only want to get the first picture.) I have made the procedure below on a codeunit, but it doesn't return anything.…
-
Delete Large amount of Records
Ladies and Gents, Due to some wrong functional setup and programming, one of our clients now has a table with 2bln lines which takes upto 2tb of storage. The table data is not being used anywhere anymore.....;) I have been trying to delete these through processing reports and codeunits, with deleteall. This does not work…
-
Notes with Notify deprecated in Business Central ?
Does anybody know why I cannot see anymore in Notes, Notify field in Busiess Central ? It was deprecated ? Can it be replicated in the BC as it is in navision ? And if that is not possible can someone tell me what it was replaced with? Thank you.
-
Problem running Web Client - NAV 2016
Since updating to CU64 this client has had issues running Web Client. They see different behavior depending on where the browser is run. Obviously these are not the real server names. Running from "mywebserver" (where IIS is installed): Using: https://mywebserver.mydomain.com/NAVService/WebClient/?company=My Company FAILS…
-
BC: PageExtension - placing the standard field from standard group to custom group
Hi All, How to properly move standard field to custom group? I am designing page as pageextension of standard page "Create Interaction". I know how to display custom fields on a page, but I just don't understand how to move standard field from standard group to new custom group that I placed on the page. placing the field:…
-
Upgrading Customized C/AL Application to Microsoft Base Application Version 19
I'm trying to upgrade from BC14 to BC19 following the directions in the Microsoft document. At task 11 step 4 (Synchronize the empty versions of system application, base application, and customization extensions that you published in Task 8) receive an error: I am sure I have performed the indicated steps correctly. What…
-
1099 report for year ending 12/31/2021 for NAV2016
Hi all, As formal support for NAV2016 has ended, Microsoft has said it will not be issuing 1099 updates for NAV2016. I'm wondering if it's possible to "downgrade" the version from NAV2016? I'm fairly certain that the database hasn't changed, but I do know that the 1099 report layout has significantly changed, and the 1099…
-
Not able to add Authorization: Basic in HttpWebRequest header Navision 2013
Hi Everyone, I am trying to get token using the POST method. I have created the same request in Postman and I am getting token there. in Nav, I am getting the below error Microsoft Dynamics NAVBreak On Error Message: A call to System.Net.HttpWebRequest.GetResponse failed with this message: The remote server returned an…
-
Char for sign Σ
Hello together, I would like to set the symbol Σ in a Code field. I tried with a char but i do not know which number i should use. Have someone a table where i can find the special characters? Thank you very much.
-
Block Jobs for Orders
Hello everyone, we are using NAV 2016 ; Vers. 9.0.47042.0 and have following problem: we would like to block a job (card 88 / table 167) in a way that any new order (Page 42 / Table 36) cannot be assigned to it. Blocking it didn't help. In the end it should work the same way as a blocked customer. As soon as somebody is…
-
Missing objects
In the live system, we are missing many menu items as shown below with EFT and others. Can anyone help me with what might happen and how to fix this? As all the needed objects are showing just find in TEST but not in PROD The following screenshot from Prod The following screenshot is from TEST I tried to update the…
-
How to change tax (VAT) amount on sales line from code (BC SaaS)
Hi Guys I have asked this question in another forum but haven't found a proper answer or why others haven't found this problem. When synching orders from web store like Amazon we need to change the tax amount per line to accommodate for rounding etc. And the statistics page where we do this in front end is a temp table.…
-
How to set Amount to Apply in Payment Allocation to invoice from code
Hi Guys I thought it's simple to allocate payments to invoices from code but after couple of days of trying I need help..:) Basically it works setting the Applied-To-Id and remaining amount , but always takes the remaining amount instead of the amount to apply This is my simple codeunitvar CustLedgEntry: Record "Cust.…
-
Problem in BC using my own DLL?
Hello guys, I am writing here, because we have one problem occurring whatever we try to do: The Problem: Cannot create an instance of the following .NET Framework object: assembly XXXX, Version=1.0.0.0, Culture=neutral, PublicKeyToken=97113f8bddac1f33, type XXXX.ClassA * It triggers in the function below I made my own .NET…
-
A DotNet variable has not been instantiated. System.Net.WebResponse.GetResponseStream
Hi, I have some code which I use to log API errors in NAV and it was working until yesterday. I have Googled this "instantiated" error and I read that I should call the constructor first but for the life of me I cannot understand what it means. So from what I understand, the GetResponseStream here is the method, which one…
-
Problem with Outlook integration
Hello, I have run into a problem regarding automatic send in Outlook. In a NAV 2017 installation the standard functionality for integration between NAV2017 and Outlook has been used so far, and with an earlier version of Outlook (Outlook 2010). Nav objects: Page 42 (Order), table 77 report selections, codeunit 260 (for…
-
Allocating permission to user and user groups
Hello everyone, kindly can anyone assist me, How can i restrict a user in Business central not to "Receive" or "Receive and Invoice" while posting a purchase order. I made a permission set and allocated that permission set to user in which i made "Insert Allowed" - Blank (NO) for "Purchase invoice header" and "Purchase…
-
Breakbulk and/or Source document Unit of Measure conversion
Hi all, Considering the following situation: - Base Unit of Measure for items is pieces - Other Units of Measure are "Master carton" and "Inner carton". For example: 8 pieces in "inner carton", 32 pieces in "master carton" (which actually is a box with 4 inner cartons) - Sales orders come from an external system and are…
-
RDLC group by - add rows dynamically
Hi All, I am changing standard report 111 - "Customer - Top 10 List" where I need to insert the customer contacts (Customer A has 3 contacts); those 3 contacts have to be displayed as the subset of second row (fields: [No_Customer], [No_Customer], [SalesLCY_Customer], [BalanceLCY_Customer]). I have inserted a group by…
-
NAV 2009 R2 - build 6.00.38655
Where can I find a download for Dynamics NAV 2009 R2 - 6.0 build 6.00.38655? I searched everywhere... Or maybe someone could help me to navigate it in partner source and customer source, because it seems I cannot find anything on that page.
-
Cumulative Update for Microsoft Dynamics NAV
Hello. While reading the CU updates I see ID number and small description of the issue. Is there a place to look for the detail of that issue? https://support.microsoft.com/en-us/topic/cumulative-update-50-for-microsoft-dynamics-nav-2017-build-30428-869d7d99-f6be-d8fb-abdc-75fa8fec7331 ID 356306 Reports with paper setup…
-
Is developing in a remote-container possible?
Following the Concept of developing inside a container https://code.visualstudio.com/docs/remote/containers i try to attach VSC to a BCxx Container that i've created with New-BcContainer. unfortunately i can't get it to work. if i click "Attach to running container" i'll get: [68 ms] Remote-Containers 0.209.6 in VS Code…
-
Consume API from BC use HTTP Client getting error, from Postman working fine
I have weird issue regarding BC consume XML API using HTTP Client. if i send a request from BC to API, i will get an error like below but if send a request using postman, working fine then i have tried to restart the server then the problem solved. here is the request headers, my code in BC, sample request and the response…
-
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
-
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…
-
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…