-
Permission for Schema Synchronization (NAV 2017)
What permissions do I need to being able to sync tables from the development environment. * In NAV I am SUPER. * On the SQL Server I have the sysadmin server role * I am db_owner of the NAV Database * This is a single tenant installation, i.e. tenant Default with application and data in the same database I…
-
BC 21 import multiple xmlport with dynamic filesnames
Hi We have written a codeunit to import via xmlports that have been defined. RequestPage is set to false, and and initial FileName is specified in the properties of the XMLPorts. The codeunit reads the import folder and imports the files, one at a time. Our problem is that although we have set the FileName on the OnInitXML…
-
Can I take backup of user personalization?
User Personalization
-
NAV webclient: Force auth by parameter
Hi All, Is there any way to keep windows auth for everyone but prompt for login for some users by giving some parameter to the URL? This way we can share a login with minimum credentials and NAV will prompt users to type login. Thanks.…
-
How to import sales orders from excel in navision?
Hi All, I am new to navision , can anyone please tell me How to import sales orders from excel in navision? Thanks, Rajan123
-
You do not have the following permissions on TableData Vendor Ledger Entry: Modify
After doing a Technical Upgrade from NAV 2013 to NAV 2018 I get the following error when trying to apply a payment to a Payment Journal: You do not have the following permissions on TableData Vendor Ledger Entry: Modify
-
Send pdf report from nav to api
Hi experts, The task is to create a web service that creates a report as a pdf file and returns the file. This must be done in NAV 2015. I have made a web service that saves the wanted report as pdf in a blob field in the table "Temp Blob". How do I return the blob field to the api? Best regards, Morten
-
Service Tier Administration Tool v3.4.0
Service Tier Administration Tool A free Service Tier Administration Tool. All functionalities are working on LOCAL and REMOTE machines when you have the administration rights to that machine. Installing, Uninstalling, Start, Stop, Restart and dynamic change of settings like Portsharing, Account, start mode and settings in…
-
Business Central Copy Link Option in Share Menu on Pages
Hi, on the copy link option in share menu on pages is there a way to add or modify the fields that you see on the Hypertext? For example, if you share the link from a sales order card the hypertext contains the number of the order and the name of the customer, if you share the link from a item card it doesn't even include…
-
Copy User field from posted purchase invoice line(123) to G/L Entry(17) table
Hi All I have user field on the purchase order line that carries to posted purchase invoice line. I have the same field in G/L entry table as well. What is the best event to transfer the field value from posted invoice line to G/L entry table? Thanks
-
NAV 2015 - Footer Only On Last Page (Here we go again!!!)
Apologies as this has probably been beaten to death. But I've been out of the loop for a few years and now have a "requirement" for a .(sizable) footer to be printed only on the last page of a purchase order. Searches have lead me through "impossible" to using a sub-report. The sub-report approach sounds intriguing - but…
-
Wrong ordering
SQL Server configured to use collation Latin1_General_CS_AS. NAV use Code(20) type column in primary key and SQL and NAV produces following wrong order: HUTNY-MATE-POLYESTER HUTNY-MATERIAL-PZN HUTNY-MATE-W.15,WPA where HUTNY-MATE-W.15,WPA should be ordered before HUTNY-MATERIAL-PZN. What is the reason or what is wrong?
-
Integration Management does not have a definition
Does anyone know how to resolve that the Integration Management has been deleted by Microsoft? I'm trying to update Microsoft Business Central to the latest version and I need to fix that prior to the update. I already checked Microsoft Wiki but it doesn't really help
-
Limit Quantity of Credit Memo Items against Invoice Quantity
Hi Is there way in NAV or BC to Limit Quantity of Credit Memo Items against Invoice Quantity ((less than or equal to)? The issue client reports is when an invoice returned by customer, they sometime return more items or items made by our company but NOT in the relevant invoice. Since the users do not check items one by one…
-
AL programming for beginners
Hello, I have just started my new position as a BC developer trainee. I have done Business Central Biistwe by Plantaan course but bedside that I have a little experience with programming plus I don't have a background in developing in any other language and I can notice that I really need to find some way to get the basis…
-
Join the Webinar: System application overview and its capabilities in Dynamics 365 BC
Dear Dynamics Community members, We encourage you to register to the Simplanova next webinar: System application overview and its capabilities in Dynamics 365 BC Webinar Date and Time: Tuesday, 16th of May, 2023, 04:00 PM CEST (Central European Summer Time). Register now HERE:…
-
Fornav, Document output, BC Azure
Hi. I would like to hear about your experiences with Fornav in a BC in Azure with an output module like Document Output? I have had minimal experience with ForNAV in a BC14, and I hope you can enlighten me with some basic Pro's and Con's. I have a friend who's recommending LaserNet, but I would very much like to keep as…
-
Date format Word layout
Does anyone know how to change the date format in the Word layout? I tried to use the following command column(Posting_Date; Format("Gen. Journal Line"."Posting Date", 0, '<Day,2>/<Month,2>/<Year,4>')) But the year is showing 0022 instead of 2022.
-
Reserve a Non-Lot tracked Pick Line (and consumption) against a Purchase Item Ledger Entry
Dynamics NAV 2013 We have thousands of FIFO items that are NOT Lot tracked (and thousands more that are). These Non-Lot tracked items, when picked, now need to record the incoming goods receipt number (GRN) produced at purchase receipt i.e. the Item Ledger Entry, and subsequently apply that item ledger entry number to the…
-
Address formatting in sales invoice RDLC report
Hello, I am fairly new to programming, so it can be my questions will sound silly:) A customer requested to hide the country name from the customer address in the header if the country code = x. It is a copy of a RDLC layout for the standard sales invoice report I am working with. Any idea for a newbie like on how to do…
-
wsdl "data contract" case difference from nav2015 to nav2018
I have the same codeunit exposed as webservice in nav 2015 and in nav 2018. But the wsdl datacontract is different in first letter case of function parameters. Any idea to have the same?
-
The requested member does not exist
Hi, I'm trying to use the Microsoft.Navision.Mail.dll v7.3 in a classic 5.1 client thru the cu400 smtp. cu400 compiles. all works as expected on the development machine. On the client machine i get an unexplained error. Could not invoke the member AppendBody. The OLE control or Automation server returned the following…
-
Cloud BC - Bank account linking issue
Hi All, I have 1 customer that always got this credential issue for bank linking. after key in the company id, user id, password. and then key in the security code, it keep getting me this error even though we tried using the same companyid, userid and password to the bank. it seems all the credentials are correct. but…
-
Update 22.1.54915.0 BC
We are getting the following error upon update Error AL0433: Table 'Integration Record' is removed. Reason: This functionality will be replaced by the systemID field. I'm confused how could we replace a table with a field!!? Does anyone know how to resolve this, please?
-
Report language
I have a code unit running on scheduled JOB QUEQUE that execute a report saving PDF in a folder. Works but there is a strage problem: report language was printed in English and not in Italian that was language selected in RTC client. Why? There is a way to select different language?
-
NAV 2016 - "User Personalization"/Customizations, can they be "moved" from old to to new role center
"User Personalization"/Customizations, can they be "moved" from old to to new role center? A customer is running NAV 2016. And their user groups need to be cleaned up. Some users need to be moved to another user group, and probably have a new role center. The individual users have made their own customizations, which I…
-
Communication between Traefik Proxy and Business Central with minimum TLS Version 1.3
Hi guys, I ran into a problem while communicating with a Traefik Proxy from Business Central Sandbox (SaaS as well as OnPrem). I get the error "An error occurred while sending the request. The request was aborted: Could not create SSL/TLS secure channel.". But only if Traefik has set the minimum TLS Version to 1.3. Did…
-
How to disable notes?
Hi experts, In my Business Central cloud app, I have made an extension where my new table has notes attached to it using a factbox like this on the page: area(factboxes) { systempart(Notes; Notes) { ApplicationArea = Notes; Visible = true; } } It works fine, but I don't want the user to change the notes that are attached…
-
BC - Handling Software Sales
Was wondering how people manage software sales? For example, a business buys and sells software from 3rd parties. It does not develop it in-house. Within the Item, there is a "Type" which allows "Service" and "Non-Inventory". This to me appears to be designed for software companies which develop their own software, not…
-
Add Report Sort to sub DataItem fields
Hello Everyone, Wondering if there was any way to add a sorting field to the attached Request page? I have tried to just hard code it by changing DataItemTableView to SORTING(Entry No.) ORDER(Descending) but it does nothing to the sorting of the DataItem. This is on Report 10136 for the Item Transaction Detail Report. Any…