-
How to use OData URL and consume it.
Hi everyone, I want to share data of shipment method table using OData. I made a page of shipment method table for this and added it to web services and got the URL. If I am accessing this OData URL then I am seeing table data in XML format on the browser. [Please check below] <?xml version="1.0" encoding="utf-8"?><feed…
-
BC SaaS - Importing CSV - How to handle text Qualifier "My text,part2"
Hi All I'm trying to import a CSV file with comma as separator but some field contain the comma as part of the text like" "Unit1, Maple St ",NY,US Is there a way to handle this in AL code instream or any other function. Currently using uplaodintoStream and LoadDataFromStream methods
-
Line Discount % in Sales Order Lines
Hello, Please can anyone help me how is called the Line Discount % field in Sales Order Lines? Where I can see this in C/AL? What I want to do is that in table 7004 Sales Line Discount, I should be able to setup discount based on Item Category. So When I create a new Sales Order and when I choose the Item for which i setup…
-
Problem with delegation...
Hi, I have a three tier setup: BCWEB1 - Running the webclient. BCWEB2 - Running the webclient. BCSER - Running the BC service tier BCSQL - Running the SQL server. dom\ser_bc - Is the service account, running both the BC Service tier, and the application pool. BCWEB is the internal DNS name pointing to the internal Azure…
-
BC 18+: Use implicit Drill Down behavior of Global-Records'-field in Page Field
Hi, I'm optimizing/cleaning up a page where there are two related records shown next to each other. One of the records is defined as the SourceTable, the other one is from a different table with a 1:1 relation. It is defined as a global variable which is retrieved in the OnAfterGetRecord-trigger with some conditional…
-
BC14 - Time zone (Table 2000000164) not showing correct information
Hello, We have done a Technical upgrade to a solution (NAV 2016 --> BC14) - The Windows client is working correctly but we discovered some issues with the Web client. I found out that (one of) the problems is that the Time Zone table is malfunctioning :-) When I try to choose the Time zone in the User Personalization card…
-
Business Central: "Correcting" a Posted Purchase Invoice
Hi: In a sandbox Business Central environment, I'm testing the clicking of the "Correct" button on a Posted Purchase Invoice. This invoice was not created based on a purchase order. The error message, as shown in the screenshot below, informs me that there must be a "Document No." at the line item level. How do I get rid…
-
Sales Invoice on Business central
Hi , we are using business central and the sales invoice of the customer needs some basic changes. Example they are using only GL accounts on the invoice and the layout has the shipment details and also other information were are not needed . Anybody can help with this please? How can we do this? Is there any option…
-
Upload several .csv files
Hi! I'm working with Business Central 19.0 (cloud). I am trying to import .CSV files with CSVBuffer and UploadIntoStream function. The problem is that I need upload several files at the same time, one behind the other, but UploadIntoStream just let you choose one file. I would like to be able to select a location and have…
-
Running a Report
Is it possible to run a report passing the report number (like in example 2), but before running the report passing some variables (like in example 1) to the report to use in the report (using Single Instance Codeunit is not an option). Basically combining these 2 ways: (1) Variable MyReport: Report 50000…
-
How to get Items filtered by Location Code ?
Hello everyone, I am trying to filter Items in Item Table to get only those ones which are stored in a specific location ? How Can it be done ? I have to specify my condition on a TableRelation property. Who helps me, I'd really appreciate. Thank you all
-
Just want to know is there an availability of Online submission of VAT report For Norway speicific
Hi Guys, Can any one suggest the Norwegian VAT online submission report with government authorities.
-
Approver cannot see record to approve upon clicking Open Record in Request to Approve page.
I created a workflow from scratch for Store Requisition. Everything works fine except that no entries are being created on table 454 ( Approval Entries). The Approver receives the request but cannot review the record. see attached screenshot.
-
Migrate a single company into an existing database
Hi, we have got a BC17 environment with 4 companies. We want to import a 100 GB database with all data into the exsisting database. The tool could be the standard import function or a PS statement. Do you think that this is possible?
-
Powershell Invoke-RestMethod to insert a new customer
Hi, I am trying to insert a new customer using PowerShell via Odata. #Create new Customer
$Credential = [System.Management.Automation.PSCredential]::new('USERNAME',(ConvertTo-SecureString 'PASSWORD' -AsPlainText -Force))
$Payload = "{ ""No"" : ""TEST10001"", ""Name"" : ""Test asdfgh"" }" $obj1 = Invoke-RestMethod ` -uri…
-
setCurrentKey no longer crashes if missing
Hi all, I just want to confirm something. I would say in old nav versions if they key didnt exist it simply used to fail. It seems like, now it searches for best ocurrence of index fields for the given setcurrentkey:…
-
Rest Call to Cognitive Service Computer vision in AL, Header Issue
Hi I'm trying to do a POST Rest call to the computer vision service of the Azure Cognitive services in the new development environment in AL using the HTTPClient as seen in the example of this blog post http://www.kauffmann.nl/2017/06/24/al-support-for-rest-web-services/. When using the code underneath I'm having the issue…
-
Issue in PO Workflow - Status is not getting changed.
Hi All, [NAV Version: 2018] I have created a new workflow for Purchase Order from the template. There are 2 approvers need to approve a PO. Even after the final approver approves, the Status is not getting changed to RELEASED and still showing as PENDING APPROVAL. When I checked in Restricted Records table, it is showing…
-
Better way to insert dimension set ID from AL Code (BC SaaS)
Hi Guys I'm inserting sales invoice lines from code and couldn't find an elegant way of creating and inserting dimension set IDs.
-
Set body for POST request
Hello mibuso community, I am trying to send a post request (no authorization required, not even simple user name and password). I need to send JSON data in the body, so I am trying to put the JSON content into a Text variable and trying to pass it to the HTTPClient.POST method (in its 2nd parameter). When in AL (Visual…
-
Layout of side by side subpages
Hello guys I have a question about page layout. In my company we use Navision 2015 and we have a page that consists of several subpages. Two of the subpages, one contains a list view and the other a cardview, are side by side. Navision automatically sizes the subpages that way, that the card sub page always gets 2/3 of the…
-
NST Services are using different amount of Memory
Hi, got a new Job in the Developmend Field and have to look for the Dev-Server regarding Performance etc. On the Dev Serrver there are different NST's for different usage Configured. I've seen that they are using different amounts of memory. After rebooting the Server this will varying between 200MB and 2GB without any…
-
Printing slow in Nav2017 when logged on in Citrix 1912 cu3
Hi all! We have an enviroment with Citrix 1912 CU3 (Windows server 2019) and Nav 2017 CU51. We have an issue with Citrix UPD. When Printing requisition order for exemple in Nav the printer only print 3 pages at the time and then it goes down to rest startup printing 3 more and so on. Has anyone else the same problem. We…
-
VAT Registration in Business Central kind of broken
Hej guys, I am facing the issue that my VAT registration always tells me, adresses and names are not valid. When I am validating my customers VAT ID, the VAT ID itself is shown as valid. But clicking on details (VAT Reistration Log Details (227)) always leads me to the same situation: Names and adresses are not valid. I…
-
QRCode support for BC Online
Hi, Barcode is supported natively in Dynamics BC 2021 wave 1 onwards. https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-report-add-barcodes Question is, is QRcode supported in Dynamics BC online? Or It only works with using a 3rd party qr code generator service?
-
[BC140] Test for OnOpenPage event
There is a pageextension that changes the "Document Date" to WorkDate() when the page opens. It is working fine - using trigger OnOpenPage(). I'd like to write a test for that:procedure IsSalesInvoiceDocumentDateWorkday() var SalesHeader: Record "Sales Header" temporary; SalesInvoice: TestPage "Sales Invoice"; begin…
-
copy text after hyphen/dash
Hello, how can I copy text after "-" or just delete the text before the "-" I tried copystr but it asks me for position and that could be dynamic. I have text := 'code - text1 text2 text3 text4 text5 text6'; int := strlen(text,'-'); text2 := copystr(text, int+1); what is a better way to write this?
-
How to make web service with links from items?
Hi experts, This is regarding Business Central cloud. On an item, you can make several links to files on some public server. I would like to make these records available for a web service. How do I do that? I can see that this has something to do with the table "Record Link" (number 2000000068). But I need to show the item…
-
Error An internal error has occurred coming after extension is successfully published
Hi everyone, "Error: An internal error has occurred" Error coming after the extension is successfully published Thanks in advance
-
automation not initiated
Hello, I am getting an error when trying to open word from NAV. Its saying automation hasnt been instantiated, see below. Not really sure how to fix it, anyone got any idea? Microsoft Dynamics 365 Business Central The automation variable has not been instantiated.OK