-
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…
-
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…
-
Table already exist Identification fields and values.. even though the record is unique
Hi, I having an error when running this script: TransSales.DELETEALL; TransSalesTransform.RESET;
TransSalesTransform.SETCURRENTKEY("Store No.","POS Terminal No.","Transaction No.","Line No.");
TransSalesTransform.SETRANGE("Trans. Date",CALCDATE('-1D',RunDate),RunDate);
TransSalesTransform.SETRANGE("Store…
-
XML Parser error
I am trying to import an XML file and am getting the following error: "The XML Parser returns the following fatal error: Illegal qualified name character. Line Number = 1, Column Number = 2" Here are the first several lines of my XML file: <?xml version="1.0" encoding="utf-16"?> <ShipUpdateEntity> <Notifications>…
-
Web Services Navision 2016
I am connected to a Web Services, and I would like to insert the result of this call in a table. Could you help me please? I leave you an overview of the code I use. url := 'http://192.168.16.23/CAMESER/cfmsv.asmx'; uriObj := uriObj.Uri(url); Request := Request.CreateDefault(uriObj); Request.Method := 'POST';…
-
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…
-
Unit Selling Price calculation using Unit Weight*Rate per kg
hello everybody! We are using Navision since 5 years but till now no solution has been reached regarding automatic selling price calculation. Please help. Our firm produces Steel Welded Mesh for Construction Industry and we make Mesh of different sizes and weights. Each item weight is calculated using the wire sizes &…
-
Getting error during sending PDF invoice attachement using bullzip pdf printer.
Hi Everyone, I am sending PDF invoice attachment through mail through Bullzip PDF printer. 1. when i am trying in server, its working fine. but 2. when client is sending from his local machine its showing error. Sometimes its showing: Error:1. 1. I have created shared path in server side and gave full permission to the…
-
Creating Charts in Excel using Automations
Hi, I create an Excel-Sheet with Navision using Automation-Variables to control Excel. Creating a Excel-Sheet and fill it with data is not a problem, but now I want to create a chart based on the data in the Excel-Sheet. I use the following Globals of type Automation: xlApp: 'Microsoft Excel 11.0 Object…
-
Cannot Insert Second Record into Temp Table
Using a report, I have a dataItem based on Ax Slave table. On After Get Record trigger I want to check if there is already inserted the combination between customer, caseID and InsuranceCompanyName and if it's then I just increment one field. I'm using the same table Ax Slave but is a temp table The problem is that I…
-
CFRONT.Dll and ASP.NET help needed.
Hi, I am trying to make ASP.NET application which takes data and insert into NAV Native database. When i am trying to execute my application I am getting exception ... The Navision CFront initialization failed, with following error: Exception of type 'System.Exception' was thrown.. Please verify that…
-
Write excel file no excel installed
Navision 4.01 SQL hi everyone, i was wondering if it is possible to write an excel file even if excel is not installed in the client machine: why? because a customer of us needs to export the budget from a TS where excel is not installed. Then he will eventually copy the file on his pc (where nav is not installed, but…
-
How to keep the order of the columns on the form
Hi, The users have customized the sales order subform to their own preference. (they changed the order of the columns) But every day when they log in to the system, they get the default order, even if they have changed the form before. We use NAV 4. Any advice on this. Thanks
-
Guaranteed run of code when record is inserted (invoice is posted)
I'm working on a legacy system (Nav 4.03). When sales invoices are posted, I need to make sure that certain code runs, regardless of what exactly triggers the posting of the invoice. I used to be able to handle this, having a place in the posting routine that would surely ALWAYS run during the posting of an invoice. But as…
-
Create report to get/track the users who have login the NAV in Particular time(Jan 2020 to June 20).
Hi Everyone, Is it possible to track the user by report that who have(Or how many user) login the NAV in particular time eg. from Jan 2020 to June 2020. If it is then how can i proceed. please guide for the above query. Regards, Mani.
-
How to use "System.Runtime.Extensions" in C/AL
Hi I need some Math expresions, but when I try to create a "Math" variable I cant access the Math expresions - as no method list are visibe when opening the System.runtime.extensions.dll Somebody knows what is wrong?
-
Date format DDMMYYYY and use as Date data type
I need to format the date into DDMMYYY. But want to use as Date, not a text. This gives me correct formate FORMAT(TODAY,0,'<Day,2>/<Month,2>/<Year4>'); but want to assign to date, when used EVALUATE again my date become DDMMYY. I am using RecRef therefore need to use same date formate IF (TableID = 271) AND…
-
Warehouse recepit from Transfer order
Good morning, I have an issue creating the warehouse recepit from Transfer Order action ribbon: once filled in all the required fields and clicking on the "warehouse receipt " button, any window opens, while clicking on the "warehouse shipment" button works perfectly. Could it depend on the Locations settings? Am I doing…
-
Unable to Run Batch sales Posting (Report 297) using Job Queue
I want to batch post sales invoices for which I am using Report 297. which is working fine if run the report manually. However, when I schedule the report 297 to run through Job queue, it shows successful in the Job queue logs but doesn't post the unposted invoice. NAS scheduler is working for other reports and codeunits…
-
Printing a default at the end of a report ?
Hello everyone, I couldn't find a solution anywhere for my issue, so i'm starting to wonder if what i'm looking to do is even possible. I want to print general terms and conditions of sales at the end of my invoice report. Whether the report has 2 or 50 pages, I want to print at the end of it a single page (text + image)…
-
How do I resolve "Amount must be negative in Gen. Journal Line Journal Template"?
Hello, Received the error when trying to post a payment journal after check has been printed. I've attached what the payment journal contains for everyone's reference. Thanks!
-
cant open my database error showing is "this file is not a database".. dynamics nav 2009 r2.
Hello, Recently i lost my database and later was able to recover it and restore it back to its original file location. Since then i have been trying to open the database file but i get this error message "this file is not a database". The file recovered is a .fdb file. I have also tried creating a new database but i still…
-
Internal error 6 occurred in module 11. Contact your system administrator.
Dear Friends, I am getting the error "Internal error 6 occurred in module 11. Contact your system administrator." while closing the NAV 2019 session over RDweb. This is not happening regularly but happening occasionally. Did anyone come across this error, if yes, could you please let me know the reason for this error and…
-
Nav 2009 R2 Weird Behavior when Changing Net Type
Hi all, I have encounter a weird behavior in client finsql 6.0.34105.0 (2009 R2). We have build a trivial custom functionality for a customer and if we use it with database login or with some windows logins it works fine. But, with a specific windows login it doesn't work as it expected (without raising an error). If we…
-
How to send REST API GET request with headers in Business Central
Hello, I am currently trying to send a GET request to a service through REST API. The request in itself is working correctly. However, for this request to return data, I need to send a login token. The issue is that I cannot add request headers in a GET request. Any suggestions/workaround for this issue? Thank you in…
-
3PL Vertical Solution
Can anyone recommend a good Vertical for 3PL companies? We're having to work around a lot of navision because we operate in a 3PL environment. We've seen what looks to be a horizontal called Radio Beacon that would do a lot of what we want, but I'd be happier if it were integrated into Navision, rather than integrating…
-
nonstock item in purchase orders
Hi Experts!! NAV 2019 SP1, I have not used this for a long time and I do not know if I remember well.... the case is that I cannot find a way to do it and I need your help I need to create a type of item exclusively for purchases that do not move stock. I think I remember that if you create an nonstock item <and it is not…
-
convert time to decimal Codeunit
I want this date to give me any date instead of today, how to change this date . DateTimeToDecimal(TODAY,TIME,'UTC'); LOCAL DateTimeToDecimal(date : Date;time : Time;timeZoneCode : Code[10]) decimalDate : Decimal IF (date = 0D) THEN EXIT(0); IF time = 0T THEN EXIT((date-01010000D) * 86.4 - L_TZDiff*3.6) ELSE…
-
How to convert Date to decimal codeunit
I want this date to give me any date instead of today, how to change this date: It's my date DateTimeToDecimal(TODAY,TIME,'UTC'); LOCAL DateTimeToDecimal(date : Date;time : Time;timeZoneCode : Code[10]) decimalDate : Decimal IF (date = 0D) THEN EXIT(0); IF time = 0T THEN EXIT((date-01010000D) * 86.4 - L_TZDiff*3.6) ELSE…
-
Internal error 6 occurred in module 11. Contact your system administrator.
Dear Friends, I am getting the error "Internal error 6 occurred in module 11. Contact your system administrator." when I close the NAV 2019 session over RDweb. This is not happening regularly but happening occasionally. Did anyone come across this error, if yes, could you please let me know the reason for this error and…