-
Create New-NAVTableConnection
Hello I am trying to make a TableConnection to connect to CRM/Microsoft Dynamics 365 for Sales Using the PowerShell command New-NAVTableConnection. But I get this error: Can someone tell me what to do ??
-
Resources boeken op projecten
Hoe kan ik interne uren, bijv. de tijd die iemand heeft gestoken in offertes, boeken op een project (NAV2013R2)? Ik heb resources aangemaakt en planningsregels, maar het lukt mij niet om op deze regels de werkelijk bestede uren af te boeken. Zodat er een verschil ontstaat tussen Planning en Gebruik op dezelfde regel. Ik…
-
How to (properly) configure server client settings (for clients over WAN)
I see plenty of documentation saying what the settings are in the Nav Administration tool. Such as, chunk size, compression threshold, etc. But nowhere can I find a google analysis of how to configure these settings properly. Can anyone speak about how they configured the settings? Specifically for optimizing performance…
-
What is your experience in converting Classic NAV report to Extensions?
hi, what is your experience in converting Classic NAV report o RDLC and then to Extension? We will share our experience of report conversion from CLassic to RDLC and to Extension during the webinar, also you will be able to ask during the webinar relevant topic questions REGISTER NOW
-
Canadian ACH file format - Data Exchange Definition
Does anyone have a custom data exchange definition for use with CIBC bank in Canada? Here is the file format? Is a custom table needed to handle accessing the fields within NAV for this format? Thanks for any and all input.
-
Standard field is missing in table 1214 on BC
Hi all, Does anyone knows why field 16 "Value BLOB" is missing in table 1214 Intermediate Data Import on business central, and where that field finished if it's moved from table 1214? Regards, Stefan
-
APPS NAV 2017 HELP
Hi , i can understand and how can configured the apps of dynamics in in my IPAD and My Phone so i creat a self certificat in windows server , and installed in my ipad no result no working , can you please give me the correct line to install and deploied in my ipad and my phone thank you
-
How to run Dynamics NAV APPS Client Tablet
hi every budy am going to install dynamics nav apps in my tablet IOS system, so how can connect to my server Via my public adress IP ,my existent requirement it is : -i have a public Adress IP -windows server 2012R -sql server 2017 - TAblet
-
Get the BC tenant ID using javascript
I have built a Busincess Central extension add-in that uses javascript to read the tenant ID and company from the URL and passes those values to the app (which is displayed in an iframe). var widget = document.createElement("iframe"); var path = window.location.pathname.split("/"); var tenant = path[1]; var sandbox =…
-
Training
how do you do them?
-
Page on Mobile Client doesn't refresh on input but RTC does?
I have a page that is used for scanning barcodes. When I scan a barcode I execute a bunch of logic in the field.validate function that updates several bits of display information for the user. If I open the page in the RTC it works perfectly. If I open in the mobile client on an Android based barcode scanner the page isn't…
-
Automated Testing of XML Ports
Hi, I want to write some tests to cover an XML Port I am creating which will be exposed via a Codeunit as a Web Service. I am just wondering if anyone has seen any patterns for doing this? I have looked in the standard test suite, but can't seem to find any which test XML Ports. I might be overlooking some, so please feel…
-
Danish (DAN) Language Translation Incorrect
Hi Expert, I'm trying to use Import-NAVApplicationObjectLanguage to import DAN language to Result.txt. I got 2 times to import language: 1) First, import the last version of customization, the character is appear correct.DAN=Ove&rs‘ttelse 2) Second, import the NAVDK current version, the character is appear…
-
How to enable a customized report to web client
Hi, I have made a report to Navision client and I want to make it available to web users as well. Can you please guide me how to do this?
-
Merge data from databases (NAV 2017)
I have to collect open item ledger entries from 3 databases every night on main database throw internet. What is the best way to do it? My suggestion is to create a table and page on main database and create Odata based on the page. On another side a new report that is running throw a job queue and makes http request with…
-
Error While entering data is date formula field in Russian Language
Hi All, I am struggling with an Issue in Navision Russia. Whenever I am entering data in Russian Language in "Dateformula" Field, system is throwing an error as attached in screen-shot. In Russian language '1D' in dateformula is equal to ''1Д'' but system is parsing ''1Д'' as '1O' which is causing the issue. Version detail…
-
Format validation of GUID Field
Hi everyone, I have created a Text data type for a "GUID" field. I need to VALIDATE it. Now i know how to use the validation function. But i need to validate so when the GUID is manually entered through a form in NAV, I need to check if the format is correct or not. If it has an incorrect format. It has to throw an error.…
-
How to get Subcon GRN no in PI
hi, am facing problem with sun con GRN no in PI. Gate entry & GRN are made & its reflecting correct quantity. but while making PI, when trying to select sub con GRN neither items or description, or the qty is reflecting. Guess subcon GRN its pick up is going wrong in back end. How to check on the same. Please help.
-
ODATA Import with Json Branches
Hello Everybody We are working with NAV2016 and we need to import data through odata services with a quite complex json format. It includes branches and arrays. i can parse a json string with json dotnet variables and extract the necessary information from it but when it comes to page web services i don't know how to read…
-
In Chart of Account Inventory G/L Balance showing Negative as on date.
Please Help me on Below Issue on Nav 16 In Chart of Account Inventory ( Trading Stock) G/L Balance showing Negative as on date. I have checked after specific date this negative balance showing negative. also i have checked Prevent Negative inventory check mark set as yes and no direct Entries posted to G/L accounts. what…
-
Query to achieve some kind of Left/Right Join with a extra condition
Hello, I have 2 tables like in the below image and need a Query in Nav that produces the result you see in the image as "Desired". This is needed in order to indentify the rows with NULL values and present them in a report: My tables can have thousands of rows, so this is why I want to find a way to indentify this in an…
-
Navision 2018 SQL pull
I am seeking some help; not the best at sql by a long shot. I had some help from a previous Macola ES programer that helped me get the base of our sql query started but is no longer able to help. Currently, as this query excecutes it pulls the available date as 30 days from todays date. we would actually want that to be…
-
Job Queue Entry Finished status to Ready status customization in NAV 2018
Hello, I am using NAV 2018. I have issue in Job Queue Entries(JQE). Due to so many JQE processing in the system, sometimes the JQE goes into Finished status although it's recurring job.User have to restart it everyday to process the bunch of records. Is there possible to develop customization which will automatically make…
-
Any online support portal for NAV 2013 - to write coding
hi, Is there any online support portal where in we can check on writing the coding for NAV 2013?
-
UK NAV VAT Return
Hello Experts, This regards to a challenge i have been facing in UK VAT return statements. NAV consultants in UK will be aware of the VAT statement Templates ( which i believe is copied from Accounts schedule in principal) which populates all values from VAT entries table for VAT reporting. VAT entries will be updated only…
-
Voucher Narration
Hey Guys How to use Voucher Narration in Purchase Order? Can you let me know The coding?
-
tcs
Hi guys kindly help i want to calculate TCS on base value on sale of scrap excluding GST eg Amount = 10000 tcs % = 1% GST % 10% currently system is calculating 10000*10 % Gst = 1000 and TCS on ( 11000 ) 10000+1000 (base + gst) i want to calculate TCS on 10000 (base value ) 10000*1 % = 100 and gst on 10100 Rs Kindly help…
-
Where can I find Test ToolKit objects for NAV 2015?
As far as I know Microsoft started delivering Test ToolKit on DVD starting from version 2016, earlier versions usually you could find on partner source. I have checked Partner Source and there are objects for 2009 and 2013 but not for 2015, then I checked DVD and it is not there as well. So my question is where I can find…
-
How to use phantoms in AX 2012 for configured options
We use Experlogix as our configurator. Phantoms are used to pass on the parts for a customer selected option into the Manufacturing BOM. the problem is, not all parts under the phantom go to the same location, and only one location is passed to AX when parts are promoted. How do we solve this without creating many more…
-
UI removal based on Permission Set - RTC client (on premise)
Hi, I am using the permission set to remove the UI element , and I think it is a very complexe job to do , because we have to set the property (accesby permission ) for all UI element ttat we want to remove , and choose the good object and the good right to make that working as we want. I was wondering if there is not a…