-
Synchronize user login outside navision client
Hi, I really need a quick help here. Is there a way to synchronize user id in newly restored NAV 4.0 SP3 database from outside the client ? I'm using NAV 4.0 SP3 paired with SQL Server right now, and i can't login to my newly restored database. I've already tried create a new id from sql server side but it seems inactive…
-
Problem with posted purchase invoice
I have posted a purchase invoice and I can see the movement in "Vendor ledger entries", however, I can not see it in the purchase invoices already posted. How can i solve this problem?
-
How do I create a barcode after creating a new Box size? E-Ship
Nav 2005. Classic Lanham E-SHip We added a new physical box size in Shipping - Setups - "StandardOption Setup Card" The new box sits alongside other existing boxes, and all the boxes have a "code" and that's used with the //Xboxcode How do you generate barcodes from the Code list, to provide users with a sheet of (barcode)…
-
Navision Coding to post value from purchase invoice line to GL Entry Table
Hi all, I want to post value from purchase line table to GL Entry table like in current scenario BCD , BED, Custome ECess & Custom SheCess values are posting to one GL code but i want to post BED amount in seprate GL in GL Entry table so i created one new field in "Excise Posting Setup" table to mention BED GL. Then i…
-
Filter on Some Customer and Still make Entries on Others
Dear ALL, My client is requesting to be able to only show the Balances/Ledger entries of specific customer but still be able to make Sales Order o all Customers, please can you advise how this might be done. Best HAYAN
-
Production buffer
Hello, in my Dynamics NAV 5.0 SP1there is a table "XXXXXX_$Production Buffer". But in this table there are not all data (i.e. product orders) like in "XXXXXX_$Value entry". Why? Thank you. Antanas
-
Arbitrary write error on OutStream apparently linked to file size, how to resolve?
We have a communication between system A (.NET handheld device) and system B (NAV) via the Navision Communication Component, writing XML files and transferring them between the two. Everything works fine for a number of requests & responses with usually single digit KB file sizes. For one particular process system A…
-
NAV 5 Custom Startup Message
I want to add a custom message at startup of NAV 5 using C/AL. Cannot find what codeunit runs at startup so I can insert MESSAGE. Any help is appreciated. Thanks. StillNAV5
-
Is it possible to run 2009R2 RTC with Nav 4.0 Objects and standard 2009R2 pages in 2009R2 Database.
Hi everyone, A Navision 4.0 Database has been converted to 2009 R2 version. But the objects are still at Nav 4.0. So I just imported the pages from a standard Nav 2009 R2 to this converted database. Now, this new database is of 2009R2 with nav 4.0 objects in it and 2009R2 pages. Will I be able to create a service for this…
-
UPS Tracking works on client side but Server side gives an error message
Curious if anybody has had such problem. We have a routine that tracks UPS delivery data using "Microsoft XML, v6.0'.XMLHTTP60". When I send the request to https://wwwcie.ups.com/ups.app/xml/Track from NAV client, it works perfectly. When I trigger the request from Web Services, it errors out at send() function saying…
-
Login issue
Hi, we have problem with windows login for one account in NAV (NAV 5.0, windows server 2008 R2). In past this user has access to NAV, but then was the windows account deleted and now was created new windows login with the same name. I added it to NAV (standard way - Tools-> security -> windows login). Everything looked…
-
microsoft.dynamics.nav.openxml.spreadsheet.workbookreader.open
I'm trying to import and xlsx file in Import. estruct. fabric. (50011) and when I click in the AssistEdit to open my file xlsx I select and then return me this error. microsoft.dynamics.nav.openxml.spreadsheet.workbookreader.open The sheet is damage. 'The attribute 'horizontalDpi' has invalid value '0'. The MinInclusive…
-
difference auxiliary balance vendor
Difference between the auxiliary balance and the supplier balance
-
GET info from HYPERLINK
I need to know if its posible to know from NAV when we use HYPERLINK() if the URL fails from NAV to OPEN another URL. For example, first I have in one folder all the documents I want to open. In NAV I only have to put a fixed route + the ID of the doc. something like c:\mydocuments\docs1\id Now I have more folders where…
-
Navision 4.0 , How to remove Credit memo for particular user
Hi , I would like to know how to remove Sales Credit Memo for a particular user. Attached is user menu screen. Thanks MP
-
Flowfield: Lookup Field A, where Field B (date) is max date
Hello, I want to lookup the latest price for an item in my table "price history", which contains the fields "item no.", "entering date", "price". I thought of having a flowfield in the item table which looks up the "price" in this table where "item no."="no." and date=max date Is there a way to specify the max date?…
-
Subistute for GETDOTNETTYPE
Hi I'm trying to use som dotnet stuff in an older nav. I hav acces to the DotNet automation variaables. A code snippet i found used GETDOTNETTYPE which i don't have in my NAV, så i wonder if you know a workaroound, pressens of a codeunit that can do the trick. It's not posible for me to upgrade NAV at the moment. Vi har 4…
-
Report Inventory Valuation/ SQL Query Alternative
see newest version below
-
code to text conversion when the data is in table
Hi everybody please tell me that is code to text conversion is possible in data type in table when it consists of the data. Thanks in advance Regards Hunny Singh
-
Purchase posting by NAS
Hi I have modified CU 90 to run by NAS (posting receipt of goods) by inserting GUIALLOWED before every dialogs, and it works perfect. Now I want to posting invoices as well by NAS, but I then get the error message "You cannot use C/AL variables of type DIALOG...". Does anyone got an idea in which objects I should look for…
-
Unable to Undo Posted Return Shipment
Hi All, I'm trying to Undo a Posted Return shipment in Nav 2009 R2. It is throwing an error - Lot number is required for Item 'XXXXX' when I click on Function-> Undo Return Shipment in Posted Return Shipment form. Though the Item has lot number mentioned in it. Can somebody please help me understand the issue? Thanks,…
-
Error in ' Warehouse Shipment' for different UoM
hi Guys, i ve got an error 'The bin content does not exist' when i do a shipment thru Warehouse menu i use Bin code but not management warehouse and i use a different unit of measure for Sales i tried for Purchase order (use different UoM also), and it works is this a bug ? if yes, does anybody know when navision will fix…
-
Navision 2009 R2 - Departments menu
Hi all, we use Dynamics nav 2009 R2, and we want to have a Form menu like the Departments menu in Dynamics Nav 2016. Is it possible? Do you know or have a form like this? Best regards. Thanks.
-
Webservice in Navision 5.0
Hi, I want to know what is the best way to access the NAV 5.0 database? What is the best approach as we do not have built in webservice. Do we have to direct query the SQL database or what? I have reviewed this link (https://blogs.msdn.microsoft.com/nav/2008/04/15/using-web-services-to-access-microsoft-dynamics-nav-5-0/)…
-
Document clearing in general ledger NAV 2009 R2
NAV 2009 R2 A general ledger a/c has 100 lines. However only 10 lines are relevant. How do I clear the 90 lines of record that are no longer relevant. Like in SAP, I could clear those 90 lines with a t.code FB05. Anyway to do this in NAV 2009 R2.
-
Dataport to import a CSV file
Hey guys, My boss told me to create a dataport so that he can export the csv file that she wants but i don´t have ideia how I will create that. Can someone help ? Thanks !!!
-
Could not create an instance of the OLE control or Automation server
Hie guys, my question is almost similar to some asked here a few years back. im getting : This message is for C/AL Programmers: Could not create an instance of the OLE control or Automation server identified by GUID={181E0F5D-D0C0-40E9-8620-2C1191CC00BC} 1.0:{BAD7EC8B-0E5B-4421-936E-F5AE2338BE32} UNknown Automation…
-
Retrieved deleted requisition in DynamicsNAV90
Dear S.R.Vaidya, I would like to ask if we could retrieved requisition since it was accidentally deleted by the user. I've tried to search in Archived Requisition but it was not there. Thanks, Eugene Mutia
-
How to Rounding off all Invoice values in Navision 4.0 SP3
Hi All, I want to post invoice with rounding off in all corresponding G/L accounts, customer accounts etc. like my invoice tax amount = 123.56 and total amount = 456.63 but i want to round it like this tax amount = 124.00 and total amount = 457.00 So i have done some setups as mentioned below :- Finance Managemnt - >…
-
Report Original, Duplicate, Triplicate
Hey guys, when i print my report i want that on the header show Original, Duplicate and Triplicate but i dont have idea how do i can make that. I tried on DataItem put Integer and then make a code that Set´s the range of number of 1 to 3 and then write the following code on the onaftergetrecords: IF Number = 1 Then…