-
CRM Integration, proxy tables, fields ids on the 10,000 range
Hi, In the context of an integration BC/CRM (BC20), we have used the altpgen tool to generate proxy tables and do the developments based on this. For example we have got the definition of the CRM account extension. We have been able to work and test deploying using Visual Studio Code. However, when we have tried to deploy…
-
scrap weight calaculations
how to calculate the particular scrap weight of items in subform and update the header level for example in item table i craeted a scrap filed data type boolean when click true items only calculate in the line level i choose 3 items line level scrap weight so three items calculate and update the header also give me…
-
Join the webinar: SALT Demo and Partner migration experience from Xitec
Join the demonstration of how simple C/AL code to AL conversion can be with automated Simplanova AL Tools (SALT), and hear from Xitec (NL) how they apply SALT in their add-on upgrade from C/AL to AL. During the webinar, you will also learn that SALT will be available for download on Visual Studio Code Marketplace. Register…
-
Why does a team member's licence not allow a user to create purchase orders via sales orders?
What is the proper user licence for users?
-
Convert C/AL code to events in AL
This video demonstrates how SALT converts standard object changes to events in AL, in an add-on upgrade project. SALT is a tool platform that supports you throughout your full Business Central C/AL code to AL conversion. SALT automatically applies many of the fixes you would normally search for and apply manually, provides…
-
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.
-
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…
-
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?…
-
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 configure manufacturing module in Dynamics D365 BC?
How to configure manufacturing module in Dynamics D365 BC?
-
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,
-
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…
-
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.…
-
How to debug in OIOUBL app from Microsoft?
Hi experts, This is regarding Business Central cloud with the Danish "OIOUBL" app from Microsoft installed. I have made an EventSubscriber like this: [EventSubscriber(ObjectType::Codeunit, Codeunit::"OIOUBL-Management", 'OnExportXMLFileOnBeforeBLOBExport', '', true, true)] local procedure…
-
Why does BC pick VAT Prod. Posting Group from GL Account Card for Prepayment Invoice?
If I am posting a Purchase Prepayment Invoice, and do not have a VAT Prod. Posting Group on my Advance to Supplier GL Account Card, I get no VAT Line in GL Entry during Prepayment Invoice Preview posting. Even the VAT Entry has a line with 0 VAT Amount. But if I have a VAT Prod. Posting Group in GL Account Card, I do get…
-
Notification test
Hi, Does anyone have experience with notification testing? I'm currently writing tests and while using handler (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/attributes/devenv-sendnotificationhandler-attribute) I manage to check if the notification message is what I assume, I can't test…
-
Approval Workflows - validation instead of just applying new value
Hello. I want to create Approval Workflow for Unit Price change on Sales Order lines. I got this using standard 'Revert the value of Unit Price field' and 'Apply the new values' responses from Workflows Templates. Unfortunately - it is just applying values without validation. After change Unit Prices approval requests is…
-
Error - The Posting Date doesnt lie in Tax Accounting Period
Validation Results - "The Posting Date doesnt lie in Tax Accounting Period" Any Clue on this error while creating Bank Receipt entry with TDS Section having Parameter "Calc Over & above Threshold" set to Yes Business Central Online - India
-
"Internet browser is not installed" error message BC13
Using Business Central 13 CU 6 users who have upgraded to windows 11 are now receiving the message "Internet browser is not installed" when attempting to open a document via the attachments fact box. I can see in NAV 2018 this was fixed as a platform update in cumulative update 48:…
-
Version 20 debugging, always breaking on UserPreference.modify
Since upgrading to version 20, every time I run the debugger from Visual Studio it breaks immediately on standard code in the Rolecenter Selector Mgt. codeunit, 1485, shown below procedure SetShowStateFromUserPreference(UserName: Code[50]; State: Boolean) var UserPreference: Record "User Preference"; begin if…
-
Danish letters in subject on e-mail using Lessor Payroll
Hi experts, I use Business Central version 13 on-prem. When I make a new codeunit and use codeunit "SMTP Mail" to send an e-mail, everything works fine. But when I use Lessor Payroll codeunit 6000802 to create an e-mail with the payslip using codeunit "SMTP Mail", then the "Subject" of the e-mail is changed from…
-
BC: Service tier generating alot of errors
Hi, In our environment, one of the service tier for our BC are generating alot of error messages in the event log. The following SQL error was unexpected:
Cannot insert the value NULL into column 'id', table 'Database.dbo.$ndo$cachesync'; column does not allow nulls. INSERT fails.
The statement has been terminated.
SQL…
-
How to create and send an email message in Business Central 20 using replaced
As you probably have noticed, the SMTP module was replaced by “Email – SMTP Connector” and “Email – SMTP API” apps in the Business Central 20 version and will cause an error if you use the standard SMTP module. Read the latest post on the Simplanova blog, where you will find possible SMTP mailing usages and learn how you…
-
This item ledger entry has already been revalued with calculate inventory function
Dear Experts, im facing issue in using revaluation journal that i want fix a cost for an item but its gave this error: “This item ledger entry has already been revalued with calculate inventory function, so you cannot use the Applies-to Entry field as that may change the valuation.” i there to fix the posted item ledger…
-
How to fix WordHelper Error
Hey ho, We export a Word document from a BLOB field in NAV2018 and open it with Word. This works fine on several client machines except one which throws an error regarding WordHelper. Office was uninstalled on the PC and then reinstalled. After that, opening the Word document worked for a short time until the error…
-
Workflow Events Predecessors not showing up in top of the workflow events and not showing up in bold
Hello, I am facing an issue in not displaying of Workflow Events Predecessors in top of the workflow events and not showing up in bold either.. We have designed the workflow as per the base General Journal Line Workflow. We have developed the functionality as per the Microsoft's standards. We have created and added -…
-
Missing column When "Send to" Excel
I added a new column to a report and that new column is showing properly when previewing the report as a PDF. On the other hand when I try to "Send to" Excel, the new column is missing as if it's not been added Any advice on why this could happen and how to resolve it? Version: US Business Central 19.2 (Platform…
-
Error: The request was aborted: Could not create SSL/TLS secure channel- In nav 2016
Hello Experts, Error Message: A call to System.Net.HttpWebRequest.GetResponse failed with this message: The request was aborted: Could not create SSL/TLS secure channel. I am facing this error while working on E-Invoicing integration.I have doubt in Security Protocol Type but used others also like…