-
Employee Turnover chart report grouped by months
Hi am trying to create a report that should calculate the turnover(Total number of leavers in a period / Total number of employee in that same period X 100) and the report should also group the turnover per month. I was able to get the turnover for the whole period but not per ,month. kindly assist.
-
Can we apply OrderBy on any field in NAV Services?
I am fetching data on scrolling in a table. On each scroll it fetches 100 records. Now i want to apply sorting on each field so that when user click on a specific heading it sort data on fetch data on scroll. Issue what i am getting is sorting with scrolling is working fine for Date values and Invoice numbers but not…
-
How to call webservice which Require Json structure and XML as attachment using REST API .
Hi i am trying to call an API which require Param as Json file structure and xml file attachment as body .
-
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;…
-
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.…
-
"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…
-
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.
-
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,…
-
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…
-
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?
-
Jobs -->> Invoice-->Credit memo-->Re create Invoice from same Job Planning Lines
After posting sales invoice, I have reversed using Credit Memo. Later I want create new sales invoice from the same job, It is showing nothing to create message. Please anyone help me how to create sales invoice after reversal of Posted Sales Invoice
-
Best way to do a Gap Fit analysis
HI All what would be the best way to do a gap fit analysis on a clients system to compare business Processes with system processes? Please could someone assist
-
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
-
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…
-
Getting warning during exporting customer data through DataMigration.
Hi Everyone, As i can't export BLOB field through dataport. so,i am trying to export Customer data through Data-Migration in NAV 2009 but i am facing below warning. As it seems by the warning message in text field has invalid character, but its complicated to find that field based on my point of view. So, Please suggest to…
-
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…
-
Job Planning Lines Page very slow switching between fields and lines
Hello, We use the Jobs module and the job planning lines table is very big. We have about 50 jobs and each job can have up to 100,000 job planning lines. The issue we are running into is when users are trying to create new job planning lines or edit fields in existing lines, it takes a almost 4 minutes to switch to the…
-
Location Code and Requisition Worksheet
HI Mibuso members, I'm running into an issue with my Business central On-Cloud instance. When I run a requisition worksheet the PO's do not include the location code in the header. It use to do this automatically but now it selects the default company address. I checked my company info and vendor card but those are both…
-
Strange problem when import txt source in 2009R2
Hello. I found strange behavior at one of our bases today. When importing a file with the source code, where there is an action with additional properties after RunObject, for examle: { 42 ;1 ;Action ; RunObject=Codeunit 15; Image=EditLines } the classic gives me an error and stops the import. Microsoft Dynamics NAV…
-
Handling Internally printed labels - Business Central (14) (on Prem)
We have a range of labels that we internally print from a plain label, that are applied during manufacture (which may be to order or to stock) To ensure we know which label to print we put it in the BOM, so a prod order will call for Label-0901. Label-0901 doesn't physically exist. We print a Label-0901 from Label-0001 and…
-
NAV WebClient, unhandled rejections
Hi We are experiencing some issues with unhandled rejections, but with a little less information to give: Error accessing Website Unhandled error occurred on a browser or device client: { "clientInfo": { "platform": "Win32", "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko)…
-
Is there a tool to migrate from a navision axapta 3.0 to a navision BC 14?
Hello, Is there a tool to migrate from a navision axapta 3.0 to a navision BC 14? You know some tools for make this job easiest? Thanks in advance,
-
Mobile App - How to make the list scroll automagically
Hi Guys, We have a list form with the a single field above it for scanning. User scans Item Nos in that field and list below is being populated. When it is being run on the computer the newest items are always on the top (list auto-scrolls to show top most item). When the same page is opened on the phone app, the list does…
-
Mobile app something went wrong "unable to localize service.."
Hi Mibuso, I try to connect to a BC Cloud with domain "blabla.onmicrosoft.com". The BC mobile App cannot connect to the tenant. If I connect using a browser it works like a charm. (same login information) Where is the problem? (I supposed it's something with the ..onmicrosoft.com) The error [translation from french] on the…
-
Updating Excel without losing formatting
Excel Buffer provides a functionality to update worksheet - but the trick is: it is forcing new cell Decorator during update - function WriteCellValue looks like this: [External] WriteCellValue(ExcelBuffer : Record "Excel Buffer Advanced")
WITH ExcelBuffer DO BEGIN GetCellDecorator(ExcelBuffer, Decorator); CellTextValue :=…
-
How to connect CDS with BC Online
Hello, Can someone help me connect a custom table in the online version of Dynamics Business Central 16 with CDS? I already tried but I have the following error "Table connection for table type CRM must be registered using ResisterTableConnection or cmdlet NewTableConnection before it can be used." How can I run the…
-
Exchange Rate Web Services - Filter on Currencies
With the Exchange Rate Web Service function, I wonder if it is possible to have it filter on one or more curencies to update. We wish to use a different source for the feed for different currencies. It seems though the tool will pull in rates for ALL currencies that exist in NAV.
-
Using AD-Group Commands in a Nav-Container
Hey there, I would like to try out a few things within a Nav-container created by Freddy Skript this way:New-NavContainer -accept_eula -licenseFile $licenceFile -containerName $containername -imageName $imagename -doNotExportObjectsToText -includeCSide
-TimeZoneId (Get-TimeZone).Id -shortcuts "Desktop" -alwaysPull…