-
How to Setup Service Module
Hi, what do i need to setup in the service module to get this desired functionallity... When an Item gets sold to a customer, sometimes a Service Contract (OHC) should get invoiced to the Customer as well... This Service contract will be a Contract for Maintenance of the bought item. So it should be something like this:…
-
I have not action "Open in Excel" on pages BC16.
We have two the same databases but in 1st database I have this action in 2nd - not. Excel version meets the system requirements of Microsoft. Permission sets include either the D365 Excel Export Action permission set or the system permission 6110.
-
Sort records based on Date
I am trying to sort the records of Item Ledger Entry to give me the expiration date as the earliest date relative to today(). If there are 2 records let us say in ILE Entry No, Item No, Expiration Date 1, itm01, 5th of October 2020 2, itm02, 10th of October 2020 3, itm03, 11th of September 2020 I want it to be sorted as;…
-
Adding a Tracking Spec Line through AL Code?
rec_trackingspec.init(); if rec_trackingspec2.FindLast() then rec_trackingspec."Entry No." := rec_trackingspec2."Entry No." + 1 else rec_trackingspec."Entry No." := 1; rec_trackingspec."Creation Date" := WorkDate(); rec_trackingspec.Positive := true; rec_trackingspec.Validate("Item No.", rec_SalesLine."No.");…
-
Clear All fields in a form
Hello, I'm sorry if this question has already been asked before but I couldn't manage to find an answer to it. a form has been created with a couple of fields, checks marks, and an "Add" button which will add all these fields into a table. My question is I want once that button is pressed all these fields in the form…
-
Can´t Undo Shipment - got error There is not enough space to insert correction lines
Hi, Then I try to Undo Shipment on a Sales Shipment I got this error messages "There is not enough space to insert correction lines" I am using NAV2016 Kind Regard Mats Gustavsson
-
Trying to find a codeunit to help me automate posting shipment.
I am trying to write a Job Queue codeunit that will at an interval try to post sales shipment from Sales Order. I have looked into Sales-Post (Yes/No) and Sales-Post codeunits and could not find a procedure that I can use to Post a Sales Shipment from a Sales Order document. What codeunit is available that will assist me…
-
How to copy data from multiple table from one DB to other DB in sql server where Timestamp is used.
I need to copy a set of tables from one DB to another DB, the tables structure is the same but the problem is when using Import/Export wizard I'm getting error that for table. Timestamp is used as column for all the set of tables which we cannot use for copy, so some one please suggest how to copy the data from db to db.…
-
Table locking on approval with Workflow Step Instance table
Since moving to NAV 2018 (R1) and now using the newer Workflows for approvals, we have a lot of locking that occurs. For example when users send for approval from the sales order, they receive an error due to the Workflow Step Instance table being locked. It is intermittent. I have looked through the code around the…
-
"Schema of the file is not supported."
Hello everyone, I'm getting this error when trying to open navision through citrix "Schema of the file is not supported." Any one got this before?, anything to check ?. Please help me with your suggestions. I found only the below post , when I googled with the error.
-
Nav 2016 Json Page Api Postman Issue
Hi, I am using Nav 2016 CU1, in which i have created a List Page-50000 on table Item Ledger Entry and have used 3 fields (Item No.Remaining Qty & Location). When i publish this page in web service, the ODATA link is working nav server & on my local machine (i.e; on public network). But when i run the same in POSTMAN, it is…
-
Creating Report DataItems via VS Code
I have gone through the tutorials and trainings on VS Code. I think by far, the most difficult part of it all, is creating report data items via VS Code. Even using the standard snippet, this gets very cumbersome. When I tried creating a very complex dataitem (e.g. a BC Sales Invoice), I ended up switching to the classic…
-
Is NAV 2015 compatible with SQL SERVER 2019?
Planning for SQL Server upgrade, I would like to know if NAV 2015 is compatible with SQL SERVER 2019? If not, what are the other version of SQL Server available that are compatible with NAV 2015
-
The connection to the server was suspended
Hi, I am getting "The connection to the server was suspended" from NAV 2017 web client. Your help will be much appreciated. Regards, Evyn
-
Displaying field from a form into a table
Hello Everyone, I'm new to Dynamics NAV, but I created a form with two buttons("Add" and "Exit") and some fields. These same fields already exist in a Table. What I'm trying to do is after filling the form's fields, then I need to press the "Add" button so all the values from the form's fields needs to be added into the…
-
Going to a job list crashes the system.
Just one computer crashes NAV (it just disappears) every time you go to the job list (<company name>/Home/Jobs/Jobs or N050 Job List-Advanced (11014549) -- yes, we have ToIncrease installed ). I uninstalled NAV, stripped out every registry entry, every appdata entry and deleted all C:\Programs* NAV folders that remained. I…
-
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 :=…
-
Incorrectly Posted Invoice
Hello all, I am completely new to this program. I am replacing a woman who left very suddenly and has given me almost no guidance. I made a mistake and posted an invoice and did not also receive the shipping. How can I fix this? If anyone can please help I would appreciate it so much. I feel very lost in this program and…
-
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…