-
What are the options to delete a file from NAV?
Hello all, I am wokring with NAV3.6 Attain, NAV5 is used as a client. The task is very simple: I have to delete a file from a folder. I used the following code to delete a file: FileSystemObjL - 'Windows Script Host Object Model'.FileSystemObjectIF ISCLEAR(FileSystemObjL) THEN CREATE(FileSystemObjL);IF…
-
Integration with LS hospitality POS Shawman with NAV 2009SP1
Hi All, Our one of the client has recently opt for the LS Hospitality Module with NAV for one of their outlet. Earlier they were having the LS Retail functionality for all of their outlets with NAV. As per my knowledge the POS system for LS hospitality i.e. ShawMan POS Can anybody help me that its possible to integrate the…
-
Purchase Order Line Amount Inc. VAT
Good day! We have NAV2009 SP1. One of our PO line do have a quantity of 350 and direct unit cost w/ VAT of 250. With these data, we are expecting a line amount of 87500. The system generated 87, 499.99 instead of a whole number. How can we correct this and what is causing this amount inconsistency? Thank you.
-
Trial Balance Report Export to Excel with Show Amounts ACY
Dear All, Trial Balance Report (ID-6) when run with Export to Excel and Show Amounts ACY option tselected shows blank figures. If Export to Excel is not turned on then there is figures in the preview. I noticed this in version 4sp3, version5 and also in 2009SP1 and 2009R2. Show Amounts ACY is not more in version 2013. any…
-
NAV Printing Solution
We're migrating from a physical system to a hyper-v system. Currently, we have thirteen locations that access our NAV 2009 classic with SQL server through RDP over VPN. Each of these locations has a printer installed on the server so that a report can be printed at their location. Each user at that location has to have…
-
How to compair two date fields
I want to compair two dates like IF "Purch. Rcpt. Line"."Promised Receipt Date" <= "Purch. Rcpt. Line"."Receipt Date" THENBEGINqty := "Purch. Rcpt. Line"."Total recived";ENDELSEBEGINqty1 := "Purch. Rcpt. Line"."Total recived";END; But If one of the date is zero then only the loop is going to be executed correctly .If both…
-
Starting the RoleTailored Client in configuration mode
Hi Is it possible to specify the Nav service to run in the command prompt which opens the RTC (2013) in configuration mode? I have a customer with a few Nav database so we would like to create separate shortcuts to open Role Centres in config mode for each database. The command I am using at the moment is: "C:\Program…
-
Letter iof Credit in NAV 2013 R2
Dear All, I searched for flow diagram for Letter of Credit. If one can send it. Further we need to do hedging as my client does forward trading in international market. Thanks in advance. Puri
-
Vat Difference
Hi, we've a interface between NAV and a onlinestore. It could be happen if we import the Orders from the store to nav that we have Vat differences of 0.01€. We wrote this differences in sales Line in the field Vat difference. We setup in the settings allow Vat difference and Max. Vat differnce. If we create the Sales Order…
-
Expiration date control on automatic lot allocation
Hi guys, I've one problem to solve. Expiration date control on automatic lot allocation doesn't work. So, it seems that when the system automatically allocates a lot on a sales order, it doesn't control the expiration date of the lot. The system must not allocate an expired lot. Can anybody suggest any idea, how to resolve…
-
Classic Client Compatibality
Is NAV 2009 Classic Client compatible with Windows Server 2012 Standard Edition 64 Bit.
-
Stock Transfer
hi experts using transfer order screen i am transferring the finish good but during receipt i have to change the fg material to corresponding raw material no. In item table I have maintained raw material no corresponding to fg item . In codeunit 22 i am getting error that item no. does not exist while receipt value into…
-
Changing the UNIT cost of an item
Hi everyone, I have an item with a wrong unit cost(the correct value is zero but it is not). I have already run the batch Adjust Cost - Item Entries but it didn't got me any result. I tried the revaluation journal with my item but I got the following error message:You must not revalue items with Costing Method Average, if…
-
Table Relation field and Database Testing
Hi there I have a doubt. Say, for a field in a table, I have a conditional Table Relation. Eg: Cust. Ledger Entry I modify Field No 50 "Reason Code" to have a table relation asIF (Document Type=FILTER(Refund)) "Reason Code".Code ELSE IF (Document Type=FILTER(Credit Memo)) "Other Reason".Code and then, when I test the table…
-
About the field Open in the Item Ledger Entry table
Hi everyone, I want to know the signification of field Open in the Item Ledger Entry table. I have an article with an entry in the Item Ledger entry table with the following information :Document Type= Sales Shipment Open= TRUEQuantity= -3Remaining Quantity= -3Invoiced Quantity= -3Applies-to-entry= 0Completely Invoiced=…
-
Weird. Adding Records to Reservation Entry
First of all, it looks weird for me. But, again, dunno whether I do the correct thing. Based the records of ILE, I wanted to fill a transfer order line (items are lot-tracked). In a loop for selected ILE records, I add the item details and quantity to Transfer Line table. Create the corresponding lines in Reservation Entry…
-
Warehouse activity Lock
Hi I use Navision 5.0 And I have some DeadLock probleme whit table Warehouse activity Line On the Unit Code 7312 Create Pick You have a function "CreateWhseDocument" Begin with locktable Like This WhseActivHeader.LOCKTABLE; IF WhseActivHeader.FIND('+') THEN; WhseActivLine.LOCKTABLE; IF WhseActivLine.FIND('+') THEN; I make…
-
Deadlocks from calcsums
NAV 2009R2 on SQL We're experiencing excessive deadlocking on our system, mostly because of additional load on the servers. When I went hunting for the most common queries that SQL was detecting as deadlocks, one that continually appeared was clearly from a calcsums (no matching flowfield): SELECT SUM("SUM$<fieldname>")…
-
updating form more than once during runtime?
Hi, has someone figured out a way to update the appearance of a form more than once during runtime? It seems like no matter what I do with it, you only see the final version when the code is through. What I am trying to do is for example to let a warning message flash. like: CurrForm.Control01.VISIBLE :=…
-
HotFix for change in Point of Taxation related to ServiceTax
Hi All, Can anyone share or mail me Hot Fix/Patch file for change in Point of Taxation related to Service Tax for Navision ??? I want to know that how it will work in NAV SP1 database then i will do the same thing(with applying changes through coding) in my current database which is NAV 2013 R2. Actually i have't access of…
-
COGS Posting with Sales return
Hi, In value entry i have two records for one sales invoice one is for sales and other one is for adjust for the same invoice. Afterthat i am posting a return order for the same invoice and run the report Adjust cost item entry and another report cost post to G/L , But system post COGS only for first value entry line for…
-
document posted with very old date
We are using Nav 2009. Someone in company posted a credit document with posting date alot older and outside the posting period. But the document date is new. How that is even possible as no one is allowed by the system to post anything outside the posting period. Bug in the system? Now can this be fixed? reverse the…
-
EWT Aitom.Server has stopped
Hello all.. an error occurs (periodically) when Plus CFront replication is running.. "F: EWT Autom.Server has stopped".. ...wherein Repl Counter writes normally, but data not replicated.. what is it? how to fix it? [nav 5.0]
-
RunModal Error in NAV 6.0
Hi Guys, I am using NAV 6.0 i get the following error when entering quantity on a sales order; 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. CodeUnit.Run() is allowed in write…
-
Can localised fields cause problems?
A client has some fields and tables from a local version of NAV 2009. Our dev licence does not have that localization; we can renumber the tables to the 50000 range, but cannot renumber the fields, since we cannot delete the localized fields. If we renumber the tables (not the fields), the client can use the database with…
-
Export in Xml
Hi all. I need to have a row like that in xml export: <p:FatturaElettronica xmlns:xsi="http://www.w3.og/2001/XMLSchema-istance" ....... I don't find the way for type right code in Navision. In this way doesn't works: Node Name Node Type Source Type Data Source p:FatturaElettronica Element Text <p:FatturaElettronica>…
-
Temporary list form --> Source a normal Table
I need create a List Form with Item table as Source, but i need the data in form will be temporary, because the user has to make changes and then modify in table in a process copying temporary values. I have test this object http://www.mibuso.com/howtoinfo.asp?FileID=16 but not working in my form, because a modify in my…
-
Automation variable has not been instantiated - IXMLDOMNode
Hello, I have the following variable setup in the global variables: xmlNode : Automation 'Microsoft XML, v6.0'.IXMLDOMNode I have a report that is run that executes code in a codeunit and it works perfectly. Here is part of the code that is in question: CLEAR(xmlNode); xmlNode := xmlNodeList.item(i - 1); The above code…
-
MARK won"t mark
Hello all, I am trying to use MARK to mark some entries and then only display them. I haven't used MARK much previously but it would really help now. I have on a form, the below code in a function which is called from OnAfterGetRecord. PurchCrMemoHeader.RESET;PostedPurchInvoice.SETRANGE("ACW Service Order No.", "No.");IF…
-
check if exe file is running automation
Hi all, Is there any way to check if a exe file is already running? I was thinking in an automation dll or something like that