-
SSO
Hi, we are still using NAV 5.0 (with file database), yeah quite lol these days, but it still works nicely. We use windows domain accounts for signing, but the corporation now pushes SSO and Azure for all apps and my question is- could this be possible? Anyone experienced in such scenario?
-
Change Navigation Menu background color.
Hi Everyone, My requirement is to change navigation menu background color. could you please guide me, how can i change this blue color to other color. eg. from blue to green or red etc. thanks, Mani
-
NAV 2009 R2 supported SQL Server Versions
Hi all, up to which SQL Server Version, is it possible to run NAV 2009 R2 (latest CU)? Currently they are running under SQL Server 2008R2 and Windows Server 2008R2. But as the support from Microsoft has ended, our idea was to update the SQL Server Version, and the operating system. Thanks in advance, Gido
-
Export virtual tables?
Hello everybody, is it possible to export virtual tables like 2000000001 2000000007 ... with all fields as a .txt file?
-
statement
.
-
How to import skip empty fields using Xml port in sales order..
I have created a XML port with sales header as a parent and sales line as a child and i want to import some data to it .But when i do this the empty records in the sales order must be skipped and move on to the next record . For Ex. In sales header I have a field called alternate number and i want skip the header which…
-
Object Designer. Why Version List is blank with last modification date.
Dear colleagues, Could you advice the reason why some of modified objects have no Version Number at all. Is it possible that Navision 'recompile' some objects and update Modification Date by itself?
-
Navision Database Schema
Can sombody help me of how to view the navision 2005 database schema Thanks.
-
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
-
NAV 4.00 Delete tables via code.
Hi, I have 2 questions: 1. Is there any quick way to delete the tables (incluing data) via code quickly? I need to remove some specific range of tables quickly. 2. Is there any quick way to remove specific fields while importing fob which are no more? Like Force in schema synchronization in NAV 2015 onwards. Looking…
-
CALCIFIED does not working!!
I have two record variable of ITEM table and another one is Transferline table(Created by me). ItemRec.SETFILTER(ItemRec."Location Filter",TransferLine."Warehouse Location"); ItemRec.GET(TransferLine."Item No"); MESSAGE('At %1 Location for Item %2',ItemRec."Location Filter",ItemRec."No."); END; ItemRec.CALCFIELDS("Qty. on…
-
Export some data from XMLPort to a bigtext issue
Hi Mibuso! This is my first post in this forum :) I have a simple issue, but is not working... maybe you may help... I'm trying to export some data from XMLPort to a bigtext. These are my vars and code: Name DataType Subtype Length XMLInfoStoc XMLport 50042 tempBlob Record TempBlob outFile OutStream Instr InStream TestText…
-
Saving Encoding in XML file with MemoryStream
Hi, I'm having a encoding problem sending XMLHttpRequests to a Domino site. The connection works nice except when there are special characters in NAV, then the client is receiving the special characters in what looks like ANSII. I am setting the request as UTF8 though and do not see how to force the request to be encoded…
-
LS Retails Scheduler Message Status
Dear Experts, When data is replicated from Server to POS and POS to Server using LS retail data director, Incoming & Outgoing messages are recorded in Navision. It used to work fine earlier. Due to some issues, we had to format server & reinstall everything. Please see attached image. But now messages are not being…
-
Lookup - Best Way and The Difference
I tried to created 4 methods to lookup table by using C/AL in the Control. All are have the same result (lookup the table, get the value, and put it to field or variable). What is the best way? are they any difference among this 4 methods? "Test Lookup" is new field in Customer table. In the form, pull "Test Lookup" and…
-
Protected CodeUnit
Hullo my dears, I have a codeunit whose contents are protected. I therefore cant modify it routines yet I need to change something so Urgently. Is there anyone with a tool I can use to unprotect the sourcecode of this codeunit? Ronald.
-
Hide Fully paid invoice in Statement
Hi All, is there any parameter that we can use if we want to show Invoice (not fully paid) in statement (Report 116)?? because right now i can see... all the invoices will show in statement thanks
-
how to do string split in NAV
Does anyone know how to do string split in NAV. I've a string like 'ABC/11-12/001;ABC/11-12/002;ABCDE/11-12/0001' and i want to split it like string1:=ABC/11-12/001. string2:=ABCDE/11-12/0001.
-
Display all sessions under Database information
I'm running NAV 2009 R2 (Build 32012) classic client under SQL-2008 R2, simple security model, no traceflag. I can't manage do display all sessions for a non-sysadmin sql-database login with traceflag 4616 set off (with traceflag set on, it works). My database login TEST has got "VIEW SERVER STATE" permissions. (Each sql…
-
NAV financials for customer in Cambodia
We are looking for another partner or free-lance resource to participate in an implementation in Cambodia. The customer is a financial institution and will only be implementing NAV for accounting. A loan portfolio will be managed in a separate system to be integrated with NAV.
-
FINDSET and Rename
I have a client project I'm working on where they need a custom table merged to multicompany, but each company has records in it. So, I'm simply going to add an offset # per company, say 100 per each company. So, the example data is simple, ID is the only PK field, an integer:Company A:ID | Some text1 | Text2 | Text3 |…
-
Does XMLPort have autosave, autoupdate, autoreplace?
In dataports you can find following settings for a data item XMLPort autosave, autoupdate, autoreplace. Does it exist similiar funtionality to xmlports?
-
Moving file to another folder
hi, how to move another file from folder A to Folder B ? like cut and paste thanks
-
Automation Server Error
Hi, My Client is using IN Nav 4.0sp3, citrix for all user. I have customize approval system while sending mail i am getting error.Microsoft Business Solutions-NavisionThis message is for C/AL programmers:Could not create an instance of the OLE control or Automation server identified by…
-
IF statement in the sourceexpr property
Hello, i have a text control in a form, called TB I need to set the sourceexpr property of it, in depending on the value of a field. In other words IF a field is equal to 10 then value of TB is A, else B. Is possible to do this? Thank's.
-
Calculate Flowfield using other fields in the same table
Hello, I have a developing question. I want to create three fields in the Item table: - Astore: Flowfield that calculates how many items are in the A store. This is the Calcformula property: Sum("Item Ledger Entry".Quantity WHERE (Location Code=CONST(Astore),Item No.=FIELD(No.))) - Bstore: Flowfield that calculates how…
-
EURO sign
I want to print the EURO-sign on several reports. A label with ALT 0128 shows a nice looking picture, but with printing it shows a little square. This is not new. But it depends on which workstation it is used. What adjustments do I need to change? Thanks in advance :D
-
Order tracking for emergency orders
Hi, I am using Nav version 5.0 and I have all my item cards set to 'Tracking only'. When I run a full regenerative plan, order tracking lines are created for all entries on the planning worksheet except those lines which are marked by the yellow caution icon as 'emergency orders'. For these lines, I get the message 'there…
-
Spit a Decimal Value
Hi, I have a decimal field amount having value say 35.65. I want to separate the left and right parts of the decimal and show in different fields. How to do that?.
-
Difference Between OnAfterGetRecord & OnAfterGetCurrRecord
Can anyone tell me the difference between these two triggers on a form, i'm getting confused: OnAfterGetRecord OnAfterGetCurrRecord I have the same code in both triggers but have a feeling i don't need too. Thanks in advance.