-
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:…
-
Update Allow posting From/To on the General Ledger Setup
Hi, I'm new to NAV so excuse me if it's not the smartest question. I have a developer license and I'm trying to update the "Allow posting from" and "Allow Posting To" fields in the GLS to the next month at midnight Could anyone please let me know how this can be done? I'm trying to find from where those fields are…
-
Using FlowFilter on Query object via ODataV4 (NAV17)
Hello, I am trying to create a simple Query with Item Inventory, then I want to call it with OData using Location_Filter. I created a Query object: and when I call/ODataV4/Company('TEST04')/ItemStock?$filter=No eq '16721' it works fine, but when I try to filter on Location:/ODataV4/Company('TEST04')/ItemStock?$filter=No eq…
-
Extension Page Name instead of original page name (BC 20)
Hi All, i notice since BC version 20 on the cloud, it will show our extension page name, instead original page. for example i have page extension for Warehouse Receipts page,i named it as PagExtWarehouseReceipts. so when user search it will show as PagExtWarehouseReceipts instead of Warehouse Receipts. is there any setting…
-
How to allow user to only select boolean once per record?
How would you approach the following example... A list page has been created where the user can create a description (e.g. blue paint) and select a series of checkboxes (i.e. gloss/matt/satin/special). For entry 1 the user has created a description and selected the checkbox 'gloss'. For the next entry, the user will create…
-
How to print a report without user interaction directly to a specific printer name ?
The customer import some orders through EDI and after that the realising it is done automatically. After releasing they want to print also a report direclty to a specific printer. The printer name it is set up on sales person table, so it is a different printer per sales person. How can I accomplish this ? Should I use…
-
Factbox with code
Hi experts, We are talking about NAV 2015. I have made a factbox with some lines in. I would like that my code would be run, when the user press a button inside the factbox (on every line or one single button below the lines). The code should work with the active line in the factbox. Otherwise the code may be run when the…
-
Business Central SaaS: User License
Is there an easy way in AL to check if a user has a Team Member License or a Full License?