-
HTML Speces in XML Document
How can I read in HTMLSpecs from XML document and save them in a table?
-
how to read blob data from c#
As you knows , NAV could store big Text string data type to BLOB data type in sql server. It works fine in NAV read and write. //---write CLEAR(Ostream); myTestRec.INIT; myTestRec."No.":='SO123456'; myTestRec."Line No":=10000; myTestRec.Comment.CREATEOUTSTREAM(Ostream,TEXTENCODING::UTF8); Com.WRITE(Ostream);…
-
How to handle errors for HTTPWebRequest.GetResponse call?
When HTTPWebRequest.GetResponse is called and no proper response is returned from the server, the code stops executing and returns some random error. I want to implement proper error handling, so the code keeps on executing without stopping here and a proper message is displayed to the user. Like we apply checks on status…
-
AL: Lists and Dictionaries
I've been looking for a good way to use the new variable types List and Dictionary to replace the use of temporary tables. If anyone here has code snippets to share on how to implement those new buffering tools in more complex ways it would be very welcome! So far I came up with this: // Welcome to your new AL extension.…
-
Transfer user accounts to another database
Is there a way to transfer user accounts and permissions (NavUserPassword Authentication) to another database with their passwords? Dynamics NAV 2018
-
permissions for receipt but not for to invoice in purchase order
Business Central. Hi experts!! I need some users to only be able to receive and not invoice purchase orders. However other users should only bill and not receive. I've created a new permission copied from "D365 PURCH DOC, POST" but I can't separate these two features. you know if it's posible?? Thanks in advance!!
-
How to add date stamp field when boolean field box is checked
When boolean box ix checked, i want the current date to populate a date box next to the boolean box on the page NAV2018
-
Auto Export of Item List
Hi Experts, I need to automatically export data (Item List) from NAV 2018. I've been searching online and got a clue that I must create a codeunit for this and use a job queue, but I really don't have a background in writing script. May I know if is the right way to do it and where I sould start?. Thanks in advance.
-
Payment Entries Appearing on VAT Exempt Section of VAT Statement Report
Good Day All, I have a Business Central Query Regarding Payments Appearing on the VAT Exempt part of the VAT Statement Report: I've Navigated to VAT Statements on Business central as seen on VAT1.png And once the VAT Statement Report Opened, I quickly Clicked On Preview as shown on Preview.png This opened up the VAT…
-
Setting Change_Status on Service Contract Header
Unable to Open & lock Service Contract Header : ServiceContract contract = new ServiceContract(); contract = css.Read("SK-99999"); contract.Change_Status = Change_Status.Open; css.Update(ref contract); contract = css.Read("SK-99999"); contract.Change_Status = Change_Status.Locked; error -> css.Update(ref contract); Errors…
-
How to disable "Go ahead and delete " notification when deleting lines on the warehouse doc. page?
Hello, How to disable this notification when deleting lines on the warehouse document page? Thanks!
-
Is over pick possible on the pick ticket for a production order?
Using NAV 2013 R2 Hello! We are trying to implement picks for production orders but Nav doesn't allow us to pick more than quantity on pick ticket. Reason why we need to do this is our scrap on production runs varies very often. Example, we a production order of finished goods calling for 100 labels. To set up the labeler…
-
How to call "New" system action on Test Page
I am making a test function in which i have to invoke system "new" action on list test page to open card test page and then in page handler set random values to fields on card. How can i achive this result? There is for example Edit() function which invoke system edit function, but there is no analogously function for…
-
Transfer Orders Question
Hi, I am doing an Item transfer from 1 location to another via Intransit locations. However, I see some differences in a few of the Posted Receipts & posted Shipments. For a few TO, I see the G/L entry Created, but for a few TO the G/L entries are not created. These GL entries are posted with a description as "Direct Cost"…
-
close year in old or new system
hello, I am doing new implementaiton should my client close the year in the old system or new system thanks
-
Debugging Business Central
Hi experts, We have a question regarding debugging. As I can not find a proper answer to my question I am asking it here, hoping to get an answer. We are working with Business Central version 17.4 onprem. We are wondering what the best way of debugging is when we want to debug our customers production database? We know we…
-
Type conversion is not possible Text + Integer
I'm trying to compile some runtime upgraded object 2009->2013->2015->2016 and i get this error But Counter is Integer and not a text, even if I delete it as a variable and add it again the error comes back, this counter is printed multiple times in this report, so making a new variable with a new name is not optimal for…
-
How can I change the default value of a field in BC?
Hi, How can I change the value of a boolean field in a table or page? For example, when adding a new item, by default the value of the Blocked field is false, but how can I change it to true in code since the Item Card is opened?
-
Upgrade v17 -> v17.2 Publish-NAVApp : Extension compilation failed
Bit stuck with v17 upgrade to v17.2 PS C:\Windows\system32> Get-NAVAppInfo -ServerInstance BC170 -SymbolsOnly Id : 8874ed3a-0643-4247-9ced-7a7002f7135d Name : System Version : 17.0.19353.19730 Publisher : Microsoft ExtensionType : ModernDev Scope : Global When publishing Base App: Publish-NAVApp -ServerInstance BC170 -Path…
-
Report dataset - DataItemTableView sorting
Hi Guys I'm trying to understand DataItemTableView in report dataset in AL. What's the point of sorting here and is it better to sort or not sort and performance implications? below is an example: dataitem("Purchase Header"; "Purchase Header") { PrintOnlyIfDetail = true; //remove header without detail RequestFilterFields =…
-
BC App Publish - Digital Sign
Hi, I need urgent help My first app is ready to publish on app-source, it is only 1 issue to solve to go-live I need to digitally sign my app I have tried everything but nothing working https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-sign-extension…
-
Report Issue
I am trying to add field in report but when i am trying to preview Field is not showing. 1) i checked visibility also., its not hidden
-
Adding DotNet3.5 to NAV2016 Docker Image
Hi all, Is anyone using Docker containers to do development for NAV2016? We are building individual docker containers for each developer/enhancement. We have an addon from an ISV that uses an addin dll that needs DotNet3.5 in order to compile and run. The standard NAV2016 container images/artificacts use the Windows Server…
-
Manufacturing Finance Assistance required
Hello, Some bad bespoke has resulted in Inventory WIP still being present in Finished Production Orders. We could Create a General Journal to migrate the WIP Value from the WIP G/L to the Finished Goods Adjustment G/L Code set up. This however still leaves the Value Entries in WIP and therefore an unbalance. How is it…
-
Upgrade BC Version 13 to Version 17 without C/AL changes
Hello everyone, this is probably a question with an obvious answer but it's still early in the morning and I can't get it out of my head. If I do an Upgrade vom Business Central Version 13 to Version 17 without having any custom changed objects in C/AL (We've already been programming in AL and have thus an…
-
Why no Notification data type in navision 2016
Why no Notification data type in navision 2016. How could I get Notification data type.
-
Where does my Item.Picture hide?
In a BC13 (Build 28871) I have a report written in al/rdlc where I want to include the item picture that is displayed in the item page. * First I just just included the Item.Picture in the dataitem column, but for some reason not all the pictures where included. * Then I changed the code to repeat through Tenant Media…
-
Belgian localisation
Hello, i am using the Belgian localisation. I would like to know which protocol (Domestic, International, SEPA, Non SEPA) if i need to pay a vendor in USD who is in Belgium? Note: Belgium forms part of SEPA
-
RDLC report with Item table left join to purchase line
Hi Guys I thought when creating the dataset in AL I have the option to determine join type but couldn't find it. So my requirement is to show all items and for items with open purchase order lines, show the next delivery dates in columns. I used below link to link po line to item: dataitem("Purchase Line"; "Purchase Line")…
-
Want to create sales order for each line from sales quote
Hi All, I have created a sales quote with multiple lines added. Here i want to to create a different sales order for each line of sales quote. Explanation: I have a Sales Quote with two lines(X and Y). While i am clicking the 'make order' button in SQ page, It should create two different Sales orders one with item line X…