-
Object extension(Table, Page) ID is not showing in AL object designer.
Hi Everyone, Good Afternoon, I have created some extension in VS code for my Business central sandbox(Trial), able to publish, getting custom field in user interface; but not able to see the Object extension ID in AL object designer. What is the issue, that i am not able to find. I checked the AL object designer extension…
-
Rename Item No
I created a report to rename the "No." field in the Item Table. Since this field is a primary key I used Rename function as shown below I know my code is working as I tried it already for another Item No, but for this certain "No." I'm getting the following error NAV Version Does anyone know how to resolve this issue?
-
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…
-
App Install error
Hi, I'm trying to install 3rd party apps (Continia). I'm getting an error about a codeunit (6192809) in the core app (which is installed without any problems, so it does exist). Below the error: Could not install the extension 'Continia Document Capture 365' by 'Continia Software' (version '9.1.0.0') on tenant 'default'…
-
SQL Error when I compile the object in NAV 2016
We are using NAV 2016 -(version 9.00.46621). I get an error when I compile the Service Header table object. This error occurs only for this table. It started happening recently. I can compile all other objects. I get the following error : An updated definition for table Service Header cannot be applied in SQL because the…
-
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.
-
Custom Automatic Posting of Purchase Invoices via Job Queue results in Job Queue Error (Error Mgt)
We are facing an issue where we would like to post all released Purchase Invoices via the Job Queue. If there is a validation error during posting of the invoice, it will skip posting and then move onto the next one. I have built a 2 Codeunits to handle this. 1 to run on the Job Queue and the second to handle the call of…
-
Moving or adding Sorting Filter
Hi Everyone, is there a way to add or move a sorting filter on a report? I want to add/move the sorting filter from Customer to Sales Order Line instead. Thank you
-
Time interval in the task queue
Can a time period be specified in the job queues in the date formulas? I would need a job that starts on the 5th of a month until the 13th of the month at 6:00am, 11:00am and 3:00pm respectively. I have not found anything in the forums. Is there any way to control this via powershell?
-
How would an end user identify they are using extensions or objects in a deployment?
Assume for a moment you're dealing with a non-technical end user, and simply want to know if they are using an ISV solution deployed as objects vs. extensions. Also assume this customer is on NAV2018 or BC13/14 where it could be either option. How would you get them to give you this information?
-
propoer item configuration for both sales and production
Hi, we are sales company, that started small production of goods item "03L". Previously it was only sub-manufacturing, so product was configured simply as "goods" because we bought it from contractor. Now we would like to continue purchase it from subcontractor, and start produce of "03L" in our factory. Our partner says…
-
Discrepancies In general ledger and subledger
I have an issue with transactions in my payment journals. When I enter an amount in ACY, it is translated to its equivalent in LCY. However, when I preview my journals, my amount in ACY differs from the amount on the journal line which matches what is in the subledger. . Any ideas on what I can look at?
-
Passing value from Job Ledger Entry
Hi All I've been trying to pass values to and from job ledger entries but it only works for header level fields like document no. This is the trigger trying to get the job ledger entry line linked to planning line:[EventSubscriber(ObjectType::Codeunit, Codeunit::"Job Jnl.-Post Line", 'OnAfterJobLedgEntryInsert', '', true,…
-
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.…
-
How to change Date format in Standard Statement (Report 1316)
Hi All, since the Standard Statement is mm/dd/yyyy I want to change all the date become dd/mm/yyyyy is there a way that i can change the date format? or need to duplicate this report and change ? Thanks.
-
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?
-
JavaScript SOAP Call against Container (CORS)
Hello, I wonder if there is anywhere a working example for javascript Soap calls (prefered with axios) against a local running NAV container? Has anyone done this and is willing to provide the working example including the container script? Have not found anything up to now and the Chrome "Moesif CORS" plugin seems also…
-
Your program license does not allow you to publish Business central ver BC 14
On installing some extension to a BC ver we get this error, We are using a runtime ver og the extension and our developer licens, to install the extension. How to fix Sync-NAVApp -ServerInstance $ServerInstance -Name 'Sproom' -Version 14.0.0.15 Publish-NAVApp : Your program license does not allow you to publish…
-
Installa extension to BC ver 14, does not show up in BC
After a installation of an extension, everything went ok, no errors The extension is is in Extensions mgt. but is visibel in BC anywhere Its is in the BC where we develop the ext. and also in other BC ver 14, but not in "this one" Other extions is installed and working Any ideas how to get visibel.
-
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.
-
User navigate to folder
Hello, as BrowseForFolderDialog is no longer available in web client in business central, how can one use a folder navigation in the web to navigate to a file path?
-
C/AL code function for Array search?
Is there an C/AL function to search an Array for a value and return the Array index if found?
-
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…
-
How to check if a field has been modified
I want to check if any fields in the Sales Order(Sales Header and Sales Line) have been modified. How to do that without writing the same code/call a function in all fields? Is there a simple way to do that without writing the same code repeatedly in all of those fields for the two tables?
-
Set parameter in table
I am trying to transfer a variable as a parameter to a table that is used in a sub page. Here is the scenario: - Created 2 actions to turn on/off a software switch as a boolean on the Sales Order (header action) - These 2 actions (on/off) are calling a function on the Sales Order sub-page, which is setting the same boolean…
-
Maximum number of allowed companies
Version: 14.0.37587 Number of existing records in table "Company": 990 License Permission Report Detailed file: Maximum No. of Companies......: 10000001 Try to create a new company: Error: "Cannot create the new company because the maximum number of allowed companies has already been reached" Tested with customer and…
-
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:…