-
NAS Service issue
We received the below error message in the event viewer while starting the NAS in windows service. Version - Microsoft Dynamics NAV 2009 R2 A timeout was reached (30000 milliseconds) while waiting for the Application Server for Microsoft Dynamics NAV
-
Strange behavior on a form
Hi to all, I need a little help to understand a strange (for me that I'm a total beginner :-) ) behavior in Navision 2009. I have a form that has several lookup fields that opens a list of child record to select one. The strange behavior for me is that when I click on the upper arrow the lookup correctly opens but when I…
-
How do I write the code in the PostCharge function trigger so that the function does the following
1. For each record in the Seminar Charge table that corresponds with the Seminar Registration Header, the function sets the JobLedgEntryNo to the result of the PostJobJnlLine function (run with a parameter of 1) and runs the PostSeminarJnlLine function (with a parameter of 3). 2. Sets the JobLedgEntryNo to 0.
-
CU400 sends special Characters to Hotmail, Gmail etc.
My client Running 2009 R2 has trouble sending emails with attachments to for example hotmail and gmails but not to xxx@[company].com mails. The subject and name of the attachments is strange characters looking like Chinese or something. In the overview list, the subject looks fine, but when you open the male noone can read…
-
Question about OnLookup Form
Hi to all, I'm very fresh as navision developer and I'm facing the following task. In my Form I have a field called Item. No., and another field called Packing List No. that is a lookup field. Each Packing List contains a list of Packing List Item and each Item is related to a specific Item No. I'd like to prefilter the…
-
Filter lookup list with specific values
Hi to all, I'm newer with Navision and in these days I'm facing a lot of new "small issues" (of course due to my lack of experience with Navision). I need to limit possible values in a lookup list, I've seen this is possible using TableRelation property with a filter but, till now I've always seen example with 2 table…
-
NAV2015/2016 classic client [dev] user privileges
Hello, i would like to ask if you know if there is any way and how to set permissions for user who should get access to the client and view the objects but can't modify them. many thanks
-
G/L Impact due to revaluation
Hi there, One of our customers is asking for a breakdown of what G/L accounts are impacted when a revaluation journal entry is posted. Specifically, they are looking for the T ledger breakdown when the following occurs: 1) Revaluation of a Raw Material (Average costing method) resulting in an increase in value on hand 2)…
-
Why does showing the Automation Server table require RunAs Administrator?
(NAV2009R2 build 35179, Classic, SQL) We have solution running at multiple sites without any issues, but now one of the sites changed the security settings for their Citrix Servers. This caused the following code to fail: AutomationServers.SETRANGE(GUID,'{3B311C81-140E-11D5-8B18-00D0590B4EC5}'); // 'Navision Timer…
-
InitValue property
Hi to all, I'm new with navision 2009 and I'm wondering if is possible to specify an Empty String for InitValue property If I leave <undefined> I got an error because I can't INSERT NULL values, so I'd like to specify a default empty string for the field in InitValue property. Is it possible? Thank you in advance for your…
-
NAV 2015 (2013, 2013r2) and ADCS (error The Field does not exist.)
Hello all. Got an error when trying to connect to adcs (all installed, setup done, all services started): Does anyone have an idea how to fix this? Some extra info (maybe useful): Investigation showed that table 2000000002 is User table in NAV <=2009r2 In NAV >=2013 User table has ID 2000000120.
-
Duplicating Tag Numbers and Item numbers in Inventory Variance Report NAV 2009 R2
When we took the Year End Inventory counts for all of our Items we posted all counts into our Data Entry table. We run the Variance Report before we post so we can try to vet out any possible issues before posting to the G/L. For some reason the Variance Report is showing all Items and Tags twice. Is there a way to not get…
-
Scheduler Job Error Sales invoice already exists
I run ICT Header of scheduler job and it show message for attach file. Who can help me? Thank you for this help.
-
delete sequentialites whats it is the impact in system
the impact on removing sequences
-
Archive Purchase Order within Invoice process
Hi All, In the codeunit 90 Purch.-Post, OnRun trigger, we have two following lines of C/AL code: IF Receive OR Ship THEN ArchiveUnpostedOrder; // has a COMMIT; Here, by the standard NAV functionality, if we do Receive lines for the Purchase Order (not Receive&Invoice), archive version will be created, but than if we change…
-
KB978605 NAV 4 SP3
Dear all, Anyone has Code Changes based on KB 978605 "The "Adjust cost item entries" batch job appears to enter an endless loop when you adjust an average cost item by using the average cost calculation type of Item and the items are used in Transfers in Microsoft Dynamics NAV 4.0" in NAV 4 SP3? I have the link…
-
Export data in Navision 2009
Dear all, I'm a new developer with Navision 2009 and I need to modify an existing export function that export data in a txt file. This function exports all data but, as separator, inserts a <NONE> tag that I'd like to remove or at least customize with a comma or a blank space. Debugging the function I can't see a part…
-
Error while converting DB from NAV 2009R2 to NAV 2013
Dear All, I'm doing data migration from NAV 2009 to NAV 2013R2. But during database conversion from NAV 2009 to NAV 2013, I'm getting an error in "G/L Entry" table. Attached is the screen shot of the error. Can anyone help on this? Thanks in advance!!
-
Multiple Attachments to a PO
Hi All, How can multiple attachments be added to a PO, scanned copies are to be attached to a single PO??
-
how to check if a number is whole or not.
I have an IF statement that I want to do but I cannot seem to get it to work. What would be the best way to solve this or am I going about this all wrong? My statement is "IF quantity/"Sales Quantity" = (any whole number) THEN BEGIN..." or I could use "IF quantity/"Sales Quantity" <> (contain '.' or a decimal number) THEN…
-
back from shopping Weighing ticket in nav 2009 R2
back from shopping Weighing ticket in nav 2009 R2 in nav 2009 R2 i have a model '"Weighing'" we have a bridge I want to add the module functionality as create shopping Returns how? what are the steps to follow ? as if the source code thank you to transfer me
-
Which is the function to use to make a program release the Filter on a field on the Header Table?
How do I write the Code that allows the program to release the filter on the No. field of the Header Table, after the page gets the record.
-
Is there a way where i could pre-assign a location to an item in NAV 2015.
Am trying to predefine location to my inventory items in NAV. So whenever i purchase or requisition it, the inventory location would automatically be pick up in the item journal.
-
Navision ver 5 on Sections vs Navision 2015 customization trial balance report
I have the following customization in trial balance report on version 5. under sections of report - integer Body 2 - Presection IF CurrReport.SHOWOUTPUT THEN BEGIN IF ("G/L Account"."Balance at Date"=0) THEN BEGIN IF ("G/L Account"."Balance at Date" <> "G/L Account"."Net Change") THEN CurrReport.SHOWOUTPUT(TRUE) ELSE…
-
NAV 2013 R2 License Backward Compatibility with NAV 2009 SP1
Dear All I would like to check whether NAV 2013 R2 Customer License can be used for NAV 2009 SP1? Is NAV 2013 R2 Customer License has backward compatibility (to use NAV 2009)? One of our customer using NAV 2009 SP1, now want to use RTC. But their license granule 9100 not included to use the said. Regards Nasheer.
-
No. Series Automatic Generation
Hi, I am facing a problem, when i open any old PO and press F3 on No. field, it is not picking up the next no. series. It is showing an error: "It is not possible to assign numbers automatically. If you want to assign the nos automatically, please activate Default Nos in No Series D" Eg: There are 4 No. series when i look…
-
How to - Store User ID into Capacity Ledger Entry Table ?
Hello, I'm looking for a solution to store Used Id in capacity ledger Entry Table. I added field User ID in the Capacity Ledger Entry table. Then, i tried to get User ID from Item Register table where Capacity Ledger Entry.Entry No >= Item Register.From Capacity Entry No. and Capacity Ledger Entry.Entry No <= Item…
-
Dynamics Online Payment Services
Hi, Is anyone using Dynamics Online Payment Services? I have it all setup for a client and running correctly. My question is how do I see that an authorization has been placed against a sales order? I don't see any fields in the sales order table for a "pre authorized" or "deposit received" field. In other words, if I'm in…
-
Change of costing method
Hi Friends Is their a way to change the costing method in Navision 2009 SP1? I am aware of blocking the old item and creation of new item, but with 15000 items it looks very difficult. Looking for feasible solution. Thanks in advance
-
How to execute an stored procedure in NAV 2015?
I would like to execute an sql stored procedure from Dynmaics NAV 2015? Is there a way to do this? Thanks.