-
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…
-
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:…
-
BC20 CU2 on-premise - help links in the navsettings.json doesn't work
Hey, since BC16 or 18 we have stored our own help links in the navsettings.json of the web server. Like this: }, "ApplicationIdSettings": { "BaseHelpUrl": "http://support.firma.com/{0}/", "BlogLink": "https://www.firma.com/", "ComingSoonLink": "https://info.firma.com/", "CommunityLink": "https://www.firma.com/",…
-
Invalid language ID supplied: 0.
Hi After Upgrading Business Central from 14 to 20, when I want to run any report, it gives an error. "Invalid language ID supplied: 0." Please suggest Warm regards Kris
-
Replace namespace in xml Ports with .net
Hi, i created an xml-export with a .net variable. (System.Xml.XmlTextWriter.'System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089') My example code is like this The result is: So far it looks ok. Now I want to change 'xmlns" in the CustomField-part by 'name'. Anybody an idea how to solve this?…
-
Copy ZPL file to printer in BC
Hi, does anybody know how to copy a ZPL file to a Zebra printer in BC OnPremise?
-
Migrating Multiple On-Premise Companies to BC Online
Following the MS documentation for the Migrating process we have successfully migrated several customers from BC14 on Prem to BC20 Online. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data But now we have a customer with multiple Companies in the same On Prem. Database and…
-
Business Central Getting Crashed when Record.Modify or Record.Insert is getting executed on Page Ext
Hi, From Posted sales invoice page I am running E-Way Bill Update Action to fetch details from API Response. I am getting the response correctly but when i am trying to insert the same in any table (Record.Insert) or sales invoice header (Record.Modify) business central is getting crashed and the Web client looks like the…
-
sys.sysobjvalues
Hi, I am getting this error. The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'sys.sysobjvalues' and the index name 'clst'. The duplicate key value is (60, 808494059, 1, 0). I have restored the database in different servers but no use. DAC is giving a big problem Does…
-
Business Central OData Price Look-up
Hi experts, For an e-commerce solution, I am looking for a way to look up the prices og multiple items which a specific customer number would have to pay right now using an OData webservice. Let's say a customer in BC browses a webshop and loads product lists with 20 products at a time, I would like to fetch the "Best…
-
Item CRM -> BC/NAV Sync Fails
Hello! We've been facing an issue when coupling items. The direction is CRM -> BC14. The record in table CRM Productpricelevel already exists. Identification fields and values: Product Price List='{00000000-0000-0000-0000-000000000000}' The sync works for the first time, but the next time it fails with this error. Any help…
-
How do get Attachment from API? (Cloud BC)
Hi All. are we able to pull attachment from BC via API? I tested from this link --> https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_attachment_get it is for Incoming Document Files but i need from Attachment (Document Attachment) Please advise Thanks.
-
Need help to Upgrade D 365 BC Spring (14) to D365 BC wave (200)
Hi, I am an It person from a user company. It is a very small company with no partner because we can't offer to pay them. I have the NAV database of BC 365 Spring (14), with data. I want to upgrade to D 365 BC wave (20). I have tried but it is giving an error at using the txt2al tool. 1. Please help me with these errors.…
-
ExtendedDataType Phone No. not calling
Hi, In a Dynamics Nav 2018 environment, the call button next to a phone number is not doing anything. It concerns the Customer Card Page (21), field Phone No. 1. It has ExtendedDatatype set to Phone No. This is the default situation, no custom code or properties. We have installed a Phone client (SwyxIt!). When we run…
-
Why we can't query with Record link (table 2000000068)
My client wants why can't we query for Record Link ( table 2000000068). I look forward to a detailed explanation, many thanks !
-
In Manhattan Scale WMS Application, How to do a replenishment demo? Where can I find bulk storage?
I am just learning Scale application, I am a given a task to do replen?
-
In Manhattan Scale WMS Application, Where can I find Bulk storage to do a Replenishment?
I am working on this WMS software, I am given a task to a Replenishment Demo.
-
App License key - suggest a logic
I have created an app, which expires in 3 months I have added a functionality where I give a key to user and app can be extended further- by 6months or 1 yr it is working fine but if app is used by a company on multiple tenants then same key can be used how can I avoid this? I can ask tenant id and generate a key based on…
-
Object license assignment required for ExternalSQL tables
Hi, It does seem that tables marked as TableType = ExternalSQL, needs to be in the assigned licensed object range. Can someone please confirm that for me, please? I remember reading somewhere that TableType Temporary and External do not need to be assigned. And now of course, I cannot find that article. However running…
-
Accessing OneDrive using Graph API in Business Central
Simplanova invites Dynamics partners to join the free webinar "Accessing OneDrive using Graph API in Business Central". Webinar Date and Time: Tuesday, 31st of May, 2022, 04:00 PM CEST (Central European Summer Time). Register for the webinar HERE:…
-
Microsoft Forms with Business Central
Has anyone used MS forms with BC? Is there any guidance for custom build, feeding data from MS Forms to BC Thanks
-
Add Attachment in Notification Approval Email
Hi all.. i have attach these files in documents. once I send approval to manager. i want to attach these attachments in notification email. is that possible? Thanks
-
Attachment Factbox move from details tab
Hi All, i create new document attachment as factbox anyone know how to move i from details tab? it keep showing at details instead of attachment
-
NAV 2016 Bank Recon: Problem when using "suggest Lines" a second time
Hi, In my first month in Navision 2016. Trying to play catch up on some bank recs that haven't been done. The issue is we have a bunch of charges that come in on auto-pay. So as I'm going through the reconciliation, I am constantly having to enter new cash receipts journals for items that have hit the bank statement but…
-
Unable to credit a purchase prepayment
Hi, My client has an issue with trying to credit a prepayment PO. The scenario is below, they are currently running an Azure cloud version. There version is CA Business Central 19.5 The scenario is as follows: A PO was created and a 100% prepayment was posted. Purchase & Payable setup allows them to receive etc on the PO…
-
"The value for the WSFederationLoginEndpoint configuration settings cannot be empty" OpenID Issue
Hello everyone, I'm trying to setup Azure AD authentification with OpenID connect but i find myself enable to move forward. I used this documentation : https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/authenticating-users-with-azure-ad-openid-connec and followed every instruction but…
-
Cloud BC - Intelligent Cloud error
Hi all, i have done migration from BC on prem to BC Cloud but i get this error message. "Data from table Ess. Business Headline Per Usr is unavailable. Intelligent Cloud replication for this table was unsuccessful." any advise? Thanks.
-
after creating a field in customer record how to Flow the value of same field on Sales Header & Line
After creating a field in customer record how to Flow the value of same field on Sales Header and Sales Line.How to do this?