-
Limit number of displayed rows
Hi there Experts, I was wondering whether it is possible to limit number of displayed rows in a list page and to show all again (if needed)? Any help would be much appreciated. Thanks, RO
-
I want to INSERT item from SQL, Anybody have statndard SQL Query or list of table name ?
I want INSERT query for sql to NAV or list table tame for ITEM.
-
Best Practise -Insert and Modify, or Insert
Hi All, After having few issues when insert code block did not triggered some field validations - form instance when insertiung sales header and setting document date, and also on sales lines and UOM, I came to the conclusion that it is always better to first insert with Key fields and then update. Am I wrong here? and I'm…
-
AL: change the standard No. Series management functionality
Hi All, I have a task to change the standard functionality of assigning a numbering series to created documents for known customers; this means that, as user creates a sales quote for a known customer, user would typically first go to a customer page, filter for customer and then click on button: "New Document" -> "Create…
-
Label Language in Report
Hi All, does anyone know how to differentiate language in standard report ? (1306 Sales Invoice) same object but for different invoice could be different language. I Duplicated report 1306 to another report ID, and then change something in the RDL as well but when i print some still english, and some are danish. anyone…
-
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…
-
Filter by name
Hi All, In the Purchase Invoice Page -> Vendor No. When a user enters a text in that field, I want to filter out by name instead of by No. as the screenshot below I have a developer license but I'm not sure how and from where I can do that. Can anyone please help me with this?
-
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…
-
OnAfterGetCurrRecord - code crashes NAV client
Hi All, issue: Page ID 5076 - Interaction Log Entries has some code in OnAfterGetCurrRecord where code that loads and displays comments in the FactBox Comments (linked to record of T5065 - "Interaction Log Entry") and another code in OnAfterGetCurrRecord of same page saves edited content of comments crashes the NAV client…
-
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.
-
BC SaaS: Add custom code at inserting new record in table Sales Header
Hi All, I am working with BC SaaS. I would need to change the standard code of table "Sales Header" as new record is being inserted, where I need to modify the code that inserts the "No." value of table "Sales Header", so Numbering series. I noticed that if I add my code in trigger OnInsert of table "Sales Header", it does…
-
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.
-
Usage of AutoIncrement fields in table
Hi All I'm trying to find the best table structure for a user table that stores Employee by shift date and time. This table will be populated via an API and will be used to create system logic and reporting, and searching by employee and datetime is vital. Having looked at base app tables I noticed that some tables like…
-
Procedure call for Visible property - warning/error in the future
Hey. I have a Group on Page. The group needs to show some content based on Blob field value. So this is what I want to do: group(MyGroup)
{ Visible = Rec.Blob.HasValue(); // some other stuff here.
} Visual Studio Code tells me that: How do I set this kind of group visibility in other way, so I don't get this warning...? As…
-
API v2.0
Hi, Quick question but do I need to do anything to enable API v1.0 or v2.0 - I'm only able to access the beta API. I'm running version 18.1
-
Link SubPage with Global Variable on Page Card
Hey, Is it possible to use somehow global variable in SubPageLink on Page Card? I have a page card without TableID specified. I am creating a record while opening the page and I need to link Page Part to one of the fields of this record, but I can't (or don't know) how to do that.
-
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…
-
Text encoding in NAV 2009 classic client?
I am working on a solution where i get response from an external API but the Danish characters are not properly encoded. I get response in the InStream and then further store it in Big Text object. How to encode my response in 'ISO-8859-1' Thanks in advance :smile:
-
VS Code Fix Variable Name Upper/Lower case
Hi, Dynamics BC variable names are not case sensitive. E.g. you can declare a variable with name of "PurchLine", and you can refer to this variable when coding with "pUrChLiNe". e.g. field("Date Filter"; DateFilter) { ApplicationArea = All; Description = 'Specify Date Filter'; trigger OnValidate() var
>> DateRec: record…
-
Create Pick from Sales Order - i get "There is nothing to create".
In a new test install .. 1) I create a Sales Order, enter a Line Item and qty 2 for an Item which we have qty 2 in inventory (in a bin location). 2) I release the order. 3) Form the Sales Order window, i click on the ACTIONS tab -> Create Inventory Put-away/Pick 4) I put a check mark only on "Create Invt. Pick" and "Show…
-
Fixed IP from SaaS
I have an app that calls an external service and the external service needs to whitelist the IP address I'm calling from. For SaaS, Microsoft says This is from https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/faq#which-ip-addresses-or-ranges-does-my-environment-s-api-use It links to a document with…
-
NAV 2018 Excel Buffer .NET Cell Alignment
Hello. Is there any way to align cells (horizontal/vertical) after writing an Excel sheet via T370 (Excel Buffer)? In earlier versions of NAV when using automations the 'Range' object provided every possibility of cell design. Just recorded an Excel macro and built the functionality in T370. Now the .NET object…
-
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?
-
Map 2 tables when creating a data exchange definition
Hello, Is it possible to map 2 tables (Bank Acc. Reconciliation table (273) and Bank Acc. Reconciliation Line table (274)) in the Line Definitions when creating a data exchange definition in NAV? This will enable the data to be loaded when the bank statement is imported. Thanks to help
-
Change Captions Dynamically
Hi, is there a way i can change a caption dynamically on a field on a page depending on the value in another field. So if field x is set to 1 i want my field to have a caption of Test. If field x is set to 2 i want my field to have a caption of Test2
-
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…
-
Combined Pick Lists for Sales Orders
My client is on NAV2013 and is switching over to using Warehousing for various reasons. For shipping, they will need to Create Warehouse Shipments and then Picks. They have a large volume of small orders, for which they currently manually create combined picks by Item. They are switching to bins and Warehousing so they can…
-
Question | NavUserPassword
Hello, I have one question, its possible Start Service with Credential Type in NavUserPassword without any certificate ? From what i've been reading, to use the service with Credential Type NavUserPassword it is mandatory to have a Certificate Thumbprint... Its right ? Thanks.
-
Dynamics NAV iPhone App will not connect
Im Trying to configure setup with NAV App (Business Central) in my iPhone and give-me all times that error... "Could not connect to the server". Im using the same internal network. This is a self-signed certificate, and I have already downloaded the certificate to the iPhone and installed it. If I try to access it via the…
-
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:…