-
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…
-
How to filter a lookup in a worksheet page
Hi everyone. I'm very new to c/al coding and am struggling to set a filter on a lookup in a worksheet page. The lookup field is 'account no.' from the gen. journal line table. The table itself has a filter on this field which populates the lookup according to the entry in 'account type' and if type is 'Customer' all…
-
Activate Microsoft funding for your migrations
Simplanova has been acknowledged by Microsoft and recently announced as the latest ISV Development Center. Being ISV Development Center enables Simplanova and its ISVs to join the FY23 ISV Investment program. Under this FY ISV Investment program, Simplanova can help you refine existing solutions or co-create new solutions…
-
How to move a file between two SFTP directories In Business central Online?
How to move a file between two SFTP directories In Business Central Online? I have tried to move a single file to the SFTP directory but is transferring all the files to another directory. Can anyone help with this? Thanks in advance.
-
Persistent User Sessions even after restarting the service
Hi, We have noticed that some of the sessions are left idle on the session list from many days ago and we cannot manually stop them (we have a mod to stop them from sessions page, using the STOPSESSION command). It normally works but for some particular sessions it just won't work. Even worse, they'll stay even after…
-
Replication issue
Dear experts: I got this error message when i ran the job to replicate items from store 1 (HO) to store 2 (branch) "Cannot forward to host ******* Data Director License has reached the max limit [SubNets:1] and cannot send the data to the host. Contact your LS Retail Partner to get updated License file" What does this…