-
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…
-
How to Create SQL Query for this scenario ?
I want to Purchase date against posted sales invoice item. Let me explain in brief. 1> First I am open "Posted Sales Invoice" Table & take one Invoice. 2> now open this invoice and from line you have to select one item & navigate to "ILE". 3> now the task is to find purchase date of particular item for this item. Problem…
-
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…
-
Calculate distance from post codes
Hi, I need to know how to calculate a distance between two postal codes (location table and sales shipment header-ShiptoCity) and know the distance and put it in a field of a custom table. How can I do? In case if I were to use a webservice, how do I implement it on nav? For nav 2018 Thanks so much
-
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…
-
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:…