-
Type conversion is not possible Text + Integer
I'm trying to compile some runtime upgraded object 2009->2013->2015->2016 and i get this error But Counter is Integer and not a text, even if I delete it as a variable and add it again the error comes back, this counter is printed multiple times in this report, so making a new variable with a new name is not optimal for…
-
AlwaysOn High Availability Groups on SQL with Microsoft NAV
AlwaysOn High Availability Groups on SQL with Microsoft NAV I have planned to do setup AlwaysOn High Availability Groups for SQL with primary & one secondary. My question is how to connect with Microsoft Navision Application & during failover how connection will get changed to connect with secondary db as primary.
-
ne wimplementation
hello, for a new implemenation I have a couple of quesitons - do the clients need to do the period end and year end in new or old system. I think no because that would give them the option to post adjustments, right? Also what else do I need to check? Any advice is welcome
-
Select a Specific Name/string from Table
Hi Friends, How to select a specific name or string from table columns in C/AL code OR how to achieve if want to get a particular name or string by searching in multiple columns alongwith. Example search a name let's say rahul among two or three columns e.g. Name and Name 2 in customer table.
-
How can I change the default value of a field in BC?
Hi, How can I change the value of a boolean field in a table or page? For example, when adding a new item, by default the value of the Blocked field is false, but how can I change it to true in code since the Item Card is opened?
-
Upgrade v17 -> v17.2 Publish-NAVApp : Extension compilation failed
Bit stuck with v17 upgrade to v17.2 PS C:\Windows\system32> Get-NAVAppInfo -ServerInstance BC170 -SymbolsOnly Id : 8874ed3a-0643-4247-9ced-7a7002f7135d Name : System Version : 17.0.19353.19730 Publisher : Microsoft ExtensionType : ModernDev Scope : Global When publishing Base App: Publish-NAVApp -ServerInstance BC170 -Path…
-
Report dataset - DataItemTableView sorting
Hi Guys I'm trying to understand DataItemTableView in report dataset in AL. What's the point of sorting here and is it better to sort or not sort and performance implications? below is an example: dataitem("Purchase Header"; "Purchase Header") { PrintOnlyIfDetail = true; //remove header without detail RequestFilterFields =…
-
BC App Publish - Digital Sign
Hi, I need urgent help My first app is ready to publish on app-source, it is only 1 issue to solve to go-live I need to digitally sign my app I have tried everything but nothing working https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-sign-extension…
-
Report Issue
I am trying to add field in report but when i am trying to preview Field is not showing. 1) i checked visibility also., its not hidden
-
NAVCore Objects Manager
NAVCore Objects Manager A simple tool for transferring and comparing customized Dynamics NAV objects between the Development and the Test/Production environments. It can be used by Customers and Developers alike. Quickly transfer modified objects from the Development to the Test/Production environment. Easily keep track of…
-
Adding DotNet3.5 to NAV2016 Docker Image
Hi all, Is anyone using Docker containers to do development for NAV2016? We are building individual docker containers for each developer/enhancement. We have an addon from an ISV that uses an addin dll that needs DotNet3.5 in order to compile and run. The standard NAV2016 container images/artificacts use the Windows Server…
-
Manufacturing Finance Assistance required
Hello, Some bad bespoke has resulted in Inventory WIP still being present in Finished Production Orders. We could Create a General Journal to migrate the WIP Value from the WIP G/L to the Finished Goods Adjustment G/L Code set up. This however still leaves the Value Entries in WIP and therefore an unbalance. How is it…
-
Upgrade BC Version 13 to Version 17 without C/AL changes
Hello everyone, this is probably a question with an obvious answer but it's still early in the morning and I can't get it out of my head. If I do an Upgrade vom Business Central Version 13 to Version 17 without having any custom changed objects in C/AL (We've already been programming in AL and have thus an…
-
Sorting report by order type and order no. in NAV 2009 R2.
Hi Everyone, I have one report that has 2 dataitem: sales header & sales line. Inside report user need to add column 'order type'(Order channel) that is present in customer table, so i have created variable and assigned in sales line on after trigger. For sorting with order type(Option data-type: B2B, B2C, B2D), i have…
-
Why no Notification data type in navision 2016
Why no Notification data type in navision 2016. How could I get Notification data type.
-
Where does my Item.Picture hide?
In a BC13 (Build 28871) I have a report written in al/rdlc where I want to include the item picture that is displayed in the item page. * First I just just included the Item.Picture in the dataitem column, but for some reason not all the pictures where included. * Then I changed the code to repeat through Tenant Media…
-
Belgian localisation
Hello, i am using the Belgian localisation. I would like to know which protocol (Domestic, International, SEPA, Non SEPA) if i need to pay a vendor in USD who is in Belgium? Note: Belgium forms part of SEPA
-
Call REST API with NAV 4.0
Hello, I plan to call a REST API in order to integrate data into NAVISION. I can't find anything for this version of NAV (4.0). Do you have any leads or advice to give me?
-
RDLC report with Item table left join to purchase line
Hi Guys I thought when creating the dataset in AL I have the option to determine join type but couldn't find it. So my requirement is to show all items and for items with open purchase order lines, show the next delivery dates in columns. I used below link to link po line to item: dataitem("Purchase Line"; "Purchase Line")…
-
Want to create sales order for each line from sales quote
Hi All, I have created a sales quote with multiple lines added. Here i want to to create a different sales order for each line of sales quote. Explanation: I have a Sales Quote with two lines(X and Y). While i am clicking the 'make order' button in SQ page, It should create two different Sales orders one with item line X…
-
Printing pdf file on network printer by Job Queue/Task Scheduler
Hi, Do you known posibility to printing pdf file on network printer by Job Queue/Task Scheduler. I tryed it by ProcessStartInfo but this DotNet variable requair Running On Client, but this is imposible to run on Job Queue. Version: BC 14 OnPrem Please help.
-
How to make single Purchase Receipt against multiple Purchase Orders.
Hi Team, Can we make single Purchase Receipt against multiple Purchase Orders. Thanks in advance, Srinvias.
-
Nav Serialization Enhancement
1.How can we automate the serial number assignation to released component production journal 2.How to validate to check if the serial number already assigned or used.
-
NAV2013 R2 Debugger without SUPER
Hi everyone, as we can read here (http://www.mibuso.com/forum/viewtopic.php?f=32&t=61338&start=0&hilit=debugger+super) you have to set a permission SUPER, without company, if you want to grant access on debugger to an user. I was wondering if there is another method. We have a very large database, with 10 companies, one…
-
NAV 2013 Universal XMLPort v5
NAV 2013 Universal XMLPort The DMS Universal XMLport allows you to quickly import tab-delimited text files into any NAV 2013 table without any development or configuration. Much faster than pasting from Excel or using the data migration tools. Full details and instructions at http://blog.dynms.com/2012/09/the-nav-2 ...…
-
Report layout in NAV/BC.
Hello, I'm creating a Sales Invoice report layout. I am trying to hide one of the columns in a row but keep the size of my table. E.g. when the "Item No." column is hidden, the "Description" field size grows. I would be grateful for your suggestions. Thanks.
-
Transfer field selections type options to another field of the same type but on another page
Hello. I have a page that has two option fields. I would like to know if it is possible that from the first page the user selects the option in field 1 and the option in field 2. After this, the two that were selected in the previous fields are shown as options on the next page. For Example: Options: Blue, Red, Yellow,…
-
Removing Default buttons from a ListPart in NAV2018
Hello Nav Experts, I am using NAV2018 with extensions. I tried to remove the "New" button from a ListPart's ribbon using "InsertAllowed = Flase" but that didn't work. Any other solution please ? Regards.
-
How to edit the Find row in Items by location Matrix.
HI All, I would like to know if there's a way to edit the subpage Find in the Items by location matrix Scenario : I just want to change the default field in this subpage From Description to No. Cheers! Thanks,
-
Import CSV file that has different table structure then the table into CSV is being imported
Hi, I need to import some data saved in CSV file into T81 - Gen. Journal Line File structure of CSV file is not identical to table structure. How to import such CSV using XMLPort? Should I import first in Temp Table and then from temporary table to T81? Thank you BR Damjan