-
Item No. cant rename
Hi, While item no. renamaing, i am getting the error message. The following field must be included in the table's primary key: Field: "Description" Table: "Item"
-
How i can connect Navision Client with server out of Lan Network? ( Not in Same network)
Hello Everyone.!! I need to know how i can connect Navision Client with Server,if my server is in one location and client is in another location. they are not in same network..!!! How i can do it?? Please suggest...!!!
-
update cost to G/L
Hi all While creating item card, standard cost is unavailable, however i have posted some transactions for the items like sale and purchases. when i check the value entrie table "cost posted to g/l" shows zero, question is when standard cost was available can and post correct cost for posted transactions this item ? please…
-
Reorder level
Hi all I am on Nav 2009 R2 classic client not RTC. My questions: 1) how to i setup reorder level for Items. When any item inventory drops to the specified quantity the same should be positioned for reorder. 2) i do not see "Reordering Policy" in item card, planning menu. please help. thanks satish
-
How do I setup decimal places for the field 'Line Discount amount' to round down.
How do I setup decimal places for the field 'Line Discount amount' to round down. For example for an item which costs 3.10. A 15% discount gives 0.465 as the line discount amount. That figure in my company is giving 0.47 as the line discount amount. I want it to give 0.46 or at least to remain as 0.465. Please assist I…
-
How to open the Jobqueue report as a PDF?
I have created the Nas and Jobqueue.I also downloaded the BullZip pdf software.But,I don't know exactly where I put the code(the report itself or Code Unit) for the Jobqueue report to Pdf conversion.Guide me please,, Thanks in advance.
-
Report by Email Sending Blank Body
NAV 4.0 (6.00) Office 16 Exchange 365 Windows 7 When using inbuilt function File > Send > Report By Email in the spec above the email is generated with the report rendered in body however, when emailed the body is blank. Currently working around this by saving the email after generated and then sending which retains the…
-
Transaction cannot be completed because it will cause inconsistencies
Hi Mates, I hope you all right. perhaps somebody can help me with this: https://community.dynamics.com/nav/b/tharangacnavblog/archive/2014/10/23/error-the-transaction-cannot-be-completed-because-it-will-cause-inconsistencies-nav-2009-sp-01-nav-2009-r2 I followed the steps above but the entries it is telling me to unapply…
-
How to create a Job queue Report in Event viewer?
I have installed the NAS in Nav 2009.the Nas is also running properly.Now how can i get the Jobqueue report in Event viewer? Guide me guys,,,
-
Query
Hi How to get a list of Items which have stock as on 31.03.2015 and after that it has been Sales directly not transferred to any Location after 31.03.2015. Thanks
-
NAV LS Retail Promotions
Hi All, I want to setup some type of promotions in the Nav LS retail POS. But after a big research I am not sure if this type of promotion That I want is possible to execute, what looks weird for any POS system I think is Possible. The promotion That I want To setup is I Have Product A and Product B and My promotion…
-
How can i check whether the NAS is properly Running or not?
I have installed the Nav application services (NAS) in NAV 2009 then I don't know how to check the running status of NAS.please guide me.
-
To create a report for last sold item with the posting date
Hi all, I create a report to print a customer last sold an item with posting date.But I am facing some issues. Here I am able to print the items based on posting date but all the items are shown here.Moreover, I want to display only last posting date but it is showing all the posting dates. Please advice. Thanks in Advance…
-
Deemed Credit
Hi How to calculate deemed credit in case of Transfers Thanks
-
Filter Subform2 By data in Subform1
Hi there, I need to add 2 subform into a main form. I then need to filter one of them with data stored in another subform (Something like subform link). Is there any chance to do that? I'm not able to do it. Many thanks.
-
Convert a string to an Integer
Is there a way to convert a string to an Integer in Navision
-
unknown language was selected '16393'
OS : Windows Vista Navision : Version 5 Whenever the user opens up navision he get's the following error message unknown language was selected '16393'.
-
Linked Server and Navision
Our customer has an external SQL server on which they want to make a lookup into a table. First of all I know (and it is working) that a view can be created on the Navision SQL server and I can access this view from the Object Designer (table). I have also managed to setup a Linked server and retrieve data from the linked…
-
Modulo on a big number
Hi, I need to perform a modulo operation on a very big number (30 digits, could even be all 9's), is it even possible to do that in Navision? If so, how would i do that? It would be a simple VARIABLE MOD 97 operation. Also, the 'number' is stored in a Text variable, since obviously integer can't hold a number of this…
-
Time in HH:MM:SS format
Greetings, How can we convert TIME into HH:MM:SS format. I mean if the Time is 5:45:23 AM then it should come as 05:45:23 and if the TIME is 5:45:23 PM then it should come as 17:45:23. Using DELCHAR i am able to delete AM and PM from TIME but how to add extra 0 if any of the hour/min/seconds are in Single Digit. We can…
-
Customer login using temporary password in MS Dynamics Nav
We have currently generated a temporary password using our customer login API, but we are not able to login to the system with this password. Please find the API details from below. <element name="GenTempPassw"> <complexType> <sequence> <element name="pCust" type="string" maxOccurs="1" minOccurs="1"/> </sequence>…
-
Integrate WooCommerce webshop
How to Integrate WooCommerce webshop with Microsoft Navision?
-
XML Automation in NAV 5.0 error message coming while Sending through Outstream.
Hello Coders, I have been trying the below Request and Response through the XML Automation in NAV 5.0 version but I am getting the following error. Microsoft Dynamics NAVThis message is for C/AL programmers: The call to member send failed. msxml3.dll returned the following message: A connection with the server could not be…
-
Block location in Item by Location
Hello all How do i block unwanted locations being visible in items by location matrix. thank you satish
-
Is possible to detect the open of an object
I would like to know if is possible to detect when you open an object in desing mode from object designer. thanks.
-
User Permission to Only Forms nav2009
Hello, Through Navigation Panel we can assigned users to module. Is it possible to assign users to individual forms only example: in Finance -> receivables -> Customer I want to assigner user to Customer form. Please advise. Thanks
-
Array Showing wrong Data
Hi I have below code . In array Qty[1] it is showing 0 whereas in OQty it is showing correct value ILE is Item Ledger Entry with DataType Record. ILE[1].SETRANGE("Posting Date",0D,CALCDATE('-1D',StDt)); IF ILE[1].FINDFIRST THEN REPEAT ILE[1].CALCFIELDS("Cost Amount (Expected)","Cost Amount (Actual)"); Qty[1] +=…
-
Nav - Complete setup of Version RU 3.60.03 is needed for one of client.
Hi All, I have one client who is on Version RU 2.60.03 They are planning to migrate from currentnt citrix platform to a new citrxi platform. For the same I need setup of above version. If Some-one can provide any idea for the or provide the dump, i will be thankful. Regards, Malaya.
-
Group rows in Classic report - report 206
Hello experts. I am not used to working with classic reports, I always worked with RDLC. I have lines like this in report: Description Description 1 EUR 574,11 Description 2 EUR 121,12 Description 3 EUR 241,23 Which are all with the same "No." on Sales Invoice Line. I want to show only one row with summed amounts for one…
-
Posted Purchase Receipt with No ILE or VE?
I searched the forum and found only questions regarding Undo receipt and adjust cost. here's my observation. I have a Purchase Order that will not post. I get the error message: Microsoft Dynamics NAVItem Ledger Entry Entry No. '0' does not exist. OK When i activate debugger, i find that the code stops in Codeunit 22 on a…