-
How to Completely eliminate bottom margin on Nav 5.0 report
Hi, please I need help on how to remove the bottom margin completely from my report. This is because when I print the report it shows an unnecessary wide space at the bottom of the page which is I do not need. Thanks in advance.
-
Job Queue Problem in Nav2009
Hi, I have a problem using the job queue in nav2009 i want to ask to see if anyone knows what's happen. I have a scheduled task in Jobqueue entry that runs Quote Report and then send by email this... When I execute the process manually it works perfectly but when i run this by scheduled task it puts in log entry the start…
-
Job Queues & Job Queue Entries
Hello friend, Some time there is some network issue Job Queues & Job Queue Entries stopping automatically, After stopping all job has been stop automatically. Then we need to start these Job Queues & Job Queue Entries run manually.My question is this someone have any idea regarding this services run automatically after…
-
Email not send, stores in DRAFT folder using CU397 ??
Hi, Using NAV 4.0 sp3, Outlook 2003. when i send the email without prompring 'outlook' it was saved in 'draft' folder, not been sent. I want to send it automatically without prompting... What is wrong ?? no one are replied back.... i just call the cu.NewMessage(,,,,,,FALSE); sugg Plz.... Thanks & Regards, Psk
-
View all access roles that contains specific object id
Hi, I'm a new here so please bear with me. May I know if there a possible way to view all access roles the contain an specific object id?. I'm using NAV 2009 R2 Classic. Thanks.
-
One invoice with multicurrency
Dear All, I have this case where I am receiving an invoice from the Vendor (freight invoice) with with 3 charges but each line with different currency. is there a way(may be a workaround) that i can create one invoice with multiple currencies. Best HAYAN
-
Combine Shipment in a single invoice
Hi, we have an issue with this process. The company have sales ítem to different hotels, and the end of each month I have to créate a single Invoice with all the shipment. The problem is when I try to select the shipment lines don´t show any lines. Each hotel are created as a customer, so on the sales orden in the sell to…
-
Split purch. invoice into several w/ different posting dates
Hi guys, Scenario is the following: NAV receives an expense/purchase invoice from external system, which can be 'periodized'. It is easier to explain using an example. Example, data from external system: - There is an invoice from vendor 'Dell A/S', which should be posted on GL account 226510 'Test account'. - Posting date…
-
add columns to the 'Choose Columns' dialog
On the Dialog that pops up where you can move over columns you want to see on a page from an available column list, how do I add columns not listed in the available columns list? I hope this makes sense. I need to add some columns to the General Journal page, but the columns are not listed in the Choose Columns dialog…
-
Service Tax calculation on Purchase order
Hi all, we are using NAV2009 SP1 IN version, facing an issue in calculating service tax on purchase orders. Had setup the Service Tax Group Codes, Service Tax Registration Nos., and tagged the service tax group code on GL number. we have requirement to use service tax alone. so do we need to use structure to get the…
-
VAT % incorrect
Hello, On Sales Orders, when the user enters a Sales Line of type Item, system ends up calculating the VAT % to 13.00875, which the system ends up rounding to 13.01. Therefore, when the user prints the invoice, it displays the tax % to be 13.01, which is not correct since the tax % should be 13%. It happens randomly, out…
-
Deleting Items from a table
I have a function that is taking the No. value in the Item table and writing the value to a new table I created called 'Blocked Items'. The items going in this table are the items that are 'Blocked' = TRUE in the 'Item' table. Once the item list is in the 'Blocked Items' table then I set all 'Item.Blocked' = FALSE. This is…
-
Copy data from one table to another
Hello all, I am still relatively new to Dynamics NAV so am having trouble with this. I created a duplicate table of the Item Journal Line table. I am using that table to archive the data from the original table. I am trying to copy the necessary records from the regular Item Journal Line table to the new archive table but…
-
Urgent: Create Pick from Bin
I have an Item "Test" and availability is 48 BinContents Bin1 38 Bin2 5 Bin3 5 Now am creating sales order for Item "test" and required Qty is 40 and then create creating warehouse shipment then i create pick. when i check the warehouse pick document. it takes the 5 qty from bin3 5 qty from bin2 30 qty from bin1 it takes…
-
Import Mail in Navision. Help needed ...
I am currently looking for a solution for the following problems. Can anyone help me out with this.. When i look on the net the o,ly thing i can find is to export or create mail out of navision. The way around -> import no info available. Therefore i call you for help ... 1) Import and read mails from a specific directory…
-
Scheduled MailMerge, WS2008R2x64, document not found
Hi, I've run into a challenge that I would appreciate your input to: My client wishes to send out welcome mails automatically every night. I've implemented the functionality by customizing C5054 and the MailMerge works as expected when run from the NAV client and when executed using the ExpandIT Launch Utility (ELU), by…
-
Notes in Danish OIOUBL invoice document
Looking at the Danish OIOUBL document objects released from Microsoft this spring I can tell that comments on invoices (invoice lines without “Type”) are not being transferred from table 113 to the xml invoice document. In order to change the standard code and include text lines I have found the documentation for the…
-
Navision and SQL ADO Connection
Dear All Developer, If you are integrating Navision and Sql server then follow the below instructions:- 1) There should not be other client's version installed on the system. Otherwise Navision Client will restart again and again. 2) user the below automation variables in Name DataType Subtype Length…
-
View data from table purchase line + archive
Hi all, I think i'm not the first one which has to capture data from both this 2 table toghether. Basically, I need to report on purchase, I don't want to do 2 different report. Somebody as any suggestion?
-
Navision Classic User & Permission related Queries
Hello All, I have following problem related to Users roles and permission. As shown in snapshot 1, For Table 113 "Sales Invoice Line", I have assigned different security filter for different role and shown roles are assigned to User. Standard User roles and permission manual says that It will sum of all the permissions…
-
Use of automation 'Microsoft ActiveX Data Objects 2.8 Librar
Hi, I am trying to use a dll (msado15.dll) in a Nav object. I declare an automation variable of the type 'Microsoft ActiveX Data Objects 2.8 Library'.Command. This type is contained in the msado15.dll. On one platform it works; if I use Nav's built-in object browser (F5), I can see that the automation variable has a…
-
SQL ERROR in Purchase Invoice Posting
Hi All, One of our client is facing the below error while posting a Purchase Invoice : The following SQL error was unexpected. Cannot insert the value NULL into column 'Cancelled', table 'IMP_EME_TRAINING.dbo.DTL$Purchase Line'; column does not allow nulls. INSERT fails. The statement has been terminated. Can anyone help…
-
BE Dynamics NAV 5.0 - Codeunit 12
Hi all, I need some help. My colleagues in Belgium having problem with Payment Discount on Service. After Service Order is posted, in Customer Ledger they are getting value "Original Pmt. Disc. Possible" = 0 although "Payment Discount %" is not 0 and "Pmt. Discount Date" is correct posted. Comparing CU12 from NAV5.0 W1…
-
Machine Center - Multiple efficiency rate
Greetings, Is there a way to have multiple efficiency rates per machine center? For example - if a machine is being used to produce multiple products, the efficiency rate might differs between one product to another. If this can be achieved, the schedule in the respective production order can be calculated accordingly.…
-
Cannot create ADO Stream automation variable!!
Hello, I am using SQL connection using ActiveX Data Object 2.8 Library. It was working fine for long time. Since today I am contineously getting this problem. All other RecordSet and Connection Variables can be created but only Stream Variable gives the problem. I installed ActiveX data objects downloading from Microsoft…
-
Space at end of text field
I have created a table that I use to run against the Ship-To Address field to see if there is a PO Box in the address. The table has one field which is Text50. The table has values in it such as P O, P.O., PO BOX etc... I am shocked to see that I cannot enter a space at the end of the text. For example I want P O (with a…
-
Invoice Discount Amount on Sales order
Hi All, I am a bit stuck on the way to proceed on Invoice Discount Amount(the field upon pressing F9).Any help would be really appreciated. I have an xml to import as a sales order and there is the field invoice discount amount which has some value lets say 20.5 ; I have to perform the same calculation in the same way as I…
-
Line No for EDI 3pl dataports
We are implementing an EDI solution. We've stumbled upon a little problem which i cannot decide what the best solution might be. The specifications of all the files i am trying to generate have a fixed length limit of 5 characters for the Line no. field. As we all know Line no in NAV starts from 10000... so obviously i…
-
No Object Metadata when compiling
Hello, I'm busy with an upgrade from NAV5.0 SP1 to NAV2015. I have converted the NAV5.0 SP1 database to a NAV2009R2 database. However when I compile the tables in the NAV2009R2 database no records in the Object Metadata table are created. All tables are compilable. What is the cause for this?
-
IUNKOWN with ABBYY Finereader DISP_E_UNKNOWNNAME
Hi, recently I acquired a Trial Version of ABBYY Finereader SDK (COM) and Installed it on our Server at work. - The Task is to work with this SDK directly in Nav (No building addin a wrapper). - Many things seem to be functioning well, except for one method "Export"engine.Export(path,fileType,exportParams); -…