-
Calling API from Dynamics 2016
In currently ruuning Dynamics 2016 and I would like to call an API, do you have any code or object to do it?
-
Read a JSON file within the projects in VS Code.
Hi all, Is it possible in Visual Studio Code to read a JSON file within the projects? Example: I got a Codeunit called ImportJSON under the Codeunit folder, and then I would like to use this Codeunit to read the xyz.json file (under JSON folder). Is it possible to read the JSON file? Thank you.
-
NAV2018 - not able to connect to NAV Server
Hi all I have 2 laptops freshly installed with NAV2018. Both laptops are the on the same network, both windows 10 pro. 1 can connect to NAV but the 2nd one cannot. Error when I open NAV2018 is - When trying to change the server, I got this error I have uninstalled and reinstalled on the 2nd laptop, copied the Config file…
-
Hii Guys, can anyone help me how can i filter Date only from date and time in reports
Thank you
-
Dynamics BC Online performance tuning
In "classic" NAV when there is a performance issue, say with a big transaction table e.g. "G/L Entry", I will run a SQL database query analyser, and find out what index key fields I need to add to GLEntry table. And this normally will address the problem. Until, some other usage trend comes along. Then I will rinse and…
-
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?
-
Adjust cost
Hi, One of our clients did an upgrade from NAV 2016 to Business Central with LS Retail. Some of their items are set to 'Standard Cost'. They did not update the cost on the Item card before they posted the Inventory qty take on, thus posting the transaction at a zero cost. They also decided that they would bring in the qty…
-
Monitoring Business Central
Hello Everyone, today as we have a lot of people working from home, sometimes the people work outside of working hours, this is good but block some routines "Lock tables" is it possible to monitoring who is blocking those tables? Thank you,
-
Performance of G/L-Posting - any benchmark?
Hi there, is there any guidance on how to size NAV14/BC SQL servers or how to benchmark good or poor performance? A customer asked us to analyze some kind of poor performance on their NAV14 production environment. They are complaining about slow general ledger journal import from csv and slow journal posting. On an…
-
[AL] How to use user input from request page for report generation
Hey all, I am completely new at AL programming and am doing a little testing in my business central sandbox. On my report's request page I would like to add a field in which I can choose a customer and then only show data for the chosen customer in the report. I have successfully added the field but fail to properly…
-
Remittance Report - 400
Hello, Has anyone successfully been able to recreate the Remittance report (400) to work with a Word Document Design in AL? At present the grouping does not work well or at all with Word Document Layouts. Thank you.
-
NAV pictures in BLOB fields
hello guys, im new in business central. im looking for a way to make the image in the attachment bigger when i click on it. how can you do that? the image is stored in a field called picture which has a type BLOB and subtype BITMAP
-
Forgot Navision Admin password
Hello Everyone, I am using Navision 2016 and NAVUserPasswrod protocol to authenticate clients. However, I lost my admin password and now cannot login as an admin. Any suggestion how can I reset my admin password. I am using MSSQL DB.
-
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.
-
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.