-
User-defined views crashes client.
Hello, one of our customers has reported the following problem: An employee has created a user-defined view for pre-scheduling delivery notes, which are documents from which the actual delivery notes are created, refer to Table 36, the document type has been expanded here by an option. This view included filtering for a…
-
Copy Files to BC Docker images
Hi, I have created BC docker and it all works. How do I copy files from local host to docker? In this blog --> https://simplanova.com/blog/how-to-start-using-dynamics-365-business-central-docker/ there are detailed steps on how to do this. It says that I have to stop the container to copy files using "Docker CP" command.…
-
Dynamics BC Online Production environment Upload Extension Error
I face the error below when attempting to open "Extensions Page" in BC Online Production environment. What is curious is, I can open this same page in a SandBox environment. I just cannot do this in Production environment. And I am logged with the same user with the same permissions. Permissions assigned to the current…
-
Parameters in the cloud
Hi experts, In an old NAV, I have a solution where some code is added in the middle of codeunit 80, procedure PostItemJnlLine. The code must only be run sometimes. It is controllede by an extra parameter on the procedure. So depending on where PostItemJnlLine is called from, the extra parameter is set to true or false. How…
-
Adding parameter to Report 292 Copy Sales Document
Hello, I am facing the need to add some parameter to use it in events of codeunit 6620 CopyDocumentMgt I therefore made and extension of the report 292: requestpage { // Add changes to the requestpage here //DOC @001 27.06.22 sis.mk - layout { addlast(content) { field(WithTechData; WithTechData) { ApplicationArea = All;…
-
NAV 2017- Positive Pay Modifications
Hi. I need to modify the file output of one of the two "stock" positive pay definitions. In past versions I just edited the simple code that spit out the file. But in this version it's all wrapped in configuration stuff. I can't find any real documentation on the specifics of the field definitions - and I'm hoping I don't…
-
HTTPWebRequest error handling vs PS Invoke-WebRequest
Hi, In Powershell, if you use Invoke-WebRequest, and if there is an error, you will get the full error message. e.g. However, in NAV when I use HTTPWebRequest, I only get the error message: I tried using Codeunit 1297 to return the webexception, and tried all the properties in websexception, but I could still not get the…
-
SQL License Question
Sorry, forgive my ignorance. I could get this right in my mind. Customer will have 50 NAV2018 users in an On-Prem environment. One SQL2019 server on Windows 2022 server. Another separate Windows server 2022 for Navision Application Server. Only NAV accesses the SQL using a single windows domain user name. May be one or two…
-
Business Central - check internet connection
Hi, Is there any way to check if the Business Central OnPrem has access to the internet? Some method like IsNetworkAvailable():Boolean ?
-
US Sales Tax
I am asking for help from any members who are experts on US Sales tax. When you tick the Expense\Capitalise field in Tax Details, the system calculates tax, but posts it to the same account as the cost, but seems to stop creating tax entries? Is this correct? Is it because that by saying you are expensing it, you are in…
-
Database locks across instances (NAV 2017)
Hi! I would like to preventively observe and hold long table locks for analysis. In addition, I would like to consider an external monitoring solution in case processes lock tables for a long time. I can see from my own error log when a process is aborted due to a table lock. Then I would like to check for a certain time…
-
POS Hardware Profile
Dear Experts I recently set up a new store using Ls NVA/Dynamics Nav 2017, Now i am on the stage of adding the cash drawer and the MSR to my app (Ls Nav); could anyone help me and clearly explain to me how to do so from scratch? Thank you a lot.
-
Modify other line in form
Hi experts, In Business Central cloud, I would like the sales order to work this way: When entering a line, it automatically makes a new line below with another item number. That works fine. When the user change the Quantity field in the first line, it is also automatically updates the other line, it created automatically…
-
POS Hardware Issue
Dear Experts, I am using ls nav integrated with dynamics nav 2017 I did all setups for a new store, Now i face a problem with adding the cash drawer and MSR to the system (Ls Nav) how to do so?
-
HttpWebRequestMgt.AddBodyAsAsciiText is working HttpWebRequestMgt.AddBodyAsText not!
Hi All, I'm using HttpWebRequestMgt with a json body to call a rest api. It works when I add the body with function "AddBodyAsAsciiText", but i want to send some text in german and that is not working with special chars like ä ü ö. So i tried to use AddBodyAsText, so the text is utf-8 encoded. But then it's not working…
-
Upgrading Unmodified C/AL Application to Version 20
Dear All, I am sorry to say, when we come across Microsoft Technology, always complicated and confusing. when we want to upgrade from 14 to 20, it should be a simple method. everybody wants to learn Microsoft technology Will you check this error 1. When I run this command "Sync-NAVTenant -ServerInstance…
-
Run table to change data
How can i run a table directly (without a page) in order to change or insert data there? Used version is BC18 Thanks for all help Roger
-
POS Hardware Issue
Dear All, I am using ls nav integrated with dynamics nav 2017 I did all setups for a new store, Now i face a problem with adding the cash drawer and MSR to the system (Ls Nav) Plz, help how to do so?
-
problem about VAT while transaction in LS Retail-POS
Good evening, I have a problem about VAT while transaction in LS Retail-POS. When I want to starting create transaction by calling an item, an error message occur "invalid VAT setup on item" I have already check my VAT posting setup, but I found nothing wrong with the setting. Can any body help me please.. Thanks before…
-
How to split lines based on condition in Business Central Report
We have this packing list report that we need to put pallet no. Column. Per sales line. Ex. Is that if we have an item no. With 1000 qty, if this item has 200cases per pallet,the item needs to split into 5 lines with qty 200 cases and with pallet no. 1 to 5. This will repeat for all the sales lines given the no. Of cases…
-
SavesAS Function & File Management in Business Central On-Prem (ver16)
I am currently working on a Packing List report that needs to save as pdf automatically in a particular path in our server upon click of an action button in a Sales Order. I am new to development, I have tried following the saveaspdf method in the Microsoft website however when the action button was ticked now, an I/O…
-
Send XML file from Dynamics Nav 2013 R2 to external endpoint
Hi guys I need to export an XML file created by an xmlPort for an external endpoint. But I can't connect with an external service. It gives me an error "The underlying connection was closed: An unexpected error occurred on a receive." When I use Postman service don't have any problem to send. I don't have a password. Only…
-
The record in Item Ledger Entry already exists. Identification fields and Values: Entry No:......
Hi, i faced same issue in Business Central "on premise" version, i delete ILE and VE and G/L Entry records using SQL query because it was wrong. i know this the wrong procedure, when try to post the sales entries in open statements its gave the error in the pic. i restart the NAV and SQL services but still the error occusr…
-
Error when trying to post/receive a Transfer Order
We have a transfer order that has been fully shipped, upon trying to post and receive this it comes up with an error "lot No. is required for item ???" This line for the item specified in the error has a lot No. assigned, we cannot receive it due to this one line outstanding. Any Ideas what could be causing this?
-
How to put a RunningTotal in ERP Navision 2009 Report like Customer Transaction Detail Report?
Hi I am a Beginner here, we have a Customer Transaction Details Report in our ERP Navision 2009, which has Amount & Remaining Amount (LCY) Column. My Boss requested me to put another column for Running Total/Cumulative Sum for the Remaining Amount (LCY). Please, any advice how to put this? Thank you.
-
The value Entry already exists. Identification fields and values. Entry No. =
NAV 2016 W1 Build 46621 When posting Item Journal - Negative Adjustment, the system prompts an error "The value Entry already exists. Identification fields and values. Entry No. = 19" Upon checking Value Entries, the entry no. is already at 83, thus Entry No. 19 already exist. Then we checked the Item Ledger Entries, and…
-
Forex account
Hi. In navision Eg - if we book invoice of 100 $ and value of 1 $ equal to 70 RS so total invoice value is 7000lcy sales invoice And when we receive payment of 100 dollar and value of 1$ is Rs 71rs then total value is 7100lcy So dollar value value gets equal to customer account bt balance lcy of customer increase by 100 rs…
-
NAV2018 CU22 All Ribbon Buttons grey out for users after a few hours.
Hi Mibuso Hive Mind Got a customer on NAV2018 CU22. They are working fine for any where between 30 minutes and 3 hours before they suddenly find their ribbon greyed out. They simply close the RTC and load is back up again and repeat exactly what they had just done. Once the ribbon is greyed out, it's greyed out for all…
-
Business Central: Renewing OAuth Token
Hello all, I am facing the following problem: We have a web application (built with PHP and Symfony) that exchanges data with Business Central via SOAP web service. Since the SOAP web services are to be removed, we are currently converting the application to OAuth2 and (JSON) API calls. An app is also already registered in…
-
Clean Isolate Storage
Is there any way to clean the Isolate Storage? I know I can do: IsolateStorage.Delete(key), but what I want to do is delete ALL the keys, because there are millions and I do not know the keys and I want to clear them all. Thank you