-
Create a XMLPort to import *.CSV files
Hi All, Do you have any basic guidance what are key steps to write an object type XMLPort that imports *.CSV file into T81 - "Gen. Journal Line"? I need to import *.CSV files into the T81 - "Gen. Journal Line" where user manually selects the CSV file to import. I know that I need to mapp fields from CSV file to the field…
-
How to merge pdf files for open Invoices in one single pdf file?
Hi Friends, [Version: NAV 2009] I have an another issue where I got struct. I need to merge the Open Invoices in one single pdf file. Below were the code I have done. Function: SendMailToRegOpenInvoicesLocals:
Parameter
CustNo (Code20) Variables:
Customer (Record) - Customer File1 (Automation) - 'Microsoft Scripting…
-
NAV 2009 R2 - Default Label Printer Settings Not Working
We use a Rollo label printer for some product labels. The labels are 61mm (wide) x 47mm (high). Everything is properly setup on the printer settings, but when I send a print job to it from NAV, the default label sizes are being overridden by NAV and it's picking some random label size. Each time we print to it from NAV, we…
-
Dash Board type report for Management
Guys, Is any body have dash board type report in Navision for higher management . so that on one screen we have key information related to business. This information might be related to Sales , purchase, Finance, project, inventory etc. If any one have then please reply. rgds dhananjay
-
LS POS Button Property Card does not have OK and CANCEL buttons. Cannot save button changes.
There are three POS in the store. It seems that all are configured the same way, but one out of three doesn't have OK and CANCEL at the buttom of the Button Property Card. What can cause this issue?
-
How do you clear an undefined Report after RUNMODAL?
Hi so i'm having trouble to clear the report afterREPORT.RUNMODAL(51173,FALSE,FALSE,GenJnlBatch); since clear only works on defined variables
-
Getting Below error while opening report at first time.Second time its working fine.
The following C/AL functions can be used only to a limited degree during write transactions because one or more tables will be locked. Form. RunModal is not allowed in write transactions.
-
Sync Item Tracking Line with warehouse Receipt Line
Hi I have added new lines to warehouse receipt line using code and realize Item tracking line does not match with warehouse receipt line. For example, Im using WhseRecLine for Warehouse reciept line record and reserveEnt for reservation entry record. WhseRecLine."Source Document" := whseRecLine."Source Document"::"Purchase…
-
Can I make an output with no expiration date?
Hello! We recently moved from purchasing our product labels from a vendor to making our own labels in house. In order to do this in Nav, we created production orders to output our labels once they are printed. Process seems to be running smooth except for we don't need an expiration date on the output as this item doesn't…
-
NAV server down and client connect
I have a doubt. NAV SQL clients connect to a DB as normal, but if the NAV Server service is down they continue to connect without problem. My question, what exactly is the NAV server service for? I have completely shut down the server with NAV server, open the NAV client sql and can access all the data. So what happens?
-
Can I Call a URL from NAV and get a XML document?
My customer is using NAV 2009 SP1.
-
Table locking and Slow performance
Problem Description: We migrated from NAV 5.0 Native DB to NAV 5.0 SQL 2008 DB a couple of weeks ago. From last few days we are experiencing performance issues with Navision. The process speed is slow (posting few lines takes lot of time) sometimes and users are often locked while doing the postings. We did some SQL…
-
Export To Excel Workbook Setting Error
Hi, While using the default functionality for Export to excel for GL Entries from "form 20" available in NAV5.0, I am getting an error when the excel is opened stating that "Problems came up in the following areas during load: Workbook Setting". And this is not constant, for some records its working fine and for some…
-
Show Dimension value name in the Posted Sales Invoices
Hi Guys, may I ask, if it is possible to show the dimension values in the list of posted sales invoices? Specifically I only need the Dimension value names of all transactions in the list. with the dimension codes : AREA and DEPARTMENT see image below for reference. thank you for those who is gonna answer
-
Confirmation Dialog if field value is greater than certain amount
Hi, I am looking to add a confirmation dialog box to my Sales Order Header page if a user inputs an unexpectedly large amount. For example, if a user enters in a sales order with an amount of $50,000 I want a message to display in the RTC that asks the user if they would like to proceed. I have written the below C/AL code…
-
Adding new field in 'Value entry' table, to sync the data from customer table, territory code.
Hi Everyone,[NAV 2009 R2] I am trying to sync data of the field "Territory code" from customer card to the new field(Custom field) in "Value entry" table. I have written below code in new field on validate trigger, but after posting sales order; my new field is not getting update in Value entry table. New field- onValidate…
-
Importing orders from XML (exercise)
Hi all, I'm doing a practical exercise for my enterprise where i'm making my stages for my software programming studies and I have to import from an XML sales orders with their headers and lines. The XML only passes me the Customer No, the Order Date for the header and the sales line type, the item no and the quantity for…
-
2009R2 classic| how to check if directory exists in network
Hello, I have a problem, when running codeunit from classic client it checks if in the directory (which is in the network for example \\vision3new\data\) is some files in File system table. All is good, when network is running, but sometimes when network is down for some reason I get a message "The network path cannot be…
-
Does anyone else have problems with exporting Item Lines on Excel using Ctrl+E ?
My customer is trying to export some Item Lines in excel using Ctrl+E. Problem is, some of his Inventory values differ from what's in the Item Lines. For example, one Item has a value in Available equal to 1500, but the value displays 0 when exported to excel. I've never had this problem before, and neither have my…
-
NAV 2009 R2 Classic Client and Shopify API + JSON
Hello I need to integrated with our new Shopify shop, so NAV 2009, can get orders, update orders, products etc by some sort of automation. Ive created a shop i Shopify, greated a private App, got the API key and the password, and when i enter the url:…
-
Export virtual tables?
Hello everybody, is it possible to export virtual tables like 2000000001 2000000007 ... with all fields as a .txt file?
-
Is there a way in the Classic Client to decrypt files encrypted with PGP?
Hi Forum, I received encrypted data from a financial service provider. I would like to decrypt this data and import it with a dataport and assign it to the customer. Except for the decryption of the file, everything runs automatically. It would be great if someone already had experience here. Best regards Tom
-
NAV 2009 R2 Classic Client post inform by API + JSON
Hi, I am using NAV 2009 R2 classic client, would like to do an API post function to put PO Header and PO Line information to 3rd parties by using API + JSON. May I know how to do it? And how to get the response message from 3rd parties and showing success or error message to user / log into a table for user to check the…
-
Downloading a file from an URL in NAV 2009 R2
I need to download a file, from an URL, in NAV 2009 R2. I'm trying to do the following: - request a list of files from a server using a XMLRequest => DONE - list the files on a form so that users can select the desired one => DONE - download the file from the same server into the users' TEMPORARYFOLDER => TODO. How can I…
-
Calling Function in Form from Report
This is very not standard, but I have some calculation code in my item card that I want to run in a report. Essentially have a qty available, very complicated in the form. I'd like to get that number without having to repeat all the calculations in my report, would like to call a function, pass in my record from the…
-
Navision 2009 R2 and Office365
Hello All, We have problem on NAV 2009 R2 when export to excel as error in attached file. On PC that have the Standard Office (2010,2016), it run ok. But on PC that installed Office365,it got this error. Does O365 not compatible with NAV 2009 R2? Have any way to fix this issue? Regards
-
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…
-
Purchase VAT Account Change for Purchase Line
Hi! Good afternoon! I would like to know if someone could help me with a situation. I need the Purchase VAT Account field to be changed for each line if it has different lines. For example, if line 1, your Purchase VAT Account is the account on line 1. And if it is line 2, the Purchase VAT Account is line 2.
-
Multiple Service resource allocation
Hi all, in service mgt. module, in the service order allocation lines, it is possible to allocate only one resource at a time per Service Item Line. It is not possible to allocate two different resources with status Active to the same service order line. There is some standard code that raises and error if you try to do so…
-
NAS freezes with heavy import at CREATEOUTSTREAM
Hi all, I'm facing an issue that drive me crazy, I hope I can find the answer among all you experts. :) We are running NAV2009R2 with a Navision Application server that run as a windows service. When we do import documents via NAS, sometimes, the import just freeze in the job queue with status "In progress", to solve that,…