-
How to resolve '_' is not a valid AllXsd value?
Whilst importing data from a CSV file using a data exchange def - I get the following error > A call to System.Xml.XmlConvert.ToDateTimeOffset failed with this message. The string '04-04-18' is not a valid AllXsd value. How do I reslove this?
-
NAV2018 Service - System.ObjectDisposedException
Hello, I'm trying to setup a service that allows me to use VS CODE. So I set the service with "Enable Developer Service Endpoint" but after that the service doens't start anymore and the event viewer retrieves the System.ObjectDisposedException error. I just have 1 service in this machine and the endpoints are not…
-
Log segment: custom layout
Hi, I just tried to create and log a segment with a interaction template using a custom (word) layout template. Unfortunately the E-Mail sent out does not contain the content from the custom layout but only a few random numbers. If I do the same for just one contact via "log interaction" it works fine. I'm using NAV 2017,…
-
There are some BPV invoices that have been posted and is reflecting the g/l accounts. It can also be
Hi Guys, There are some BPV invoices that have been posted and are reflecting the g/l account. It can also be seen in the G/L Entry table. But not in the G/L registers page? Why? and how can i print or open those entries? Are they compressed to a similar posting type group or what. Why does it happens and what is the…
-
Using DLL in NAV 2017 - Run on client - "true" works fine - but run on client "false" fails
Hi, I have written a DLL and installed it in the add-on folders on both my server and my client. When i try to use the DLL in a codeunit it works fine as long as i define the - run on client property to "true". - but then ofcourse i can't use "with events". When i set the - "run on client" to false i get an "object…
-
Does anyone has any idea on how the Navision encrypt / decrypt works in NAV 2013 ?
I am trying to encrypt a text file and save the encrypted file in the disk. Then, use the encrypted file to decrypt and write the contents back to another text file. For the encryption / decryption, I am using the NAV codeunit 824 Encryption Mgt. functions. Although the encryption part seems to work, but when I try to…
-
PowerBi reset autoregister
Hello all, Somebody registered my powerbi in azure for NAV2018 and it does not work, so I want to "reset" it. Or at least change the app id. Anybody knows how to do that?
-
No Power BI account in NAV 2018??
Hi all, I have a very annoying problem. I have registered Azure with Power BI in NAV 2018. But now NAV is telling me I don't have a PowerBI account (see image below), which, offcourse, is not true. Any ideas are welcome!
-
LS Retail Extended Variant issues
Hi We have just started using LS Retail and is facing huge performance problems around the Extended Variants. We are using version 10.00 (new version) with NAV 2017 We have converted from older system (also with variants) and therefor we have quite extended Variant Framworks. We have maybe 800 colors and 10 sizes in a…
-
How to rename an Item which consists a hidden character (ENTER)
Hi There, NAV2013R2. I have a few Items in my database where there are hidden characters stored in their codes. When I am opening the Item Card i am getting an error message like this: The record that you tried to open is not available. The page will close or show the next record. Do you know how to rename such an Item? Or…
-
Hesitating debugger
Hi all, 2009 - classic. When using the debugger it seems to hesitate and only move forward if I continously move around with the mouse. Rather annoying. Do anyone know the cure for this? Thanks
-
No Copies is not working
Hi everyone, I'm trying to create a shipment order but when I put 2 in my Number of Copies the report only prints one page.. and must have 3 pages understand? So I have in Request Page Expanded Type SubType SourceExpr Name Caption 0 Field NoOfCopies <Control1> N.º Cópias And in my Code: CopyLoop - OnPreDataItem() NoOfLoops…
-
Web client when new line is being created previous changes type
When new line is being created on a document previous changes type to the 0 option. The options are table,field,const etc. When the row (except first one) is selected and u create a new line, the new line appears but previous changes source type to 'Table'. The same behaviour when you reopen document, line which you stay…
-
Using Transparent Data Encryption (TDE) with Dynamics NAV
In case you have an urgent need for encryption at rest for your Dynamics NAV installation, we just declare support for Transparent Data Encryption... https://blogs.msdn.microsoft.com/nav/2018/04/26/using-sql-server-transparent-data-encryption-tde-with-dynamics-nav/
-
With NAV 2017 - Print and Send to Excel
We are having issues with NAV 2017 doing a Print and Send. We are accessing NAV 2017 through Citrix.
-
Filter Tables from code where TableType is not Normal
Hi guys, do you have any idea how to filter out tables where the TableType is not Normal? Cheers, Marton
-
Output cost is reversed in NAV
Hi, We have an Item on Standard Cost. We noticed that when we posted an output from Prod. Order, the cost is posted and reversed immediately, meaning system created a negative entry also in value entry. We checked the inventory value zero is false for this Item. and this happens only for a particular Prod. Order and not…
-
Trying to use codeunit 419 File management to show a dialog
I am new and trying to show a dialog with an image on it. The image content is stored as BLOB. I want to show this image on the dialog with OK button. I tried to use codeunit 419 FileMgt to do this. Is it possible? Any expert suggestion?
-
nav Report Sales orde
In sales line there is tow fields quantity and quantity shipped. i want to subtract the the two values and get it in report. The line value should print in Remain QTY1 and second value should print in Remain QTY2 and 3rd value should print in Remain QTY3 if more lines are there then it should print in Remain QTY3 The…
-
ADCS - Custom Field
Hello there. I need help with ADCS and looking for Ideas. I have a simple miniform, getting info from the purchase line. I enter the PO number Then I enter the Item number. A custom field populates with a value in that field that exists on the PO Line. I want to be able to overwrite that value with smth else from my…
-
Attempt to post Jnl Line clears ShortCutDim3 and then complains about missing Dim3
(NAV2016 - Platform CU8 build 45046, Application CU5 build 45243) I have a client who recently started using the third dimension, after having used two dimensions for years. They have some G/L Accounts set with Code Mandatory for the third dimension and also set up with a default third dimension. In most situations, this…
-
Accounting Period in DB1 FA Depreciation Method
Hi all, As we know, the standard DB1 depreciation method of FA in NAV is considering the system's accounting period when calculating the depreciation. For example, if the depreciation starting date is 1 March 2018 (No. of depreciation year = 4) and the accounting period is from Jan-Dec, by using DB1 depreciation method,…
-
Report for Inventory Received during a date range with quantities, costs, and totals
Is there an existing report in Nav 4.0 SP3 for Inventory Received during a period with costs? All I need is to show received dates, quantities, costs, with totals for a given date range. If not, what's the fastest way to create one?
-
Dynamic rectangle size inside a table row
Hi all, I have a rectangle placed into a table row. It contains another table inside with hidden expression on several rows. My problem is when the table is smaller than its max size (for example 2 out of 7 rows are visible) the size of the table row that contains the rectangle still 7 rows high. how can I make it…
-
NAV2018 AL XMLPort Issue
Blijkbaar zit er een bug in NAV2018 wanneer je een XMLPort overzet van C/AL naar AL en je een veld van het type RecordId gebruik. Iemand dit al heeft voorgehad? Bij het builden voltrekt zicht de volgende fout uccess: The package is created. [2018-04-10 07:29:43.61] Sending request to…
-
Shipping in UK
What are the major shipping companies, and what is the add-on used in UK ? In Sweden I use LogTrade covering schenker, Bring, DSV, DHL, PostNord In US I use Lanham E-ship covering USPS, UPS, FEDEX I'm wondering what to use in UK and what shippers it covers?
-
ADCS VT-100 emulator
Is there a way to switch between VT-100 emulators when using different NAV versions? I'm trying to do some ADCS testing between 2 NAV versions (NAV2016 and NAV2018). I have the NAV2018 emulator up and running. But how can I switch emulator if I want to run it for NAV2016?
-
Pin in a specific field/column of purchase line
Good morning, I need to know if there's a way to insert a new item in purchase line starting in the column "nº". I need this because with bar codes pistol is easier than type "produto" in the column "Tipo" and then go to column "Nº". thanks a lot!
-
Cost , Purchase Price
Hi How to get the Cost , Purchase Price of Item in Lot Wise Stock report using query. Thanks
-
Calculate Purchase Field in a page
Hi, I have create a page which contains: 1. A Group where I can filter with: - Date Filter from table Item - Item Ledger Entry Type from table Value Entry - Entry Type from table Item Ledger Entry 2. A Group -> Repeater where I have - No. from table Item - Description from table Item - A variable Purchase where I need to…