-
Tables in SQL
Hi all Please refer the attached picture. I do not see these tables under Object Designer but available in SQL Database tables section? What are these table used for? No records at all.
-
How to connect to and authenticate an external web service from BC cloud
I am trying to connect to the ABN Amro sandbox. The API example is as follows: curl -X POST "https://auth-mtls-sandbox.abnamro.com/as/token.oauth2" \ -v \ --cert CertificateCommercial.crt \ --key PrivateKeyCommercial.key \ -H 'Cache-Control: no-cache' \ -H 'Content-Type: application/x-www-form-urlencoded' \ -d…
-
EventSubscriber - Get Calling Record
Hello, I am looking at using this EventSubscriber to change the IsHandled value based on a condition. [EventSubscriber(ObjectType::Table, database::"Sales Line", 'OnBeforeValidateBlanketOrderLineNo', '', true, true)] local procedure OnBeforeValidateBlanketOrderLineNo(var IsHandled: Boolean) begin end; As there is no…
-
Open Invoice Integration
Hi, has anyone done any API integrations to the Open Invoice Platform from BC140? We use BOOMI to handle messages but was looking for a leg up on the invoice export process if anyone has done an implementation.
-
BC AL: It is not possible to add a breakpoint at line number
Hi, We created a Business Central Extension that we can debug locally, i.e. in the development environment. In the live environment we run into an issue that we want to debug, however we are unable to do so. We receive the followin error: Error: It is not possible to add a breakpoint at line number 445 in application…
-
Best practise for large Business Central customer?
We are almost in the final phase of a large sale of Business Central. The customer will have about 1000 users (700 essentials and 300 teams). The customer must run Business Central On-prem. We want to host it in Azure. Would have liked technical advice and some 'best practice' for this type of customer size. For example,…
-
Securing a Published App
Just wondering, what the steps we must follow to secure our published apps, so code cannot be seen or copied. I know only 1 place which is on app.json "resourceExposurePolicy": { "allowDebugging": false, "allowDownloadingSource": false, "includeSourceInSymbolFile": false } is there any other thing, we must do before…
-
Vendor Card - missing Actions under different Profiles
A customer came across a problem whereby a Vendor Card is missing "Recurring Purchase Lines" action (Purchase section under Navigate tab) under a Profile linked to a bespoke Role Center Page ID. IT Manager Profile (Role Center ID 9018) works fine, but when a default Profile is linked to the bespoke Page, the same Vendor…
-
Keyboard and Accessability
Hi All, Got a user who is very heavy on keyboard shortcuts due to not being able to use a mouse. Set up keyboard commands for various actions, however does anyone know of an action to jump from the "header" to the "lines" on a document. For example, if cursor is in the "No." field on a Purchase Order, in order to get to…
-
Error: Unable to compare operands of type 'NavInteger' with 'Boolean'.
Hi i'm still new to BC and i'm running into this error while executing the Send Method of the HttpClient ( Same error occurs when using the Get Method directly ). I have no idea why i'm getting the error since i can't see the line of code in said method that's causing it. Also the same URI + Authorization works perfectly…
-
[BC] Problem with insert into "Customer Bank Account" through custom API
Hi, so the primary key of the "Customer Bank Account" is ( Customer No. + Code ) . Right now we handle the Code field internally to make sure the field is consistent ( incremental number) . If i try to POST an insert through my API which only contains Customer No. and IBAN , I get the error "Code must have a value in…
-
Cloud Migration: Permissions
I have completed an upgrade from BC14 to Business Central Cloud V20. The Cloud Migration Setup has completed but as stated in the guide, permissions are not carried across. As it stands my permissions have only "Intelligent Cloud". What am I meant to do to get the permission sets back in the system. Thank you. Ignore:…
-
Running Multiple Reports in BC
I am currently upgrading a customer from old NAV to BC SaaS. 2 or 3 times a year they send out renewal documents to a few hundred customers. Each "pack" has 3 reports. We currently have a batch that prints them as report 1, report2, report 3, for each customer as separate prints. This makes it easy to collate the…
-
Add request page group on a report extension
Is there a way to add a group on a request page of a report extension that does not have any groups? I only have the option to add after/before and then the anchor group. Problem is there is no Group at all to anchor to. Report: Vendor - Payment Receipt
-
Copy NAV webservice in SOAP UI give Premature end of file error
Hi, When I copy to URL from the webservices page in NAV in SOAP UI, I get the error Premature end of file. If I copy it into the browser I see the wsdl, so that works correctly. What is the problem with SOAP UI? Best regards, Maurice
-
SQLDataReader call not returning any records (works if using SQLCommand.ExecuteNonQuery)
Hello, I've got a SQL Stored Procedure that is called using one input parameter (sales order no.) and two output parameters (one text and one decimal field). If I call the SQLCommand.ExecuteNonQuery and retrive the 2 output parameters, it works. However when I translate this to a SQLCommand.ExecuteReader call, the…
-
ERROR - Sorry, this action is not available for the online version of the app
Hello nav experts, i am getting the following when executing this code My guess is saveasword or download to file dont work but wont able to find ti for ages now.. any ideas? IF CONFIRM('Preview all records?') THEN BEGIN ...some code.... IF table2.FIND('-') THEN REPEAT _servertempFileName :=…
-
Compatibility Dynamics NAV 2015 and Windows Server 2022
Hi there, A customer asks if their current Dynamics NAV 2015 installation will run on a Windows Server 2022 which they are considering to use? Josh
-
XMLPort requestpage visibility before .run
Hi All, This is something I think I've done in the past dozens of times but, it doesnt seem to work or I can't find the event. If you want to pass a parameter to condition the visivility of certain fields in a requestpage, it seems like there isn't a trigger for this example: Clear(X50026);
X50026.SetDocType("Document…
-
Clickonce won't open after Windows update for some users
Background specs: NAV version: NAV 2017 (11.0.23019.0) Client Windows version: 21H1 (19043.1415) Since our customer updated their computer to the new Windows version, their clickonce stopped working. We click the icon and nothing happens. Error messages that occur in the log: Tillämpningsprogram:…
-
Using Temp Table for ListPart page source table
Hi All I'm still trying to get tableType = Temporary work in certain scenarios. Has anyone used a temp table on a listpart page or factbox? Created a list part page on sales order to show subtotals and the source table is marked as temp table, but then using temp table no data displayed (BC SaaS 19v) Tabletable 60114…
-
BC (SaaS) - Populate custom fields from standard Outlook email message
Hi All, How to populate custom fields displayed on Page - "Create Interaction" with standard fields from Outlook e-mail message? I cannot figure out how to map field ("Subject", "From", "Sent") of the email message to custom field ("Mail From", "Mail To", Mail Received On", etc.). Business Case: As email message is…
-
instream error when word download
Hello, I have functionality which in old NAV I could export word and open it with the following code Table1.SETRANGE("Mark for Printing", TRUE); Table1.SETRANGE("SayYes", FALSE); IF Table1.FIND('-') THEN REPEAT _servertempFileName := _FileMgt.ServerTempFileName('DOCX'); _clienttempFileName :=…
-
API Calls PATCH/DELETE not allowed for table.
Hi, so i built an API Page for the customer bank account table and i cannot modify or delete entries i created ( Error says those calls are not allowed for customerBankAccount with EdmType „Collection“ . How do i solve this?
-
page not searchable
hello, i am encountering the following problem - page is not searchable when i search for it however, if I go to the waffle menu i can see it there. this only happens on certain role centres I have application area and usagecategory filled in in the code any ideas?
-
Filters on Queries
hello, I created a simple query that returns some data from table 36 and others from table 37, so far so good. Now I would like to filter the data, and I would like to let the user do that. I thought it would be an idea to call a page from the query's OnBeforeOpen trigger where you can enter the values and then have them…
-
Error when start running Business Central
Hi I create a new instance and a new webclient instance server with the command New-NAVWebServerInstance. I can download symbols in VC but can't run Business Central. Appears the error below: Already see some configurations, database... but I'm a rookie in BC so I don't know if I'm doing something wrong. Any suggestion?…
-
Is there any way to get information about the local session?
I have an issue that requires that I know which station/computer a user is logged in with. The user itself isn't important, but I need to know if they are using computer A, B or C. Is there any way of achieving this with Business Central 19 CU 1? Some sort of session metadata that includes information about the computer…
-
New Purchase Job Price list screen, costs are not picking in the purchase lines.
Hi, Enabled the New sales price feature from feature management. Here is my Purchase Job Price List, with Job JOB00020, Item 1908-S, Min Qty 3, Cost 45 and Discount 10%. Trying to create the purchase invoice with Vendor 20000, Job JOB00020, Item 1908-S, Min Qty 3, but it didn't picked the cost 45 from the new purchase job…
-
Unapply Payment Via API
Hi All, is there a way that we unapply payment via web services? is there any standard api? or must be customized? Thanks.