-
Webinar: How to Install Dynamics 365 Business Central Development Environment using Docker
If you ever considered deepening your knowledge on Docker, don’t wait up – attend our webinar on how to install Dynamics 365 Business Central Development Environment using Docker. Webinar Time and date: Wednesday, 15th of April, 04:00 PM CEST. Find more info and register here ->…
-
BC Web Client using IP Address redirect to login page again
Dear Friends I am configuring Dynamics BC Web Client, accessing web client using localhost working fine. But if i use ip address (local ip address), system shows login page, after key in credentials and click Sign In, system will show the login page again. We are using 'NavUserPassword' credential. Please help to suggest.…
-
It's possible to publish an Odata webservice with json complex structure on Nav 2013 R2?
I wanted to share a structure with elements, for example sales documents with lines. I tried do a page with subpart element but with not sucess. I only obtain headers. { "odata.metadata": "http://server:port/bd/OData/$metadata#Sales", "value": [ { "Document_Type": "Invoice", "No": "VTFR012000001", "Sell_to_Customer_No":…
-
TXT2AL Tool: How to Convert C/Side Solution to AL
Developer Justinas is sharing some knowledge on how to use TXT2AL tool to convert C/Side Solution to AL. Find a full blog post here ➡️ https://simplanova.com/blog/txt2al-tool/
-
The New Life with an App-based ERP of Dynamics 365 Business Central
In this new blog post, Stefano Demiliani discusses how Dynamics 365 Business Central has extremely changed the partner’s habits in creating and distributing their ERP solutions. Interested? Find the full article here: http://bit.ly/3b6SCf3
-
Lookup XmlPorts Objects
There is someone who knows if I can lookup the xmlports objects in C/AL code ? Basically what I want to have is a field on a page which lookup the entire list of xmlport objects and offer me the possibility to select one. If you know, please help me. Thank you :smile:
-
Dynamics 365 Business Central Wave 1: New Features Review
Since Dynamics community is waiting for Dynamics 365 Business Central Wave 1 release, Simplanova's technical team prepared a short review of features, that could be real game-changers 😎. Go and have a read of what to expect in April: bit.ly/2QgHBQE
-
Attention, Austrians, Intrastat will stop working... about now
That's because in the Austrian and only that versions of the Intrastat export there is: IF PeriodYear < 20 THEN Period4 := '20' + Period ELSE Period4 := '19' + Period; Makes no sense and the fix is obvious (it should be always 20), just saying as the deadline for submitting the January Intrastat is upon us, every customer…
-
Everything you need to know before Add-on to Extensions upgrade
Considering upgrading the Dynamics 365 BC Add-on to Extensions? We prepared a free checklist with everything you need to know before an upgrade. Please find the download link here: http://bit.ly/335zL1j
-
Remove chars from a string to get only the numbers
Last night i must from a string eleminate all chars (like 'Ak;%') that are not a number (like 7 2 3 5 0). I was to lazy to solved this with a "loop" (for i = 1 to strlen(TextVariable)). So i taked a look into the systemvariables of type sting. I know that delchr() is very powerful. So the solution was very easy: a ->…
-
How to Use Standard Test Libraries
Hi All Developing AL Extension in BC130 on-prem I've imported the following from Dynamics.365.BC.33838.NA.DVD\TestToolKit and downloaded symbols* CALTestRunner * CALTestCodeunits.US * CALTestLibraries.US I'm trying to create a customer in one of my test codeunits: local procedure CreateCustomer(var Customer: record…
-
AL DevOps, Docker and 3rd Party Add-ins
Hi All Just watched this: https://www.youtube.com/watch?v=iVLOerdCuwA and it seems very interesting. I've got docker up and running with standard MS docker repos. However, we use BC130 on-prem with a major add-in ($1.8K per user) that is written in C/AL (won't be AL extension until v16). This add-in adds 500+ tables and…
-
Passing Filter Criteria to proc
Hi All New to Nav and AL code and working on first extensions. It's all working, but now I'm factorizing my code I have a case statement that repeats this code and want to factorize it SalesLine.SETRANGE("Document Type", rec."Document Type"); SalesLine.SETRANGE("Document No.", rec."No."); SalesLine.SETRANGE(Type,…
-
Event Sequence - update field on modify and insert
Hi All Finalizing my first extension and stuck on one thing. For certain shipping methods we have to add a freight line (non inventory item) and calc freight as percent of total order value. The percent is a unit price for each customer (e.g. 0.1 = 10%) and we put the order total in qty, so if Order is $1000, freight is…
-
How to pass constant of LineType::Item to a proc
Hi All Writing an AL extension and need to call a proc that finds all sales lines of Type "Item", How do I pass the constant "Item". I'm calling from a subscription on a Sales Header, so i can pass rec."Document Type" for the Doc Type, but can't figure out how to pass LineType of Item Can someone point me in the right…
-
Open specific page in RTC client
Hi All My dev instance doesn't have web client enabled (on-prem bc130) How can I open 9510 Event Subscriptions Thanks Mark
-
How to Debug in VSCode in BC130 on Prem
Hi All I'm using BC130 and RTC on prem. Here's my launch.json { "version": "0.2.0", "configurations": [ { "type": "al", "request": "launch", "name": "Dev", "server": "http://10.10.0.24:13069", "serverInstance": "Dev", "authentication": "Windows", "startupObjectId": 22, "startupObjectType": "Page", "breakOnError": true,…
-
Inserting Sales Line - Poulete item desc, special price, etc
Hi All Creating my first extension. One of the functions is to add a line item for freight based on the ship method. When I'm using the UI, I select line type "Item" and enter item No 'FLOC' (for example). when I tab out of that field it will lookup the item desc, , posting groups, customer special pricing. this is my…
-
How to get sales price per Customer and Item
Hello, I'm wondering if somebody could help me with CAL code for getting Sales Price with discounts per a specific Customer and Item. Thanks
-
CSV Buffer encoding trick
So I am reading some Amazon files with the CSV Buffer and I keep seeing strange characters in Spanish or French names. Hm. Thought encoding problems are a thing of the past. I play with importing the file into Excel with the various encodings until it turns out the characters display best with UTF-8. Which is to be…
-
Business Central AL , disable Factobox Calculation
Hi all, everytime I Open a customer it's a pain it's very slow, I already disable facboxes but keep calculation those fields. exist any way to stop that calculation behind ? Thank you,
-
Tip: add "button" to Report Request Page
Make a text constant with the name of the "button". Add a new field to the Request Page. SourceExpression is this text constant. Name and Caption empty, as in '', empty string, two apostrophes. Write your code into the OnDrillDown trigger. It will make the SourceExpression appear much like a hyperlink, the user clicks it,…
-
Docker Pull NAV Version Question
Hi All, This used to work fine for versions 2018 and below. I go to Help --> About, and I get the Version no. and I can find the cumulative update no. and I can find out the docker manifest to pull. E.g. to pull NAV2018-CU8, the docker command would be --> New-NavContainer -accept_eula -containerName "NAV2018-CU8" -auth…
-
PATCH method
Hi! I have recently encountered a problem with PATCH call from C/AL. I have already tried a solution for AL, but it didn't work, here's my code:CASE RestMethod OF 'PATCH': BEGIN String := 'PATCH' //it's a DotNet String variable HttpRequestMessage.Content(HttpContent); //HttpContent contains JSON object which I sent…
-
Can we upgrade Microsoft Nav 2009 to Nav 2018. Need resource to help email vinodtakke@rediffmail.com
Can we upgrade Microsoft Nav 2009 to Nav 2018. Need resource to help email vinodtakke@rediffmail.com
-
Can you remove a shortcut function on nav2016 sales orders?
instead of the standard copy and paste function across most of nav2016 when in 'Sales Orders' ctrl+c is doing a copy document and ctrl+v is opening the 'edit' sales item history. Can these be removed so that the normal copy and paste works?
-
WaldoNavPad for Navision 2018 or 365BC
Hi there, is there the Version for WaldoNavPad for Navision 2018 or maybe 365BC? Regards Bogumil
-
How do I renumber "Dimension Value ID" field in Dimension Value table ( NAV 2017)
Hello, I entered some values in the Dimension Value Table. This created Dimension Value IDs since it is an autoincrement field. After discussing with our Accounting Manager, we decided to revise the Dimension Values since no data had been entered yet anyway. I deleted the dimension values and entered new ones. However, the…
-
Insert new lines
I need to insert new lines in order. The order line has a field called 'suborder code' and I need to insert a line per 'suborder code'. To achieve this I created a key in the order line table with (suborder code, line no). Then created a processing report. In the processing report, I added the order line table and add sort…
-
Join the webinar: Best practices on upgrading C/AL to Dynamics 365 Business Central Extensions
Interested in best practices on upgrading C/AL to Dynamics 365 Business Central Extensions? In this webinar, Simplanova Head of Sales Domas will share his insights on how to prepare for upgrading to Extensions. Save your spot by registering here: https://zoom.us/webinar/register/8215712910151/WN_VgP8U0IHQZCmCCy1fdHYew