-
Type Conversion In navision
Can You Explain Type Conversion in Navision how Convert the One data type to another data type give me the example Can you explain type conversion using string function if it is passible
-
what is Format Function And EVALUATE function
what is use of this function and how should I use this where it is I use this function give me the examples and give me reference links also if you have
-
Business Central - Project-Centric organisation setup
Hi, im trying to configure BC and i have an idea in my head how i would like it to work for my users, ii wondering if anybody could clarify if its possible to achieve what i want? * id like all new projects to have the same tasks. * id like the project manager to be able to allocate resource to the job (i know his can be…
-
How to subtract current value from previous value in a column
I have a column that i need to subtract a current value from the previous value and save the result on another column. The value is incrementing instead of decrementing. Here is the image of what i want to achieve This is my code:LastDailyReturn := 0;
TempFundPriceNew.RESET;
TempFundPriceNew.SETCURRENTKEY("Fund…
-
How to configure manufacturing module in Dynamics D365 BC?
How to configure manufacturing module in Dynamics D365 BC?
-
<SOLVED> Migration error in Microsoft Dynamics 365 Business Central Indian Version
I got this error while use below options(for migration) in Microsoft Dynamics 365 Business Central (IN) Version 14.0.47832 Tools>Sync. Schema For All Tables>Check Only
-
Inventory Valuation having quantities and values not in G/L
Greetings, I have a client running Business Central Spring 2019. The system is set up to run a batch job that updates Item Cost Entries and one that posts inventory cost to G/L in the night and these two are working fine. The issue I am facing is that the Inventory Valuation has items that have quantities and values that…
-
how to insert 6 months contract period data when click action
how to insert the data one table to another Customer have a 6 month Contract period when create the customer 1000 with 6 months contract that record should be save on contract list with 6 months records like jan,feb,march like until 6 month can you give me reference code if you any links also likes this Contract1…
-
Presentations of BC TechDays 2022
Presentations of BC TechDays 2022 Presentations of the BC TechDays 2022 conference of 15 & 16 September 2022 in Antwerp (Belgium) Thursday 15 September 2022 Troubleshooting Business Central SaaS environments (Kalman Beres, Nikolay Dobrev) Cloud Migration (Roman Sauber, Julia Lisovaya, Nikola Kukrika) ALM Accelerator for…
-
Nav.Integration.Office.Excel.ExcelHelper Replacement in BC
Hi, I have to make an update of a codeunit from NAV2017 to BC19. As there does not exist anymore the Excelhelper, I have replace some of these functions. Microsoft.Dynamics.Nav.Integration.Office.Excel.ExcelHelper.'Microsoft.Dynamics.Nav.Integration.Office, Version=10.0.0.0, Culture=neutral,…
-
Replace CONTEXTURL in BC19
Hi, due to the fact that the buildin function CONTEXTURL does not exist anymore, I hav to replace this function by other function. Has anybody a solution from where I get the same information like CONTEXTURL? best regards,
-
tenant id is mandatory ??
In sample projects sometimes i forgot give to give tenant id in launch.json it will came(I mean output BC Client), In other projects i gave tenant id ,that is also came? can anybody tell me what is effective way to do it with it or without it?
-
How to POST a JSON to an API
Hi experts, This is Business Central cloud. I'm trying to send a POST HttpRequestMessage to an API. The body of the message must contain a JSON object, that I have created. When I run the code, I get this error: {"type":"https://tools.ietf.org/html/rfc7231#section-6.5.13","title":"Unsupported Media…
-
VAT is being rounded up wrongly
I am baffled by this behavior of BC rounding up the VAT Amount. My BC has Local Currency setup as USD and VAT Rounding Type set to as Nearest; Here is my currency setup for AED; When I create a PO in AED with Total Value without VAT as 50, with 5% VAT 52.50; The VAT Prod. Posting V1 with VAT Bus. Posting is configured to…
-
How to export my JSON File in TEXT File & Save it on my desktop
We are working with NAV_BC14 using C/AL code. My Jason Code is as follow: **************************** //Create Json IF ISNULL(StringBuilder) THEN Initialize; SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type"::Order); SalesHeader.SETFILTER("No.",'2258634'); IF SalesHeader.FINDFIRST THEN…
-
pass by value and pass by reference
what is pass by value and pass by reference what is the use of this both diff b/w both and can you explain explicitly give me reference link of this also
-
Error while running the report in Trial Version of D365 F&O.
Dear All, I'm using trial version of D365 F&O, I can post all the transactions but cannot generate report. please help with the issue. Thanks in advance, Srinivas.
-
BC TechDays 2022 Video
My impressions of this year's conference: BC TechDays 2022
-
Consume external NAV SOAP webservices from SaaS BC
I am trying to consume a webservices in Business Central 14 (RTC C/AL) from Business central (BC19). I need to send an xml file from BC19 to BC14 to obtain checks and validation. So, I've a function in CU to do this:[External] ValidaXML_AIFM(VAR _XMLToValidate : Text;VAR _Error : Text) RetVal : Boolean IF NOT…
-
NST Services problem
Hi, got a new Job in the Developmend Field and have to look for the Dev-Server regarding Performance etc. On the Dev Serrver there are different NST's for different usage Configured. I've seen that they are using different amounts of memory. After rebooting the Server this will varying between 200MB and 2GB without any…
-
NAV CLient(s) using VPN
Hello Good day. Does anyone knows or have any idea on how to connect the NAV Client using VPN? currently we're using FORTiClient Thanks :)
-
upgrade Server version
Hello Guys. I need your help. I need to install my old navision server into a new Virtual machine , I've installed the Client and server. classic is working well but when I open RTC . I got this error. My question is , how can I upgrade de server version and where I get the upgrade.
-
Local characters in e-mail subject
Hi experts, I use Business Central version 13 on-prem. I have made a new codeunit that uses codeunit "SMTP Mail" to send an e-mail. It works fine (also with Danish characters in the e-mail subject and body). But if I add an attachment (a pdf-file), the Danish characters in the e-mail subject, is shown wrongly in Outlook.…
-
Business central standard application/system app code to protect a pdf-file with a password
Hello everyone, is there maybe a way to protect a pdf-file with a password in the business central application/system app? Or would be the only ways to implement this with azure functions or a control-addin? Best regards and thank you very much in advance
-
How to remove HTML tages without removing style
Hello am trining to add an add-in editor STyle to be the Notpade for the description fields on Sales Quote Page in Business central , so when i add this add-in the desciption was shwing with the html tags and i haven't experience on Javascript to correct this issue , so how can delete or replace moving this tags to not…
-
Setting password on pdf file OnCloud
Hey! I would like to set a password on pdf file (or just it's stream representation) in cloud ready solution; that means I don't want to use a DotNet. Ideally no Azure Functions either. Just a pure AL - is it even possible? Have any of you encountered such issue?
-
What’s new in Dynamics 365 BC version 2022 Wave 2
As the new version of Dynamics 365 Business Central is coming, Simplanova is organizing the webinar with Microsoft MVP for Business Applications – Stefano Demiliani, and encourages you to attend. During the webinar, you will hear detailed information about What’s new in Dynamics 365 Business Central version 2022 Wave 2.…
-
Nav 2018 Multiple Servers
Hi everyone, While I am not going to go into super specific details, is it normal for Nav to be ran across several servers? For example: You have a SQL Server named Server A, A Nav instance running on Server B, database -> Server A Another instance running on Server C, database -> Server A This might sound silly, but does…
-
Add or Subtract Days, Months, or Years using cueent month and year and date
how should I calculate current month to next months as per customer given For example I have Date Field "Start Date" customer given like this(01-01-2022) I have Contract Period Filed Customer should give In this field 06 Months contract period so That ending date automatically return should be like this with calculate…
-
I don't see automation dbOleWrapper.ocx in variable editor on Win10 x64 or Win Server 2019 x64
Hi. I need to use some automations methods in Classic Client. And some of them are params of type SAFEARRAY. So I downloaded here component "dbOleWrapper v 0.2". Then I copied dbolewrap.ocx to C:\Windows\SysWoW64\ and exec by admin:%SystemRoot%\SysWoW64\regsvr32 C:\Windows\SysWOW64\dbolewrap.ocx I recieved message that…