-
Office 365 and NAV 2009 R2
We have installed Office 365 at our company, but now we can't send Email from our NAV 2009 R2. Automation "'NS Outlook Synchronization Handler'.OSendMail" does not work anymore. I can see that there is an Automation "'Microsoft Outlook 16.0 Object Library'.Account" but there is no Sendmail in this Automation. Is there…
-
Importing text file in NAV which has two lines.
Hi Friends, I need to read data from text file and import into NAV table using dataport. The text file contains have below 2 lines. Field1="XXXXX"
Fiedl2="AAAA-BBBB-CCCC-DDDD" I need to store the value XXXXX in Field1and AAAA-BBBB-CCCC-DDDD in Field2 in new NAV table. Can anyone let me know how to do this task? Thanks,…
-
Report, background picture
Hello, I searched quite well, but maybe this has already been asked though.. Is it possible to fill each page with a background image? The whole text should be printed on an image with almost the same dimensions as the page. Thanks for your help in advance, Steffen
-
MRP & Blanket Purchse Orders
Dear All I was wondering if someone could confirm how MRP handles blanket purchase orders for items. Does it ignore the existence of the PO?
-
Closed Profit and Loss with wrong "Income/Balance"
Hi, Two of my balance sheet accounts were incorrectly set to Income Statement. So when we closed the Fiscal Year, they closed to retained earnings. How do I fix this type of issue? Thanks, Steve
-
Supply Planning Transfer Reordering Policy
Hello everyone, Maybe someone could explain why SKU with replenishment system Transfer should have the Reordering Policy set? For example: SKU of the same item: Warehouse A: Replenishment System - Purchase; Reordering Policy - Lot-for-Lot; Inventory = 0 Warehouse B: Replenishment System - Transfer; Reordering Policy -…
-
Mail
Hi. We have NAV 2009 R2. We have installed Office 365 and now we can¨t send mail in NAV. OLHandler.dll not working. Someone else that have same problem?
-
Invoice
Hi When i print the Invoice the Posting Date is 090818. How can I do to get 09082018?
-
Transfer error when trying to post sales order
Hi, I'm trying to post a sales order but am getting an error due to one of the lines When I try to post I see error Quantity on Line No. 70000 for Order SO12343 hasn't been completely transferred to Despatch ( where Despatch is a location) The order has been released. There is a quantity of 1 on the sales order line but…
-
Retrospective Forecast - NAV 2009 R2
Dear All We use component forecasts for our longer lead time items to ensure we make appropriate provisions thro' MRP. I have spotted a colleague has manually created a purchase order for an item rather that creating a forecast to provide the demand to order. As a result the Planning Worksheet is suggesting that the…
-
Windows Language table
Hi, I want to know where the virtual table Windows Language is filled from. In our NAV 5.0 database some records have an empty name. The ID is filled, but the name is empty.
-
Closing Workbooks in Navision
How can i Close all workbooks Except the active one using Excel Buffer in navision Thanks
-
NAV 5.0 connecting to Exchange Server 2016
Hi, My client is using NAV 5.0 and they have recently updated to Exchange Server 2016. Now the client is facing issue with connecting to Outlook with the following error: "The call to member GetDefaultFolder failed. Redemption.RDOSession returned the following message: Error in IMAPISession::OpenMsgStore:…
-
Marking records for special filtering
Hi all, Am a little stuck on a problem with lines in a simple line-form. Have a field in which I can key-in a condition. Then call a function that runs through all recs (repeat/until) and if the rec fulfil the condition by check in another table, the rec is Marked(TRUE). When loop is finished comes the line…
-
Nav09 license issue
I'm new here so if this is in the wrong group, please let me know where to post. I'm try to help a client with Nav09 classic. The license information shows 30 licensed Sessions but if they try and connect more then 12 sessions they get a message saying 'Your program license does not permit more user to work…
-
Ls Retail Credit Card set up (No. series)
To Expert I set up credit card no. series when I printed receipt type Credit card not correct. Example step set up as below: POS when I select order and Create Payment. I select tender type by Credit Cred > enter Card No. 5412345678901234> Expires Date: 0220 Receipt Printed Credit Card Visa 1234 why Credit card type show…
-
Mandatory fields on Item card
I am trying to think of a way of making the creation of item cards more full proof. I have investigated the use of Item card approval, but this doesn't really prevent someone from missing some fields the card that has an effect when running the MRP, eg missing vendor, or replenishment system etc. I was thinking that maybe…
-
Distorted TXT Data when exporting via dataport (Hidden charachters problem)
Hello everyone, I am exporting the customer table with a dataport. How can I clean the data with code before exporting from the Carriage Returns and Line Feeds into fields like Invoice Numbers, Addresses, Names, etc? I will appreciate your help very much.
-
You must upgrade navision client to the latest version to view database.
Hi all I am on Nav 2009 cc. Recently we have added new client system running on Windows 10 Home edition. After Nav client installation, while login to navision initially i was getting SQL startup parameter error which i had resoled. Now while login to navision i find following error: "The XXXX database on the server XXXXX…
-
Shortcuts don't work after installing French language
Hello NAV Experts, My NAV 2009 R2 shortcuts to any servers and databases are stopped working since installing the French language. Everything was working fine before. I got different error message than my users. Please help on how to fix this. Here is the shortcut properties: "C:\Program Files (x86)\Microsoft Dynamics…
-
How to calculate no. of month between two dates?
Hi friends, I need to calculate no. of months between two (From and End) dates. The From and End date can be first day and last day of the month respectively. Else From date can be mid of a month and End date can be mid of some other month. I want to count the no. of month in between the two dates. It should take care of…
-
How to use a Related Template?
I am using LS-Nav version 9.0.46621. I am creating item templates in Setup Master Templates. I get it that a Template uses the same table as the template that calls it, but how does one tie together the Related Templates? So for example, I want to automatically fill in the Item Unit of Measure for the newly created item,…
-
How to give 2 or 3 Salespers./Purch. Code in user setup table it just takes only one code.
How to give 2 or 3 Salespers./Purch. Code in user setup table it just takes only one code. I tried using concatenation ex. 2102|2105 it takes only one why? ple help?
-
G/ L entry sql server error
Please guys I need your help on this one I am replicating nav data from one nav database to another on sql server 2005. But when I try to run the replication data on the G/L Entry for instance I get error message: 8171,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Hint 'noexpand' on object…
-
Nav freezes while applying customer entries
Hi, Greetings! We have 2009 installed for one of client.The 2009 NAV is opened via Citrix.Now this is unique issue only ONE user is facing.When she drills on the customer card balance and tries to apply customer entries and selects more than 1 and applies(f9) the system freezes.This behaviour is observed only sometimes…
-
Printing ZPL label to Zebra printer from NAV 5.0
Hi Everybody, I'm currently struggling with the problem of printing ZPL label from NAV. I've got the ZPL code label from FEDEX and saved it in a file. Now I need to print this label from NAV. The printer is network and connected via IP port. I've tried to do this via command line (SHELL) as suggested here, but probably…
-
NAV automation and NAS
Hi guys, for some reason nav automation stopped working. CLEAR(WshShell); IF ISCLEAR(WshShell) THEN returnval:= CREATE(WshShell); returnval seems false. when running from nav client, not in NAS, it seems working. Any ideas? thanks. its nav 2009
-
Export Picture Fields as WebService in NAV 2009 SP1
Dear All, I am trying to publish a picture field as web service in NAV 2009 SP1. Since I am not very familiar with automation objects I couldn't manage to succeed so far. I tried to replicate functions codeunit 99008516 - BizTalk XML DOM Management but I realized that I can not even compile the object because automation…
-
display extended text in report
Hi Guys, does anyone know how to display the extended lines in the report of purchase order. i'm making a customized form that will make this appear. i used the Extended Text in the item card to make it appear in the Purchase Line. now I have to put it on my custom report
-
Closing Inventory Periods
Hi, We have several accounting periods, dating back to 2014. When we run adjust cost, we don't want any value entries or any GL entries to post prior to 06/01/18. So what we did is closed inventory period May 2018. We also set the Allow Posting To and From as 06/01/18 to 07/31/18. This worked out well. All item ledger…