-
How to sync Dynamics 365 Sales to Dynamics Business Central (variant Code)
Hi All, I am new to Dynamics 365 for sales in the Dynamics 365 for sales we have Variant Code in Sales Order. the question is , is there a way to sync this customized field (Variant Code) to Business Central Variant Code in Sales Order line ? Please advise. Thanks.
-
Who Imported object?
We are using NAV 2018. Is there a way to tell who imported an object into the production database? Someone imported something into the production database without proper authorization, and the users ended up getting the "The tenant “default” is not accessible" error. We want to find out the following: 1) Who imported it?…
-
BC20 Convert-PermissionSets.psm1 error
Hello I would like to convert our costume permissions from database data to permission objects, but i am getting so many errors when i try to Import-Module -name "C:\Path\Convert-Permission Sets.psm1" library . Regs. Firas error sample At C:\Program Files\Microsoft Dynamics 365 Business…
-
Inventory Valuation
I used report from NAV 2017 - R1001 - Inventory Valuation, to create a new report that could group by location. Because in the original report i can take the results of all Locations or filter by a specific. My goal is to show all locations . I added Location as Data Item, and indented Item , and dataitemlink by Code -…
-
How to Prevent Users from Viewing Chart of Accounts in Business Central
Hello, I have a small company with only a few employees, so we don't have full on User Groups and Permission Sets set up. I want to only restrict users from seeing financial data. What would be the simplest way in doing this?
-
how to start application server at service.msc
my company was using Navision 5.0 SP1, and now i have migrate to Windows server 2019 & SQL 2019. i can running finsql at client side properly . but i can't make the application server start normally at service.msc ! anyone have idea ?
-
When I select date from calendar why year always wrong? (Dynamic NAV 2018)
Hi Expert Please see in attachments why year always wrong ?? Actually when I type be manual if I input year 4 digits such as 01/01/2022 error still occur but if I input 2 digit it's can work by properly. May be I think error is came from SQL. please give me some suggestion How to fixed its? Best Regards, Funaki
-
CardPart in content area
Hi In an EDI context I have a transmission with one or more documents, each document having one or more lines. In a Page a want to show the document. Along with the document I'd like to show transmission details. So I created a Page with PageType=Document and added a Part Subtype=Page, referencing a Page of…
-
Read the field note on the table record link in sql server ?
Hi, I'm looking for read the field note on the table record link in sql server. I have find how read the field record ID with that :SELECT CONVERT(varchar,substring([Record ID],8, LEN([Record ID]))) as 'ID',* FROM [Record Link] But I can't find how read the field note in sql ](*,) Any ideas ? Thank for your help
-
How can I concatenate two fields into one?
How can I concatenate two fields into one? I have to concatenate Item No. and Variant Code into one field with underscore. Ex: Item No._Variant Code. 2000_Onesize. Regards, Perizat.
-
SMTP Mail Attachment sending issue
Hi All! I have the following issue when I send e-mail from BC14. The mail has one or more of the following parameters: recipients, CC, BCC and Attachments. I have an issue with the Attachments: the files are uploading to a BLOB field, I can retrive the size of the file and from there I can download the correct file (png,…
-
How to remove underscores on the excel layout report in Business Central
Hi, Am new in business central and I want to create the excel report layout. This is what I did, 1. I selected my filters on the report request page 2. Click on Send to 3. Select the Send to Excel (Data only) 4. Then run the report. 5. It download the excel report. Issue: The report headings comes with underscores (e.g…
-
Read JSON Object
Can we extract Object (nested Object) name from this kind of JSON? I am able to count how many objects are in the json, but cannot extract value. ("27675","27676") I am using Newtonsoft "27675":{ "entity_id":"27675", "status":"complete", "coupon_code":null, "shipping_descript }, "27676":{ "entity_id":"27676",…
-
Problem with Nav C/AL Queries
Hello, i'm using NAV 2017 and i attempt to the the following (the real case is more complex but i just ask for a specific function): I have a table Items and i want to use a Query that give me bak ONE record for ITEM, with some static field and some computed fields: - purchased quantity (sum of quantity from Item Ledger…
-
ASN1 encoding with System.Formats.Asn1 / DotNet Enums in general
Hi everyone, right now I'm working on an extension, that among other things has to encode data into a predetermined ASN1 structure. For that task I wanted to use the DotNet assembly System.Formats.Asn1. I referenced the assembly in the dotnet.al looking like this: The assembly is on the server with the service tier…
-
Surcharge over Line Amount in Table 37
Hello, one of our customers has commissioned a surcharge that is to be calculated as a percentage of the sum of all line amounts in table 37. The line amounts are changed in various places, e.g. by changing the quantity, the ex-factory price, etc. This surcharge would therefore always have to be updated if the line amount…
-
How to change license type of user from Full user to Esentials
Hi, Thank you. Actually, I missed to tell you that, this is Business Central latest version. BC 20. Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not mylicense.flf, it is mylicense. license How to change in user card in BC 20, and also from 'Full…
-
Do We have any app In Microsoft Dynamics 365 business central app source for Magento Connector
app source for Magento Connector with reasonable price?
-
Problem grouping SUMS using Queries
Problem with Nav C/AL Queries Hello, i'm using NAV 2017 and i attempt to the the following (the real case is more complex but i just ask for a specific function): I have a table Items and i want to use a Query that give me bak ONE record for ITEM, with some static field and some computed fields: - purchased quantity (sum…
-
Business Central License for extra objects
Hi, Thank you. Actually, I missed to tell you that, this is Business Central latest version. BC 20. Microsoft partner who sold the license told me that, for a new BC license, we don't need to buy any extra tables. this is not my license.flf, it is mylicense. license I am using 30 tables, in the case required, I will buy…
-
Bin Quantity - SQL
Dear All I am trying to pull in to Excel the current quantity in each Bin Code using SQL and the Nav db as an external data source. Can anyone advise which Table holds the current bin quantity for items. We are using the Warehouse module
-
How to get effect new license to the users with Essential, Premium, Team Member, External Accountant
How to get effect new license to the users with Essential, Premium, Team Member, External Accountant list in user card in on-promise Warm regards Krish
-
Can anyone help on Permission on custom tables
You do not have the following permissions on Table Cash Collection: Execute. To view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '29'. Internal session id: 42535434-d994-4bfe-a31c-439ff2c0d0fe Application Insights session id:…
-
Consume Webservice and Import data in Navision
Hi All, Hope you are all doing well. I want to consume webservice(GET) and import that data(Xml format) into Navision table. Is there any code reference to consume and import data from Webservice. If you need more info about requirement. Please ping me. Thanks.
-
MRP Planning Worksheet, show the reservation Production Order Number
We have a small number of purchased items where the Reordering Policy is set to Order. We use this so that an automatic reservation is created between the requirement (Production Order) and the corresponding purchase order. This works well and when you examine the resulting purchase order you can see the Production Order.…
-
My sub form/page is not editable
Hi Before migration sub-page was working fine, with minor customization and it is a copy of the Standard sales invoice but a completely new object itself. Subform is not editable. it is going grey. Does anyone help me, please. my code in AL is page 50002 "POS- Sales Invoice Sub" { AutoSplitKey = true; Caption = 'Lines';…
-
What's the point of SetTableView
Hi All I'm trying to understand the usage of SetTableView . My understanding is that it creates a filter so the question is why we cannot just use Setrange or SetFilter instead. Below is from purchase order subform to find linked sales orders:protected procedure OpenSpecOrderSalesOrderForm() var SalesHeader: Record "Sales…
-
You do not have the following permissions on CodeUnit Prova: Execute
In Dynamics Nav 2018 I made this codeunit 50006 called Prova: OnRun()
MESSAGE('Hello'); When I Ctrl+R or run it will display this error message: You do not have the following permissions on CodeUnit Prova: Execute My user has SUPER permissions. If it's a license thing I really don't know how to check that. How can I run…
-
Record being modified but can't find where even exporting all objects to txt
In Dynamics Nav 2018, I'm using the selected action in this page rows, when I click "Validar", all selected rows will change it's status to "Pendiente". After some time, the row will change to status "Error": I can see in debugger when it changes from "Registrando" to "Pendiente". But I can't see when it's changing to…
-
Docker Development
Hi Experts, I need suggestion on a Development environment setup for more than 2 developer. Scenario: We have a Azure VM and a Container is setup there with Latest BC insider image of V17. Now i want to give access to 2-3 developers target to that BC Container from there local system. I want to give them access of…