-
Transfering goods between EU countries
Background: in the past a company usually just did business in one country, and if they wanted to do business in another they founded a subsidiary. This is not the case anymore. In the EU a company can without a subsidiary easily have VAT Registration No. in multiple countries, rent or own warehouse in multiple countries…
-
Avg. Cost Adjmt. Entry Point table
Anybody knows if this table supposed to be populated if there are no items with average costing method? The name for the table is misleading.
-
Import and Export Objects in NAV 2013 through cmd
Hi All, Can anyone know the process that: "How we can import / Export the NAV (.txt, .fob) objects through windows command prompt (cmd)"? Thanks in advance
-
Web Services to Access Microsoft Dynamics NAV old versions
Dear All, I am in search for the webservice accessing method in lower versions(< 2009) if any of you have the sample project that was downloaded from the below link please help to share with me, currently it seems not available to download. http://blogs.msdn.com/b/nav/archive/200 ... v-5-0.aspx email - avi657@gmail.com
-
OLE error using "Import budget from Excel"
Hi all, When using the import routine I receive the following message as soon as i hit the button to open the File Name dialog: Does anyone know how to solve this? Any help is greatly appreciated! Thanks in advance. Regards, Gerard
-
Inventory In Intercompany Transactions
Dear Sir/Madam, Using the Intercompany postings feature is it possible to handle inventory transactions such as transfer orders or shipments and receipts ? Regards
-
Condition on CALCSUMS use
Hi everyone, I know may be it is common knowledge but I need to know: if I use CALCSUMS on a field, does that field have to be a flowfield? Thanks in advance :)
-
Set dataport prioperties
Hi, I have special question. How to set dataport properties UseReqForm from C/SIDE ? Thanks
-
Client crashes after executing XmlPort export
Hi everyone, I have a problem with NAV 2009 R2 I'm trying to export XML Port with the following code: XMLPortOrder.SETTABLEVIEW(SalesHeader) ;XMLPortOrder.SETDESTINATION(XmlOutStream) ;XMLPortOrder.EXPORT; after executing third line my client crashes without any message. Am I doing something wrong here?
-
Excel Automation - insert row in Excel sheet
Hi, i am trying to insert a row in an excel sheet i create out of Navision. I found a topic about excel with a function called "Selection.EntireRow.Insert" viewtopic.php?t=927 Now i am trying to use this function but i cannot find it in any automation variables. I can find Selection in the Properties of the Application…
-
You do not have permission to modify records posted table
Hi, I know this error is already discuss before i post here. But my case is different. One of our client hit below error when they try to rename the customer no. Specially those customer no. does not exist in posted shipment table (all of posted table). Why system giving error without posted shipment record and not…
-
Can you Test and trap for ADO SQL Open connection fail?
Hi, There are numerous posts here on how to create an ADO SQL connection. The general syntax is to define a variable of type "Automation" and subtype "Microsoft ActiveX Data Objects...", then ADOConn.Create then ADOConn.Open(ConnectionString); //ConnectionString is the text of the connection string. When the OPEN works…
-
New developer
Hi all, I am new to NAV development, currently working for a company who has many customers on Classic Navision 4/5. I'm trying to understand the posting process, for example, how a sales order with header and lines gets all the way through to being posted, what is the order of events and tables/code units used. I would be…
-
How to use page footer without reserving space on every page
Hello... We recently created a customized report which required the footer items to be shown at a fixed position with respect to the layout. Also, the footer items should only show on the last page. We used the page footer and report items hidden property to achieve the same. But the problem now is, although the fixed…
-
CurrForm Update
Hi ALL, I have a doubt in Form update. In form, If one GL entry is checked & made boolean tick mark then & other entries of same Document no should also be boolean ticked. then if i click on update button it should filter the rest of entries which is not reviewed. Can anyone tell me how I can make the update of entries…
-
Job Queue execution once in NAV 2013
Hi Everyone, I have a job queue that I only want to be executed only once in NAV 2013. Can anyone have any idea how we can achieved this? Thanks in advance Vivek
-
codeunit "get posted document lines to reverse"??
Hi experts!! NAV 2009 R2 I need to change the line description "invoice number xxx:" - "chipment number xxx:" generated with "get posted document lines to reverse" (credit memo) the funtion is "GetPstdDocLinestoRevere" but I do not see that codeunit belongs Please, which codeunit? Thanks for all
-
Memory leak in finsql.exe - NAV 2009 R2 Build 36259
Compared with fin.exe, the finsql.exe NAV-Client consumes about 5 times of memory (RAM), when running. Typical values according to Windows Task Manager are 10 MB for fin.exe compared to 50 MB for finsql.exe. Furthermore the memory consumed by finsql.exe seems to grow more and more the longer the client is running, finally…
-
Nav solution to transfer order non delivary
Hi All, I have the practical issue which cannot cater from NAV 2009, as my client uses Transfer order function to post inventory transfer to location across the country, therefore when posted transfer order shipment goods will be in in-transit location. but after this the transport vehicle broke down and goods came back to…
-
Reclass Item When Reserved?
Please can someone assist with providing clarification on the standard Navision2009r2 functionality for reclassing items between bins if a reservation entry exists? Currently we have basic warehousing enabled with picks, put-aways and bins enabled and we seem to keep having issues where we cannot reclass an item if said…
-
Duplication of receipt no. in LS Retail Transactions
Hi All, Anyone has ever come across a situation when the receipt no. gets duplicated in the transaction register while doing transactions in LS Retail (thru Retail POS). I am facing this problem wherein the receipt no. gets repeated while doing POS transactions. I am unable to track that under what circumstances does this…
-
Navision Hyperlink broken
How can I undo what application is used when a navision hyperlink is selected? Using 2009R2 on Windows 7. User selected a program instead of using navision hyperlink entrypoint.
-
How to show time on form constantly updating?
Hi experts, Please tell me 1.How to show systems time constantly updating? I have tried with TIME function which is showing systems time, but it is not updating with the systems time. 2.I have created a form with three fields code1(code datatype), code2 (code), code3(code) My question is when I type 'A' in the first field…
-
Barcode
Hi everyone, I'm new to the forum and I need some help to solve some issues.My issues are: 1.)I need to create a report or a form that will help me to generate a barcode and i should be able to print the barcode.The barcode should store the data that it got. The scenario would be like this: I should take the fields from…
-
Unable to delete a table
Hi everyone, I am trying to delete a table and getting the following error message:The XXX table contains a field that has a SQL Server data type that cannot be manipulated by Microsoft Dynamics NAV Classic within the current activity:Field: Date PV | BISQL Type: ? What shall I do? If I try to delete it from SQL Server,…
-
Automation Error
Hi, Currently, our customer facing the following error during simcrest add on credit card process. it works fine for other user but for one of the user this error occurs. is any one come across this issue please revert me. Regards, Shyam
-
Greek Characters
Hi Mibuso World :D I've search the various Mibuso communications on help with Character sets but each one I tried doesn't seem to retain the Greek Characters. Using Navision 2009 Classic - English (United Kingdom). Can somebody provide a routine that I can use to bring in a file that has Greek Characters and retain them in…
-
BANK PAYMENT VOUCHER
Bal. Account Type must be Bank Account in Gen. Journal Line Journal Template Name='BANKPAYMT',Journal Batch Name='BP BLUE',Line No.='10000'.
-
Copy Filters one by one
Hi all, Hope you can help. Here it goes: T50006.RESET; T50006.SETRANGE("Setup No. Sequence",T50005."No. Sequence"); IF T50006.FINDSET THEN REPEAT //create a "filtered" T27 so we can send it to the report and copy //filters to dataitem tobject.open(27); tfield:=tobject.field(T50006."Field No.");…
-
Service tax-Clearing agents -India localisaiton
I would like to know as how to handle Clearing & forwarding agent bill- Service tax. The agent provides bill as follows: e.g. AGencey charges 10000 Transport chg 20000 Other chg 1000 Total 31000 No service tax is charged in the bill Service tax is applicable on only Transport charges as GTA and if I declare it a GTA vendor…