-
Navision MS-Message Queue Bus Adapter error
Greetings to all. I want to make code that will work with MSMQ. I use Nav2009 R2. Communication component (NSComCom2.dll and MSMQBusAdapter.dll) are installed and registered with regsvr32. Then I created private queue "test". Then I wrote simple code in codeunit (SingleInstance = Yes):OnRun()
IF ISCLEAR(ComCom) THEN…
-
Currency conversion
Hi Experts, I have a field call grant total in report which is defined in C/AL globals as decimal and is use to calculate Grand total for totals. How do you convert this field values which is in foreign currency to a local currency? Thanks.
-
Posting Description in Dynamics Nav 2009 R2.
Hello everyone, How I can make "Posting Description" field equals to "Cusomer Name"+ "Sales Invoice Header"."No." when I validate sales order. Tanhk you in advance
-
closing income statement error
Doing the closing income statement in Navision Version 4, I´m getting following error, posting date is not within your range of allowed posting dates in Gen. Journal Line Journal Template Name General, Journal Batch name General line no 1000 Working date is on 12/31/2021
-
Error While Compiling a table
After cumulative upgrade, I am trying to compile the objects and I found the following error. The following SQL error was unexpected: Cannot find the object " NAVDBName.dbo.CompanyName$TableName" because it does not exist or you do not have permissions. Please help regarding this.
-
updating, code changes in NAV2016 after "Enhancement Plan" expired
Hi, We have NAV 2016. We've been paying (the 16%) for the "Enhancement Plan" for a few years, during which our partner has applied only 1 CU update (MAY 2017). We want to stop paying $16k a year for this "enhancement plan". Questions: 1) Our partner is telling us that in order to update to the latest CU update, we must…
-
'Failure sending mail. Unable to read data from the transport connection: An existing connection was
Hi everyone I have implemented some mail sending functionality to send(Posted Sales Invoices) with custom email body, when I try to send multiple it send few of them and show a message that enables sending email If I try to debug it shows them following error. "'Failure sending mail. Unable to read data from the transport…
-
German Language
hi, anybody can send me the German language? how do i say Lot No. in German? Thanks
-
Item xxxx is not on Inventory
Does anyone have any idea why the following error is being outputted when posting a transfer order for certain items. Please note that xxxx stand for the item no. Item xxxx is not on Inventory
-
purchase order report
I have a report that should prints the image of the products that are in the related purchase order ( print only the images of the products that has the property Imprimir Desenho checked on Quality product requirement) the code I have in the report is *Requisito produto Qualidade - OnAfterGetRecord() IF…
-
how to correct an invoice's client header?
there was a mistake creating a new client 436. the invoice appears as the picture shows. I need to correct the "invoice to No.client" label as 436 not 098 as it writes.The invoice was already register.thanks for the support.
-
Warehouse Class Codes on Released Production Orders
I am currently using directed put away and pick for my location and have recently started testing transactions with warehouse class codes. While I can get the initial inbound flow to work (Purchase Order receipt and Put Away) with warehouse class codes, FYI you need a bin for receiving and storage that match the warehouse…
-
Automatic Reservation after Undo Sales Shipment
Hello everyone, The scenario is a Service Order with a reservation automatically placed for 5 units of the item XYZ (Reserve=Always). 5 units are shipped, and then the shipment is undone. Advance Warehousing is in use. Is it possible to automatically restore the original reservation after the Service Order has been shipped…
-
Dataport - Item & Item Ledger Entry
I want to create a dataport to EXPORT all item ledger entries for only ITEMS that have a quantity on hand of > 0. So if the Item has 0 qty on hand, then I don't want any of the ledger entries exported. Any ideas?
-
NAV 2009 webservice cannot access SQL
We have 2 NAV 2009 Webservices, one for production and one for test, that has been working flawlessly for 10 years. A couple of days ago they were suddenly denied access to the SQL-server. We have checked credentials etc., and everything seems ok. Yesterday we got the access restored by restarting the whole server…
-
How to convert Hexadecimal to Base64
Hello everyone, I did a codeunit that converts string to hexadecimal. How can I convert the hexadecimal to Base64? Thanks!
-
Can we use same container number when doing transfer orders?
Hello! We need to transfer orders from our main facility to our 2nd facility. However, we are not able to register the pick. We get this error "Container CONT1856055 may not exist in more than one Bin Code". I believe its because we are using same container number where output was originally made. This is to avoid extra…
-
Error when I print Purchase order more than 2 times
The following error is appearing in one of my clients when printing a purchase order: The indexing 3 in the array is outside of the permitted range.
-
Programming web solutions on top of classic client
Dear all, What solutions are you guys using for developing web and mobile interfaces for interacting with Dynamics NAV? Is there any low-code or no-code framework available for Dynamics NAV?
-
Loading only 10000 Records from large table ( Cust. Ledger Entry )
Hi, so even after applying filters the table contains still 800.000 - 1.000.000 records. This seems to be too much for the system ( loading for multiple hours ) and I only need 10.000 at a time anyway. Is there a way to only load 10.000 at a time without an extra filter ? something like a "SELECT TOP (10000)" ? Cheers.
-
Upgrade Windows OS version NAvision 2009 R2 Application
Hello, My navision 2009 r2 application is installed on windows server 2008 R2, I would like to know if it's possible do direct upgrade to 2012 R2. I'm not telling create a new machine. Thank you.
-
Windows client issue
Windows client is resetting in every 4-5 minutes This issue only happens on Windows Client connected to particular Server instance and we compared the server instances and are same. Its showing below message “The server is either unavailable or your connection has been lost. Do you want to attempt to reconnect?” I am…
-
I am designing a form and subform in classic based on the item table. How do I add a filter field
I want to create a filter field that will allow filtering by inventory posting group. Please someone give me some code
-
NAV2009 on Server/SQL 2016+
Does anyone know of a solution still running NAV2009 but on a newer MS Server OS (2016+) and MS SQL solution (2016+)? Or alternatively stopped an update of Server/SQL from doing this for any reason, bug etc?
-
How to print batch sales invoice but with separate PDF
Hello comunity, I want to print multiple posted sales invoices. With Print->PDF the system group all the invoices in one PDF. The request is to print multiple sales invoice but in separate PDF. Does anybody know how can I accomplish this ? If there is any way to save the in different pdfs on a specific location ? Thank you.
-
How to check multiple checkboxes on a page based on conditions
Hello everyone, I'm having trouble with a feature I'm trying to implement: I have this "Data Page" that shows Customers and their respective invoices below them: So I'm trying to click on the checkbox from the line where "Type = Customer" (Marked red) and the lines where "Type = GL Account" should get checked (marked…
-
Warehouse - NOT Direct Pick and Put-Away
Setting up Warehousing and not using Directed Pick and Put-Away, however, I can create Warehouse Shipments, but I can't create a Pick from the shipment. I get the message that nothing exists. Do you need to used Directed Pick and Put-Away to get a Warehouse Pick? Or is there another Form/Page available that I'm not seeing.…
-
Can't scroll down in Section Designer Nav 5.0 sp1
Hey experts, I've got a problem with report Section Designer. I need to do a large Report and when I added few new Sections, I can't scroll down to sections below because scroll won't go any lower. (There are few sections below the last visible section, screenshot below) Does anyone know how to fix this problem? Regards
-
Transfer Bin from Item Tracking
Hi, I've added some code to fill the bin code of the item tracking according to the serial number entered. Now I need to transfer this bin to the transfer order. Can someone point me in the right direction? Thanks!
-
Test a webservice [SOVLED]
Hi Can someone tell me how I can test a NAV webservice? Thanks in advance.