-
Upload data from BC150 to SaaS
Good morning all. I am trying to upload my data from a BC150 to SaaS with all the tools that BC has. But I can not. I have some errors when trying to conect from SaaS to my local BBDD in SQL. By the look of things it is because of the server and DDBB. I use this format: SQLSERVERNAME\DATABASENAME and the diferent process…
-
How to Create Sales Lines in Test CodeUnit
Hi All We're and end user developing some of our own extensions, so we can't use the test tool or test libraries. I need to write tests that insert lines (which will update other items based on an event subscription) I got as far as opening the sales order in edit mode (hard-coding the sales order no for now), but I'm…
-
Blog Series Part 1: Customer Requirement for AL Development MSDYN365BC
Hi Reader, Lets take a deep dive into AL and consider customer requirement.We will develop the functionality using Vs Code as an Extension for Microsoft Dynamics 365 Business Central.Lets consider this example as this capture all object types. Pre-requisites Download Microsoft Dynamics Business Central (on-prem) or you…
-
FILE CREATE
I try to use "File.CREATE(FileName)" instruction in RTC but same code work in FORM not in page.. Why this?
-
Data synchronization with user feedback
Hello, On BC cloud I have to build a synchronization between companies. To keep it simple let's just say I have a Customer record that needs to be replicated in the other company that is triggered by an action "Sync". The tricky part is that this should tell the user whether it was successful or failed with an error…
-
Problem with printing large word documents
I have a problem with NAV 2018 and large word documents, build with it's own word layout. My customers wants to print about 5'000 pages from a report with word layout. The report runs a long time until the client crashes. There are only one small jpeg in the layout. Is it possible to print such large documents from NAV? Or…
-
Fail in running NAV BC on Prem & CRM on Prem integration
Hi all, Have an installation of Dyn CRM on Prem and BC 13 on Prem and I'm trying to configure the connection between the two of them to replicate data from one to the other. I'm configuring the D365 Connection Setup with user pass and everything goes through well, the standard table/field mappings are created, jobs are…
-
Does it make sense to create autotests as a customer?
Dear Experts, We have quite a module of customization, which runs on several databases in several countries. Same codebase, different setup. NAV2018 + AL Extensions How do I know whether it makes sense to create autotests? If yes, then should I use NAV TestTool, or maybe some other approaches like testing web-client using…
-
JSON file. Return to Webservice
I have a Webservice (Codeunit) that accepts a parameter of DocNo. A search of the Vendor Ledger Entries is carried out and if the External Document No. is found a JSON message is constructed. I can open the file in Notepad but do not seem to be able to send the values back to the Webservice. Any help would be appreciated.
-
XMLport update only
Hello, I am trying to set up an XMLport that works for updating values only and not inserting new records. Is this possible? I don't see an obvious option to limit it like this. Thank you, Tim
-
BC 15 webclient how to overview Report Dataset
When we had the RTC client we could get the Dataset for the report from Print Preview page -> About this report Who knows how to get the Report Dataset on Webclient when we don't have RTC anymore?
-
How to add a 'Invoice No' in Report
Hi All, I want to add the 'Invoice no.' in Customer/Item statistics report(report id - 10048). Please help me with this... Thanks in Advance, Jacob.A
-
How to delete the Purchase order while posting a invoice from Purchase invoice screen
Hi All, While posting the invoice from the purchase order, the purchase order gets deleted when the order is completely invoiced. It's a standard functionality. But in my case, I have created a purchase order(X) with lines and I received(post-receive) all the quantities. Then I went to Purchase Invoice screen and get the…
-
Can CUs with Event Subscribers on high traffic tables causing high memory usage at NST?
Hi guys, as in the topic asked: Is it possible that one CU with many Event Subscribers on high traffic tables (like Sales Line, Item Ledger Entry) causing a high memory usage on NST? We noticed that we have one little process which do the following: On every change on the table (insert/modify), write a little log to…
-
Replace Text "Additional Fee" on (Issued) Reminders
Hi there, when creating reminders, there's an option to add additional fees per reminder level. The line that is being created for the Additional Fee (G/L Account line) has a standard text: "Additional Fee" (if i remember correctly). Is it possible to amend that standard text to be something like "Reminder fee"? I know…
-
Wave 2 Upgrade from BC Spring - Obsolete tables
Hi all Same as Ahmed described in an other post, I'm trying to upgrade a BC14 Cronus database to BC15. https://forum.mibuso.com/discussion/comment/329584#Comment_329584 I'm faced with a slightly different problem than him though. In my case I'm upgrading from BC14 CU6 to BC15 CU4 I have followed the upgrade guide all the…
-
Filter for Currencies in Currency Exchange Rate Service
hi, is there a way to run the Currency Exchange Rate Service for one Currency only please? I don't want to update all the currencies in the Currency table, just one :) thanks!
-
How to export the data of a single client to xml
Hi guys, I'm new to the world of dynamics nav and I want to export the data of a single client in xml. I am studying with the 2015 version. Looking at the documentation there is an example code to export the clients to an xml file, but it exports all the clients. CustXmlFile.CREATE(TEMPORARYPATH + 'Customer.xml');…
-
How to use API in NAV2018?
Hi, I want to use the ZPL Web Service (RESTful API) in NAV2018. My aim is to send a ZPL-Code and get back a png. I tried diffrent ways, but failed. I Always get diffrent Error-Messages. To post them would make no sense... I tried it with two funktions. First (using Codeunit 1297) Second Using DotNet (but it is almost the…
-
How to import the data through xmlport when received from Webservice?
I called external web service and when a response was received, I saved the XML file. Now I want to import the data from that XML file into the table. But with the XML file structure I am unable to import Please let me know how the XML structure will look like? What properties needed to set? Or will these type of files…
-
NAV Performance - JetBrains DotTrace
Has anyone worked with JetBrains DotTrace to analyse the performance of CAL Code. I believe it was used in this Techdays Session (Example 1h13m) Thanks for your help.
-
Item template 'pop'
We want to use item templates, but not for number series. After the user selects NEW (item), we first need them to select the number series before an item template. We'd have too many templates if we did one for every number series/template combination. Is there a way to supress the template prompt without a modification?…
-
Problem with height of Part in a List page
Hello I have a page like this : A Page with PageType = List, containing a group of 3 fields and a repeater and at the end a part page (PageType = ListPart) the part page has to show lines that refer to the record selected in the list page Problem is that this part page has a height problem like here in this picture :…
-
(RESOLVED) How to call NAV SOAP Web Service from NAV (C/AL)
Is there any working method how to call NAV SOAP Webservice (published codeunit) from another NAV using C/AL (using codeunit 1290)? Even with 'contentType' and 'soapAction' modifications I can't pass method parameters - getting 'parameter ... is null' error.
-
Business Central - Bank Statement Import - MT940
Hi, Dutch Local functionality says that it supports MT940 Bank Statement Import But when I look at NAV/BC, there is no setup for it. Am I missing something? How can I import MT940 format? Thanks
-
Rounding on Item Attribute of type Decimal
Hello. I hope some can help me with this question about Item Attributes and the weird rounding of attribute type Decimal. For starters, we are using Dynamics NAV 2017. I created an Item attribute of type Decimal. Then I added it to an Item and entered value 1000. I closed the Attributes window and reopened it, and the…
-
How to know which table extends a TableExtension
Howdy. Good morning. I need a piece of code to know a tableextension which table extends. I have code for OnPremise with the table "NAV App Object Metadata" but in SaaS this table is not allowed. Does anyone know how can I achieve this for an App type Extension, not Internal? Thank you in advance.
-
AL Coding to Change Role Center.
Hi Experts, Is it possible to use AL coding to change the role center? Thanks.
-
NAV can't create invoices and cash receipts
Good day, We have the job queue that creates invoices and cash receipt for customers once receiving payments from the online payment system. This has been working perfectly but now it is not working though the job queue seems to be running but the automated invoices and receipts creation ends up with an error; The value of…
-
Sub-contracting produce one to many items
Dear All, Is it possible in sub contracting process to produce one to Many items. BOM- A output = B & C This is requirement of clinet send the A item to sub con location for consumption and receive B & C ( output) product from usage of component A.