-
Show details of Statistics in FactBox in Sales Invoice
I am trying to customized Fact box of sales Invoice line to Show the details of Statistics in the fact box Customer Statistic i.e it should show all details of Statistic page in fact box i tried to keep the fields of Statistics page in Customer Statistics FactBox and took an record Variable for sales line but how can i…
-
Apparent CalcFields failure (NAV 2009)
Hi all, I recently had to create a table for a report that accumulated contact information from the Customer and Ship-To Address tables. The report needed the Sales (LCY) value from the Customer table, with the value being left blank on Ship-To lines. So I copied the Customer table and deleted all the columns that I didn't…
-
Embed Image in report
Is there any way of embedding an image in a report. Within the report there is an image (BLOB) and some texts. I saved the report as an HTML using SAVEASHTML function and then I am reading the generated (HTML) file and sending the read information to the Body of an email. All the texts show up properly, however the image…
-
Vendor Payment report
hi experts I am performing vendor payment using applying entry. And after posting this payment entry I want to see a report which will show against which external document no the vendor payment has been done.Is there any report or I have to develop a new report. Please mention the report id or table name using which i will…
-
Different versions of NAV
Good day! Can we have 2 different versions of NAV under a single server? Say we have a previous installation of 2009 SP1 being used by another "company" and another company will use 2013. OS is Windows Server 2008 R2. The database is MSSQL 2008 standard. Eventually the older version will also be migrated but we could not…
-
how to find what are the object imported into Navision
Hi all, Trying to import set of objects into navision classic client and once it done all those imported object alone need to be inserted into another table. Can anyone help me to find out?? i tried using virtual object table but i have no idea how to fetch imported object from that virtual Object table. :?: :?:
-
Problem in Creating Codeunits
i've client license (NAV 5), showing 100 codeunits, 8,600 Application Objects - Codeunits (100) 1 but when we try to create new code unit it's showsMicrosoft Dynamics NAVYou do not have permission to run the 'Design, Codeunit, Basic' System. Contact the system manager if you need to have your permissions changed. In…
-
How to Compile Nav 6.0 Objects through C/AL Coding
Hi everyone, Is there any way to compile objects through C/AL Code??? :-k
-
Common Stock Purchase
We have to purchase specified items on a single location but stocks are keeping on different locations. For example, if we are purchasing the materials from Loc1 and stocks are keeping on Locations like Loc1, Loc2 and Loc3. While calculating the replenishment of Loc1 need to consider the stocks for the Loc2 & Loc3. May I…
-
item price from value entry in report basedgrouping itemledg
I make report to grouping data in item ledger entry table as following item no quantity amount but i face problem . unit price not found in item ledger entry table but it found in value entry table How i got unit price from value entry table can you show me example code I need report as following item no quantity unit…
-
Outlook Vs yahoo Mail Email body.
One of our clients sends out e-mail confirmations on sales order. When the receiver receives the email, the body of the email looks fine in Outlook (properly formatted) but when you open the mail in Yahoo Mail, the formatting is messed up (carriage return are missing; If there was an empty line between two lines, that…
-
Open PDF from external SQL database. Citrix, BLOB and ADO
Hi folks, Problem: Not possible to open external web site URL (a link to an invoice registered outside) from NAV launched in the Citrix environment. More details in the previous topic: http://mibuso.com/forum/viewtopic.php?f=23&t=60040 As a result information on the page (PDF and some other data) is not accessible from…
-
Palette and Case Tracking
Hi Is there a way to track the items based on the palette and case they were packed in the production floor? TIA
-
Need to Import Objects in .txt and .fob using "C/AL Code"
I have used IMPORTOBJECTS functions but it is not importing .fob format and its working fine for .txt format while importing objects.. Is any other way to import object through only C/AL Code..
-
Error when entering customer credit card info
Hello, I am getting the following error when entering from one of the work stations when entering customer credit card info. We are using NAV 2009 R2 classic client on SQL database. The error is only on one of the workstations (all the others are ok). This workstation used to be ok as well, but started getting this error…
-
outlook folder sync - Navision Attain Hash
Hi, We just did technical upgrade from v4 to 2009 and outlook sync stopped working I am trying to select the outlook folder on salesperson card and Navision crashing on this line WHILE OLFolders.GetNextFolderIDPortion(TextBuffer, MAXSTRLEN(TextBuffer)) > 0 DO I think something wrong with variable TextBuffer (Text 250) Any…
-
NAS doesn't pickup new file(xml)
Hi Guys, We have a problem right now on using NAS to read the NEW file with the interval of 40 sec., the situation is that when I copy a NEW file in the working folder NAS doesn't pickup the file, but when I restart the NAS it'll pickup successfully without any error log in event viewer. what I noticed is that when the…
-
Odd Permissions Error with record level security
Hi, I'm about to go mad, I've been ](*,) for hours on this and can't see what the problem is. I've setup 2 roles; CREATE-PICREATE-PC The first to allow access for a user to create purchase Invoices, the second to allow creation of purchase credits - not posting, on both. The roles are exactly the same apart from the…
-
Display toggle
Can anyone tell me display toggle property in Navision report in visibility tab when I select the text box in report.
-
ToolTip
Can anyone tell me how to use tooltip in report with explaination.
-
Low Level Copy
Hi Mibuso.com World Hope all well :D ! Thought this was gonna be a walk in the park, copying the Records and Fields from one Company Table to another but no so.... lRecref.OPEN (312, FALSE, 'Test Company #1'); lRecref2.OPEN (312, FALSE, 'Test Company #2'); Loopy := 0; IF lRecref.FIND ('-') THEN REPEAT lRecref2.INIT; WHILE…
-
Compare Tables in 2 database
Hi, Is there any way I can compare my 2 database and it can show me only tables & fields which are different by different fields data type, size or missing field etc. Ideally, if I can sync all tables structures automatically would be superb like adding fields, change data type, length, adding new table from 1 database to…
-
NAV 2009 client slow on Hyper-V
So we are planning to move our infrastructure with NAV 2009 from a hardware environment to a virtual environment. But the first tests on our virtual platform are going bad with performance. But it looks like the NAV client is de bottleneck. We are running NAV 2009 R2 build 6.00.33194 classic client. NAV is maintained by…
-
questions about nav 5.0 and future version
hello everyone! i have two questions for nav 5.0 and one question for newer versions if we upgrade down the road we wanted to work on making navision better to.....look at. I feel like we don't really use all that navision has to offer. maybe having a program that's visually appealing will make me want to explore what else…
-
payment discount
Before 2013r2, when posting a purchase invoice, NAV would calculate the "Original PMT Discount Possible" field, when posting an Invoice after the allowable discount date has passed. What that means is I am posting an invoice on 03/15/2014, the document date is 03/01/2014, and in the terms there is a 2% discount in 10D…
-
Lost Language layer
Hi, We are working with a 3.70B version. No Language layer is installed. But as far as I can remember Navision was basically installed in the past with 2 langages: ENU and (in our case) Dutch. From 2000 on we are working with scanners. With a running Navision client, connected by Citrix. Because the scanners are not broad…
-
NAV license
If I get NAV 2013 user licenses forexample as I believe we cannot get older licenses no more. So if we get NAV 2013 license will it work on our current version NAV 2009 GB? I am talking about the user licenses and not the developer license. Thanks
-
UBL XML Export :(
How to export UBL XML ? (with cbc: , cac: and :ext tags ) I tried to export with XML DOM Management but i received the below error: Microsoft Dynamics NAVThis message is for C/AL programmers: The call to member createNode failed. msxml6.dll returned the following message: undeclared namespace prefix : 'cbc'. I must use…
-
Add my Windows login to the database from SQL
Hi everyone, I have restored a .bak file for a NAV 2009 SP1 database. When I tried to access the database, I couldn't make it. What shall I do to log in?How can I add my Windows login to the database from SQL? Thanks in advance :)
-
Create email with plain text
Hi all! I´m trying to create an email with plain text (no HTML or rich text). The email window must pop up in plain text and then the user click on send. I have tried the following: CU397.NewMessage("E-Mail",'','Pedido compra: '+FORMAT("No."),Conte, PathFichero,TRUE); //Last parameter to show window and also I have tried…