-
Report must be initialized.
For report 7391, there is a code on OnPreDataItem as follows I was wondering how is that correct! As the user will always get this error since it's on OnPreDataItem. Does anyone know the reason behind such a code and why it's there? As I'm trying to run the report but I'm getting that error all the time(obviously)
-
Word-Layout repeating DataItem OPNo_ProdOrderRtngLine - Report 99000762 Manufacturing Job Card
Hi all, I am trying to adjust the Word layout for report 99000762 to achieve a similar behaviour compared to the integrated RDLC layout: one page per production order routing line. Therefore I placed my report layout inside a 1x1 table with the following XML mapping:* 'OPNo_ProdOrderRtngLine' as a text-element inside the…
-
Order my Record Set on a FlowField
Hello everyone, I'm desperating ! I have a table with a field which is a FlowField. I declare a temp table (Record temporary) where I put some records from this table. Now I need to order my temp table on the base of this flowfield. No way to do this with Setcurrentkey or ascending :/ Who can help ? Thank you a lot Stefano
-
Wordlayout Mini Sales Header - Alignment of Decimal Fields
I've encountered a strange thing, when looking at the standard Mini Sales Header Reports of NAV 2016 (reports 1304,...,1307, 1316). For example in the word layout of report 1304 "Mini Sales - Quote", the columns Quantity_Line, VATPct_Line, etc. all appear right aligned, when printed, but in the word layout itself, I cannot…
-
Security protocol TLS 1.2 in Dynamics NAV 2013
Hi out there! I am trying to increase a web requests security protocol in order to access a web service which is requiring TLS 1.2. My default SSL is not accepted. The request is send from Dynamics NAV 2013 (7.00). I have of course searched for a solution to this problem elsewhere. One single line should be enough:…
-
Pass XML into function
Hi, i have an xml file that i import manually into the system using an xmlport. I then want to convert this whole xml file to text and pass the text to a function. Can someone tell me how i can do this please?
-
Compare objects in two databases
I need to get BC140TEST updated to current data but am not certain if the objects currently match between PROD and TEST. I can't afford to delete the BC140TEST company until I know for sure. Can anyone please let me know how could I validate the two to allow for a data update into BC140TEST? I'm assuming there is a faster…
-
Find which tableextension a field belongs to
I have done a page that has system table Fields as source. It is very useful since you can filter on all the tables/fields and see data types, captions and so on. However, I'm missing a new important feature. I would like to know which table extension a field belongs to. Are there any system tables that I can use for this?
-
Read Windows Registry from NAV2016 C/AL
Hi all, I'm trying to read a registry value in NAV2016. I've defined a DotNetVariable as ProcessFileName Microsoft.Win32.Registry.'mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' If I look in Regedit, I see a registry key I'm looking for. I exported it to a .reg file and here is the contents:…
-
Closing inventory period - item has entries in this period that have not been adjusted
Hi All, Wondering if you can help ? We have a customer that is currently not able to close their inventory period on a regular basis because of the error above - it seems that the affected item isn't updating when running the adjust cost routine and we have been getting around this by removing the tick on the cost is…
-
How to add a Shortcut Dimension to a table/page
Hi, I'm a NAV Developer, and I'm using NAV 2018. Does anyone know how to add a Shortcut Dimension 4 Code to a table and to a page? Thank you!
-
Preview posting when using "Post batch"
Hi all, Is there a way to use the "Preview posting" functionality on multiple documents (purchase orders in my case) at the same time? I'm looking for a solution to do some kind of bulk check before actually launching Post batch, so all posting errors can be handled before posting any of the orders. Thanks for your answers!
-
LinkedInTransaction deprecated in BC19
I'm migrating some tables from BC14 (C / AL) version to BC19. These tables are external to the DB and have property "LinkedObject" = true. According with Microsoft in these cases LinkedInTransaction property is set to false: Now compiler show a warning because this property is deprecated and in future became an error. So…
-
Unable debugging Business Central 19 onprem
I'm trying to debug my BC19 installation but when I try I get the following error in VSCODE: Error: In the server event log I find the following error: My server configuration: Can anyone help me?
-
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:…