-
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?
-
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…
-
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.
-
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?
-
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…
-
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…
-
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?
-
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
-
XMLPort - Job Queue
I've an XMLPort I'd like to run via the Job Queue. In the Job Queue Log Entries, I'm getting the message: Client callbacks are not supported on Microsoft Dynamics NAV Server. Here is my Job Queue Entry codeunit; SalesHeader.SETRANGE("Document Type",SalesHeader."Document Type"::Order);…
-
NAV2013 R2 -> As data are inserted into imported Excel file, the style (layout) is changed
Hi All, System: NAV2013 R2 Errors: Issue #1 -> Excel file cannot be edited by the NAV, if any style is applied on the sheet. Issue #2 -> Styles are changed as Excel file is edited with some data from Job record. Functional steps: 1. on page "Job Card" user clicks on button "Populate Excel" 2. function to copy the template…
-
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
-
Write XMLElement nil="true"
I try to set the following attributes in an XML element:<mactive xsi:nil="true"/>. With the statement XMLElement3.SetAttribute('nil','true') I unfortunately miss "XSI:", For information I would be grateful _________________________________________________________________________________________________ AL: XMLDoc :=…
-
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…