-
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
-
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…
-
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.
-
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…
-
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.
-
Shipping a sample without cost
Hi all, I have an item in the system with 500 units valued using the average method. One of our accountants wants to ship 10 units of this item as a sample to a customer but he does not want that NAV takes any cost from the inventory that is, the idea would be to have the item ledger entry generated by this shipment with…
-
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…
-
Amount in words - Passing Parameters
Hi, How can i print decimal amount in words. I have tried using report 1401. However i am not sure about the parameters to pass in the function 'FormatNoText' ,Especially the first parameter ' VAR NoText : ARRAY [2] OF Text[80] ' . Anybody please explain this. Thanks in advance. Shibily
-
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…
-
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
-
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…
-
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.
-
Nav 2015 Bank Acc. - Detail Trial Bal. Non showing opening balance
Hi , I have installed Navision 2015 and on the Bank Acc. - Detail Trial Bal. there is no opening balance. I have searched on updates but I didn't find any correction regarding this. Can somebody help on this?
-
navision automation in ms-word
can any body give me any code, so that i could throw (generate) navision report in ms-word. can any body show me how i can use coding for "ms office-word automation" in navision. i have allready used following coding, but it is showing error.Name DataType Subtype Length wrdApp Automation 'Microsoft Word 11.0 Object…
-
Is It possible to add background image to table field (not BLOB, just background) ?
Hi everyone, I'm pretty stuck in a problem. I tried to set default column width of the field, which is containing BLOB. But Navision returned error, that it is not possible. I wanted to ask you if it is possible to fill table field with the background image. Thanks in advance for your responses :smile:
-
How can i save login data (user id or user name) into SQL table of NAV.
Hello, Which data are used to store login data. I want to use these data to save login information into article ledger. As my customer used SQL server and Nav5.0, is it a good idea to write trigger and stored procedure ? Thanks for your help
-
Invoice a service Contract In full at the start of Contract
Hi- I am trying to work out a way of generating an invoice for the full value of a service contract when it is created. We have contracts that can be for 3 years but need to invoice the contract in full at the time it is entered. we don't need the revenue to be split out over the 3 years - the total sale can be shown with…
-
Run a report with the current record in form
Hi, i try to run a report from a form, the form sourcetable and the report main dataitem are the same. i used Report.Run(...,Rec) in the Command Push trigger. the matter is that the report do not run with the current record of the form but with the random record in the table. HAve any idea, please share with me.
-
Slow Lot No. Selection
Hi All! A customer is using lot numbers on some of the items. Those items are often used as components on Prod. Orders. When they open Item Tracking Lines form and click the assist button on the Lot No., it can take anything from 30 sec to even couple of minutes before the form opens up. So far I managed to establish…
-
Exporting report to excel in Dynamic nav 5.0
I'm currently trying export dynamic nav 5.0 report to excel . Any way I have most of the values to excel currently I'm stuck at getting the table values to my excel file i.e entercell(Row, 1, FORMAT( fixedAsset."No."), TRUE, FALSE, FALSE); // this is always empty entercell(Row, 2, FORMAT( fixedAsset.Description), TRUE,…
-
Problem in end of year closing with additional reporting cur
Dear All, I am trying to close the year but i am getting an error of inconsistency in GL see attached. the problem is that i had two scenarios: 1- without additional reporting currency setup in General Ledger setup and it is working fine 2- when i setup addition reporting currency in General Ledger setup i get the attached…
-
Paste Rows in Dynamics NAV 2013 Not Working
Hello Expert, I have created a new functionality as purchase quote in systems.Their is "Paste Rows" functionality of Dynamics NAV 2013 for list page in not working for my subform. So any one please give me the solution :cry: Thank you for replay... [-o< [-o< [-o<
-
unknown automation server variable after object import
Hi @all, I've got a solution to create an email with attachment with the pdf creator. It works fine. But when i import a new object witch was modified on another server, I get the error that the automations are unknown. When i select the variables again, I will find all tools in the library and after the selection all…
-
Allowed to upgrade without using my reseller?
We find ourselves in an awkward situation and looking for some insight. For >8 years we have had the same reseller, through which we have paid the required annual fees/license. In those 8 years we have kept the same version, thus never actually upgrading our NAV. Now that we are actually ready to upgrade, we prefer not to…
-
Impact on Cost (wrong unit of measure)
An item on the warehouse floor was received (with the unit of measure) as "watts" instead of "ea". However, the item was consumed in "ea", so we cannot simply reverse it. Therefore, we must do a negative adjustment. But I am not sure how this will impact the cost. I need to understand the impact of doing a negative…
-
Internal Error 47-1 (.stx file)
Hi all, I'm trying to set up a Windows 2003 Server with Citrix Program Neighborhood, and when I run Navision in the Client side of Citrix Metaframe, the following error occurs: "There are errors in the text conversion (text no. 1949-0 does not exist in the .stx file). Internal Error: 47-1" I'm using Navision 4.0 ES…
-
Running Report With Request Page Parameters From C/AL?
Hi all, I am wondering if i can run the report from C/AL by entering the parameters that the request page needs, but without opening the request page itself?
-
adjustement item
this article should be enliven between the date .... and ... in nav 2009 r2