-
VAT Statement - credit memo
I want to have the value but only considering the entries of credit memos of a certain VAT, business group, etc.
-
One or more return document lines were not copied. This is because quantities on the posted documen
Hi, how to reverse a transaction for this? Thank you.
-
Error message currency : The request was aborted: Could not create SSL/TLS secure channel.
Hello Error : Microsoft Dynamics NAV A call to System.Xml.XmlDocument.Load failed with this message: The request was aborted: Could not create SSL/TLS secure channel.OK No problem to access with Explorer to https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml but error when I try to update with NAS or Update…
-
NAV 2009 RTC Export to Excel not working occasionally
Hi there everyone! I have a user who uses CTRL+E to export sales orders to excel and this works normally but every so often this stops working. When attempting to export the blue busy circle is appearing briefly but it isn't opening excel or anything. I've attempted exporting the same order on my machine and it works…
-
D365 Business Central v 20.5, company hub
page Company Hub, how the requests to approve column is updated? users have requests to approve but the column is not updated, displays 0 instead of the number of request to be approved by the user. Additionally, can you please let me know what is the filters that the company hub uses for the field Vendors - Payment on…
-
Unusual behavior calling external web service NAV2013
Hi all, I've written some functions to call a provider's web service from NAV2013 and process the response. Thanks to great examples found here on Mibuso, it all works... for the most part. Here is where it gets weird. The first time I run either of the two functions I created after a NAV service restart, it always fails.…
-
Trying to set up a codeunit to consume External REST API
Hi! I'm trying to learn a bit about APIs but not getting very far. Can anyone help me? I had a browse for some APIs I could mess around with and decided to use this one as it seemed to have a lot of documentation. Free Public football API. I'm struggling to get my code to work with it however. Currently I am only trying to…
-
MSXML.XMLHTTPRequest Replacement
Hi, to challenge an update from NAV to BC I have to refactor the code, because some of the libaries doesn't exist anymore: MSXML.DOMDocumentClass.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' MSXML.XMLHTTPRequest.'Microsoft.MSXML, Version=8.0.0.0, Culture=neutral,…
-
The server has rejected the client credentials
Hi all, In a SOAP web service we get sometimes the error 'The server has rejected the client credentials'. If we get this error we must restart the instance. After restart everything is working fine again. In the eventviewer we don't see any warning or error when this error occurs. Does someone have a suggestion for me?…
-
GetRangeMax and GetRangeMin
Can you explain the Both Function give me the examples and where should I sue this two function while develop the code what is the use of this two
-
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…