-
How to increment a field value if it has same another field value
In Nav 2009, I am creating a dataport export where I am taking values from g/l entry table. My question is For suppose if we are having document no as 'qwerty123' I need to keep '1' in another field 'numbers' and again if I have the same same document no in next line the field 'Numbers' should be incremented by 1 and…
-
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!?…
-
Insight works shop floor
Does anyone have experience with Insight Works shop floor for BC and is willing to share
-
Warehouse management
Hi all, If I need to restrict shipments (only direct shipping) from a particular BIN, which setup needs to be activated? I know there is a setup on Bin "Block Movement" for inbound/Outbound/All, but that doesn't work correctly. Thanks in advance!
-
UseWindowsAuthentication for SaaS
Good afternoon. I have an App working for OnPrem with this line: HttpClient.UseWindowsAuthentication(User(), PasswordF()); I need to migrate to SaaS, and then I get this error: The type or method 'UseWindowsAuthentication' cannot be used for 'Cloud' development. How can I replace HttpClient.UseWindowsAuthentication for…
-
Description formula in Recurring Journals
hello, is there a way to have something like "payment 10 out of 20" in recurring journals? Obviously, the next one will be "11 out of 20" etc etc Is there a way to make this work
-
HTML Parse
I have a problem with the HTML editor, my editor doesn't read the special characters like ö and ü etc. correctly. can tell me where the error is please.
-
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.…
-
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…
-
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
-
ne wimplementation
hello, for a new implemenation I have a couple of quesitons - do the clients need to do the period end and year end in new or old system. I think no because that would give them the option to post adjustments, right? Also what else do I need to check? Any advice is welcome
-
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…
-
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
-
How can automate the serial number assignation
how can i automate the serial number assignation to the released component and insert the serial number in reservation entry
-
Insert Sales Lines AFTER Sales Header complete Or aster MakeOrder complete
Hi All We want to insert freight charges (non inv items) on sale orders automatically. The item inserted will be dependent on the ship method. We have a version that works using a event subscription on the ship method code in sales header Works great when I change the ship method, but I have 2 problems 1. if I create a new…
-
Automated Testing: Check Validation Message
Hi All I'm writing automated tests for one of our extensions and I need to confirm that the validation message is correct as part of the test. Let's take a simple (made up) case Record.Field1 cannot be more than 2x it's current value. The extension would have an Subscription to the OnAfterValidateEvent and raise an error…
-
How to correctly read XML to import the data into a table?
Hi, Currently I have a procedure that reads and imports some elements from the XML to a table correctly, I only need to read some elements well, since some fields are repeated when they are imported. I get the XML of a response from a WS, the response is stored in InStream and then I read it to import the information into…
-
EU VAT Reg No. Validation Service Setup
Hello, Does anyone know if or when a service will be available for UK to validate VAT Registration Numbers? This was previously available via the service connection "EU VAT Reg No. Validation Service Setup" but is no longer valid since we have left the EU. Thank you.
-
NAV 2009 R2 - Default Label Printer Settings Not Working
We use a Rollo label printer for some product labels. The labels are 61mm (wide) x 47mm (high). Everything is properly setup on the printer settings, but when I send a print job to it from NAV, the default label sizes are being overridden by NAV and it's picking some random label size. Each time we print to it from NAV, we…
-
Dash Board - Dynamics NAV Web Version
Figures are coming with out separating thousands, ("000). But if we change the language code to Srilanka (Sinhala), then only it's coming perfectly. any one know how to configure same to English.. ??
-
wave 2 Add-in not found
I want to use control add-in in my project on wave 2 With setting But I have this error An assembly named 'Microsoft.Dynamics.Nav.Integration.Office, Version=13.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' could not be found in the assembly probing paths 'my folder\./.netpackages, C:\Windows\assembly,…
-
LS POS Button Property Card does not have OK and CANCEL buttons. Cannot save button changes.
There are three POS in the store. It seems that all are configured the same way, but one out of three doesn't have OK and CANCEL at the buttom of the Button Property Card. What can cause this issue?
-
Quickentry not working?
hi All, hope someone can help. It seems like we don´t have nextcontrol anymore so I placed quickentry in few fields. However it seems not to work (it goes always to the next field and then to the top of the page). Do I have to set quickentry=false in all the remaining fields? Thanks. Edit: I will answer myself: On classic…
-
How can I install Test ToolKit on an existing Azure Container?
I have created a Business Central conatiner in Azure using az container create ` --resource-group 'RG-Container' ` --name 'democontainer’ ` --image mcr.microsoft.com/businesscentral/sandbox:13.1.25940.26323 ` --dns-name-label 'democontainer’ ` --port 80 Once installed, how can i now add / install the testtoolkit ? I dont…
-
Nav 2016 Web Services Pausing
We use Nav 2016's web services for various minor tasks. All has been working well for years, but yesterday we started getting random slowdowns that seem to consistently last 2 minutes. For example we'll send a command to update an order, let's say changing a checkbox from checked to unchecked. The response will take a…
-
Lot Expiry Dates on Whse Item Journals
Hello, When items are booked in during the putaway, a lot number expiry date is applied. However we have a situation that Warehouse entries based upon Whse Item Journal lines are not carrying the expiry dates. Is this supposed to be this way, or is there missing setup to carry these dates? Thanks
-
NAV 2013 R2 with Azure AD authentication
I'm trying to configure app registration from Azure AD for NAV 2013 R2 using Access Control Service (ACS) credential. the web client is working well and can login using azure AD account, but the windows client having some error as below: Understand NAV Windows client does not fully support Windows Azure AD and we can only…