-
Export Same Table data in one excel with different sheet in Nav 2009.
Hi Everyone, I am trying to export the same table data using process only report in one excel with multiple sheet in NAV 2009. ie, any particular table's 10 fields and corresponding data in first sheet and another 10 fields and corresponding data in second sheet of same excel. I tried for one sheet its working fine, but i…
-
We are having issues with printing speed on Dot Matrix Printers in Nav 2017
We are a Bakery, we sell bread and rolls. we deliver to sub shops, schools, pizza shops, etc. When we deliver, we use a 2 part form, the customer signs and keeps 1 part, the second part comes back to the office and is used for delivery confirmation and billing. We need the 2 part form, and therefore we need to still use…
-
How to increase the Unit Cost on finished goods
Hi all, Is it possible to book invoices also on finished goods? I mean, can we book invoices on production orders for instance so that the value (Unit Cost) of the finished goods gets increased? Example: 11,055 kg of Lot No. XXXXX, were produced under Production Order YYY with total cost of USD 6.81/kg. Any chance to add…
-
Pick Qty. is always 0 Upon Creating Warehouse Shipment
Hi All, I'm Having trouble in creating a pick in my Current Warehouse shipment Document, the Error I receive is "Nothing to Handle" after check for several hours I noticed that the Pick Qty. in my Current Warehouse Shipment Document is 0. ( I don't know if this is the cause, but literally Speaking and based on my hunches,…
-
The type 'UNDEF' is not defined for the function during upgrade from 2009 to 2013
Hi, I'm new here and this is my first question, but I already found a lot of helpful discussions here. However, during an upgrade process from NAV 2009 R2 to NAV 2013 (RTM) we came across this error message: 'The type 'UNDEF' is not defined for the function'. I have done a thorough search on the internet (most of on…
-
how to enable "request a read receipt" when sending email via CU400 SMTP Mail
Hi Expert, Version : NAV2009SP1 classic client I am ok for sending email to users via SMTP mail CU400, may I know 1. how to enable "request a read receipt" 2. As the sender is a generic account, how can I specify another email account for receiving those "read receipt" feedback Thanks for your advise
-
Mail Triggering through workflow for approval process
hi i want o know how can we send mails to approver id's when we send approval request for purchase order in navision. waiting for the response. its functionally we can do or through code we have to do?
-
application-aware backup for 3.70 native db?
We have Navision 3.70 with native database on 2003 R2 server (virtual machine). I am wondering if native db takes advantage of "application-aware" backup technology in today's backup solutions such as "Veeam Backup & Replication" or "Shadowprotect SPX". I ask because we are using Shadowprotect SPX which has…
-
How do i catch a TIME variable overflow?
Hi, so i useRemainingTime := 000000T + ROUND((ProcessingDuration / NoOfProgressed ) * ( NoOfRecs - NoOfProgressed ),1) in my ProcessBar to roughly calculate the remaining time. This can give my an overflow issue during debugging because the max value i believe is 23:59:59.999? is there a way to catch that error without…
-
Ls NAV - Offer if an item costs over a specific amount
Hi everyone! We want to setup a special offer in Ls Nav. If a customer buy any item from a specific Item Category, and this item costs more than a specific amount (e.g. 50€) we have discount amount -5€ (for example). So, we want something like "Amount to trigger" setting but not for the total amount. Only for the specific…
-
CFRONTDOTNET Navision 2009 R2
Hello, I am trying to connect via .net C# program to Nav server(SQL) getting the last transaction for a specific POS and then trying to connect to that POS (Native) by changing the CFRONT driver type, sometimes it's working and sometimes not I think cause I don't have 2 instance of the CFront object (the same Object is…
-
OData update
Hi, I'm having problems updating records using OData web services on Business Central. I've published a couple of pages, 21 and 518, as OData web services. The both return json perfectly, and I can set filters also. However, when updating, I get an HTTP 405 - Method Not Allowed. The the event viewer on the NAV server the…
-
Create a table with CAL code ?
Is it possible in a codeunit (or processing only report) in Navision, to create a table via code ? I could create a temp table and store my data in there, but that's not what I want. In Sql there's the Create Table statement, is there something like that in CAL ? I don't think it is possible, please proove me wrong.
-
error sending email via external web service
Hi Experts!! NAV 2009 SP1 Upon receiving the request from an external WS we need an email sent. When executing the code from the WS it always gives the same error "Error while executing messaging codeunit for App PASARELA. Details: This message is for C/AL programmers: The call to member Send failed: Method…
-
General Journal Posting Errors
Hi, I'm having a few problems trying to post a general journal. It's quite a large journal with varying account types (G/L, Vendor, Customer, Bank Account) on varying posting dates, but the total does balance. I'm getting 3 error messages in particular that I'm not sure of how to address : - JNL00538 posted on 01/12/07…
-
Generate txt report using Automations
I have a report that after generated I want it to be downloaded as a txt using Automations. If you could guide me on how to do this. What I want to achieve is not need to go to the server and download it, but use Automations and do it directly from the client.
-
Assign an option field value
Hello All, i have a field type option where i want to assign the options like Option 1 -> 0,0 - 1,0 Option 2 -> 0,0 - 2,0 and so on. How can i do it on NAV 16 and above
-
ADCS - ESC function Keys on Miniform Type Selection List
Hi Everybody! I'm new to the Adcs, Can you please help me to understand how the Esc keyFunction works on a Selection list? I explain: When I'm on a selection list Miniform Type, and press the Esc button, I expect to go to the previous Miniform, instead it goes to the First miniform on the list. Is there a way to change…
-
Does any one encouter this error? Hope you can help me on this.
-
Update Amount Including VAT or Total Incl. Tax
Hello guys I would like to know how they help me. I would like to change the Amount Including VAT, Outstanding Amount (LCY) field, well I explain. I have 3 fields that I added, and these fields must add the subtotal amount, although these 3 fields should not be taken into consideration for taxes. Direct Unit Cost Excl. Tax…
-
Transfer Order Receipt Issues
Hello Guys I have customized a transport management module for a client. I am utilizing the standard Transfer Order document as the parent document. I have two additional Documents, a dispatch and a Receiving Advice. The dispatch advice posts the shipment and the receiving posts the receipts. My problem is sometimes the…
-
Date and Time Field corrupt?
Hey guys, so we've had problems with the table 405 ( change log entry )... it has been inserting the wrong time since the beginning (-1h) ... even though it shows let's say 3am when i open the table in navision, the actual entry is 2am ( that's what SQL is saying ) ...is it possible that the field itself is just corrupt ?…
-
NAV2009 reports to NAV2018
Has Microsoft put out a better tool yet for report transformations? I have a client on NAV2009 that is upgrading. I have been doing the Convert Object, Transformation Tool stuff and then finalizing with the Upgrade Reports function to get them to NAV2013....so then I can upgrade them further with the RDL in place. But my…
-
Julian Date In export File
hi how can add Juliant date base 0YYDDD on exported text file formating bank format with lenth and position thank you
-
Block Cost Update on Specific Items
I have a client on NAV2009, Classic Client with an average cost issue that won't stay fixed. We've obsoleted the Item and blocked it, but it is the parent from a very large BOM, and it keeps on recalculating wrong and we end up with 0 quantity in inventory worth upwards of a $100,000. At this point, I've revalued and done…
-
Online Map : Return value
Hello all, does anybody know if its possible to return value of distance from Online Map to Dynamics? For an ex. using this hyperlink. HYPERLINK('http://www.google.de/maps?f=d&hl=en&saddr=[from street]+[from post code]+[from city]&daddr=' +Address+' '+"Post Code"+' '+City); ..and then return the distance from A to B.
-
Problems with CAL function calcdate
Hello we have the issue that since px. 5-10 weeks calcdate using "WD" for weekdays isn't working properly. Px.: calcdate('<-1WD>',09122019D) you get the result Sunday 08.12.19 instead of Friday 06.12.19. :o Before it worked well, but now I'm realy worried about our scheduling due to this error. We are using an NAV 2009 /…
-
Configure package
we are using Import excel file to generate Sales orders in bulk with using configuration package. the same way can we link references attachment file sale order.
-
Navision 4.0 on Windows server 2016
Does Navision 4.0 works on Windows server 2016 (native database)?
-
Convert Navision 2009 Nativ to Navision 2009 SQL
Hallo To all i want to convert the Nativ Database Navision to sql , i did all the steps, but i do not know how i can remove all the Wrong symboles from the Text which cause error in the converting, symboles like ž and so one. can any one please help me by find a a routine which can do all that. Thanks with my best regards