-
NAV2009 RTC: URL parameters to open specific page with filters
Hi, I am using an URL to open a NAV2009 RTC page from a third party application. The syntax is like this: DynamicsNAV://MYSERVER:PORT/INSTANCE/CompanyName/runpage?page=9305 This works like a charm. However, I would like to send a filter on a specific Sell-to Customer No. in this url. I have found this syntax for newer NAV…
-
Is it possible to display promoted actions on the navbar of the mobile BC client?
I need fast and clear access to an action for users on a mobile device. Is it possible to add a custom action to the navigation bar at the bottom of the screen? If not, is there some other way to make an action clearly visible and presentable without having to hide it behind a menu?
-
How to extract SQL Query/ Store Procedure from SQL Profiler tool for MS Navision ?
for an example, I want to extract store procedure for INSERT item from SQL Profiler so from store procedure i will get idea how much table hit during INSERT.
-
How do I save name of item attributes on my own table?
Hi experts, I have made an extension to Business Central cloud. On my own table, I would like to have a field, where the user can select one of the item attributes and save the selected item attribute on my table. The problem is that item attributes have an integer as unique key and I only want my user to see the name of…
-
Consolidated DB after closing
We have a consolidated Company which consists of data coming from 2 companies in our NAV 2013. We just closed the fiscal year for both companies. Do we just simply import data from both companies again to refresh our consolidated company? Or do we need to also close the fiscal year in the consolidated companies once we…
-
Assistant in Main Panel.
Hi! In the Accounts tab, there is a section or group called Activities with several tabs. I would like to know if that wizard can be put in a panel of those that appear on the main CRM page. Greetings and thanks.
-
How to deduct TDS for customer as per Indian Taxation in Dynamics NAV 2016
Hi All, Can someone please help me to solve the below issue? "How to deduct TDS for the customer as per the Indian Taxation Standards for services in Dynamics NAV 2016"? Thanks in Advance, Srinivas Maddula.
-
Tips & tricks: How to handle limitations during the process (Automations, File Management, .NET, etc
Simplanova invites Dynamics partners to join the webinar: Upgrade to extensions: limitations and workarounds Webinar Date and Time: Thursday, 9th of September, 2021, 04:00 PM CEST (Central European Summer Time). Register HERE. The session will explore the most popular limitations and refactoring cases developers face when…
-
Sales Journal Deferral Code - With Balancing Customer Type doesnt create G.L Entries upon posting
Hi all, i just show deferral code in sales journal (standard is hidden) generate schedule as per standard I preview posting (with balancing G/L Account Type) is ok but if balancing is Customer, it doesnt create deferral schedule in gl entries is anyone has any clue whats wrong with it?
-
Sort order in drop down list
Hi experts, When entering a line in the sales order page, there is a drop down button on the number field (where we put the item number). In my case there is a lot of items that have almost the same item number and almost the same description. So I have added the flow field "Inventory" from the Item table to the drop down…
-
How to GET rest api in AL?
Hi all, how to convert this rest api to become AL Code? GET
/iras/sb/Authentication/CorpPassAuth?scope=EmpIncomeSub+CITFormCSSub&callback_url=https%3a%2f%2fwww.yourdomain.com%2fcallback&tax_agent=false&state=390b25fa-4427-4b10-9ae2-34d6e0cd91a1
HTTP/1.1
Host: https://apisandbox.iras.gov.sg
X-IBM-Client-Id:…
-
Dynamics 365 Business Central 2021 Wave 2: what to expect
The new release of Dynamics 365 Business Central 2021 Wave 2 is coming out this October. In the new blog post, Stefano Demiliani summarizes all the upcoming new features planned for the launch date and the next months after the launch. If you are interested in what to expect from this new major product release, have a read…
-
BC365: Remove grey background on a un-editable text field
Hi! Currently, I am working on implementing a solution that gives the user a possibility to add own instructions (i.e. captions and instructional texts) to certain wizard steps in a navigate page and I am very close to achieve it, but there is a minor detail that keeps bothering me. When you enter the first wizard step in…
-
BC365 How to get Temporary Data on G/L Entry after Preview Posting on Journals
Hello Experts, Good day. Is there anyway I can get Temporary Data/records on GL Entry after Preview Posting using AL Extension? I just want to show it on a report on Journal Page. Thanks and God Bless Slight smile
-
BC365 Variables Empty After Running Request Page on a Report
Hello Experts, Good day. I have created a custom button on a default page of BC365, this button runs a custom report too. See code below action("AR Voucher")
{ trigger OnAction(); var rptJournalVoucher: Report "Journal Voucher"; GenJnlLine: Record "Gen. Journal Line"; begin Clear(rptJournalVoucher); GenJnlLine.Reset;…
-
Automation translate in DotNet Help Me!
Hi all, I'm new in this area, in my company we are making a full migration from NAV2009 to NAV2018. There are some automations but as you well know they have been abandoned. One of them is the following : Microsoft ActiveX Data Objects 2.8 Library.Stream we would like to replace it with the DotNet does anyone know how to…
-
External Tables in BC
Our client needs to connect to an external SQL database used by a third party application. I've been looking into how to accomplish this, but there seems to be surprisingly little documentation on this topic. I could find some information for Dynamics NAV, but our client uses BC Cloud. From what I can tell, there are…
-
Are you concerned about converting your customers to BC SaaS cost-effectively?
Simplanova invites Dynamics partners to join the webinar: Cost Effective Way to Convert Your Customers to BC SaaS. Register for the webinar HERE. Webinar Date and Time: Thursday, 19th of August, 2021, 04:00 PM CEST (Central European Summer Time). During the webinar, an instant upgrade quote model will be presented which…
-
Transfer header does not exists. Identification fields and values : No. = 'TS-00010'
While ship the transfer order, I'm getting Transfer header does not exists. Identification fields and values : No. = 'TS-00010' this error in Can anyone suggest some answer Thanks in advance.
-
Au Nz Statement - Email
Does anyone know of an extension available for emailing Aunz statement in AU BC
-
How can I automate republishing?
As it currently stands, BC requires all apps with dependencies to another app to be unpublished before it's possible to update it, making us either have to unpublish multiple apps manually or unpublishing and publishing every custom extension through a hardcoded sequence of PS-commands. I find this very tedious and…
-
Dataverse Integration Sales -> Business Central
Hello to All, I have setup the integration between D365 Sales and Business Central successfully. Creation and updates of accounts is working fine between the two systems however when i deactivate an account in D365 Sales this does not update the Customer in Business Central. I am using the OOTB functionality. I was just…
-
Testing ListPages
Hi, Is there any way to invoke the "New" Action on a Testpage based off of a ListPage (e.g. CustomerList), in a way that the CardPage opens with the new Record? TestPage.New only "puts the cursor in a row" - which does nothing in a Page that is not editable.TestPage.OpenNew does nothing in a ListPage as far as i figured it…
-
Item Unit Cost
Hi, In an average unit cost codebase .. is the "unit Cost" on an item record inclusive of "indirect cost %" or is this only considered when entered on a purchase line ? And is this ever considered when entered on a sales line ? MY current testing suggests no to both but im curious as to why, if it is so..
-
Sorting cannot be done based on following FlowFields, you must set the security filtering mode to ‘F
Hi, Need help I logged into development environment and changed the property of the flowfield from validated to filtered but the error still persists
-
FILTERGROUP Sales Order by Location
I'm having a filter problem on the Sales Order list and the Employee warehouse table. I want to set filters the Location codes on the Sales Order (sales header) according to the location codes of the user when opening the Sales Order List page. (The Sales Order list only shows the location codes by the warehouse employee…
-
xxx is inaccessible due to its protection level AL(AL0161
Hi, We are in the process of migrating our C\AL application towards AL. One of the issues we need to deal with is that in some page extensions we would like to access the value of a global variable in the base page. However this is impossible, getting the message "xxx is inaccessible due to its protection level AL(AL0161)"…
-
NAV Mobile App cannot connect to the server on Tablet
Hello Good day, Masters. I have a problem using NAV Mobile app, it says Cannot connect to the server. 1. I didn't use HTTPS, only HTTP. didn't use any signed or self signed cert. all I did is that I install normal configuration and that includes web and just forwarded the port. 2. Outside network, Web and Phone client…
-
Import flat file to create invoices in BC
Hi Guys I have looked at below NAV thread to get ideas on how to import a flat file and create invoices to BC https://forum.mibuso.com/discussion/52828/xmlport-flat-file-import-header-line-on-one-line So my file is imported to a staging table and external number is used as unique key since auto numbering of invoices Ext_No…
-
Temporary tables outside of license range
Has there been a change in the last 12 months for how these are handled? A BC14 license from Jun 2020 allows me to use tables outside of my license range so long as they are Temporary = yes. But when I try do design the same object using a license from July 2021, I get: "You do not have access to read the 'XXXX' table.…