-
Pk values of a Virtual Item Journal Line
Sir, Do you know the values of the primary keys of a Item Journal Line created virtually when a Purchase Order is being posted with line Items :?: Blank. :-#
-
Permission Error
I am going to upgrade NAVISION 4.0 to NAV2009. 1st I merged objects using merge tool. After that I follow Microsoft standard instruction and when I import merged objects it shows this error Microsoft Dynamics NAV ClassicYour program license does not permit you to delete the Outlook Tasks Folder Path field in the…
-
MaxUpload Size Limit
Hi , We are using NAV 2009 R2 client.While sending XML file through Web Service we are getting OutofMemoryException. Default it is 5. First we changed it to 100 as we are sending 74MB XML file.It get send without error. But now we have to send larger XML files so we changed it to 200 and we are getting…
-
export sales invoice posted to .txt
Hi experts!! I'm trying to export an sales invoice posted to .txt and I have no problems with any field except with the value of "Amount" and "Amount Including VAT", both return me 0 but in the table (112) there are other value I don't understand why I can't export the values if the report has the dataitem "Sales Invoice…
-
Missing automation
Hi, I am missing an automation in my NAV 2009 SP1, or actually it is missing on the server. How can I get this? I have a codeunit that uses these two automations: Automation 'Microsoft XML, v6.0'.XMLHTTP Automation 'Microsoft XML, v6.0'.DOMDocument However these are not available on a new server, here I have (Notice the…
-
Inventory Valuation NA vs. W1
Hello In NA version the inventory valuation report is different than in W1. In NA it report 10139 In W1 it's report 1001 I was wondering why US built a new report and why the W1 wasn't sufficient. Thanks.
-
Saving a posted document as PDF at Particular location on Se
Hi, We are using NAV 5.0 US and we like to save our posted documents like Sales shipments/Purchase receipts etc (when user click post and print) as PDF at particular location on server. we will be moving to newer version but at this time we like to have a solution for this. We tried PDFMailer and on printer Selection we…
-
Dimensions with Physical Inventory
We use Dimensions on our system 3.70.B We have Dimensions set as mandatory. This has implications when you do Physical Inventory Journals which are causing me trouble. When you do a Physical Inventory Journal --> Calculate inventory... all the items come up with the Dimension Code NOT filled in, which takes ages to do…
-
Item profit% for different locations
Hello everyone. I am working on Dynamics NAV 2013 R2 and this is my issue: On item card there is field Profit% and you can define it for that item on company level. Is it somehow possible to define Profit% for one item based on location?(for example: company has a lot of retail locations and different Profit% on every…
-
overriding DataItemTableView
It's been about a decade since I've been in the NAV world, so bear with me please. I’ve got a report running pretty well from a form via a Print button (it only prints the records that show on the form), but I can’t seem to get the sorting to be in the same order that it is on the form. I need to show the Options tab of…
-
NAS maillog e-mail dispatcher error from 1 e-mail adress
Hello I have a problem with the e-mail dispatcher from navision. The maillog is running in a nas and I see below error. This error is triggered from 1 e-mail adres from the public folder QUEUE. I have tried to run the maillog in a navisio client and I get exact same error. The call to member Count failed. Collaboration…
-
Different Line Discount on Customers with same Bill-to Acc.
Hi, i have a Group of Customers which have the same Bill-to account. I need to assign different Line discounts to the different customer. as far as i can see the system allways just takes what ever is setup on the bill-to account. Can anyone help on this? /Tommy
-
Export to Excel
Dear Sir, How to export data into a single column of a CSV File. Data length may exceed 250 Characters. Is it possible without using any dataport/xmlport within NAV 2009 R2 System ? Thanks in advance.
-
Adjust Cost - Item Entries [Error Division By Zero 0/0]
I am getting a "Division by Zero" error message when trying to run the Adjust Cost - Item Entries in Navision 4.0. The error occurs in Inventory Adjustment codenit number 5895 within the function CalcCostPerUnit. The error occurs after the second IF statement and I don't really know what values the program is using to…
-
Deleting the Items which does not have any Transactions
Hi, I am new to Navision / LS Retail we have classic client 2009 sp2. I need a help ,in deleting items (almost 50,000) which does not have any transaction entry in Item Legder entry table I tried it with two ways, 1.I Created a Code unit, On Run Code: item.reset; if item.findset then repeat itemledgentry.reset;…
-
automate Import 1000 sales credit memo in navision 2009 r2
Hi, One of my client wants to automate the sales credit memo imported in navision. They have this csv file which will be imported. I searched this forum,& i got two options 1.Data migration tool-I ma not aware as how to run this & how to import this.Will this approach be ok?? 2.Creation of dataport-I craeted a buffer table…
-
Schemes & Offers
Dear Friends, We have a requirement to customize the freight & offer scheme modules for a client. Just wanted a few pointers from you people of the things that i should keep track of before starting.Suggestions are welcome. Thanks, Omkar
-
job will not always finish completely
We have a job in job scheduler managament that will not always finish completely. It hashas been started because in progress screen I see record 1 and 0%. When I move the mouse or press a random key on the keyboard it will suddenly start and finish succesfully. All other jobs are waiting on this and will not start until…
-
Function "activate" on Controls selects wrong control
Hi, I Build a Form, supposed to be used on a terminal with a touchscreen display and a a barcode scanner. The scanner automaticly adds an enter at the end of the scanned text and I want to manage the next selected Control manually. However after the execution there is always the next control active right after the one my…
-
adding fields to tracking specification
hi everyone, i am trying to add a field in the tracking specification table, let's say a code10. If i add it to its form and evaluate it, it's all ok, but if i exit/reenter the form, the value is no more there. The "problem" is that the tracking specification is sent to the reservation entry table (tracking specification…
-
NAV 2013 - easy security export object as source code
I have a question to ask, is regarding the export source code while using the easy security, my client was having an issue which unable to export the all object to txt.file, other than own a developer license, is there any solution to solve it? alert message : 'you do not have permission to run the 'File, Export, Text'…
-
VAT 2015 in Europe
Starting 1 Jan 2015, new VAT rules for telecommunications, broadcasting and electronic services will apply in the EU. VAT will then always be taxed in the EU member state where the customer is established. http://ec.europa.eu/taxation_customs/taxation/vat/how_vat_works/telecom/index_en.htm Apart from having to consider…
-
US Fixed Amount Taxation
Is there a way to capture a fixed tax amount from the N.A. Sales Tax module, instead of a percentage. Certain US tax jurisdictions are applying fixed tax amount per item sold. Example would be bottled water, where some areas charge $0.05 per bottle sold in addition to regular sales tax percentage. If this is not possible,…
-
FIND('=><')
Hi, What does FIND('=><') means? Thanks in advance
-
Main Grouping and sub Grouping in Dynamics nav 5.0
Hi guys, I can group by a field in a report but I have challenges having sub groups under a main group in a report. Please kindly assist. For example: I have a field called locations an another field called JobTitle so I want to group by locations and then have sub groups of each JobTitle under a location. Finally I want…
-
Copying DateTime fields from one database to another
Hi, I have some ADO code that copies records from one NAV database to another NAV database. There are some DateTime fields in these records. The query does a SQL FORMAT to return the DateTime in the format where it can be EVALUATE'd into the target table: SELECT [No_], FORMAT([Complete Date_Time], 'MM/dd/yyyy hh:mm:ss tt')…
-
"Applied Item Entries" form empty
NAV 2009 R2 Classic on SQL 2008 R2 We wanted to see and unapply of sales made from a particular production order. Current remaining balance of the PO Output is 0. So, I thought to unapply the entries and re-apply another correct PO (this is a special case. normally we accept default way). We notice that "Applied Item…
-
How to add DOCTYPE to xml file using xmlport in Version 2009
Hello all, One of my client require a xml file with the following declaration: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE cXML SYSTEM "http://xml.cXML.org/schemas/cXML/1.2.009/InvoiceDetail.dtd"> The first declaration is generated automatically when I run the xmlport I created but not the second one. Does anyone know…
-
Upgrade from NAV 4.0 to NAV 2013
Hi to all, Please can somebody tell me samo few instructions (some good book or video) about how to make upgrade from NAV 4.0 to NAV 2013 Thanks a lot,
-
Multi NAS instances in the server
Hello everyone, I am in a situation where we need to run two or more instances of NAS for the same company synchronously. Is there a way to do so in NAV 5.0 SP1 ? Thanks a lot for the help!