-
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…
-
Single sign on for windows account
Now I have used Axapta 3.0 and I am trying to setup windows authentication enabled. So I have enabled 'use windows NT/2000 authentication for the clients' in setting for AOS and input the windows account in 'Network account name' in user options. And then, I have tried to login but login failed. The error message is…
-
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,…
-
Dynamics 365 Urgent assistance
Hi, is there any documentation or tool to extract the as is processes from Dynamics 365 F&O
-
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…
-
Generic onModifyRecord for all tables
My company needs me to add some code every time the user tries to modify any of the fields in all the pages (for example in the customer card and in the item card). I want to know if there is a generic event to which i could subscribe to(like onModifyRecord ) that gets called before the modification of ANY OF THE FIELDS OF…
-
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
-
DocXtender
DocXtender Easily drag-and-drop documents to pages in Microsoft Dynamics 365 Business Central. DocXtender from Insight Works is a free utility that enables users to attach documents to any page in Microsoft Dynamics 365 Business Central with a simple drag and drop. DocXtender works with any page in Dynamics 365 Business…
-
PrintNode Connector
PrintNode Connector Connect your local or network printers to Dynamics 365 Business Central Cloud. You need to be able to print multiple reports and documents to different printers without having to print each one individually or print to PDF. The Insight Works PrintNode Connector is a free add-on that allows you to make…
-
Barcode Generator
Barcode Generator Add 1D and 2D barcodes to your Microsoft Dynamics 365 Business Central reports. Barcode Generator from Insight Works makes it possible to add linear (Code39) or 2D (Data Matrix) barcodes to reports in Microsoft Dynamics 365 Business Central. Now you can modify existing reports such as invoices, order…
-
WMS Express
WMS Express The FREE warehouse management system for Dynamics 365 Business Central WMS Express from Insight Works is a free add-on for Microsoft Dynamics 365 Business Central Cloud that brings mobile device integration to the warehouse setting. This means you can save a lot of time, while increasing accuracy, by scanning…
-
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?
-
Skip empty field value during import through dataport.
Hi Everyone, I want to import 'FirstEmail' and 'SecondEmail' through dataport in customer table in NAV 2009 R2. But in the list of customer email fields, some customer doesn't have email. So, i want to skip that customer and to import for the remaining customers. But getting below warning:The field cannot be empty. Please…
-
How register dll server on pc cilent
i have focus accounting program , and i register dll file for active barcode and working in server , but i register dll file in cilent pc but not working . This massage error : activex component can't create object Please help me
-
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…