-
Navision Style Sheet Tool cuts off macros
I want to provide a marco into a document template used by the Navision Style Sheet Tools (for creation of some bulk/merge field mails). The macro itself works fine and the Style Sheet Tool itself works also fine, we use it for a lot of documents. But the combination of both don't work at all. If i assign the macro to the…
-
Report with a filter to look in another table
I have a report on the table extension contract. I want to make an option field that you can say that you only want to see the jobs which are open. The option field is no problem, but the job status field excist only in the table JOB. How can get the report look in the JOB table and give me only all JOBS which are open.…
-
WebServices.ServiceBrokerException
i try with codeunit 12 and published.. and checked thru internet explorer. localhost:7047DynamicsNAV/WS/CRONUS_International_Ltd/services working fine and list "GenJnlCodeLine " but localhost:7047DynamicsNAV/WS/CRONUS_International_Ltd/CodeUnit/GenJnlCodeLine then face issue. This XML file does not appear to have any style…
-
Receiving goods and getting paid for it...
Hi, I got a customer (still on Navision 4) who has the following problem. He "buys" goods and gets paid for it. The goods have to be received wit lot tracking. What he wants do to is create an purchase invoice, then receive the goods (wit lot tracking) and post the document. However Navision doesn't allow a negative amount…
-
PrintOnlyIfDetail and exporting to excel
Hi everyone, I am trying to customize standard report 709 so that I can export it to excel.In the dataitem Item, PrintOnlyIfDetails is set to Yes, so if there is no data the preview of the report is empty... but the excel file I am generating is printing data (name and description of the items)... How can I make sure that…
-
when click on "Post" Document No G00004 is out of balance
I written on web page service for insert value to “General Journal Line” table. I facing one issue is that “Document No” not generating sequence. I assigned the “account no” is 8720. Page code is 39.When I try to post in NAV message appears and info that “Document No G00004 is out of balance ..Please check that posting…
-
General journal line
I write one web service for insert values to General journal line .Page code ID 39 .it works fine but date fields and amount fields values are not saved as intended, always values (decimal) become zeros and date 29-Jan-2010.Anyone please suggest me a remedy for this issue.
-
NAV 2009 SP1 Logging Activity Report
Hi, I wish to keep track on Activity Logs/User Access Logs for two specific user ID (SQL Login). These members no longer using NAV, however they still have the access in Navision System and Active Domain . Therefore we would like to track on the activity log under these users for the entire Year of 2013. Is there any…
-
Problem while generating Excel file from classic report
Hi everyone, I am trying to generate an Excel file from a report.I have a trouble with the following line of code:ExcelBuf.AddColumn('(01)',FALSE,'',TRUE,FALSE,TRUE,''); I want the value (01) to be displayed in the column header, but what I get in the Excel file is -1. How can I display what I want? Thanks in advance :)
-
creating a batch file to run the native DB in server
Hi ALL, I have to create a batch file to run native DB in Server. Can anyone pls help me to create a batch file in cmd prompt.(Windows 7) .
-
Sort Report by third table value
I have a report which displays lines sorted by linenumber, but I want to sort the results a kind different. I have the following setup: Dynamics NAV 2009 SP1 / Dynamics NAV 6.0 SP1 Classic Client Table: Sales Line Relevant Fields: Document Type, Document No, Line No., Type, No., ShelfNo(foreign key to item.ShelfNo) Table:…
-
production BOM : HOW TO ?
Hello, I am starting with nav, and I would like to be able to product some BOM. I have created some BOM, set up Article, quantity of all article in the BOM, and the Unit of the BOM. Now, I don't know how to product this bom, and update all the entry of all article depending the configuration of the bom, and the number of…
-
Cannot Open Table in Design Mode After Deleting 1 Field
Hi everyone, I have created 6 tables in Navision for Consignment Module which are as follows: 1) Consignment Header 2) Consignment Line The above 2 tables have Document Type field with option string: Outward and Return. All the consignment outward and return entries will be added here first. After posting it will move to…
-
There is no company in the database. NAV 2013 R2
i have installed navsion from DVD for client but when i run it on client pc it gives error Microsoft Dynamics NAV There is no company in the database. Contact your system administrator.....
-
Dimension filetr on reports
Hi experts Through item journal I am posting the consumption entry using dimension . On the basis of these posted data I want to develop a report on which this two dimension will be applicable as report filter. Plz give me the idea and table name .
-
Printing Preferences in NAV 5
hi all, i got problem with paper size in report. I have set in the report the paper size to legal, also in printing preferences in control panel. but somehow when print the report, the paper size is back to letter. have anyone got this issue? need your advice to set the paper size. thanks in advance.
-
NAV Update
Hello guys We are planning to update our NAV 5.0 SP1 System to NAV 2013 R2. As I know, I have to do an update to 2009 SP1 first. When I converted the database and want to run the 104001 Upgrade - Old Version (I imported 601700.1.fob, not 601701.1.fob --> I don't have this file in my UpgradeToolKit). When I run it, I got…
-
Multi field Item filter for dataport - ?best way?
Using a dataport, I am trying to export only items that are members of a specific Item Categories, Product Groups or Product Lines. Each of these are a separate field in our Item table. To exclude those that I do not want I have written the following. Item - OnBeforeExportRecord()IF NOT ( ("Item Category Code"='1730') OR…
-
speed Problem in Subcontracting Module
Dear Concern One of our client is using NAV 2009 R2 (IN Version), when they are sending material in subcontracting then systems taking 3-4 hours to post 100 lines and even some time system comes at non responding stage.DB is in SQL (SQL Server 2008 R2). There is no customisation in Code units : 16360,90,11,12,13,21,22,23…
-
drop shipment
Hi people!! NAV 2009 SP1 When a purchase line/sales line are drop shipment I can see the sales order No. (in purchase line) and purchase order No. (in sales line), but when I post the sales invoice these data disappear I need to preserve the data until I post the purchase invoice Why NAV delete that data? and Which…
-
Standard Costing and Adjust Costs
We're thinking of transitioning to a complete standard costing setup. My question is whether the adjust cost program needs to be run if a company is exclusively standard cost? I'm thinking "no" but would like any additional feedback.
-
Navision 2009 SQL-Server periodically slow (white screens)
Hello, We are randomly experiencing white screens, Navision runs periodically slow, but another time its running normal doing the same things. I do not really know where to start searching for the reason. We've a good server with the SQL database on multiple disk systems so the hardware the Navision runs on is ok, but we…
-
Inventory in additional currency
I am trying to understand the process to true up the inventory value in additional currency between general ledger & inventory sub ledger. If I run the process to adjust exchange rate (report 595) for a date, it seems to update additional currency in g/l, customer, vendor & bank ledgers but not inventory sub-ledger, value…
-
Change additional reporting currency
I need to test changing the additional reporting currency from THB to PHP in one of our companies. The company has been active since 7/2006. We are currently on NAV5.0, SP1 I confirmed I have exchange rates for PHP starting on 4/30/12. The table contains monthly rates through 1/31/14. I changed the rate on GL Set-up and…
-
NAV 4.0 / Users & ADO / operations at the same time
Hello everyone, Please how handle operations which are performed at the same time? (i.e. operations performed by user through NAV client and operations performed automatically by ADO.recordset through ODBC) Please can you give me any advice/tips about this... Thanks in advance.
-
Picture from NAV on ASPX C#
I need to have on aspx page a employer picture... do you know how to do?
-
depreciation
Hi, can anyone help me please. I have run the depreciation for a particular fixed asset for the year 2013. my problem is that the depreciation was correct till the month of September and after September for the last three months of the year, the depreciation value changed. I am using Nav 5 straight line method and…
-
SQL Profiler - Audit Logout
Hi All, I'm going through the results of a MSQL Profiler session to see where the Navision slowdowns will be. And 1 value is always quite high: Audit Logout Anyone an idea what this value means?
-
Posted Invoice is not having entry in Service Tax detail
I am new to navision i have an issue, when i post an purchase invoice for payment method blank i have posted two invoice and i ham getting one entry in Service Tax Details Table and i am not getting entry for other invoice i have checked the invoice and compared them but i am not getting why i am not getting the posted…
-
Warning message in Error function
Hi Friends, When I compile an codeunit with the below ERROR function, I am getting the following warning: A maximum of 11 parameters must be used when calling the function. For example: Myfunc(..,..,..) Round(MyVar) Round(MyVar,0.005) ERROR('No valid combination found.\Game:%1 Jurisdiction:%2\C1:%3 C2:%4 C3:%5 C4:%6 C5:%7…