-
Error while opening Bank Account List in Dynamics NAV 2016
Hi all, Below error is getting when opening Bank Account List in Dynamics NAV 2016. Error: Microsoft Dynamics NAV Hint 'noexpand' on object 'Test.dbo.24 Mantra$Bank Account Ledger Entry$VSIFT$1' is invalid. Statement(s) could not be prepared. Page Edit - Bank Account must close.OK Thanks in advance, Srinivas.
-
How to convert blob field to base64 format in BC 16
Hi guys, May I know how to convert blob field to base64 format in BC 16? Thank you.
-
How to create a Reservation Entry?
Hi experts, I'm using NAV 2015 and have created a purchase table with some purchase lines. Now I need to register one or more Serial numbers and/or Lot numbers regarding one of the lines. How do I do that using C/SIDE code? I have tried this, but it doesn't create anything: // I have found the purchLine doFullReserve :=…
-
LS calculate statement warning with BC14
Hi, I'm using LS14.02, when running Calculate Statement, got following warning messages: Warning - 17 Transaction Header records were found from POS Terminal xxx, 34 were expected Warning - End of Day Declaration is missing for Store xxx, Staff Any idea what is missing? Appreciate your help.
-
Something went wrong. Cannot build the page xxxx. The metadata object Page xxxx was not found.
Business Central 365 Sandbox. Getting the following error when I try to publish from VS Code project. The code has been working for 3 or 4 days without issue until recently. The table x is the source table for the page x. There are no table relations defined in table x. Something went wrong. Cannot build the page x. The…
-
Error while connecting to development environment in Dynamics NAV 2016
Hi all, I'm getting below error while connecting to development environment in Dynamics NAV 2016. To be precise on issue we have a virus attack and all the mdf and ldf has been encrypted and we recovered the DB, after recovering the DB we have successfully connected to SQL and all the sql queries are working fine. To…
-
Sessions - Debug issue in RTC Only!
Hi Mibuso.com :) ! When I call a Session in RTC it is trying to link to the wrong Server Connection. I put in the correct Server Connection but this just opens a new RTC Session! If I call Debug from the DEV Client Environment - this works no problems! How to call Sessions from the RTC please?
-
Need to add a non-table field to a card page
I have a card page with a lookup. I want to display a field from the lookup table on my page. For purposes of discussion, let's say my lookup is into the Item table and I want to display the matching Item Description. I defined a global var ItemDescription and decorated it with the [InDataset] attribute. I can add it as a…
-
Two or more Joins at the same level in Query Object
Hi, how can I make two or more Joins at the same level in Query dataitem(Sales_Invoice_Line; "Sales Invoice Line") { dataitem(Dimension_Set_Entry; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Sales_Invoice_Header."Dimension Set ID"; SqlJoinType = InnerJoin; ... } dataitem(Sales_Invoice_Header; "Sales…
-
How to use the ODataV4 web service to get the item picture in Visual Studio 2017
Hi guys, May I know how to use the ODataV4 web service to get the item image/picture in Visual Studio 2017? Any expert can help me on this or provide me the sample? I had installed the OData v4 client code generator also but still cannot get it. Thank you.
-
BC License Backward Compatibility
I have tried googling and searching this forum but was unable to find a clear answer so i hope i am not reposting a previously asked question and if so then please point to the old post :) Is there any documentation or clear answer from Microsoft in regards to the backward compatibility of BC licenses? I need to know if a…
-
How to inspect pages in Dynamics NAV 365 V16 ?
In this version, I don't know how to inspecting pages or see about this page, What should I do? Thank you so much.
-
Refresh Server Instance table
Hi, I am using NAV2018. But I have seen this issue in NAV2017 too. I often back and restore databases to make copies of them to run on the same Server Box, but on different NAV server instance (running on different port nos). But often I face a problem where the copy of the database refers to the old NAV server instance,…
-
XMP import problem
Hi! I have made an xml import, I am importing a cell as follows evaluate(table.field, myfield) table(field, myfield) the problem is if i do message before and after this code I am getting empty value and there is a value in the cell. the vaue is 'text01234'. if the vaue was only 'test' it would be okay why and how can i…
-
Generated Hash is using UTF-8 Encoding, while XMLDoc will save in UTF-8 BOM Encoding
Hi, I am using Microsoft Dynamics 365 Business Central, version 14.0.29530 I have to send an xml via HttpRequest that should have a validation hash. This hash is generated based on the whole file to be sent, so these are the seps: 1) Generate XML (without Hash) 2) Write XML to InStream 3) Use EncryptionManagement codeunit…
-
Business Central accounts
HI I have imported my GL accounts via config package without any errors, however if i want to setup my Gen Posting Setup or Customer Posting Groups the list is blank it doesnt show my accounts, please advise I have applied the package so its showing under my chart of accounts
-
Job Queue entry
Hello, I am currently using NAV2016. I want to know what causes the job queue entry to set the status as Finished? At times, the status of the job queue entry has a status as Ready but the message indicating "Metadata is not in sync for table with ID XXXX. Please try again or contact your system administrator" is appearing…
-
NAV 2017upgrade
Getting an error when opening RTC - "There is no company in the Database. Contact your system administrator." They are there. Ran the New-NAVCompany cmdlet and added a new company. User is a 'Super' and all tables synced.
-
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
-
Webclient new instance errors
Hi, I am working on a BC2018 CU3 project and got problems opening the web client. This is a non default instance. What I have done so far: * Created a new Cronus database and server instance using the Service Tier Administration (Version v3.4.0.0). The service tier and database are on the same server. * I have verified…
-
Page OnAfterActionEvent not refreshing page
Hi, We are in the middle of migrating from C/AL to AL. As a first step we are replacing as much custom code with events. Now I am working on a page with a custom action. The code beind is:* Execute a Function in a Codeunit, Rec is passed as VAR * This codeunit changes the Rec * CurrPage.UPDATE, changes are reflected on the…
-
How can I access multiple databases from the Dynamics NAV RoleTailored Client?
I am trying to config another database for test but l cannot find the path with service. What l have in my path is (C:\Program Files (x86)\Microsoft Dynamics NAV\60\RoleTailored Client) inside this path I cannot find the custom.Settings.config file so that l can change the database name
-
Can we integrate NAV 2016 with Go-Frugal.
Hi all, Can some one please suggest on how to connect to GoFrugal from NAV 2016 to sales order and Cash Management integration. Thanks in advance, Srinivas
-
Intercompany Journal Lines, only shortcut dimensions?
Hi, I'm using NAV 2018 CU3. Seems like posting of Intercompany Journal Lines only forwards dimensions that is specified as shortcud dimensions in G/S Setup. Bug or limitation? Any idea?
-
Sales Return Order - Wrong goods physically sent compared to posted sales shipment
Hi, I have a scenario where we have shipped Item A according to Nav but in reality we have physically sent Item B. I want to use a return order to arrange the collection\receipt of Item B back from the Customer. However as from the Nav perspective it never left stock I don't want to do a receipt or credit the customer for…
-
Can't subscribe to OnAfterLogInteraction in CU5051
I need to run a process after an interaction log entry is created, but I can't seem to be able to subscribe to the above captioned event. any tips? thanks
-
BC14 OData Request Error (Only sometimes)
Hi all, BC 14 version 14.0.38650.0 We have OData set up and are experiencing problems when connecting. Sometimes it works like a charm but sometimes we get Request Error with the below error message on the server. If i refresh the call it sometimes work and sometimes don't. <EventData> <Data>Server instance: prod_ws Tenant…
-
Email Logging
Hello, I have set up Email Logging and initially this was working fine and now it isn't. I have a Salesperson with my email address used. I have a Contact set up with a colleagues email. Once the Job Queue runs and moves the email from Queue to Storage no new Log Interaction Entries are created. There is no bespoke at this…
-
Error while installing Business Central 16 Wave1.
Hi All, Below is the error while installing Business Central 16 Wave1. Error Details: Microsoft Dynamics 365 Business Central Build 14073 Error Report SQL Server Database Components Cronus Sample Database for Microsoft Dynamics 365 Business Central Fatal error during installation. Database 'Demo Database BC (16-0)' cannot…
-
Error 701: Azure Key Vault
Hi BC 16.2, we see this alot, anyone knows whats wrong? There is not setup any Azure key vault, but is that required at all? It runs as an onPrem, on azure VMs Server instance: PROD Category: Azure Key Vault ClientSessionId: 6a295346-70c9-4d7c-a5a8-9f4b564aa735 ClientActivityId: 16f53968-b2d3-4f59-b527-0eedd770b481…