-
Get Purchase Price into Purchase Order Lines
Hello, guys! Im a begginer in C/Al, not native english speaker. I dont know what is wrong in the code below, as Im trying to get the purchase price from the Purchase Price table into a field on the Purchase Order Lines, and i've put this code in the on validate section of the No field of the Purchase Line table. I also get…
-
Disable Lookup from fields on a form.
Hi Are there any ways of preventing a lookup from a field on a certain form: For example on a copy of the customer card, I want to prevent the user from making F6 in the 'Post Code' field (I want to do this, because I'm changing company on the customer record, and don't want to do this for all the related tables). Jens
-
Adjust Cost - Item Entries - Blocking issue
Hi All, My client is having Dynamics NAV 2013. The issue we have is, anytime we do a Cost Rollup (Bulk update of Item cost of raw materials) the "Adjust Cost - Item Entries" process/report ends up taking 30+ hours. Normally it takes only a few minutes each night. This process ends up blocking everyone for almost two day…
-
SEPA and Nav 5.0
Hello Evreyone ! In my company, we have a little problem. In Nav 5.0 we can't take any transfert with the new protocol SEPA (ISO 20022). There are any "Add-on" for Nav to do transfert under SEPA ? Thanks in advance for read my post and big thanks for answer me. P.S. sorry for my english Yohan
-
Renaming company and VSIFT schema bounded views
I have renamed the company basically by dropping VSIFT because it wasnt possible to rename without dropping them as all of them were schema bound. I do not see an issue in NAV but Is it right thing to do? Thanks
-
Possible to download NAV2009 database with all hotfixes up to 6.0.38655
See title, if possible NLD.
-
NAS in Stopping Mode
Sir, A Custom Windows Service is responsible to run & stop four different NAS services for the four different Companies on NAV 2009 R2 SQL Server Database. [ As License permits one at a time ] Activities of NAS 1. Periodic NAV Activity, Batch Processing, etc. 2. Report PDF generation & mail merge. 3. Others The whole…
-
Restricting Company Access
Hi, I have a few user setup and they are all SUPER users. We have a couple test companies setup and one live company. Is there a way to prevent users from accessing the test companies? Thanks, Steve
-
Selling Extended Warranties with Service Items - How to change length automatically?
So as we're aware, each item in NAV can only have a single item tracking code, and therefore a single 'default' warranty length for service items that are auto-created at posting. So how do people generally deal with selling extended warranties? Obviously we can go into each service item individually but if you happened to…
-
Error while validating RDL content
I am building a report in NAV 2009 SP1 for classic client use only. I am attempting to clone a report using posted tables from an unposted tables version. I used to be able to just change the tables and fix any hard coded table names. With the datasetFieldName it is no longer practical since it does not change when you…
-
Need to connect to Nav 5.0 - is there a good API / Connector
Hi, I want to connect to NAV 5.0 via an API or a connector. Ideally I'd be using a C# client, or JSON REST API. I need to create and edit products, prices and sales orders. Does such a product exist? Has anyone written a c# client? Thanks!
-
CURRENCY DIFFERENCE
I am using NAV 4.0 and have this issue: I had raised an Invoice on an international customer in USD. This customer paid me the full and final payment in one go, but in EURO. And both these entries have already been posted in NAV - the Invoice in USD and the Bank-Receipt in EURO. How do I now apply the money received…
-
NAV2009 R2 Client Painfully Slow
I have one machine that when you fire up the NAV client, it takes at least a minute or so to open the DB and once open it's painfully slow. Client has been uninstalled and reinstalled twice (for good measure) to no avail. All other applications on the machine run perfect. No viruses/malware, clean machine (Windows 7 Pro),…
-
Update Service Item Components List from Customised BOMs
This was recently posted in the wrong forum, my bad. I'm looking to use the auto-create service items functionality in NAV and to bring in components to the service item MSDN features a 'How to: Set Up Service Item Components from BOMs' - https://msdn.microsoft.com/library/hh177556(v=nav.71).aspx However, there appears to…
-
Nav 4.03 ADCS Install fail
I have a customer that is only liscened up to Nav 4.03... I have to use an older unused server running Windows 7 professional SP1. I have a Nav 4.03 disk BL=25143(the magic number minimum for windows 7 under Nav 4.03). Other than it whining about company notes and compatabilty warnings.. every installed fine.. Client,…
-
Retrive all records from a Table
My Task is very simple, 1. Retrieve all the records from the Table(G/L Entry) 2. Use SetFilter on the required field which is not PrimaryKey 3. Check whether record/local variable it is empty or not. I am struck with first point, I am unable to retrieve all the records. GET will require Primary Key as the value Please help…
-
Tax Setup Question
Hi There, I have an inventory item ABC. Item ABC is taxable to customer RETAIL but is nontaxable to customer WHOLESALE. I then have another item XYZ that is always taxable, regardless of the customer. I have an order for customer WHOLESALE. The order will have item ABC that needs to be tax free but also has item XYZ that…
-
Table Filter in Report - OR Condition required
Hi All, I am designing a report considering "Gen. Journal Batch" and "G/L Entry" tables. I have Batch Name as link field between above tables. I want to retrieve the records if Sub Type in "Gen. Journal Batch" be either "Cash Receipt Voucher" OR "Cash Payment Voucher" OR "Bank Receipt Voucher" OR "Bank Payment Voucher"…
-
Polish Language Pack
Hi, My client is parpreing to upgrade to NAV 2009 SP1(W1 version) form 4.0 and they will like to have Polish language installed. I search the web and found out for Polish version, the version is only up to 5.0. My question are 1. Why there is not Polish version for NAV 2009? 2. Can I use 5.0 Polish version to export…
-
Bug in Mail codeunit?
Hi all! I've Nav 2009 R2 (the database is migrated from Nav 4 SP2). There is an application that create a PDF file (with PDFCreator libraries) and attach it into an e-mail. The e-mail's recipient doesn't see the attach file or better some recipients sees the attachment and others one not. It is used Mail codeunit to…
-
LS Webservice give error
Dear all, I am facing an error. I am using standard ls retail database for 2009 version. I try to view standard web services but when I run the URL i am getting following XML error, This is my URL http://localhost:7027/DynamicsNAV/WS/CRONUSLS2009/Codeunit/RetailWebServices <?xml version="1.0"?> -<s:Envelope…
-
Outlook Syncronisation stops after 249 entries
Hi, the Sync of Navision contacts to Outlook stops every time after exact 249 entries. I have to sync more than 5000 contacts. Does anybody have an idea, how to eliminate this limit? Edit: I now get also a lot of error messages like: One of the conflicting synchronisation entities is not available I would like to do an…
-
Automate full copy/backup and restore Company NAV 4x
Hello, It's a classic client 4x version. There is a manual process in place for an organization for backing up production company and restore it on another server that users could use it there. Please advise how it would be possible to automate it. I've seen a code how to do it before and even had a copy of it but I…
-
GET Item No.
On a Form I need to look at a Warehouse shipment line and pull the Item No. to compare whether that Item No. has an Item Packing Rule or not. So far I want to use IF WhseShptLine."Item No." = ItemPackingRule."Item No." THEN BEGIN... but I am not getting an Item No. Any suggestions on how to get the Item No.?
-
Non-Pegged Receipt
We are looking at purchase receipts in Item Ledger Entries and for a particular item we see Qty 354, Invoiced 354, Remaining 175, and shows open. The question was asked how can there be a remaining qty and open when it has been fully invoiced. After poking around we find a non-pegged receipt for 175. Does anyone know what…
-
Add a new dimension to all entry's
Hi All I need to add a new dimension to all entry's, if a dimension already exist. If dimension = x then insert a new dimensioncode/value. Only add, not replace, so Dimension Correction Tool is not useful. Please advice best practice for this task, thanks in advance :smile:
-
Building Cubes For navision thru SQL sever
hi , i am currently working on building OLAP from navision on SSAS , but suprised by no realtionship for navison tables on SQL. And as well when i bulid any cube , as well not all fields appear . How can i start from zero to learn how i can bulid cube for navision from SSAS . please help or hint where i shoud go to go…
-
How to calculate Tax Amount in pre sales invoice.
I knew that "Amount Including VAT" field in Sales line gets updated when we release the order. we can use that field to calculate total tax amount of the invoice. but before releasing we can able view the total tax amount in statistics (F9). i need to show that total sales tax amount in sales invoice form with out…
-
Set default Location Code on Production Order - NAV 2013
I am new here. thanks for any help on this. I am trying to figure out how to set a default value for all new Released Production Orders & Firm Planned Production Orders. I can't find a way to do that. How is this done ?
-
Urgent: Suggest NAV Bar Code Scanner
From the list of below Bar code Scanner, Please suggest me which one to buy.. systemid.com/datalogic/memor/ systemid.com/datalogic/datalogic_elf/ systemid.com/motorola/mc3100/ systemid.com/datalogic/falcon_x3_/