-
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…
-
Problem using TLS12/13 for connection with webService
Hi everyone, I am working with NAV 2018, installed windows server 2012 R2 standard. I have created a a few years ago an integraion with an external webService. it is working perfectly, but they are changing the security protocol to use TLS 1.2 or 1.3. The system administrators from the webService gave me a new URL for…
-
Problem with jobs in the work queue
Navision 2018. Created a job in the work queue. Registered the schedule. The validity period is not limited. Everything works, but from time to time the task stops working. No error messages. What could be the reason for such strange behavior?
-
Illustrator Tech Pack Fashion integration NAV
Hello, I would like to discuss a possible project to implement and i would be open to read some ideas. Designers fashion use Illustrator or speadsheets to make their tech pack fashion. Imagine a scenario where designers build their tech pack in illustrator and the goal here is to intregate with nav's manufacturer so that…
-
SetRange in Dataport
Hi, Primary: Boolean Item: Code 20 I'm trying to import a CSV file using Dataport. This CSV file has multiple records. I want to check if there are any records in the table before importing the CSV file, if so, then if their Primary field is true, then before importing the CSV File I want to set that Primary field to be…
-
Trying to openEdit a General Journal TestPage
Hi, I'm trying to test the Post Action in TestPage General Journal, but when i use the OpenEdit() it always returns an error saying that i can't open the page. If i don't put this option the returned error is "This Page is not open". Here is my codevar
LibJournal: Codeunit "Library - Journals";
GenJournal: TestPage…
-
Batch Report
Hi everyone, I'm trying to create a batch report/routine that automatically updates all open POs that contain items that have had their purchase price quotes updated. This batch report will update the relevant cost/etc.. information on the purchase order lines from the item card Can anyone please help me with such a task!?…