-
How do we register down time for machine or work centers? We work with Microsoft DynamicsNAV 2013 R2
Hello! We are learning about machine and work centers. One question that came up is -how do we tell Nav one of our machines(machine center) is down? before production orders are released or once they have been released. Also, does Nav auto allocate the capacity to another machine once we register the first one is down?…
-
SSRS report to PDF
I'm looking for a way to silently print an SSRS report to a PDF from within NAV. I'd prefer to use a call to the SSRS URL or NAV DotNet. I've looked at the Microsoft.ReportViewer.WebForms assembly but can't find enough info to be able to tell if that would work. I can call the SSRS URL but it pops up a web browser which…
-
Odata Service Reference
Hi all, Recently we've made a migration to a new server with Dynamics Business Central 365. We have a internal application in c# that uses Odata to Update/Delete information between NAV and c# When i try to update the service it gives me this error I also changed some IIS configurations accordind the old server. Enabled…
-
Save report as pdf and send as e-mail
Hi experts, On Business Central cloud, I have made my own report in my own extension. I need to add an option for the user to select, if the report should be printed as normal or if it should be sent as an e-mail with a pdf document attched. I don't want the user to select, where the pdf document should be saved during the…
-
Post image into Business Central via API page
Hi I would like to publish an API page through which an image can be transferred to a table in Business Central. I am using Business Central 2020 Spring release wave 1 Can anyone please give me an example of how to achieve this. Thanks
-
How to link a dataitem with record variable and fetch fields of record variable.
Hi all, I am trying to create a report with dataitem trans.sales entry and record variable with trans. Infocode entry. I want two records "amount" and " information" from trans. Infocode entry. I have given filter of setrange of transaction no. on OnAfterGetRecord() of report dataitem trans sales entry. Please help me to…
-
sales price discounted by an amount between level parametre
Hello friend, please I have a question on the unit price, once I want to create the order and (enter the item that will be programmed in a special price contract) the price of the second line of the same item is discounted by an amount set in a field in the price contract. I show you an example:: Line NO Item Delivery Date…
-
List of all published extensions from AL Code
Hi, I need to get all published extensions from AL Code. Ideally would be if I could extend "Extension Management" page. Unfortunately, I cannot extend this page and I cannot use "Published Application" table for Extension Developement. Is there any other way to get a list of all installed applications? Maybe there is some…
-
AL(AS0085) Warning Message
Hi Experts, I have activated the Script Analysis and found that got warning in app.json file. The warning message is: I have checked in Microsoft website and compare the sample, it is exactly the same as mine. What should I do with this warning? Thanks.
-
Retrieve data from XML file
Hi everyone I am new to the world of soap webservice response files and XML. I was wondering if anyone could advice on how to retrieve data like accno, carriername etc from the following file <GetDeliveryOptionsResult><deliveryoptionresults> <recommended><DeliveryOption><accno>123456</accno><carriername>TEST…
-
Export File to Azure Storage Location
Hi, From BC on prem, is it possible to export a file to an azure storage location? Regards,
-
Proforma Invoice
Hi, I'm using Navision Business Central. Is there any way to print proforma invoice having GL accounts instead of items? The report layout includes only items and non GL accounts.
-
Error in Invoke-NAVApplicationDatabaseConversion for Azure SQL
Hi, I am upgrading BC15 database to BC17. I am getting the following error when I run the Invoke-NAVApplicationDatabaseConversion command: Invoke-NAVApplicationDatabaseConversion : The database create operation failed due to the following error returned by SQL Server: Execution Timeout Expired. The timeout period elapsed…
-
UnitPrice in sales line
Hello , My need is how to change automaically price unite if insert second line for the idem item on sales line , the sales line is connect to contract price , and can change if shipped for next qte on idem delivery date for 3 leavel variante.
-
How to add Chart in Role Centre Page
Hi ... is there any way to create a custom generic chart and add that to any roll canter page in new BC? Previously in NAV desktop application by add new chart part and then customize that part and selecting the required chart from generic chart list. I could not find this option in Business Central web version. I can…
-
Permissions Dialog for Interacting with External Functionality
Hi, The first time you Send to Excel, or send an email via outlook from Microsoft Dynamics 2016, you get a one time dialog informing you that you are about to interact with external functionality. The dialog asks you is if you want to not allow it, to allow it once, or to allow it always for that external functionality. I…
-
structure of a web service published in Business Central
Hi Experts!! I have published a web service (via a published CU) to import data from an xml in Business Central. When I see the schema from SOAPUI these two labels appear in the structure that I have highlighted in the attachment These labels correspond to the published CU function and its parameter But as you can see, the…
-
Import Picture in BC 18.0 (Cloud Environment)
Hi all experts, I would like to ask about the import picture's coding. In BC 18.0 (Cloud), it is no longer support FileManagement.UploadFile() function. If in the cloud environment, I want to select a picture from my computer, what should I do? Thanks. bestian
-
Automatically declining sales price for each trip.
Hello I have a serouselly question in the nav 2016 how to Automatically declining sales price for each trip., for exemple Tripr one it lunch for start date 01/01/21 to 01/01/21 with sales price record from contrat for item No 000001 = 100 $ When shipped the first delivery unite price get from contract but when i send a new…
-
Error when run customized report "Adjust Exchange Rates"
In Dynamics 365 Business Central OnPrem, when we try to run Adjust Exchange Rates report we get an error "The value "409*" can't be evaluated into type Integer". The report is not the standard one. We copied the standard one and add some changes. The problem is I cannot figure out where the error comes from. When I clicked…
-
FIFO Unit Cost with lots
Hi all, For what i understand NAV allows the item to be batch(Lot) tracked Purchases: Posting date = 01/01/2021 Item code = A Qty = 1 Item cost = 1000 Lot No = A1 Posting date = 02/02/2021 item code = A Qty = 1 Item cost = 2000 Lot no = A2 When we make a sales order : Posting date = 03/03/2021 Item code = A qty = 1 Item…
-
Retrieve value from XML file with <
Hi I am trying to retrieve values from a retrieved XML file after making a POST webservice call. The structure of the returned XML file is - <?xml version="1.0" encoding="utf-8"?> <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"…
-
Auto import file from folder (Job Queue) - Cloud BC
Hi all, for cloud BC, are we able to auto import file from certain path or folder? 3rd party will export file to the certain folder.. then BC need to auto import from this folder. Thanks.
-
External Tables and distributed transactions
Hi all, I am a fan of External Tables. I prefer them to the linked objects for their flexibility and no mandatory use of views. I have a problem with this scenario. I have the SQL instance of Nav on a server while the external table points on a server on another instance SQL. I have to write in the external table some…
-
NAV 2015 Bug? TableRelation and Enabled with condition
Recently I encountered a reproducable NAV 2015 client crash that took me a while to understand. Table "A" contains a field "Ref B"(Code 20) that is used to reference Table "B". Therefore the Field "Ref B" has its property TableRelation to "Table B"."PK Field". Page "Card A" uses table "A" as SourceTable. An action "Show…
-
BACS bulk file missing
hello! in the old nav there is export bulk option.where is this in the new nav
-
BACS - how to chnage the exported file format
hello, how do you chnage the bacs format in the exported file
-
Export to Excel
Hello, a user have to connect to navision using RDP. When she tries to export Vendor ledger entries to Excel, a blank Excel sheet opens. When she tried to copy the lines from Navision and paste it on the Excel installed on her Laptop, the format of the amount changes. For all 4 figures amount, the formatting is as Text and…
-
Zetadocs Express Addin unable to open docs without Internet Explorer
As Internet Explorer is being discontinued later in the year, we have started disabling it in pcs. An issue we discovered though is Zetadocs Express addin is unable to open any documents without IE. Nothing happens. We raised it with Equisys, who informed us of the below KB.…
-
Webservice with table datapercompany=no
Hello, Business Central Spring Edition, We have Table1, with datapercompany=yes. this table has a field with a relation to table2 table2 is datapercompany=no. Via webservice, we add a value to table2 and after, add a line to table 1 => Error : related info in table1 doesn't exist ... If we look into the table with classic…