-
Technical Guidelines: Code Analysis Tools (CodeCop, UICop, AppSourceCop, PerTenantExtensionCop)
I would like to share a useful blog post for developers about Code Analysis tools: CodeCop, UICop, AppSourceCop, PerTenantExtensionCop. You will find here some tips on how to make your solution more readable and clean as well as some tricks on how to modify some rules, make them more or less important, and in such a way…
-
WebHook for BC Onpremise
Hi all... I have question about webhook. I am using BC on premise version 18. and integrate to 1 of e-commerce. the scenario is if any changes / update from customer in this e-commerce, it will update to BC Customer master. any advise how do we use this webhook from BC? Thanks.
-
How to apply entries between 2 GL accounts on the CoA
Hello, I am currently on a Business Central version 19.1 w1. I want to know if its possible to apply entry between two GL accounts. I am unable to spot this functionality. Is there a limitation? I have seen that this is available on the French and Belgium localisation. Can you please help? Thanks
-
Webservice can not return response when calling from CRM
Hi All, We are using BC 16 Onprem and published a soap webservice which is consumed in CRM to push sales order data. sometimes it does not return response from BC to CRM in few cases and prompt below error in CRM. have anyone faced this issue before?
-
Add Cash Flow Chart to NAV Client
I'm trying to add the Cash Flow Chart that is available already in the Accounting Manager Profile to the Staff Accounting Profile When I went to the Staff Accountant Profile -> Customize ->Customize this page, and I added the chart in there, for some reason the chart keeps loading as the screenshot below and it doesn't…
-
Currency Error
Hi Folks, There is no problem in cases where there is invoice and then payment, but when the payment and then the invoice are received and these two transactions are applied to each other, that is, when the application is made, there is a problem in the G/L Entry records and the realized loss or gain account line. This…
-
website certificate of mibuso.com seems to be expired
The cert of mibuso.com seems to be expiered. My WEB- Brower warns me for the expired certificate.
-
Notes with Notify deprecated in Business Central ?
Does anybody know why I cannot see anymore in Notes, Notify field in Busiess Central ? It was deprecated ? Can it be replicated in the BC as it is in navision ? And if that is not possible can someone tell me what it was replaced with? Thank you.
-
Problem running Web Client - NAV 2016
Since updating to CU64 this client has had issues running Web Client. They see different behavior depending on where the browser is run. Obviously these are not the real server names. Running from "mywebserver" (where IIS is installed): Using: https://mywebserver.mydomain.com/NAVService/WebClient/?company=My Company FAILS…
-
1099 report for year ending 12/31/2021 for NAV2016
Hi all, As formal support for NAV2016 has ended, Microsoft has said it will not be issuing 1099 updates for NAV2016. I'm wondering if it's possible to "downgrade" the version from NAV2016? I'm fairly certain that the database hasn't changed, but I do know that the 1099 report layout has significantly changed, and the 1099…
-
Warehouse Class Codes on Released Production Orders
I am currently using directed put away and pick for my location and have recently started testing transactions with warehouse class codes. While I can get the initial inbound flow to work (Purchase Order receipt and Put Away) with warehouse class codes, FYI you need a bin for receiving and storage that match the warehouse…
-
Is developing in a remote-container possible?
Following the Concept of developing inside a container https://code.visualstudio.com/docs/remote/containers i try to attach VSC to a BCxx Container that i've created with New-BcContainer. unfortunately i can't get it to work. if i click "Attach to running container" i'll get: [68 ms] Remote-Containers 0.209.6 in VS Code…
-
G/L Account lines add on sales line in Posted Sales Invoice
In NAV, fetch sales order from webshop in Microsoft dynamic NAV and posted right away by using standard codeunit 80.In posted sale invoice, G/L account type line will be created automatically. Please guide me about that how to overcome this problem.
-
Drag and drop functionality in NAV/BC
Hi all We have developed a function Drag&Drop on NAV standard fuctionality. You can find the code below: 1. On a page on the field choose attribute Control addin - WebPageViewer 2. This Control addin allows to display websites through the function SetContent. This function could have 2 parameters - HTML Code and Script on…
-
Word-Layout repeating DataItem OPNo_ProdOrderRtngLine - Report 99000762 Manufacturing Job Card
Hi all, I am trying to adjust the Word layout for report 99000762 to achieve a similar behaviour compared to the integrated RDLC layout: one page per production order routing line. Therefore I placed my report layout inside a 1x1 table with the following XML mapping:* 'OPNo_ProdOrderRtngLine' as a text-element inside the…
-
Dynamics 365 Business Central Email and Email Message
If you are interested, how to use the functionality of Dynamics 365 Business Central for sending emails, check Simplanova's latest blog post in which our developer Raimund reviews specific settings that enable additional functionality, such as adding attachments and recipients in a letter. Have a read here:…
-
Read Windows Registry from NAV2016 C/AL
Hi all, I'm trying to read a registry value in NAV2016. I've defined a DotNetVariable as ProcessFileName Microsoft.Win32.Registry.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' If I look in Regedit, I see a registry key I'm looking for. I exported it to a .reg file and here is the contents:…
-
I am retired, pleas remove or disable my account
Dear administrators, I am retired, please remove or disable my account. Regards, Rudolf Stammis.
-
Job market in Mexico
Hi, I might move to Mexico, how are job or freelance opportunities there in the NAV sector? I have to admit my spanish is more on a toddler level and this has to improve, obviously. But may be english is sufficient at first? Thanks!
-
The server failed to resume the transaction
Hi, A user is on NAV2017 and Microsoft SQL Server 2016 Enterprise Edition. The error log for the NAV Service tier contains various rows with the error message "The server failed to resume the transaction". Does anyone have experience with this error and experience regarding how to solve it? Thanks in advance for any help
-
How to use OData URL and consume it.
Hi everyone, I want to share data of shipment method table using OData. I made a page of shipment method table for this and added it to web services and got the URL. If I am accessing this OData URL then I am seeing table data in XML format on the browser. [Please check below] <?xml version="1.0" encoding="utf-8"?><feed…
-
How to access my BC Instance from different computer?
Hi all, Am new here and trust all is well with you, I have created a new VM(Window server 19) on Azure and I have installed Business central 18 on it and I configured IIS as well as AD DS, I tried to access my service through localhost/bc180 and it runs well. Now I want to access my services from other computers using URL…
-
Problem with delegation...
Hi, I have a three tier setup: BCWEB1 - Running the webclient. BCWEB2 - Running the webclient. BCSER - Running the BC service tier BCSQL - Running the SQL server. dom\ser_bc - Is the service account, running both the BC Service tier, and the application pool. BCWEB is the internal DNS name pointing to the internal Azure…
-
Media to text
Dear All good day. I'm on BC on cloud (accordingly I can't use any on-prem procedure) I have to convert a media file to text in order to push it on out API. local procedure MEDIAasTXT(): Text var DocumentAttachment: Record "Document Attachment"; MediaAsOutStream: OutStream; begin DocumentAttachment.SetRange("Table ID",…
-
BC 18+: Use implicit Drill Down behavior of Global-Records'-field in Page Field
Hi, I'm optimizing/cleaning up a page where there are two related records shown next to each other. One of the records is defined as the SourceTable, the other one is from a different table with a 1:1 relation. It is defined as a global variable which is retrieved in the OnAfterGetRecord-trigger with some conditional…
-
Approver cannot see record to approve upon clicking Open Record in Request to Approve page.
I created a workflow from scratch for Store Requisition. Everything works fine except that no entries are being created on table 454 ( Approval Entries). The Approver receives the request but cannot review the record. see attached screenshot.
-
Powershell Invoke-RestMethod to insert a new customer
Hi, I am trying to insert a new customer using PowerShell via Odata. #Create new Customer
$Credential = [System.Management.Automation.PSCredential]::new('USERNAME',(ConvertTo-SecureString 'PASSWORD' -AsPlainText -Force))
$Payload = "{ ""No"" : ""TEST10001"", ""Name"" : ""Test asdfgh"" }" $obj1 = Invoke-RestMethod ` -uri…
-
TableRelation with extensions
Hello, I have a problem with this table extension and I want to change it. This is the standar code of the table 1208 in field "Applies-to Entry No." TableRelation = "Cust. Ledger Entry" WHERE("Customer No." = FIELD("Customer No."), "Document Type" = FILTER(Invoice | "Finance Charge Memo" | Reminder | Bill), Open =…
-
QRCode support for BC Online
Hi, Barcode is supported natively in Dynamics BC 2021 wave 1 onwards. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-add-barcodes Question is, is QRcode supported in Dynamics BC online? Or It only works with using a 3rd party qr code generator service?
-
Upgrade Windows OS version NAvision 2009 R2 Application
Hello, My navision 2009 r2 application is installed on windows server 2008 R2, I would like to know if it's possible do direct upgrade to 2012 R2. I'm not telling create a new machine. Thank you.