-
How to implement GST on Navision in indian company?
We are using NAV 2009 in my project and three companies implemented in same database 2 is USA based and 1 is Indian based. How to implement GST on Navision in Indian company without affecting USA subsidiary? Pls give me your valuable response.
-
Transfering BLOBs
Hi everybody, I have to transfer the contents of a BLOB-field into another one, but can't access the record directly, because I don't know, which table will be used, so I'm using RecordRef. How can I do this? Thanks in advance Master of Dragons
-
Filter on Customer "Salesperson Code" - giving wrong results.
Hi I have Customer.SETRANGE("Salesperson Code",'1','2'); to pick up only those customers with a salesperson code of 1 or 2 - when I run the report it gives me numbers 1 2 and 11? What am I missing? Thanks
-
How to change remaining quantity on component line on Finished Production Order?
Dear All, I have finished production order (with remaining quantity > 0 ). Now, I want to change Item Unit of Measure but system gives error that "You cannot modify Item unit of measure xx for Item xxxx because non-zero remaining quantity with xx exists in Prod. Order Component". I understand that it is not possible to…
-
Problem with Drill down
I have a field in a table that sum another (I put the calcformula in the property of calcformula of the field). Then I show in a form. In my database it works, but in the database of the customer not. The objects are the same in bouth case (form with same filter, same calcformula...etc) In my database. Customer In customer…
-
Navision installed, can't connect, checksum error
Hi all, I've just installed Navision Server 4.03 on an XP pro machine. I'm trying to connect to it from another machine with Navision client 4.0 SP3 installed and I get the following error: "The network is not functioning correctly. A 'packet' has been corrupted (a checksum error). This error indicates that the network is…
-
NAV 2009 .NET automation cant find assembly for custom config section
Hello I am writing a .NET dll to be used as an automation for NAV 2009 R2. It communicates with several web APIs that are configured in a .config file. The .config uses custom configuration classes (ConfigurationSection, ConfigurationElementCollection and ConfigurationElement), these classes and the .config file have been…
-
NAV 5.0 SP1 - SQL Server - Changing Companies Very Slow for only One User
We are using NAV 5.0 SP1 with SQL Server. Have one user, using windows login credentials, that takes at times 15 - 20 secs or more to switch companies. Replaced the machine which is directly on our network with no change. Even if the user logs in through a Terminal Server session, it still takes about the same amount of…
-
Problem with BigText and OCX "Microsoft Internet Transfer Control 6.0"
Hello! We are trying to retrieve some information from a webservice in our Navision 5 system. Therefore, we use the OCX "Microsoft Internet Transfer Control 6.0" and do a GET request from a URL. As an answer, we receive a string of text. This text can be bigger then 1024 digits - so we can not work with a normal text…
-
how we can check a number is integer or decimal in nav
Inside the validation of quantity I need to validate whther it is a decimal or integer how can we write code in nav
-
How to use nascontrol 1.0 Type Library
Hi, I found this post https://forum.mibuso.com/discussion/22633/job-queue-for-unlimited-company/p2 and tried using nascontrol, but it doesn't seem to work at all. My code is simple enough:IF CREATE(nasccontrol,TRUE,TRUE) THEN BEGIN nasccontrol.ComputerName := '049WS106'; //omitting this doesn't make a difference…
-
how i can make a tender type in pos ls retail
i want to made a tender type with end of days counts and corts how i ca make in POS Ls retail
-
NAV Classic 2009 R2 - Case statements
Morning. I am having to write case statements to pick out the country code and match it to the Country name. Tested it before I finished putting in the 80+ lines and It is just picking up the first case. It treats all customers as if it had GB. I inserted a test phraze in the first line - instead of blank I put "This is…
-
Grant deleted session to user - Navision 2009 R2 with SQL database
Hi All, I have migrated Native Database to SQL database for NAV system. Almost things work fine, but I have problem with user permission to delete user session when user license full. The user with super role can't delete the user session because do not have permission to kill session on SQL server. After searching from…
-
Want print in arabic
Hi, Do anyone can suggest me/guide me how to set codepage in navision. I want type Arabic in Item card description field Please warm regards
-
Replace existing record
I have a table with 2 fields in the key. I would like to receive a confirm dialog if i try to input data in a Card of a record that already exists with that key, to choose if i want to replace it or not. However when i input a key that already exists, NAV has it's own error that says there is such a record. Is there a way…
-
How to Convert Codepage 1250 to 852 (middle Europe) to import text
Hi, I want to import text (just once for setup) in NAV 2009 R2 codepage 1250 text. As I understand, I have to convert to codepage 852 to import it per Dataport. Does anybody know how to convert it in a correct way. A solution via Notepad++ would be also fine. Did't geht the right way so far. Thanks.
-
2009 R2 Classic reports -
Hi. I need to add a permanent filter to a report - so that the report only picks up records where the due date for an invoice is within the current month and it is in the open state. I am very new to NAV and have been trying to use CM for current month - but it doesn't like it. Any pointers would be appreciated.
-
Distribution of FOBs to several databases
We have something like 90 NAV 2009 R2 classic client databases with virtually the same objects and we have to import new objects manually in each and every one of them. Is there a tool which automates this? Edit: We can't do a technical update to the later versions to use the finsql.exe parameters. For now we are stuck…
-
MS SQL login from Navision 4.0 client
I have copied then file xp_ndo.dll to the binn libary on MS SQL Server ver. 8 (date 15. sept. 2004) I have Add the extended stored xp_ndo_enumusersids and xp_ndo_enumusergroups, with permission exec permission to guest and public But, when i start the client and try to connect with windows login, i get the following error:…
-
Ledger auto reapply solution
Is there any functionality to all ledger with all apply and unapply
-
Reminders NAV 2009 R2
Hi. I am trying to create reminder terms that will allow for an early reminder (2 weeks before due) our partner says to use a negative date in the due date column on the levels table. so under grace period leave at 0D but under Due date calculation use -14D , - 2W etc. I can get the correct text etc but I cannot get the…
-
Allow posting date from gets automatically updated.
Hi All, I am facing a problem on LIVE. It is I have set up the General ledger Setup to have "Allow Posting From" to "01/01/2017". But every month after some processing the date automatically gets updated to the start date of that month like on 15/07/2017 it was updated to 01/07/2017. Why is this getting updated? I am…
-
Warehouse Receipt in jobs module
Hello friends, I have a problem, when I want to receive from (Warehouse Receipts) the lines of a purchase order for job, I do not show the lines from (get source document). Tnks for the help
-
we are getting error the automation server has returned error(HRESULT)-2147352567.
While clicking on some button on Item card getting error for data type automation and subtype 'Windows Script Host Object Model'.WshShell.This message is for C/AL programmers: An exception was raised in method run. The OLE Control or Automation server has returned error (HRESULT) -2147352567." in navision 2009 r2.What is…
-
DIALOG variable error when posting with NAS a service order
Hello all, Using a NAS service I try to post a Service Order, but I still got the following error: You cannot use C/AL variables of type DIALOG when running the Microsoft Dynamics NAV Application Server. I tried to add IF GUIALLOWED on each DIALOG or CONFIRM sequence of code from CU 5980, but the error still appear.. Can…
-
Selecting Elements
Within this XML file i need to store the first 3 elements within a temp table. After selecting the node path how can I essentially skip onto the next node? Or only select the 3 from the header to apply to the body. In this instance I have I want to store the 'Location, Component and Comment' within the thead.…
-
Coupon Issue
I am working on LS Retail (Navision 2009 ). I want to create a coupon which will give discount of 5% on every article customer buys or on the total bill. I am trying to create a discount coupon but it not working(as it depends on no. of items to trigger). The values i am entering are- Discount type as discount %. Discount…
-
Should we use planned and/or firm planned production orders?
NAV 2009, classic client Currently our scheduler creates new production orders only as Released orders. We have not been using any sort of "planned" status, but we are now wanting to implement a "Planned" Production Order. I notice there is both a planned and a firm planned. Which should I use? I also notice on a released…
-
OpenFileDialog
Hi, With OpenFileDialog, Iam able to popup Open Windows message and select one file and Zip File it. ClientFile:= FileMgt.OpenFileDialog('Import a XML file', '', 'Word Files (*.XML)|*.XML|All Files (*.*)|*.*'); But not able to select multiple file at a time and Zip file. is there is any way to do that. Or