-
Error while opening sales order in Nav 2016 equiped with SQL 2014.
Hi All, Below is the error while opening Sales order. Error: Microsoft Dynamics NAV Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CS_AS" in the equal to operation. Statement(s) could not be prepared. Page Edit - Item must close.OK Thanks in advance, Srinivas.
-
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 :=…
-
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.
-
NAV 2016 India - Reverse Transaction Error
Dear All, I am getting text overflow error in T-179 while trying to reverse a vendor ledger entry transaction. when i checked the code i see that GLEntry."External Document No." which is 35 characters long is beging passed as filter to DetailedGSTLedgerEntry."Document No." which is standard 20 characters. I find it…
-
costing
Hi, i purchase a Raw material with unit cost 10 qty @ 10 rs total amount is 100 rs, and also consumed 5 qty out of that, later on i found unit cost is rs 20 per so i use item revaluation journal, at rs 20. but i only ravalued for remaining qty , i want to load cost on complete purchase of 10 qty and also want its cost…
-
item of type "non-inventory" on BOM, problems with planning worksheet in BC365V14
Dear colleagues i face the problem, that if I have a item of type non-inventory on a BOM, planning for the BOM-Item can not be performed. I always get an error-message: The field Item No. of table Planning Component contains a value (0082.100) that cannot be found in the related table (Item). the item of course is there,…
-
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…
-
BC14-list with values from all dimensions, instead of selected Dimension only (Filter on List Pages)
Hi all, I have experienced strange BC14 (14.0.35570.0) behavior. On the List Pages (Customers, Vendors, Chart of Accounts) for that specific RTC version when we select to filter (Show results ... Where ....) per any Dimension, after dropdown in the list for values we have listed values of all possible Dimensions in system,…
-
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…
-
Job Queue with Task Scheduler and User ID
Hello, I am facing problems in NAV 2018 with the Task Scheduler that runs Job Queues. When a new NAV session is opened, all Job Queues are rescheduled by the codeunit Job Queue User Handler (function RescheduleJobQueueEntriesOnCompanyOpen). My troubles come from the fact that these tasks will be executed on behalf of the…
-
Direct Applied Account Entries not Updating on PO
Hi, The PO entries were working fine, but due to heavy locking issue, i unchecked the Adjust cost to G/L boolean on Inventory Setup. After this Direct Cost Applied Account entries are not posting to the G/L for posted purchase Invoices. I have tried running the 2 batches: 1. Post Inventory Cost to G/L report with Per entry…
-
Sync-navTenant Problem
Hi, did anyone had the problem with Sync-navTenant related to Metadata.MultiLanguage. Here Log from EventViewer: Type: System.ArgumentException Message: An item with the same key has already been added. StackTrace: at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at…
-
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…
-
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.
-
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…
-
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…
-
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
-
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?
-
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.
-
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…
-
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…
-
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,…
-
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…
-
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.
-
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…
-
Change Listener RTC Connection Error 26
Hi, i try to setup Dynamics NAV 2009 R2 and get the following error message when connect through RTC. "The Microsoft Dynamics NAV Server cannot connect the Change Lisener to SQL Server because of the following error: A network-related or instance-specific error occured while establishing a connection to SQL Server". The…