-
Drop column in SQL but not from Nav
Hi everyone. I'm newbie in Nav, accidentally I've run SQL Command 'Alter Table [TableName] Dorp Column [ColumnName]'. But I have not deleted that column from Nav. And now, there are two errors appears when Im trying to drop that column and compiling object in Nav. Errors: 5074, "42000", [Microsoft][ODBC SQL Server…
-
Payment Export Data for SEPA
Hi everybody, I'm working on the Microsoft objects for generate SEPA files. Can anyone tell me where the table "Payment Export Data" is deleted? Thanks!
-
Consuming a Codeunit Web Service problem
Hi guys, I have a problem with consuming web service codeunit on a couple of different databases. I’ve used the walkthrough example from Microsoft link. I created the codeunit for receiving price/rebate on three different databases (for different customers). Codeunit is the same for all three databases and when I call them…
-
What is a C/AL code module?
What is a C/AL code module? Is it a function? Is it similar to a Visual Basic code module? I cannot find definition anywhere.
-
Options, options
Can anyone with expirence with the option datatype give me some help? I have a field "X" setup as an option type with "A" and "B" as the values to choose from. I know I can use IF X::A THEN to catch if the value is "A" but how can I determine if the user hasn't set the option? How can I test for null?
-
Some problems with currency import
Hi, friends! I have obscure problem with currency import. So, I wrote report for updating exchange rate from European central bank at it starts every day under NAS as a job queue. It works fine during two weeks, but then it failed. Report works, but exchange rate load wrong, look at screenshot. It is so strange, because I…
-
How to pre-create column in SQL Server to speed up Nav FOB import
We've been using Nav 2009R2 for about five years now, and the process of adding new columns to certain large tables (sales invoice line, etc.) has become agonizingly slow. We've experimented with adding the column at the SQL Server level in an attempt to have the column "prebuilt" when the FOB import for the table happens,…
-
Import Historical transactions of companies into single company
My company has asked me to read up on the possibilities of merging data of three companies into single company. we are on NAV 2009 IN Version. Eg. we are using three NAV companies within India. like Chennai, Bangalore and Mumbai as separate companies for STPI reporting purpose and also acquired a company. have been…
-
Not able raise the bill in LSRetail in Particular POS terminal no LG0104
Error message :Microsoft Dynamics NAV ClassicThe POS Voided Transaction already exists. Identification fields and values: Receipt No.='0000LG0104000012649'OK
-
Create PDF 2.* NAV2009 Classic
Hello everyone, I have a problem that is driving me crazy, I have to create a PDF file version 2.+ with nav2009 Classic, is there anyone who can tell me how to do? I'll have on your conscience if I do not solve :) THANK YOU.
-
Setrange with an option field
Why this isn't working? Table.setrange("Reason for Archiving",'<>%1|<>%2|<>%3', Table."Reason for Archiving"::'Delete Manually',Table."Reason for Archiving"::'Delete Completed Document',Table."Reason for Archiving"::'Delete Manually without Posting'); Thank you!
-
PDF417 - 2D Barcode
Hi, Is there any NAV compatible, barcode generator tool available? I want to print PDF417 2D barcodes. Thanks, Bobby
-
how i put unit of measure box in the report
iam doing a report "sales invoice" i put the unit of measure but u want to put another unit of measure based on box which mean that a box contain 4 PCS how ca i solve this task
-
how i write this formula in a code
quantity per unit= quantity unit of measure * amount based on unit of measure
-
How to get Time with seconds and milliseconds
Hi all. Any way to find the current Date and also the time with seconds and milliseconds.?? Thanks in advance shibily
-
whats mean this error
my aim to get the itemno2 from the table item to the table item journal line when i run the page "phy.inventory journal" "the item journal line does not exist. identification fields and values;journal template line='PHYS.INV';journal batsh name ='default',line No.='0'" whats mean this error
-
Convert code to text during export to excel
I have a report which exports information of items such as crossreference no to excel. On report preview I have the information ok , such as Crossreference no 020000100 but on excel it gives 20000100 because it transfers them to number Can someone help me how to export to excel this to text? I have tried a lot of commands…
-
Source Subtype Field, Reservation Entry Table
What is a meaning of Source Subtype Field in the Reservation Entry Table in the case when a record is related to Prod.Order Line Table. No info in MSDN Thanks in advance
-
how i solve this
my aim to get the "item no.2" from the table (item) to the table (item journal list) i have write this code on the item no, _ on validation IF Item.GET("No.") THEN "Item No.2":=Item."No. 2"; what is the way in code to solve this task
-
how i solve this task
hello I add a new field "item No.2"in a table named "item journal line" i want to get "item No2" from table "item" how i write the code in order to solve it
-
Migration nav 2009 R2 to NAV 2017
Hello First a real Mibuso site help me a lot to find solutions to my problems in dynamics nav, then again I am up to the new version of navision from the current version R2 to the latest version 2017, well we are really interested in Do the migration to the new version knowing that the budgets is lower than the wait, for…
-
Any 2D Barcode fonts for Navision Report
Hi Guys, We have to print some Navision Reports in 2D Barcode? We need to just add the fonts or we need to have barcode generator for this?
-
DataMatrixCode - 2D Barcode
Hi everybody, we have a request from a customer to print 2D-Barcode on a product Label. All the Posts I found are a coupe of days old .. Anybody here with some recommendations and/or experiences how to integrate DMC-Codes into NAV Reports ? Thank you in advance.. Dirk
-
Integrate USB Scale with NAV
I have a Fairbanks USB Scale and wanted to be able to integrate it with NAV (Classic Client). I want NAV client to communicate with the USB Scale and get the weight information from it. Is there a dll or driver that I need to download? I appreciate any help I can get. Thanks
-
How can l show print function on Preview Mode?
Hello, I would like to show Print function on Preview mode but some reports have, some not. How can l get through this issue? Thank you for your help. :)
-
Make Non Editable Bank Payment and Req.Line
Dear All, We are using approval system in Bank Payment and Requisition line. I want to change record non-editable when it is in Pending for Approval status or Released status. So, please guide me what are the code and where i have to change code for this. Thanks in advance. Regards, Kishor Bhatt
-
how i write message in right way
hi i want to know how i right the message code in a right way inorder to give to me the right answerMESSAGE('%1 calculated Debit Amount',"g/l entry"."Debit Amount",'%2 calculated Credit amount',"g/l entry"."Credit Amount");
-
how i solve this task?
hello i want to do a codeunit read from table g/l entry to give the total debit amount and the total credit amount i use the function " calcsums" and i write the codeunit {"g/l entry".CALCSUMS("Debit Amount"); "g/l entry".CALCSUMS("Credit Amount");} what is the rong in this code and how i solve it to run the code
-
Modify a Field By its FIELDNO and Without Knowing its Name
I wonder if it's possible to modify a field by only knowing its ID? For example i want to modify the 50001 ID field in the X table with the Y value. How can i reach that field an assign the Y value to it in C/AL?
-
How to Implement Tab Order in Navision
Can anyone tell me how I can implement tab order in navision????