-
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.");…
-
REST API call Date Header format
Hi, In BC16 I'm consuming an external REST API. To make a request, I use the HttpClient datatype. I'm struggling to add the http-header Date. It's unclear to me what is the correct format for the date header value as it is not documented. Already tried following date formats: 1/ httpHeaderDate := FORMAT(CurrentDateTime(),…
-
Write and read Active Directory
Hi, I need to create or read users on active directory, anyone with experience with this? thanks in advance NS
-
XMLport send Post Code plus Ship-to Adress
Hello all, I'm building a XMLport that sends some information to our internal sofwtare, such as name of contact, address , post code etc..im getting difficulties on the post code. The logic is, if the the contact is customer, then it returns by default the customer post code. If that customer has more than shipping address…
-
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…
-
"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…
-
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.
-
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…
-
Insert a line at the end of a table
Hello, I'm sorry if this question has been asked before but I couldn't manage to find an answer to it. I'm trying to insert a new line by pressing "Insert button" which is created in a form, that line I wanted to be the last line in a table(If other lines exist) The function Rec.INSERT would insert the line and it would be…
-
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…
-
Track who uninstalled an extension on production environment of Business Central cloud?
One of the extensions from production env was uninstalled, I have checked Change Log Entries and it doesn't keep a log of such events. How can one, find out who installed or uninstalled an extension?
-
Problems creating a WebIntance for BC160
I'm trying to create a WebInstance with 2 different version of BC, 140 and 160. 140 works, but as far as BC16 is concern, when it opens the webbrowser it provokes and error: The client version does not match the server version. You can only connect to a server with a matching version. Client version: 14.0.38650.0 Server…
-
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
-
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
-
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…
-
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,…
-
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,…
-
Job Queue not runing automatically; only when user logs in
In a NAV 2017 CU6 i am facing a situation where a job that has been set up in the job queue will not run automatically. Instead it is running the instance I log in. We have set up a range of jobs, both codeunits and report, and all except one run just as they should. However one job will not run automatically. Going…
-
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…
-
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…